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_WB_UTIL dependencies on MST_DELIVERY_DETAILS

Line 94: FROM mst_delivery_details mdd

90: BEGIN
91: -- Used in MyFacility Details UI
92: SELECT NVL(sum(mdd.Gross_weight),0)
93: INTO l_weight
94: FROM mst_delivery_details mdd
95: WHERE mdd.plan_id = p_plan_id
96: AND mdd.source_code = p_source_code
97: AND mdd.source_header_number = p_source_header_number;
98:

Line 116: FROM mst_delivery_details mdd

112: BEGIN
113: -- Used in MyFacility Details UI
114: SELECT NVL(sum(mdd.volume),0)
115: INTO l_volume
116: FROM mst_delivery_details mdd
117: WHERE mdd.plan_id = p_plan_id
118: AND mdd.source_code = p_source_code
119: AND mdd.source_header_number = p_source_header_number;
120:

Line 138: FROM mst_delivery_details mdd

134: BEGIN
135: -- Used in MyFacility Details UI
136: SELECT NVL(sum(mdd.number_of_pallets),0)
137: INTO l_pallets
138: FROM mst_delivery_details mdd
139: WHERE mdd.plan_id = p_plan_id
140: AND mdd.source_code = p_source_code
141: AND mdd.source_header_number = p_source_header_number;
142:

Line 160: FROM mst_delivery_details mdd

156: BEGIN
157: -- Used in MyFacility Details UI
158: SELECT NVL(sum(mdd.requested_quantity),0)
159: INTO l_pieces
160: FROM mst_delivery_details mdd
161: WHERE mdd.plan_id = p_plan_id
162: AND mdd.source_code = p_source_code
163: AND mdd.source_header_number = p_source_header_number;
164:

Line 183: FROM mst_delivery_details mdd

179: BEGIN
180: -- Used in MyFacility Details UI
181: SELECT NVL(sum(MDD.ALLOCATED_COST),0)
182: INTO l_cost
183: FROM mst_delivery_details mdd
184: WHERE mdd.plan_id = p_plan_id
185: AND mdd.source_code = p_source_code
186: AND mdd.source_header_number = p_source_header_number;
187:

Line 251: FROM mst_delivery_details dd,

247:
248: /*skakani - commented on 16-10-03 ...
249: CURSOR cur_get_trip_orders is
250: SELECT COUNT(DISTINCT dd.source_header_number)
251: FROM mst_delivery_details dd,
252: mst_delivery_assignments da
253: WHERE dd.plan_id = p_plan_Id
254: AND dd.delivery_detail_id = da.delivery_detail_id
255: AND dd.plan_id = da.plan_id

Line 264: FROM mst_delivery_details dd,

260: AND dl.trip_id = p_trip_id);*/
261:
262: CURSOR cur_get_trip_orders is
263: SELECT COUNT(distinct nvl(dd.split_from_delivery_detail_id,dd.delivery_detail_id))
264: FROM mst_delivery_details dd,
265: mst_delivery_assignments da
266: WHERE dd.plan_id = p_plan_Id
267: AND dd.delivery_detail_id = da.delivery_detail_id
268: AND dd.plan_id = da.plan_id

Line 414: FROM mst_delivery_details mdd

410: RETURN NUMBER IS
411:
412: /*CURSOR Cur_Get_Trip_Stop_Orders IS
413: SELECT COUNT(DISTINCT mdd.source_header_number)
414: FROM mst_delivery_details mdd
415: WHERE mdd.plan_id = p_plan_id
416: AND mdd.delivery_detail_id IN
417: ( SELECT mda.delivery_detail_id
418: FROM mst_deliveries md,

Line 439: FROM mst_delivery_details mdd

435: AND stop_id = p_stop_id;
436:
437: /*CURSOR Cur_Get_Trip_Stop_Orders is
438: SELECT COUNT(mdd.delivery_detail_id)
439: FROM mst_delivery_details mdd
440: WHERE mdd.plan_id = p_plan_Id
441: AND mdd.delivery_detail_id IN
442: ( SELECT mda.delivery_detail_id
443: FROM mst_delivery_assignments mda,

Line 453: FROM mst_delivery_details mdd

449: AND mdl.pick_up_stop_id = p_stop_id;*/
450:
451: CURSOR Cur_Get_pick_Orders(p_stop_sequence NUMBER) is
452: SELECT COUNT(distinct nvl(mdd.split_from_delivery_detail_id,mdd.delivery_detail_id))
453: FROM mst_delivery_details mdd
454: WHERE mdd.plan_id = p_plan_Id
455: AND mdd.delivery_detail_id IN
456: ( SELECT mda.delivery_detail_id
457: FROM mst_delivery_assignments mda,

Line 473: FROM mst_delivery_details mdd

469: AND mts1.stop_sequence_number <= p_stop_sequence));
470:
471: CURSOR Cur_Get_drop_Orders(p_stop_sequence NUMBER) is
472: SELECT COUNT(distinct nvl(mdd.split_from_delivery_detail_id,mdd.delivery_detail_id))
473: FROM mst_delivery_details mdd
474: WHERE mdd.plan_id = p_plan_Id
475: AND mdd.delivery_detail_id IN
476: ( SELECT mda.delivery_detail_id
477: FROM mst_delivery_assignments mda,

Line 529: FROM Mst_Delivery_Details DD,

525: RETURN NUMBER IS
526:
527: CURSOR Cur_Get_Orders IS
528: Select Count(distinct nvl(DD.split_from_delivery_Detail_id,DD.Delivery_Detail_Id))
529: FROM Mst_Delivery_Details DD,
530: Mst_Delivery_Assignments DA
531: WHERE DD.PLAN_ID = DA.PLAN_ID
532: AND DD.Delivery_Detail_Id = DA.Delivery_Detail_Id
533: AND DA.parent_delivery_detail_id is null

Line 1385: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1381: fnd_message.set_token('MODE_OF_TRANSPORT', l_temp);
1382: -- item_description
1383: select description, med.delivery_detail_id
1384: into l_temp1, l_id2
1385: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1386: where med.plan_id=p_plan_id
1387: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1388: and med.delivery_detail_id = mdd.delivery_detail_id
1389: and med.plan_id = mdd.plan_id

Line 1410: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1406: AND trip_id = P_TRIP_ID;
1407: -- item_description
1408: select description, med.delivery_detail_id
1409: into l_temp, l_id3
1410: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1411: where med.plan_id=p_plan_id
1412: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1413: and med.delivery_detail_id = mdd.delivery_detail_id
1414: and med.plan_id=mdd.plan_id

Line 1551: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1547: AND trip_id = P_TRIP_ID;
1548: fnd_message.set_token('TRIP_NUMBER', l_id1);
1549: -- item_description
1550: select msitl.description into l_temp1
1551: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1552: where med.plan_id=p_plan_id
1553: and med.plan_id = mdd.plan_id
1554: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1555: and med.delivery_detail_id = mdd.delivery_detail_id

Line 1584: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med

1580: AND trip_id = P_TRIP_ID;
1581: fnd_message.set_token('TRIP_NUMBER', l_id1);
1582: -- item_description
1583: select msitl.description into l_temp1
1584: from mtl_system_items_tl msitl, mst_delivery_details mdd, mst_exception_details med
1585: where med.plan_id=p_plan_id
1586: and med.plan_id = mdd.plan_id
1587: and med.exception_detail_id = P_EXCEPTION_DETAIL_ID
1588: and med.delivery_detail_id = mdd.delivery_detail_id

Line 2504: -- The data model supports the selling price in the mst_delivery_details table

2500: where mt.plan_id = p_plan_id;
2501: */
2502: -- Changed as per bug # 3509257
2503: -- The Plan value should be calculated from the selling price at the delivery lines.
2504: -- The data model supports the selling price in the mst_delivery_details table
2505: -- as unit price column, which is directly snapshot from the wsh_delivery_details.unit_price.
2506:
2507: select sum(nvl(mdd.unit_price,0)* mdd.requested_quantity)
2508: into l_plan_value

Line 2509: from mst_delivery_details mdd

2505: -- as unit price column, which is directly snapshot from the wsh_delivery_details.unit_price.
2506:
2507: select sum(nvl(mdd.unit_price,0)* mdd.requested_quantity)
2508: into l_plan_value
2509: from mst_delivery_details mdd
2510: , mst_delivery_assignments mda
2511: where mdd.plan_id = p_plan_id
2512: and mda.plan_id = mdd.plan_id
2513: and mda.delivery_detail_id = mdd.delivery_detail_id

Line 2555: mst_delivery_details mdd,

2551: from mst_trips mt,
2552: mst_trip_stops mts,
2553: mst_delivery_legs mdl,
2554: mst_deliveries md,
2555: mst_delivery_details mdd,
2556: mst_delivery_assignments mda
2557: where mt.plan_id = p_plan_id
2558: and mt.mode_of_transport = p_mode
2559: and mt.trip_id = mts.trip_id

Line 2576: mst_delivery_details mdd,

2572: from mst_trips mt,
2573: mst_trip_stops mts,
2574: mst_delivery_legs mdl,
2575: mst_deliveries md,
2576: mst_delivery_details mdd,
2577: mst_delivery_assignments mda
2578: where mt.plan_id = p_plan_id
2579: and mt.mode_of_transport = p_mode
2580: and mt.trip_id = mts.trip_id

Line 2596: mst_delivery_details mdd,

2592: from mst_trips mt,
2593: mst_trip_stops mts,
2594: mst_delivery_legs mdl,
2595: mst_deliveries md,
2596: mst_delivery_details mdd,
2597: mst_delivery_assignments mda
2598: where mt.plan_id = p_plan_id
2599: and mt.mode_of_transport = p_mode
2600: and mt.trip_id = mts.trip_id

Line 2614: from mst_delivery_details mdd,

2610: */
2611: /*
2612: select count(distinct mdd.source_header_number)
2613: into l_total_orders
2614: from mst_delivery_details mdd,
2615: mst_deliveries md,
2616: mst_delivery_assignments mda
2617: where md.plan_id = mda.plan_id
2618: and md.delivery_id = mda.delivery_id

Line 2834: from mst_delivery_details mdd,

2830: -- As per bug # 3364598, this change is done for calculating total orders for myfac.
2831:
2832: select count(distinct mdd.source_header_number)
2833: into l_total_orders
2834: from mst_delivery_details mdd,
2835: mst_deliveries md,
2836: mst_delivery_assignments mda
2837: where md.plan_id = mda.plan_id
2838: and md.delivery_id = mda.delivery_id

Line 2982: from mst_delivery_details mdd

2978: l_count_origin_orders number;
2979: begin
2980: select count(distinct nvl(mdd.split_from_delivery_detail_id, mdd.delivery_detail_id))
2981: into l_count_origin_orders
2982: from mst_delivery_details mdd
2983: , mst_delivery_assignments mda
2984: , mst_deliveries md
2985: where md.plan_id = mda.plan_id
2986: and md.delivery_id = mda.delivery_id

Line 3227: from mst_delivery_details mdd

3223: l_count_dest_orders number;
3224: begin
3225: select count(distinct nvl(mdd.split_from_delivery_detail_id, mdd.delivery_detail_id))
3226: into l_count_dest_orders
3227: from mst_delivery_details mdd
3228: , mst_delivery_assignments mda
3229: , mst_deliveries md
3230: where md.plan_id = mda.plan_id
3231: and md.delivery_id = mda.delivery_id

Line 4157: from mst_delivery_details mdd

4153:
4154: begin
4155: select sum(mdd.allocated_cost)
4156: into l_order_cost
4157: from mst_delivery_details mdd
4158: where mdd.source_code = p_source_code
4159: and mdd.source_header_number = p_source_header_number;
4160:
4161: return l_order_cost;

Line 4889: from mtl_system_items_tl msitl, mst_delivery_details mdd

4885: fnd_message.set_token('MODE_OF_TRANSPORT', l_str2);
4886:
4887: -- item_description
4888: select msitl.description into l_str3
4889: from mtl_system_items_tl msitl, mst_delivery_details mdd
4890: where mdd.plan_id = P_PLAN_ID
4891: and mdd.delivery_detail_id = l_id2
4892: and mdd.inventory_item_id = msitl.inventory_item_id
4893: and mdd.organization_id = msitl.organization_id

Line 4916: from mtl_system_items_tl msitl, mst_delivery_details mdd

4912: fnd_message.set_token('DELIVERY_DETAIL_ID', l_id2);
4913:
4914: -- item_description
4915: select msitl.description into l_str2
4916: from mtl_system_items_tl msitl, mst_delivery_details mdd
4917: where mdd.plan_id = P_PLAN_ID
4918: and mdd.delivery_detail_id = l_id2
4919: and mdd.inventory_item_id = msitl.inventory_item_id
4920: and mdd.organization_id = msitl.organization_id

Line 5360: from mtl_system_items_tl msitl, mst_delivery_details mdd

5356: END IF;
5357:
5358: -- item_description
5359: select msitl.description into l_str1
5360: from mtl_system_items_tl msitl, mst_delivery_details mdd
5361: where mdd.plan_id = P_PLAN_ID
5362: and mdd.delivery_detail_id = l_id2
5363: and mdd.inventory_item_id = msitl.inventory_item_id
5364: and mdd.organization_id = msitl.organization_id

Line 5467: from mtl_system_items_tl msitl, mst_delivery_details mdd

5463: END IF;
5464:
5465: -- item_description
5466: select msitl.description into l_str1
5467: from mtl_system_items_tl msitl, mst_delivery_details mdd
5468: where mdd.plan_id = P_PLAN_ID
5469: and mdd.delivery_detail_id = l_id2
5470: and mdd.inventory_item_id = msitl.inventory_item_id
5471: and mdd.organization_id = msitl.organization_id

Line 5736: delete from MST_DELIVERY_DETAILS

5732:
5733: delete from MST_DELIVERY_ASSIGNMENTS
5734: where plan_id = p_plan_id;
5735:
5736: delete from MST_DELIVERY_DETAILS
5737: where plan_id = p_plan_id;
5738:
5739: delete from MST_DELIVERIES
5740: where plan_id = p_plan_id;

Line 5826: , mst_delivery_details mdd

5822: cursor cur_orgs is
5823: select mdd.organization_id
5824: from mst_deliveries md
5825: , mst_delivery_assignments mda
5826: , mst_delivery_details mdd
5827: where mdd.plan_id = mda.plan_id
5828: and mdd.delivery_detail_id = mda.delivery_detail_id
5829: and mda.plan_id = md.plan_id
5830: and mda.delivery_id = md.delivery_id