DBA Data[Home] [Help]

APPS.AP_CREATE_PAY_SCHEDS_PKG dependencies on PO_VENDORS

Line 1359: po_vendors pv

1355: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7261556/7375488
1356: FROM ap_payment_schedules aps,
1357: ap_invoices ai,
1358: --iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1359: po_vendors pv
1360: WHERE ai.invoice_id = p_invoice_id
1361: AND ai.vendor_id = pv.vendor_id -- changed for bug 9531288
1362: --AND pv.party_id = ipab.party_id(+)
1363: AND ai.invoice_id = aps.invoice_id

Line 1376: po_vendors pv

1372: SELECT ai.external_bank_account_id, 'Y' --modified for the bug 7437597
1373: FROM ap_payment_schedules aps,
1374: ap_invoices ai,
1375: iby_payee_assigned_bankacct_v ipab, /* External Bank Uptake */
1376: po_vendors pv
1377: WHERE ai.invoice_id = p_invoice_id
1378: AND ai.vendor_id = pv.vendor_id
1379: AND pv.party_id = ipab.party_id(+)
1380: AND (ai.vendor_site_id = ipab.supplier_site_id