APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on WSH_DELIVERY_DETAILS

Line 124: WSH_DELIVERY_DETAILS WDD

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'
128: AND WL.WSH_LOCATION_ID = nvl(WTS.PHYSICAL_LOCATION_ID,WTS.STOP_LOCATION_ID)

Line 281: FROM WSH_DELIVERY_DETAILS WDD,

277:
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'

Line 298: WSH_DELIVERY_DETAILS WDD

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'
302: GROUP BY WDD.SHIP_TO_SITE_USE_ID

Line 311: FROM WSH_DELIVERY_DETAILS WDD,

307: -- and WDD.CUSTOMER_ID
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,