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 460: FROM ap_supplier_sites_all apssa,

456: apssa.city,
457: apssa.state,
458: apssa.zip,
459: apssa.country
460: FROM ap_supplier_sites_all apssa,
461: ozf_supp_trd_prfls_all ostp
462: WHERE apssa.vendor_id = to_NUMBER(p_search_text1)
463: AND ostp.supplier_id = apssa.vendor_id
464: AND ostp.supplier_site_id = apssa.vendor_site_id

Line 544: ap_supplier_sites_all assa

540: ||poc.phone phone,
541: poc.email_address,
542: poc.fax
543: FROM po_vendor_contacts poc,
544: ap_supplier_sites_all assa
545: WHERE assa.vendor_site_id = TO_NUMBER(p_search_text1)
546: AND assa.party_site_id = poc.org_party_site_id
547: AND assa.vendor_site_id = poc.vendor_site_id
548: AND p_search_criteria1 = 'VENDOR_SITE_ID'

Line 2116: ap_supplier_sites_all

2112: state,
2113: zip,
2114: country
2115: FROM
2116: ap_supplier_sites_all
2117: WHERE
2118: vendor_id = p_vendor_id AND
2119: nvl(rfq_only_site_flag, 'N') ='N' AND
2120: vendor_site_id = p_vendor_site_id;

Line 2183: FROM ap_supplier_sites_all assa,

2179: poc.last_name ,
2180: poc.area_code||poc.phone phone,
2181: poc.email_address ,
2182: poc.fax
2183: FROM ap_supplier_sites_all assa,
2184: po_vendor_contacts poc
2185: WHERE assa.vendor_site_id = p_vendor_site_id
2186: AND assa.vendor_site_id = poc.vendor_site_id
2187: AND assa.party_site_id = poc.org_party_site_id