APPS.PO_CLOSEOUT_PVT dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 685: FROM ap_invoice_distributions_all aid,

681: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
682:
683: SELECT Count(1)
684: INTO l_count
685: FROM ap_invoice_distributions_all aid,
686: ap_invoices_all aia,
687: po_distributions_all pod,
688: po_line_locations_all poll
689: WHERE aid.po_distribution_id = pod.po_distribution_id

Line 700: FROM ap_invoice_distributions_all aid,

696:
697: IF l_count > 0 THEN
698: SELECT Count(1)
699: INTO l_count
700: FROM ap_invoice_distributions_all aid,
701: ap_invoices_all aia,
702: po_distributions_all pod,
703: po_line_locations_all poll
704: WHERE aid.po_distribution_id = pod.po_distribution_id

Line 2054: FROM ap_invoice_distributions_all aid,

2050: WHERE pmmd.multi_mod_request_id = p_req_id
2051: AND pmmd.document_id = pha.po_header_id
2052: AND pha.type_lookup_code = 'STANDARD'
2053: AND NOT EXISTS (SELECT 1
2054: FROM ap_invoice_distributions_all aid,
2055: ap_invoices_all aia,
2056: po_distributions_all pod,
2057: po_line_locations_all poll
2058: WHERE aid.po_distribution_id = pod.po_distribution_id

Line 2092: FROM ap_invoice_distributions_all aid,

2088: WHERE pmmd.multi_mod_request_id = p_req_id
2089: AND pmmd.document_id = pha.po_header_id
2090: AND pha.type_lookup_code = 'STANDARD'
2091: AND EXISTS (SELECT 1
2092: FROM ap_invoice_distributions_all aid,
2093: ap_invoices_all aia,
2094: po_distributions_all pod,
2095: po_line_locations_all poll
2096: WHERE aid.po_distribution_id = pod.po_distribution_id