APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 206: WSH_DELIVERY_DETAILS WDD

202: wsh_lookups le,
203: WSH_NEW_DELIVERIES WND,
204: WSH_TRIPS WT,
205: WSH_TRIP_STOPS WTS,
206: WSH_DELIVERY_DETAILS WDD
207: where
208: sta.lookup_type = ''EXCEPTION_STATUS''
209: and sta.lookup_code = we.status
210: and sev.lookup_type IN ( ''EXCEPTION_SEVERITY'',''EXCEPTION_BEHAVIOR'')

Line 244: FROM wsh_exceptions we1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd1

240: AND we1.status <> ''CLOSED''
241: )
242: OR we.exception_id IN (
243: SELECT we1.exception_id
244: FROM wsh_exceptions we1, wsh_delivery_assignments_v wda, wsh_delivery_details wdd1
245: WHERE we1.delivery_detail_id = wdd1.delivery_detail_id --LPN Synch Up.added delivery_detail_id instead of container_name..samanna
246: AND wdd1.container_flag = ''Y''
247: AND wdd1.delivery_detail_id = wda.delivery_detail_id ';
248: IF P_DELIVERY_ID_LOW IS NOT NULL THEN

Line 323: WSH_DELIVERY_DETAILS WDD

319: SELECT
320: CONTAINER_NAME,
321: CONTAINER_FLAG
322: FROM
323: WSH_DELIVERY_DETAILS WDD
324: WHERE WDD.DELIVERY_DETAIL_ID = X_DETAIL_ID;
325: L_INFO C_NAME%ROWTYPE;
326: BEGIN
327: IF CONTAINER_NAME IS NOT NULL THEN

Line 362: WSH_DELIVERY_DETAILS WDD,

358: SELECT
359: NAME
360: FROM
361: WSH_NEW_DELIVERIES WND,
362: WSH_DELIVERY_DETAILS WDD,
363: WSH_DELIVERY_ASSIGNMENTS_V WDA
364: WHERE WDD.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
365: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
366: AND WDA.DELIVERY_ID = WND.DELIVERY_ID