DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on AP_SUPPLIER_SITES

Line 293: FROM ap_supplier_sites_all apssa,

289: SELECT apssa.vendor_site_id
290: ,apssa.vendor_site_code
291: INTO p_txn_header_rec_type.vendor_site_id
292: ,p_txn_header_rec_type.vendor_site_code
293: FROM ap_supplier_sites_all apssa,
294: ozf_supp_trd_prfls_all ostp
295: WHERE apssa.vendor_id = to_number(p_txn_header_rec_type.vendor_id)
296: AND ostp.supplier_id = apssa.vendor_id
297: AND ostp.supplier_site_id = apssa.vendor_site_id

Line 5096: FROM ap_supplier_sites

5092:
5093: IF p_supplier_site IS NOT NULL THEN
5094: SELECT vendor_site_id
5095: INTO l_supplier_site_id
5096: FROM ap_supplier_sites
5097: WHERE vendor_id = to_number(l_supplier_id)
5098: AND vendor_site_code =p_supplier_site;
5099: END IF;
5100: