ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F26D3869E053B46B63588994 SELECT dist.vendor_id CDL_SYSTEM_REFERENCE1, dist.CDL_SYSTEM_REFERENCE2, inv.invoice_num, apdist.distribution_line_number line_num, dist.EXPENDITURE_item_date, dist.EXPENDITURE_TYPE, dist.GL_DATE, pa_utils3.getcachedprojnum(dist.PROJECT_ID) project_number, dist.acct_raw_cost, pa_utils3.getcachedtasknum(dist.TASK_ID) task_number, SUBSTR(vend.vendor_name,1,80) , dist.transaction_rejection_code, l.meaning, inv.invoice_amount, inv.invoice_date, inv.invoice_currency_code, inv.base_amount, DECODE(dist.transaction_status_code, 'PR', 'A', 'R', 'B', 'C') sort_c, l1.meaning trx_type,l1.lookup_code ,to_char(pa_utils4.get_invoice_payment_num(dist.transaction_source,dist.cdl_system_reference4)) po_number, apdist.invoice_line_number po_line_num FROM pa_transaction_interface_all dist, ap_invoices_all inv , ap_invoice_distributions_all apdist , po_vendors vend , pa_lookups l , pa_lookups l1 WHERE NVL(:Transaction_Source, dist.transaction_source) = dist.transaction_source AND NVL(:Batch_Name, dist.batch_name) = dist.batch_name AND dist.transaction_status_code IN ('R' , 'PR', 'PO') AND dist.org_id = pa_moac_utils.get_current_org_id AND apdist.invoice_id = inv.invoice_id AND dist.cdl_system_reference5 = apdist.invoice_distribution_id AND dist.vendor_id = vend.vendor_id AND to_number(dist.cdl_system_reference2) = inv.invoice_id AND NVL(:System_Linkage, dist.system_linkage) = dist.system_linkage AND NVL(:Original_Transaction_Reference, dist.orig_transaction_reference) = dist.orig_transaction_reference AND l.lookup_code = dist.transaction_rejection_code AND DECODE(dist.transaction_source,'AP INVOICE','A_INV','AP NRTAX','B_TAX','AP DISCOUNTS','C_DISC','AP VARIANCE','D_VAR','AP ERV','D_VAR','AP EXPENSE','E_EXP','INTERPROJECT_AP_INVOICES') = l1.lookup_code AND l1.lookup_type = 'PA_CMT_TRX_TYPE' AND l.lookup_type IN ('TRANSACTION REJECTION REASON','FC_RESULT_CODE', 'COST DIST REJECTION CODE','INVOICE_CURRENCY', 'TRANSACTION USER REJ REASON') UNION ALL SELECT dist.vendor_id CDL_SYSTEM_REFERENCE1, dist.CDL_SYSTEM_REFERENCE2, rcv_shp.receipt_num invoice_num, po_dist.distribution_num line_num, dist.EXPENDITURE_item_date, dist.EXPENDITURE_TYPE, dist.GL_DATE,pa_utils3.getcachedprojnum( dist.PROJECT_ID) project_number, dist.acct_raw_cost, pa_utils3.getcachedtasknum(dist.TASK_ID) task_number, SUBSTR(vend.vendor_name,1,80) , dist.transaction_rejection_code, l.meaning, rcv_sub.entered_DR invoice_amount, rcv_txn.TRANSACTION_DATE invoice_date, rcv_txn.CURRENCY_CODE invoice_currency_code, rcv_sub.accounted_DR base_amount,DECODE(dist.transaction_status_code, 'PR', 'A', 'R', 'B', 'C') sort_c , l1.meaning trx_type, l1.lookup_code,po_head.segment1 po_number,po_line.line_num po_line_num FROM pa_transaction_interface_all dist , rcv_transactions rcv_txn , rcv_shipment_headers rcv_shp , po_headers_all po_head , po_distributions_all po_dist , po_lines_all po_line ,(SELECT SUM(NVL(sub.accounted_dr,0)) accounted_dr ,SUM(NVL(sub.entered_dr,0)) entered_dr ,dist1.cdl_system_reference2 po_header_id ,rcv_shp1.receipt_num receipt_num ,dist1.transaction_source transaction_source FROM rcv_receiving_sub_ledger sub ,rcv_transactions rcv_txn1 ,rcv_shipment_headers rcv_shp1 ,pa_transaction_interface_all dist1 WHERE NVL(:Transaction_Source, dist1.transaction_source) = dist1.transaction_source AND NVL(:Batch_Name,dist1.batch_name) = dist1.batch_name AND NVL(:System_Linkage, dist1.system_linkage) = dist1.system_linkage AND dist1.org_id = pa_moac_utils.get_current_org_id AND NVL(:Original_Transaction_Reference,dist1.orig_transaction_reference) = dist1.orig_transaction_reference AND to_number(NVL2(LTRIM(dist1.cdl_system_reference4, '0123456789'), NULL, dist1.cdl_system_reference4)) = sub.rcv_transaction_id AND rcv_txn1.shipment_header_id = rcv_shp1.shipment_header_id AND sub.rcv_transaction_id =rcv_txn1.transaction_id AND ((dist1.transaction_source = 'PO RECEIPT' AND EXISTS (SELECT NULL FROM pa_transaction_interface_all dist2 WHERE dist2.cdl_system_reference4 = dist1.cdl_system_reference4 AND dist2.transaction_status_code = 'R' AND dist2.transaction_source = 'PO RECEIPT')) OR (dist1.transaction_source = 'PO RECEIPT NRTAX' AND NOT EXISTS (SELECT NULL FROM pa_transaction_interface_all dist2 WHERE dist2.cdl_system_reference4 = dist1.cdl_system_reference4 AND dist2.transaction_status_code = 'R' AND dist2.transaction_source = 'PO RECEIPT')) OR (dist1.transaction_source = 'PO RECEIPT PRICE ADJ' AND EXISTS (SELECT NULL FROM pa_transaction_interface_all dist2 WHERE dist2.cdl_system_reference4 = dist1.cdl_system_reference4 AND dist2.transaction_status_code = 'R' AND dist2.transaction_source = 'PO RECEIPT PRICE ADJ')) OR (dist1.transaction_source = 'PO RECEIPT NRTAX PRICE ADJ' AND NOT EXISTS (SELECT NULL FROM pa_transaction_interface_all dist2 WHERE dist2.cdl_system_reference4 = dist1.cdl_system_reference4 AND dist2.transaction_status_code = 'R' AND dist2.transaction_source = 'PO RECEIPT PRICE ADJ')) ) AND sub.actual_flag = 'A' AND sub.code_combination_id = dist1.dr_code_combination_id AND dist1.transaction_status_code = 'R' GROUP BY dist1.cdl_system_reference2,rcv_shp1.receipt_num,dist1.transaction_source) rcv_sub , po_vendors vend , pa_lookups l , pa_lookups l1 WHERE NVL(:Transaction_Source, dist.transaction_source) = dist.transaction_source AND NVL(:Batch_Name, dist.batch_name) = dist.batch_name AND rcv_txn.shipment_header_id = rcv_shp.shipment_header_id AND po_head.po_header_id=po_line.po_header_id AND po_head.po_header_id=po_dist.po_header_id AND po_line.po_line_id=po_dist.po_line_id AND po_dist.po_distribution_id = to_number(dist.cdl_system_reference3) AND po_head.po_header_id = rcv_sub.po_header_id AND po_dist.project_ID IS NOT NULL AND rcv_sub.accounted_dr IS NOT NULL AND po_dist.accrue_on_receipt_flag= 'Y' AND dist.transaction_status_code IN ('R' , 'PR', 'PO') and dist.org_id = pa_moac_utils.get_current_org_id AND dist.vendor_id=vend.vendor_id AND to_number(NVL2(LTRIM(dist.cdl_system_reference4, '0123456789'), NULL, dist.cdl_system_reference4)) = rcv_txn.transaction_id AND rcv_shp.receipt_num = rcv_sub.receipt_num AND NVL(:System_Linkage, dist.system_linkage) = dist.system_linkage AND NVL(:Original_Transaction_Reference, dist.orig_transaction_reference) = dist.orig_transaction_reference AND DECODE(dist.transaction_source,'PO RECEIPT','F_REC','PO RECEIPT NRTAX','G_RTAX', 'PO RECEIPT PRICE ADJ','H_RECADJ','PO RECEIPT NRTAX PRICE ADJ','I_RTAXADJ') = l1.lookup_code AND l1.lookup_type = 'PA_CMT_TRX_TYPE' AND l.lookup_code = dist.transaction_rejection_code AND l.lookup_type IN ('TRANSACTION REJECTION REASON','FC_RESULT_CODE', 'COST DIST REJECTION CODE','INVOICE_CURRENCY', 'TRANSACTION USER REJ REASON') AND dist.transaction_source IN ('PO RECEIPT','PO RECEIPT NRTAX', 'PO RECEIPT PRICE ADJ','PO RECEIPT NRTAX PRICE ADJ') ORDER BY 20,18,11,3,4 Y PA PAAPIMPR_XML AR PA تدقيق واجهة تكاليف المورد Application: المشروعات Source: AUD: تدقيق واجهة تكاليف المورد Short Name: PAAPIMPR_XML DB package: PA_PAAPIMPR_XMLP_PKG D PA Lieferantenkosten - Schnittstellenprotokoll Application: Projects Source: PA: Lieferantenkosten - Schnittstellenprotokoll (XML) Short Name: PAAPIMPR_XML DB package: PA_PAAPIMPR_XMLP_PKG F PA Audit de transfert des coûts fournisseur Application: Projects Source: AUD : Audit de transfert des coûts fournisseur (XML) Short Name: PAAPIMPR_XML DB package: PA_PAAPIMPR_XMLP_PKG US PA Supplier Costs Interface Audit Application: Projects Source: AUD: Supplier Costs Interface Audit (XML) Short Name: PAAPIMPR_XML DB package: PA_PAAPIMPR_XMLP_PKG ZHS PA AUD：供应商成本传送审核 Application: 项目 Source: AUD：供应商成本传送审核 (XML) Short Name: PAAPIMPR_XML DB package: PA_PAAPIMPR_XMLP_PKG BI Publisher :batch_name :c_company_name_header :c_dummy_data :c_error_msg :c_no_data_found :cp_func_currency_code :operating_unit :original_transaction_reference :p_conc_request_id :p_debug_mode :p_min_precision :p_rule_optimizer :p_user_id :purgeable :system_linkage :transaction_source 1 10 :transaction_source LOV Oracle PA_SRS_USR_TRANSACTION_SOURCE Y select transaction_source id, user_transaction_source value, null description from pa_transaction_sources order by user_transaction_source Y AR مصدر الحركة D Transaktionsherkunft F Origine de mouvement US Transaction Source ZHS 事务处理来源 2 20 :system_linkage LOV Oracle PA_SRS_SYSTEM_LINKAGE_FUNC Y select function id, meaning value, null description from pa_system_linkages order by meaning Y AR رابط النظام D Systembezug F Lien système US System Linkage ZHS 系统链接 3 30 :batch_name LOV Oracle PA_SRS_WEB_BATCH_NAME_RPT Y select batch_name id, batch_name value, null description from pa_trx_intf_batch_name_v order by value,description AR اسم المجموعة D Stapelbezeichnung F Nom du lot US Batch Name ZHS 批名 4 40 :original_transaction_reference LOV Oracle PA_SRS_ORIG_TRANS_REF Y select orig_transaction_reference id, orig_transaction_reference value, null description from pa_trx_intf_orig_transref_v order by value,description AR مرجع الحركة الأصلية D Ursprüngliche Transaktionsreferenz F Référence de mouvement d'origine US Original Transaction Reference ZHS 原始事务处理参考