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_RLMNETCH_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES

Line 88: HZ_CUST_ACCT_SITES ACCT_SITE

84: SELECT
85: ACCT_SITE.ECE_TP_LOCATION_CODE
86: FROM
87: HZ_CUST_SITE_USES_ALL CUST_SITE,
88: HZ_CUST_ACCT_SITES ACCT_SITE
89: WHERE CUST_SITE.SITE_USE_CODE = L_SHIP_TO
90: AND ACCT_SITE.STATUS = L_STATUS
91: AND CUST_SITE.SITE_USE_ID = NU_SHIP_TO
92: AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID

Line 432: HZ_CUST_ACCT_SITES ACCT_SITE

428: SELECT
429: ACCT_SITE.ECE_TP_LOCATION_CODE
430: INTO V_INTRMD_SHIP_TO_EXT
431: FROM
432: HZ_CUST_ACCT_SITES ACCT_SITE
433: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = ITRMD_SHIP_TO_ID;
434: RETURN (V_INTRMD_SHIP_TO_EXT);
435: EXCEPTION
436: WHEN OTHERS THEN

Line 495: HZ_CUST_ACCT_SITES ACCT_SITE

491: CUST_SITE.LOCATION
492: INTO V_SHIP_TO_NAME
493: FROM
494: HZ_CUST_SITE_USES_ALL CUST_SITE,
495: HZ_CUST_ACCT_SITES ACCT_SITE
496: WHERE CUST_SITE.SITE_USE_CODE = 'SHIP_TO'
497: AND CUST_SITE.SITE_USE_ID = SHIP_TO_ORG_ID1
498: AND ACCT_SITE.STATUS = 'A'
499: AND ACCT_SITE.CUST_ACCT_SITE_ID = CUST_SITE.CUST_ACCT_SITE_ID