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.QP_PRICE_BOOK_UTIL dependencies on HZ_PARTY_SITES

Line 1356: hz_parties hp, hz_party_sites hps, hz_locations hl

1352: SELECT 1
1353: INTO l_count
1354: FROM ecx_tp_headers eth, ecx_tp_details etd,
1355: ecx_ext_processes eep, ecx_transactions et,
1356: hz_parties hp, hz_party_sites hps, hz_locations hl
1357: WHERE eth.party_id = p_pb_input_header_rec.customer_attr_value
1358: AND eth.party_site_id = p_pb_input_header_rec.dlv_xml_site_id
1359: AND eth.tp_header_id = etd.tp_header_id
1360: AND etd.EXT_PROCESS_ID = eep.EXT_PROCESS_ID

Line 2748: HZ_PARTY_SITES PARTY_SITE

2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,
2745: ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
2746: FROM HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2747: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
2748: HZ_PARTY_SITES PARTY_SITE
2749: WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2750: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2751: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
2752: AND NVL(ACCT_SITE.ORG_ID,- 99) = NVL(LOC_ASSIGN.ORG_ID,- 99)