eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_UTILITY_PVT dependencies on AP_SUPPLIER_SITES_ALL

Line 481: FROM ap_supplier_sites_all apssa,

477: apssa.city,
478: apssa.state,
479: apssa.zip,
480: apssa.country
481: FROM ap_supplier_sites_all apssa,
482: ozf_supp_trd_prfls_all ostp
483: WHERE apssa.vendor_id = to_NUMBER(p_search_text1)
484: AND ostp.supplier_id = apssa.vendor_id
485: AND ostp.supplier_site_id = apssa.vendor_site_id

Line 572: ap_supplier_sites_all assa

568: ||poc.phone phone,
569: poc.email_address,
570: poc.fax
571: FROM po_vendor_contacts poc,
572: ap_supplier_sites_all assa
573: WHERE assa.vendor_site_id = TO_NUMBER(p_search_text1)
574: AND assa.party_site_id = poc.org_party_site_id
575: AND assa.vendor_site_id = poc.vendor_site_id
576: AND p_search_criteria1 = 'VENDOR_SITE_ID'

Line 2028: ap_supplier_sites_all

2024: state,
2025: zip,
2026: country
2027: FROM
2028: ap_supplier_sites_all
2029: WHERE
2030: vendor_id = p_vendor_id AND
2031: nvl(rfq_only_site_flag, 'N') ='N' AND
2032: vendor_site_id = p_vendor_site_id;

Line 2097: FROM ap_supplier_sites_all assa,

2093: poc.last_name ,
2094: poc.area_code||poc.phone phone,
2095: poc.email_address ,
2096: poc.fax
2097: FROM ap_supplier_sites_all assa,
2098: po_vendor_contacts poc
2099: WHERE assa.vendor_site_id = p_vendor_site_id
2100: AND assa.vendor_site_id = poc.vendor_site_id
2101: AND assa.party_site_id = poc.org_party_site_id