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_ACCT_SITES

Line 13: HZ_CUST_ACCT_SITES ACCT_SITE

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
17: AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID

Line 269: HZ_CUST_ACCT_SITES ACCT_SITE

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'
271: AND CUST_SITE.SITE_USE_ID = SHIP_TO_ORG_ID3
272: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
273: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 294: HZ_CUST_ACCT_SITES ACCT_SITE

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'
296: AND CUST_SITE.SITE_USE_ID = INTMED_SHIP_TO_ORG_ID
297: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
298: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID