DBA Data[Home] [Help]

APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 226: WSH_DELIVERY_ASSIGNMENTS_V WDA --Bug 8800213

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
230: and sev.lookup_type IN ( ''EXCEPTION_SEVERITY'',''EXCEPTION_BEHAVIOR'')

Line 402: WSH_DELIVERY_ASSIGNMENTS_V WDA

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
406: AND WND.DELIVERY_TYPE = 'STANDARD';