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_ACCT_SITES_ALL

Line 276: HZ_CUST_ACCT_SITES_ALL CA,

272: WSH_OTM_LOCATIONS_GTMP WLT1,
273: WSH_OTM_LOCATIONS_GTMP WLT2,
274: WSH_DELIVERY_DETAILS WDD,
275: WSH_DELIVERY_ASSIGNMENTS WDA,
276: HZ_CUST_ACCT_SITES_ALL CA,
277: HZ_CUST_SITE_USES_ALL SU
278: WHERE CA.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
279: AND SU.SITE_USE_ID = WDD.SHIP_TO_SITE_USE_ID
280: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID

Line 295: hz_cust_acct_sites_all ca,

291: CURSOR get_customer_id (p_delivery_id NUMBER) IS
292: SELECT ca.cust_account_id customer_id
293: FROM wsh_delivery_assignments wda,
294: wsh_delivery_details wdd,
295: hz_cust_acct_sites_all ca,
296: hz_cust_site_uses_all su
297: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
298: AND wda.delivery_id = p_delivery_id
299: AND su.site_use_id = WDD.SHIP_TO_SITE_USE_ID

Line 309: hz_cust_acct_sites_all ca,

305: --WDD.CUSTOMER_ID
306: ca.cust_account_id CUSTOMER_ID
307: FROM WSH_DELIVERY_DETAILS WDD,
308: WSH_DELIVERY_ASSIGNMENTS WDA,
309: hz_cust_acct_sites_all ca,
310: hz_cust_site_uses_all su
311: WHERE WDA.DELIVERY_ID = p_delivery_id
312: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
313: AND WDD.container_flag = 'N'

Line 345: HZ_CUST_ACCT_SITES_ALL HCAS,

341: FROM WSH_DELIVERY_DETAILS WDD,
342: WSH_DELIVERY_ASSIGNMENTS WDA,
343: HZ_PARTY_SITES HPS,
344: WSH_LOCATIONS WSL,
345: HZ_CUST_ACCT_SITES_ALL HCAS,
346: HZ_CUST_ACCOUNT_ROLES HCAR
347: WHERE WDA.delivery_id = p_delivery_id
348: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
349: AND WDD.SHIP_TO_LOCATION_ID = WSL.WSH_LOCATION_ID