APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICE_DISTRIBUTIONS

Line 91: FROM ap_invoice_distributions_all AID, ap_invoice_distributions_all APD

87: AND aeh.vouchno is not null
88: AND hou.organization_id(+) = aeh.org_id
89: AND I.invoice_id = aeh.vouchno
90: AND P.invoice_id IN ( SELECT apd.invoice_id
91: FROM ap_invoice_distributions_all AID, ap_invoice_distributions_all APD
92: WHERE AID.invoice_id = I.invoice_id
93: AND AID.prepay_distribution_id = APD.invoice_distribution_id
94: AND AID.line_type_lookup_code = 'PREPAY')
95: AND V.vendor_id = I.vendor_id

Line 2512: FROM ap_invoice_distributions aid

2508: INTO l_available_prepays
2509: FROM ap_invoices I,
2510: ap_suppliers PV
2511: WHERE exists (SELECT 'x'
2512: FROM ap_invoice_distributions aid
2513: WHERE aid.invoice_id = i.invoice_id
2514: AND aid.line_type_lookup_code IN ('ITEM','TAX')
2515: AND NVL(aid.reversal_flag,'N') <> 'Y'
2516: AND nvl(aid.prepay_amount_remaining, aid.amount) > 0 )

Line 2541: FROM ap_invoice_distributions aid

2537: INTO l_available_prepays
2538: FROM ap_invoices I,
2539: ap_suppliers PV
2540: WHERE exists (SELECT 'x'
2541: FROM ap_invoice_distributions aid
2542: WHERE aid.invoice_id = i.invoice_id
2543: AND aid.line_type_lookup_code IN ('ITEM','TAX')
2544: AND NVL(aid.reversal_flag,'N') <> 'Y'
2545: AND nvl(aid.prepay_amount_remaining, aid.amount) > 0 )