DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on AP_ENCUMBRANCE_LINES_ALL

Line 2194: FROM ap_encumbrance_lines_all ael

2190: AND dist.po_distribution_id = P_PO_Distribution_Id
2191: AND dist.po_distribution_id = pod.po_distribution_id --Added for bug 7592825
2192: AND dist.line_type_lookup_code NOT IN ('IPV', 'ERV', 'TIPV', 'TERV', 'TRV', 'QV', 'AV') -- added due to bug 5639595
2193: AND NOT EXISTS (SELECT 'X'
2194: FROM ap_encumbrance_lines_all ael
2195: WHERE ael.invoice_distribution_id = dist.invoice_distribution_id
2196: AND encumbrance_type_id = 1001 );
2197:
2198: