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 |
