eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MST_AUDIT_REP_EXCP dependencies on MST_DELIVERY_DETAILS

Line 58: MST_DELIVERY_DETAILS det

54: location_id,
55: userIdIn, userIdIn,-1,sysdate, sysdate, 3
56: FROM (SELECT distinct wsh_location_id as location_id
57: FROM WSH_LOCATIONS loc,
58: MST_DELIVERY_DETAILS det
59: WHERE det.plan_id = plan_idIn
60: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
61: AND ( det.ship_from_location_id = loc.wsh_location_id
62: OR det.ship_to_location_id = loc.wsh_location_id)

Line 144: FROM MST_DELIVERY_DETAILS det,

140: SELECT mst_exception_details_s.nextval, excptnId , plan_idIn, 900,
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

Line 224: FROM MST_DELIVERY_DETAILS det,

220: CREATION_DATE, STATUS)
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 (+)

Line 244: FROM MST_DELIVERY_DETAILS det,

240: CREATION_DATE,STATUS)
241: SELECT mst_exception_details_s.nextval, excptnId , det.plan_id,219,
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

Line 293: FROM MST_DELIVERY_DETAILS DET,

289: --Allows access to the relevant pieces and their dimensions.
290: CURSOR c_pieces IS
291: SELECT det.delivery_detail_id,
292: IT.UNIT_LENGTH, IT.UNIT_WIDTH, IT.UNIT_HEIGHT, it.DIMENSION_UOM_CODE, it.inventory_item_id
293: FROM MST_DELIVERY_DETAILS DET,
294: MTL_SYSTEM_ITEMS IT
295: WHERE IT.INVENTORY_ITEM_ID = DET.INVENTORY_ITEM_ID
296: AND det.organization_id = it.organization_id
297: AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE

Line 451: mst_delivery_details det

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;
455: EXCEPTION

Line 511: -- FROM MST_DELIVERY_DETAILS det,

507: -- CURSOR c_pieces IS
508: -- SELECT DELIVERY_DETAIL_ID, det.inventory_item_id,
509: -- net_weight, si.unit_length, si.unit_width, si.unit_height,
510: -- requested_quantity, si.weight_uom_code, si.dimension_uom_code
511: -- FROM MST_DELIVERY_DETAILS det,
512: -- MTL_SYSTEM_ITEMS si
513: -- WHERE det.PLAN_ID = plan_idIn
514: -- AND det.SPLIT_FROM_DELIVERY_DETAIL_ID is null --added so we consider only input data from TE
515: -- AND det.requested_quantity = 1

Line 526: FROM MST_DELIVERY_DETAILS det,

522: CURSOR c_pieces (tp_vol_uom VARCHAR2, tp_wgt_uom VARCHAR2) IS
523: SELECT det.delivery_detail_id, da.delivery_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

Line 673: FROM MST_DELIVERY_DETAILS det,

669: CURSOR c_DL (tp_vol_uom VARCHAR2, tp_wgt_uom VARCHAR2) IS
670: SELECT det.delivery_detail_id, da.delivery_id,
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

Line 980: FROM MST_DELIVERY_DETAILS det,

976: SELECT distinct delivery_id, det.delivery_detail_id,
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

Line 993: TYPE delivery_detail_id_t IS TABLE OF MST_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;

989: AND loc2.wsh_location_id = det.ship_to_location_id;
990:
991: --Auxiliary data structures to cache all the data to insert in exception_details
992: TYPE delivery_id_t IS TABLE OF MST_DELIVERIES.DELIVERY_ID%TYPE INDEX BY BINARY_INTEGER;
993: TYPE delivery_detail_id_t IS TABLE OF MST_DELIVERY_DETAILS.DELIVERY_DETAIL_ID%TYPE INDEX BY BINARY_INTEGER;
994: TYPE distance_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
995: TYPE time_t IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
996:
997: all_details_delivery_id delivery_id_t;

Line 1140: FROM MST_DELIVERY_DETAILS det,

1136: CURSOR cursor_past_due_orders IS
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

Line 1348: FROM MST_DELIVERY_DETAILS det,

1344:
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

Line 1549: FROM MST_DELIVERY_DETAILS det,

1545:
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