DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 136: FROM pa_transaction_interface_all ti

132: ti.attribute10,
133: ti.orig_transaction_reference,
134: substr(orig_transaction_reference, 1,(instr(orig_transaction_reference, '-', 1, 2)-1)) instance_id,
135: ti.transaction_source
136: FROM pa_transaction_interface_all ti
137: WHERE ti.transaction_source IN ( 'CSE_PO_RECEIPT', 'CSE_IPV_ADJUSTMENT')
138: AND (ti.transaction_source, cdl_system_reference3) IN ( SELECT
139: 'CSE_PO_RECEIPT' txn_source , p_po_distribution_id sys_reference3
140: FROM dual