DBA Data[Home] [Help]

APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on STANDARD

Line 243: and ( WND.DELIVERY_TYPE is null or WND.DELIVERY_TYPE = ''STANDARD'') -- R12 MDC changes

239: and we.TRIP_ID = WT.TRIP_ID (+)
240: and we.TRIP_STOP_ID = WTS.STOP_ID (+)
241: and we.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID (+)
242: and ( WND.SHIPMENT_DIRECTION is null or WND.SHIPMENT_DIRECTION IN (''O'', ''IO'') ) --Bug# 3748009
243: and ( WND.DELIVERY_TYPE is null or WND.DELIVERY_TYPE = ''STANDARD'') -- R12 MDC changes
244: and ( WT.SHIPMENTS_TYPE_FLAG is null or WT.SHIPMENTS_TYPE_FLAG IN (''O'', ''M'') ) --Bug# 3748009
245: and ( WTS.SHIPMENTS_TYPE_FLAG is null or WTS.SHIPMENTS_TYPE_FLAG IN (''O'', ''M'') ) --Bug# 3748009
246: and ( WDD.LINE_DIRECTION is null or WDD.LINE_DIRECTION IN (''O'', ''IO'') ) ';
247:

Line 406: AND WND.DELIVERY_TYPE = 'STANDARD';

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';
407: BEGIN
408: IF DELIVERY_DETAIL_ID IS NOT NULL AND DEL_NAME IS NULL THEN
409: OPEN C_DELIVERY(DELIVERY_DETAIL_ID);
410: FETCH C_DELIVERY