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_SITE_USES_ALL

Line 87: HZ_CUST_SITE_USES_ALL CUST_SITE,

83: CURSOR CUR_P_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
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

Line 494: HZ_CUST_SITE_USES_ALL CUST_SITE,

490: SELECT
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'