DBA Data[Home] [Help]

APPS.CSE_AP_PA_PKG dependencies on DUAL

Line 116: FROM dual

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

Line 140: FROM dual

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