ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F27A3869E053B46B63588994Y 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 PA PAPERACTRULES_XML AR PA قواعد تنفيذ الإجراء (بتنسيق XML) Application: المشروعات Source: PRC: قواعد تنفيذ الإجراء (بتنسيق XML) Short Name: PAPERACTRULES_XML DB package: PA_PAPERACR_XMLP_PKG D PA Vorgangsregeln durchführen Application: Projects Source: PA: Vorgangsregeln durchführen (XML) Short Name: PAPERACTRULES_XML DB package: PA_PAPERACR_XMLP_PKG F PA Règles de réalisation d'action Application: Projects Source: PRC : Règles de réalisation d'action (XML) Short Name: PAPERACTRULES_XML DB package: PA_PAPERACR_XMLP_PKG US PA Perform Action Rules Application: Projects Source: PRC: Perform Action Rules (XML) Short Name: PAPERACTRULES_XML DB package: PA_PAPERACR_XMLP_PKG ZHS PA PRC：执行活动规则 Application: 项目 Source: PRC：执行活动规则 (XML) Short Name: PAPERACTRULES_XML DB package: PA_PAPERACR_XMLP_PKG BI Publisher :p_action_set_type_code :p_conc_request_id :p_debug_mode :p_project_number_from :p_project_number_to 1 10 :p_action_set_type_code LOV Oracle PA_SRS_ACTION_SET_TYPES Y select action_set_type_code id, action_set_type_name value, null description from pa_action_set_types order by value,description AR نوع قاعدة الإجراء D Vorgangsregelart F Type de règle d'action US Action Rule Type ZHS 活动规则类型 2 20 :p_project_number_from Char AR رقم المشروع من D Von Projektnummer F Numéro de projet - De US Project Number From ZHS 项目编号自 3 30 :p_project_number_to Char AR رقم المشروع إلى D Bis Projektnummer F Numéro de projet - A US Project Number To ZHS 项目编号至