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_SITE_USES_ALL

Line 277: HZ_CUST_SITE_USES_ALL SU

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
281: AND WND.DELIVERY_ID = WDA.DELIVERY_ID

Line 296: hz_cust_site_uses_all su

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
300: AND su.cust_acct_site_id = ca.cust_acct_site_id

Line 310: hz_cust_site_uses_all su

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'
314: AND su.site_use_id =WDD.SHIP_TO_SITE_USE_ID