PA Perform Action Rules

select trunc(aud.action_date) action_date4,
aud.action_set_type_code ACTION_SET_TYPE_CODE1,
ast.action_set_type_name ACTION_SET_TYPE_NAME1,
aud.object_type OBJECT_TYPE1,
aud.object_id object_id1,
aud.status_code STATUS_CODE1,
pl1.meaning status_name1,
aud.reason_code REASON_CODE1,
pl2.meaning  REASON_NAME1,
aud.action_code ACTION_CODE1,
pl3.meaning  ACTION_NAME1,
aud.audit_display_attribute AUDIT_DISPLAY_ATTRIBUTE1,
aud.action_date ACTION_DATE1,
temp.project_number PROJECT_NUMBER1,
temp.object_name OBJECT_NAME1
FROM pa_action_set_line_aud aud,
pa_action_set_types ast,
pa_lookups pl1,
pa_lookups pl2,
pa_lookups pl3,
pa_action_set_report_temp temp
WHERE aud.action_set_type_code = ast.action_set_type_code
AND pl1.lookup_type = 'ACTION_SET_AUDIT_LINE_STATUS'
AND pl1.lookup_code = aud.status_code
AND pl2.lookup_type = 'ACTION_SET_AUDIT_REASON'
AND pl2.lookup_code = aud.reason_code
AND pl3.lookup_type = aud.action_set_type_code
AND pl3.lookup_code = aud.action_code
AND aud.encoded_error_message IS NULL
AND aud.action_set_line_id = temp.action_set_line_id(+)
AND request_id = :p_conc_request_id 
ORDER BY 1 ASC,3 ASC

select trunc(aud.action_date) action_date4, aud.action_set_type_code ACTION_SET_TYPE_CODE1, ast.action_set_type_name ACTION_SET_TYPE_NAME1, aud.object_type OBJECT_TYPE1, aud.object_id object_id1, aud.status_code STATUS_CODE1, pl1.meaning status_name1, aud.reason_code REASON_CODE1, pl2.meaning REASON_NAME1, aud.action_code ACTION_CODE1, pl3.meaning ACTION_NAME1, aud.audit_display_attribute AUDIT_DISPLAY_ATTRIBUTE1, aud.action_date ACTION_DATE1, temp.project_number PROJECT_NUMBER1, temp.object_name OBJECT_NAME1 FROM pa_action_set_line_aud aud, pa_action_set_types ast, pa_lookups pl1, pa_lookups pl2, pa_lookups pl3, pa_action_set_report_temp temp WHERE aud.action_set_type_code = ast.action_set_type_code AND pl1.lookup_type = 'ACTION_SET_AUDIT_LINE_STATUS' AND pl1.lookup_code = aud.status_code AND pl2.lookup_type = 'ACTION_SET_AUDIT_REASON' AND pl2.lookup_code = aud.reason_code AND pl3.lookup_type = aud.action_set_type_code AND pl3.lookup_code = aud.action_code AND aud.encoded_error_message IS NULL AND aud.action_set_line_id = temp.action_set_line_id(+) AND request_id = :p_conc_request_id ORDER BY 1 ASC,3 ASC