APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 225: WSH_DELIVERY_DETAILS WDD,

221: wsh_lookups le,
222: WSH_NEW_DELIVERIES WND,
223: WSH_TRIPS WT,
224: WSH_TRIP_STOPS WTS,
225: WSH_DELIVERY_DETAILS WDD,
226: WSH_DELIVERY_ASSIGNMENTS_V WDA --Bug 8800213
227: where
228: sta.lookup_type = ''EXCEPTION_STATUS''
229: and sta.lookup_code = we.status

Line 362: WSH_DELIVERY_DETAILS WDD

358: SELECT
359: CONTAINER_NAME,
360: CONTAINER_FLAG
361: FROM
362: WSH_DELIVERY_DETAILS WDD
363: WHERE WDD.DELIVERY_DETAIL_ID = X_DETAIL_ID;
364: L_INFO C_NAME%ROWTYPE;
365: BEGIN
366: IF CONTAINER_NAME IS NOT NULL THEN

Line 401: WSH_DELIVERY_DETAILS WDD,

397: SELECT
398: NAME
399: FROM
400: WSH_NEW_DELIVERIES WND,
401: WSH_DELIVERY_DETAILS WDD,
402: WSH_DELIVERY_ASSIGNMENTS_V WDA
403: WHERE WDD.DELIVERY_DETAIL_ID = P_DELIVERY_DETAIL_ID
404: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
405: AND WDA.DELIVERY_ID = WND.DELIVERY_ID