DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on HZ_PARTIES

Line 607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia

603: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
604:
605: CURSOR customer_num_cur IS
606: SELECT DISTINCT part.party_number Customer_Number
607: FROM HZ_CUST_ACCOUNTS cust, HZ_PARTIES part, AP_INVOICES_ALL aia
608: WHERE cust.cust_account_id = aia.party_id
609: AND cust.party_id = part.party_id
610: AND aia.Invoice_Id = pn_invoice_id; --parameter: pn_invoice_id
611:

Line 2123: FROM HZ_PARTIES part

2119: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2120:
2121: CURSOR supplier_num_cur IS
2122: SELECT part.party_number Supplier_Number
2123: FROM HZ_PARTIES part
2124: WHERE part.party_id = pn_supplier_id --parameter: pn_supplier_id
2125: UNION
2126: SELECT Sup.Segment1 Supplier_Number
2127: FROM ap_suppliers Sup