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.WSH_OTM_REF_DATA_GEN_PKG dependencies on HZ_CUST_ACCOUNTS

Line 116: FROM HZ_CUST_ACCOUNTS HCA,

112: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID);
113:
114: cursor l_stop_dd_cust_csr(p_stop_id IN NUMBER) is
115: SELECT HCA.CUST_ACCOUNT_ID
116: FROM HZ_CUST_ACCOUNTS HCA,
117: HZ_PARTIES HP,
118: HZ_PARTY_SITES HPS,
119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,

Line 141: FROM HZ_CUST_ACCOUNTS HCA,

137: AND HCA.CUST_ACCOUNT_ID = WDD.CUSTOMER_ID;
138:
139: cursor l_stop_cust_csr(p_stop_id IN NUMBER) is
140: SELECT HCA.CUST_ACCOUNT_ID
141: FROM HZ_CUST_ACCOUNTS HCA,
142: HZ_PARTIES HP,
143: HZ_PARTY_SITES HPS,
144: WSH_LOCATIONS WL,
145: WSH_TRIP_STOPS WTS

Line 1452: HZ_CUST_ACCOUNTS HCA

1448: WSH_LOCATIONS WL,
1449: FND_TERRITORIES FNDTR,
1450: WSH_OTM_LOCATIONS_GTMP WLT,
1451: HZ_PARTIES HP,
1452: HZ_CUST_ACCOUNTS HCA
1453: WHERE HZL.LOCATION_ID = WL.SOURCE_LOCATION_ID
1454: AND WL.LOCATION_SOURCE_CODE = 'HZ'
1455: AND FNDTR.TERRITORY_CODE (+) = HZL.COUNTRY
1456: AND WL.WSH_LOCATION_ID = WLT.LOCATION_ID