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.OE_CNCL_VALUE_TO_ID dependencies on HZ_LOCATIONS

Line 5371: HZ_LOCATIONS LOC,

5367: INTO l_id
5368: FROM
5369: HZ_CUST_SITE_USES_ALL SITE,
5370: HZ_PARTY_SITES PARTY_SITE,
5371: HZ_LOCATIONS LOC,
5372: HZ_CUST_ACCT_SITES ACCT_SITE
5373: WHERE
5374: SITE.SITE_USE_CODE = 'SOLD_TO'
5375: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 5564: FROM hz_locations loc,

5560:
5561: -- cursor to get the site_id for end_customer
5562: CURSOR c_site_use_id(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5563: SELECT site_use.site_use_id
5564: FROM hz_locations loc,
5565: hz_party_sites site,
5566: hz_cust_acct_sites acct_site,
5567: hz_cust_site_uses site_use
5568: WHERE

Line 5594: FROM hz_locations loc,

5590: and site_use.site_use_code = in_end_customer_site_use_code;
5591:
5592: CURSOR c_site_use_id2(in_end_customer_id number,in_end_customer_site_use_code varchar2) IS
5593: SELECT site_use.site_use_id
5594: FROM hz_locations loc,
5595: hz_party_sites site,
5596: hz_cust_acct_sites acct_site,
5597: hz_cust_site_uses site_use
5598: WHERE loc.ADDRESS1 = p_end_customer_site_address1