DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 137: FROM pa_transaction_interface_all ti

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