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 WSH_DELIVERY_ASSIGNMENTS

Line 123: WSH_DELIVERY_ASSIGNMENTS WDA,

119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,
121: WSH_DELIVERY_LEGS WDL,
122: WSH_TRIP_STOPS WTS,
123: WSH_DELIVERY_ASSIGNMENTS WDA,
124: WSH_DELIVERY_DETAILS WDD
125: WHERE WTS.STOP_ID = p_stop_id
126: AND HPS.LOCATION_ID = WL.SOURCE_LOCATION_ID
127: AND WL.LOCATION_SOURCE_CODE = 'HZ'

Line 282: WSH_DELIVERY_ASSIGNMENTS WDA

278: cursor l_get_dd_loc_info_csr(p_delivery_id IN NUMBER) is
279: SELECT DISTINCT WDD.SHIP_TO_LOCATION_ID,
280: WDD.CUSTOMER_ID
281: FROM WSH_DELIVERY_DETAILS WDD,
282: WSH_DELIVERY_ASSIGNMENTS WDA
283: WHERE WDA.DELIVERY_ID = p_delivery_id
284: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
285: AND WDD.container_flag = 'N'
286: AND NOT EXISTS (

Line 297: FROM WSH_DELIVERY_ASSIGNMENTS WDA,

293:
294:
295: cursor l_ship_site_use_csr (p_delivery_id IN NUMBER) is
296: SELECT WDD.SHIP_TO_SITE_USE_ID, COUNT(*) CNT
297: FROM WSH_DELIVERY_ASSIGNMENTS WDA,
298: WSH_DELIVERY_DETAILS WDD
299: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
300: AND WDA.DELIVERY_ID = P_DELIVERY_ID
301: AND WDD.CONTAINER_FLAG = 'N'

Line 312: WSH_DELIVERY_ASSIGNMENTS WDA,

308: cursor l_del_contact_csr(p_delivery_id IN NUMBER) is
309: SELECT DISTINCT HCAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID,
310: WDD.CUSTOMER_ID CUSTOMER_ID
311: FROM WSH_DELIVERY_DETAILS WDD,
312: WSH_DELIVERY_ASSIGNMENTS WDA,
313: HZ_PARTY_SITES HPS,
314: WSH_LOCATIONS WSL,
315: HZ_CUST_ACCT_SITES_ALL HCAS,
316: HZ_CUST_ACCOUNT_ROLES HCAR