DBA Data[Home] [Help]

APPS.DPP_TRANSACTION_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 288: FROM ap_supplier_sites_all apssa,

284: SELECT apssa.vendor_site_id
285: ,apssa.vendor_site_code
286: INTO p_txn_header_rec_type.vendor_site_id
287: ,p_txn_header_rec_type.vendor_site_code
288: FROM ap_supplier_sites_all apssa,
289: ozf_supp_trd_prfls_all ostp
290: WHERE apssa.vendor_id = to_number(p_txn_header_rec_type.vendor_id)
291: AND ostp.supplier_id = apssa.vendor_id
292: AND ostp.supplier_site_id = apssa.vendor_site_id

Line 4809: FROM ap_supplier_sites_all

4805:
4806: IF p_supplier_site IS NOT NULL THEN
4807: SELECT vendor_site_id
4808: INTO l_supplier_site_id
4809: FROM ap_supplier_sites_all
4810: WHERE vendor_id = to_number(l_supplier_id)
4811: AND vendor_site_code =p_supplier_site;
4812: END IF;
4813: