PA Perform Action Rules
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Perform Action Rules (XML)
Short Name: PAPERACTRULES_XML
DB package: PA_PAPERACR_XMLP_PKG
Source: PRC: Perform Action Rules (XML)
Short Name: PAPERACTRULES_XML
DB package: PA_PAPERACR_XMLP_PKG
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Action Rule Type |
|
LOV Oracle | |
Project Number From |
|
Char | |
Project Number To |
|
Char |