[Home] [Help]
141: userIdIn, userIdIn,-1,sysdate, sysdate,3,
142: delivery_detail_id, delivery_id
143: FROM ( SELECT DISTINCT det.delivery_detail_id AS delivery_detail_id, da.delivery_id AS delivery_id
144: FROM MST_DELIVERY_DETAILS det,
145: MST_DELIVERY_ASSIGNMENTS da,
146: WSH_REGION_LOCATIONS origReg,
147: WSH_REGION_LOCATIONS destReg
148: WHERE det.PLAN_ID = plan_idIn
149: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
221: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id, 219,
222: det.delivery_detail_id, da.delivery_id,
223: userIdIn, userIdIn,-1,sysdate, sysdate,3
224: FROM MST_DELIVERY_DETAILS det,
225: MST_DELIVERY_ASSIGNMENTS da
226: WHERE det.plan_id = plan_idIn
227: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
228: AND det.delivery_detail_id = da.delivery_detail_id (+)
229: AND da.parent_delivery_detail_id is null
242: det.delivery_detail_id, da.delivery_id,
243: userIdIn, userIdIn,-1,sysdate, sysdate,3
244: FROM MST_DELIVERY_DETAILS det,
245: MTL_SYSTEM_ITEMS it,
246: MST_DELIVERY_ASSIGNMENTS da
247: WHERE det.plan_id = plan_idIn
248: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
249: AND det.delivery_detail_id = da.delivery_detail_id (+)
250: AND it.inventory_item_id = det.inventory_item_id
446: --obtain delivery_id
447: BEGIN
448: SELECT da.delivery_id
449: INTO deliveryId
450: FROM mst_delivery_assignments da,
451: mst_delivery_details det
452: WHERE det.delivery_detail_id = da.delivery_detail_id (+)
453: AND det.plan_id = plan_idIn
454: AND c1rec.delivery_detail_id = det.delivery_detail_id;
524: NVL(det.net_weight,0) weight,
525: NVL(det.volume,0) volume
526: FROM MST_DELIVERY_DETAILS det,
527: MTL_SYSTEM_ITEMS si,
528: MST_DELIVERY_ASSIGNMENTS da
529: WHERE det.PLAN_ID = plan_idIn
530: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
531: AND det.delivery_detail_id = da.delivery_detail_id (+)
532: AND (det.requested_quantity = 1 OR det.container_flag = 1)
671: NVL(det.net_weight,0) weight,
672: NVL(det.volume,0) volume
673: FROM MST_DELIVERY_DETAILS det,
674: MTL_SYSTEM_ITEMS si,
675: MST_DELIVERY_ASSIGNMENTS da
676: WHERE det.PLAN_ID = plan_idIn
677: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
678: AND det.delivery_detail_id = da.delivery_detail_id (+)
679: AND det.requested_quantity > 1
977: det.ship_from_location_id ship_from_location_id,
978: det.ship_to_location_id ship_to_location_id,
979: latest_acceptable_date, earliest_pickup_date
980: FROM MST_DELIVERY_DETAILS det,
981: MST_DELIVERY_ASSIGNMENTS da,
982: WSH_LOCATIONS loc1,
983: WSH_LOCATIONS loc2
984: WHERE det.plan_id = plan_idIn
985: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
1137: SELECT DISTINCT da.delivery_id, det.delivery_detail_id,
1138: det.ship_from_location_id, det.ship_to_location_id,
1139: ((det.latest_acceptable_date - plan.start_date)*24) AS availTime
1140: FROM MST_DELIVERY_DETAILS det,
1141: MST_DELIVERY_ASSIGNMENTS da,
1142: MST_PLANS plan
1143: WHERE det.plan_id = plan_idIn
1144: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
1145: AND det.delivery_detail_id = da.delivery_detail_id (+)
1345: CURSOR cursor_DL IS
1346: SELECT det.delivery_detail_id, det.ship_from_location_id, da.delivery_id,
1347: det.earliest_pickup_date, det.latest_pickup_date
1348: FROM MST_DELIVERY_DETAILS det,
1349: MST_DELIVERY_ASSIGNMENTS da
1350: WHERE da.delivery_detail_id = det.delivery_detail_id (+)
1351: AND da.parent_delivery_detail_id is null
1352: AND det.plan_id = plan_idIn
1353: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null; --added so we consider only input data from TE
1546: CURSOR cursor_DL IS
1547: SELECT det.delivery_detail_id, det.ship_to_location_id, da.delivery_id,
1548: det.earliest_acceptable_date, det.latest_acceptable_date
1549: FROM MST_DELIVERY_DETAILS det,
1550: MST_DELIVERY_ASSIGNMENTS da
1551: WHERE da.delivery_detail_id = det.delivery_detail_id (+)
1552: AND da.parent_delivery_detail_id is null
1553: AND det.plan_id = plan_idIn
1554: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null; --added so we consider only input data from TE