ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2DB3869E053B46B63588994Y SELECT substr(ti.batch_name,1,20) batch , substr(ti.batch_name,1,20) batch_name , NVL(pa_utils3.GetEmpNum(ti.person_id),ti.employee_number) employee_number , substr(NVL(pa_utils.GetOrgName(ti.organization_id),ti.organization_name),1, 60) organization_name , ti.expenditure_item_date , ti.expenditure_type , NVL(pa_utils3.getcachedprojnum(ti.PROJECT_ID),ti.project_number) project_number , NVL(pa_utils3.getcachedtasknum(ti.TASK_ID),ti.task_number) task_number , ti.non_labor_resource , ti.transaction_rejection_code , DECODE(ti.transaction_status_code, 'PR', 1, 'R', 2, 3) sort_c FROM pa_transaction_interface_all ti WHERE ti.transaction_status_code IN ('R', 'PR', 'PO') AND ti.transaction_rejection_code IS NOT NULL AND ti.batch_name = NVL( :P_batch_name, ti.batch_name ) AND ti.interface_id = :P_xface_id AND ((mo_global.get_current_org_id IS NULL AND mo_global.check_access(ti.org_id) = 'Y') OR ( mo_global.get_current_org_id is NOT NULL and ti.org_id = mo_global.get_current_org_id )) GROUP BY ti.transaction_status_code , ti.batch_name , ti.batch_name , NVL(pa_utils3.GetEmpNum(ti.person_id),ti.employee_number) , NVL(pa_utils.GetOrgName(ti.organization_id),ti.organization_name) , ti.expenditure_item_date , ti.expenditure_type , NVL(pa_utils3.getcachedprojnum(ti.PROJECT_ID),ti.project_number) , NVL(pa_utils3.getcachedtasknum(ti.TASK_ID),ti.task_number) , ti.non_labor_resource , ti.transaction_rejection_code , ti.ROWID ORDER BY sort_c PA PAXTRTRX_XML AR PA استيراد حركة (بتنسيق XML) Application: المشروعات Source: PRC: استيراد حركة (بتنسيق XML) Short Name: PAXTRTRX_XML DB package: PA_PAXTRTRX_XMLP_PKG D PA Transaktionsimport Application: Projects Source: PA: Transaktionsimport (XML) Short Name: PAXTRTRX_XML DB package: PA_PAXTRTRX_XMLP_PKG F PA Importation de mouvements Application: Projects Source: PRC : Importation de mouvements (XML) Short Name: PAXTRTRX_XML DB package: PA_PAXTRTRX_XMLP_PKG US PA Transaction Import Application: Projects Source: PRC: Transaction Import (XML) Short Name: PAXTRTRX_XML DB package: PA_PAXTRTRX_XMLP_PKG ZHS PA PRC：事务处理导入 Application: 项目 Source: PRC：事务处理导入 (XML) Short Name: PAXTRTRX_XML DB package: PA_PAXTRTRX_XMLP_PKG BI Publisher :c_company_name_header :c_dummy_data :c_error_code :c_error_msg :c_no_data_found :lp_user_id :operating_unit :p_batch_name :p_conc_request_id :p_debug_mode :p_purgeable :p_rule_optimizer :p_status :p_trx_source :p_user_id :p_xface_id 1 10 :p_trx_source LOV Oracle PA_SRS_TRANSACTION_SOURCE Y select transaction_source id, user_transaction_source value, null description from pa_txn_sources_import_srs_v order by user_transaction_source Y AR مصدر الحركة D Transaktionsherkunft F Origine de mouvement US Transaction Source ZHS 事务处理来源 2 20 :p_batch_name LOV Oracle PA_SRS_TRX_BATCH_NAME Y select batch_name id, batch_name value, null description from pa_trx_import_batches_v where transaction_source=:$flex$.pa_srs_transaction_source order by value,description AR اسم المجموعة D Stapelbezeichnung F Nom du lot US Batch Name ZHS 批名