DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_INVOICE_DISTRIBUTIONS

Line 1456: FROM ap_invoice_distributions aid

1452: INTO l_available_prepays
1453: FROM ap_invoices I,
1454: ap_suppliers PV
1455: WHERE exists (SELECT 'x'
1456: FROM ap_invoice_distributions aid
1457: WHERE aid.invoice_id = i.invoice_id
1458: AND aid.line_type_lookup_code IN ('ITEM','TAX')
1459: AND NVL(aid.reversal_flag,'N') <> 'Y'
1460: AND nvl(aid.prepay_amount_remaining, aid.amount) > 0 )

Line 1485: FROM ap_invoice_distributions aid

1481: INTO l_available_prepays
1482: FROM ap_invoices I,
1483: ap_suppliers PV
1484: WHERE exists (SELECT 'x'
1485: FROM ap_invoice_distributions aid
1486: WHERE aid.invoice_id = i.invoice_id
1487: AND aid.line_type_lookup_code IN ('ITEM','TAX')
1488: AND NVL(aid.reversal_flag,'N') <> 'Y'
1489: AND nvl(aid.prepay_amount_remaining, aid.amount) > 0 )