DBA Data[Home] [Help]

APPS.AP_CREATE_PAY_SCHEDS_PKG dependencies on PO_VENDORS

Line 1311: po_vendors pv

1307: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1308: FROM ap_payment_schedules aps,
1309: ap_invoices ai,
1310: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1311: po_vendors pv
1312: WHERE ai.invoice_id = p_invoice_id
1313: AND ai.vendor_id = pv.vendor_id
1314: AND pv.party_id = ipab.party_id(+)
1315: AND ai.invoice_id = aps.invoice_id

Line 1325: po_vendors pv

1321: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1322: FROM ap_payment_schedules aps,
1323: ap_invoices ai,
1324: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1325: po_vendors pv
1326: WHERE ai.invoice_id = p_invoice_id
1327: AND ai.vendor_id = pv.vendor_id
1328: AND pv.party_id = ipab.party_id(+)
1329: AND (ai.vendor_site_id = ipab.supplier_site_id