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.RLM_RLMDMSIQ_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 12: HZ_CUST_SITE_USES_ALL CUST_SITE,

8: CURSOR CUR_P_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
9: SELECT
10: ACCT_SITE.ECE_TP_LOCATION_CODE
11: FROM
12: HZ_CUST_SITE_USES_ALL CUST_SITE,
13: HZ_CUST_ACCT_SITES ACCT_SITE
14: WHERE CUST_SITE.SITE_USE_CODE = L_SHIP_TO
15: AND ACCT_SITE.STATUS = L_STATUS
16: AND CUST_SITE.SITE_USE_ID = NU_SHIP_TO

Line 266: HZ_CUST_SITE_USES_ALL CUST_SITE,

262: SELECT
263: LOC.ADDRESS1
264: INTO V_VALUE
265: FROM
266: HZ_CUST_SITE_USES_ALL CUST_SITE,
267: HZ_PARTY_SITES PARTY_SITE,
268: HZ_LOCATIONS LOC,
269: HZ_CUST_ACCT_SITES ACCT_SITE
270: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'

Line 291: HZ_CUST_SITE_USES_ALL CUST_SITE,

287: SELECT
288: LOC.ADDRESS1
289: INTO V_VALUE
290: FROM
291: HZ_CUST_SITE_USES_ALL CUST_SITE,
292: HZ_PARTY_SITES PARTY_SITE,
293: HZ_LOCATIONS LOC,
294: HZ_CUST_ACCT_SITES ACCT_SITE
295: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'