DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on DUAL

Line 117: FROM dual

113: AND ei.expenditure_item_id = cdl.expenditure_item_id
114: AND ei.transaction_source IN ( 'CSE_PO_RECEIPT', 'CSE_IPV_ADJUSTMENT')
115: AND (ei.transaction_source, cdl.system_reference3) IN (
116: SELECT 'CSE_PO_RECEIPT' txn_source , p_po_distribution_id sys_reference3
117: FROM dual
118: UNION ALL
119: SELECT 'CSE_IPV_ADJUSTMENT' txn_source , distribution_line_number
120: sys_reference3
121: FROM ap_invoice_distributions_all aida

Line 141: FROM dual

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
142: UNION ALL
143: SELECT 'CSE_IPV_ADJUSTMENT' txn_source , distribution_line_number
144: sys_reference3
145: FROM ap_invoice_distributions_all aida