APPS.WSH_WSHRDXCP_XMLP_PKG dependencies on STANDARD

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

219: and we.TRIP_ID = WT.TRIP_ID (+)
220: and we.TRIP_STOP_ID = WTS.STOP_ID (+)
221: and we.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID (+)
222: and ( WND.SHIPMENT_DIRECTION is null or WND.SHIPMENT_DIRECTION IN (''O'', ''IO'') ) --Bug# 3748009
223: and ( WND.DELIVERY_TYPE is null or WND.DELIVERY_TYPE = ''STANDARD'') -- R12 MDC changes
224: and ( WT.SHIPMENTS_TYPE_FLAG is null or WT.SHIPMENTS_TYPE_FLAG IN (''O'', ''M'') ) --Bug# 3748009
225: and ( WTS.SHIPMENTS_TYPE_FLAG is null or WTS.SHIPMENTS_TYPE_FLAG IN (''O'', ''M'') ) --Bug# 3748009
226: and ( WDD.LINE_DIRECTION is null or WDD.LINE_DIRECTION IN (''O'', ''IO'') ) ';
227: L_DEL_LINES_CONT := L_DEL_LINES_CONT || P_BATCHES;

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

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
367: AND WND.DELIVERY_TYPE = 'STANDARD';
368: BEGIN
369: IF DELIVERY_DETAIL_ID IS NOT NULL AND DEL_NAME IS NULL THEN
370: OPEN C_DELIVERY(DELIVERY_DETAIL_ID);
371: FETCH C_DELIVERY