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_AGG_PKG dependencies on MST_DELIVERY_ASSIGNMENTS

Line 277: mst_delivery_assignments da

273:
274: CURSOR cur_alloc_cost IS
275: SELECT SUM(dd.allocated_Cost)
276: FROM mst_delivery_details dd,
277: mst_delivery_assignments da
278: WHERE dd.plan_id = p_plan_id
279: AND da.plan_id = dd.plan_id
280: AND da.delivery_detail_id = dd.delivery_detail_id
281: and da.parent_delivery_detail_id is null

Line 1050: MST_DELIVERY_ASSIGNMENTS MDA

1046: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
1047: INTO l_carrier_orders
1048: FROM MST_DELIVERY_DETAILS MDD,
1049: MST_DELIVERIES MD,
1050: MST_DELIVERY_ASSIGNMENTS MDA
1051: WHERE MD.PLAN_ID = MDA.PLAN_ID
1052: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
1053: AND MD.DELIVERY_ID IN
1054: (SELECT MDL.DELIVERY_ID

Line 1083: mst_delivery_assignments mda

1079: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
1080: INTO l_carrier_orders
1081: FROM mst_delivery_details mdd,
1082: mst_deliveries md,
1083: mst_delivery_assignments mda
1084: WHERE md.plan_id = p_plan_id
1085: and md.plan_id = mda.plan_id
1086: and md.delivery_id = mda.delivery_id
1087: and mda.plan_id = mdd.plan_id

Line 1110: mst_delivery_assignments mda

1106: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
1107: INTO l_carrier_orders
1108: FROM mst_delivery_details mdd,
1109: mst_deliveries md,
1110: mst_delivery_assignments mda
1111: WHERE md.plan_id = p_plan_id
1112: and md.plan_id = mda.plan_id
1113: and md.delivery_id = mda.delivery_id
1114: and mda.plan_id = mdd.plan_id

Line 1352: , mst_delivery_assignments mda

1348:
1349: select sum(nvl(mdd.net_weight,0))
1350: into l_total_weight
1351: from mst_delivery_details mdd
1352: , mst_delivery_assignments mda
1353: , mst_deliveries md
1354: where md.plan_id = mda.plan_id
1355: and md.delivery_id = mda.delivery_id
1356: and mda.plan_id = mdd.plan_id

Line 1399: , mst_delivery_assignments mda

1395:
1396: select sum(nvl(mdd.volume,0))
1397: into l_total_volume
1398: from mst_delivery_details mdd
1399: , mst_delivery_assignments mda
1400: , mst_deliveries md
1401: where md.plan_id = mda.plan_id
1402: and md.delivery_id = mda.delivery_id
1403: and mda.plan_id = mdd.plan_id

Line 1444: , mst_delivery_assignments mda

1440:
1441: select sum(ceil(nvl(mdd.number_of_pallets,0)))
1442: into l_total_pallets
1443: from mst_delivery_details mdd
1444: , mst_delivery_assignments mda
1445: , mst_deliveries md
1446: where md.plan_id = mda.plan_id
1447: and md.delivery_id = mda.delivery_id
1448: and mda.plan_id = mdd.plan_id

Line 1491: , mst_delivery_assignments mda

1487:
1488: select sum(nvl(mdd.requested_quantity,0))
1489: into l_total_pieces
1490: from mst_delivery_details mdd
1491: , mst_delivery_assignments mda
1492: , mst_deliveries md
1493: where md.plan_id = mda.plan_id
1494: and md.delivery_id = mda.delivery_id
1495: and mda.plan_id = mdd.plan_id

Line 1525: mst_delivery_assignments mda

1521:
1522: select count(1)
1523: into l_total_orders
1524: from mst_delivery_details mdd,
1525: mst_delivery_assignments mda
1526: where mdd.plan_id = p_plan_id
1527: and mdd.customer_id = p_customer_id
1528: and mdd.split_from_delivery_detail_id is null
1529: and mdd.delivery_detail_id = mda.delivery_detail_id

Line 1540: MST_DELIVERY_ASSIGNMENTS MDA

1536: /*SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
1537: INTO l_total_orders
1538: FROM MST_DELIVERY_DETAILS MDD,
1539: MST_DELIVERIES MD,
1540: MST_DELIVERY_ASSIGNMENTS MDA
1541: WHERE MD.PLAN_ID = MDA.PLAN_ID
1542: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
1543: AND MD.DELIVERY_ID IN
1544: (SELECT MDL.DELIVERY_ID

Line 1561: MST_DELIVERY_ASSIGNMENTS MDA

1557: from (
1558: SELECT mdd.SOURCE_HEADER_NUMBER
1559: FROM MST_DELIVERY_DETAILS MDD,
1560: MST_DELIVERIES MD,
1561: MST_DELIVERY_ASSIGNMENTS MDA
1562: WHERE MD.PLAN_ID = MDA.PLAN_ID
1563: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
1564: AND MD.DELIVERY_ID IN
1565: (SELECT MDL.DELIVERY_ID

Line 1576: MST_DELIVERY_ASSIGNMENTS MDA

1572: union all
1573: SELECT mdd.SOURCE_HEADER_NUMBER
1574: FROM MST_DELIVERY_DETAILS MDD,
1575: MST_DELIVERIES MD,
1576: MST_DELIVERY_ASSIGNMENTS MDA
1577: WHERE MD.PLAN_ID = MDA.PLAN_ID
1578: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
1579: AND not exists
1580: (SELECT 1

Line 2341: , mst_delivery_assignments mda

2337:
2338: select sum(nvl(mdd.net_weight,0))
2339: into l_total_weight
2340: from mst_delivery_details mdd
2341: , mst_delivery_assignments mda
2342: , mst_deliveries md
2343: where md.plan_id = mda.plan_id
2344: and md.delivery_id = mda.delivery_id
2345: and mda.plan_id = mdd.plan_id

Line 2387: , mst_delivery_assignments mda

2383:
2384: select sum(nvl(mdd.volume,0))
2385: into l_total_volume
2386: from mst_delivery_details mdd
2387: , mst_delivery_assignments mda
2388: , mst_deliveries md
2389: where md.plan_id = mda.plan_id
2390: and md.delivery_id = mda.delivery_id
2391: and mda.plan_id = mdd.plan_id

Line 2433: , mst_delivery_assignments mda

2429:
2430: select sum(ceil(nvl(mdd.number_of_pallets,0)))
2431: into l_total_pallets
2432: from mst_delivery_details mdd
2433: , mst_delivery_assignments mda
2434: , mst_deliveries md
2435: where md.plan_id = mda.plan_id
2436: and md.delivery_id = mda.delivery_id
2437: and mda.plan_id = mdd.plan_id

Line 2479: , mst_delivery_assignments mda

2475:
2476: select sum(nvl(mdd.requested_quantity,0))
2477: into l_total_pieces
2478: from mst_delivery_details mdd
2479: , mst_delivery_assignments mda
2480: , mst_deliveries md
2481: where md.plan_id = mda.plan_id
2482: and md.delivery_id = mda.delivery_id
2483: and mda.plan_id = mdd.plan_id

Line 2512: mst_delivery_assignments mda

2508: /***
2509: select count(1)
2510: into l_total_orders
2511: from mst_delivery_details mdd,
2512: mst_delivery_assignments mda
2513: where mdd.plan_id = p_plan_id
2514: and mdd.supplier_id = p_supplier_id
2515: and mdd.split_from_delivery_detail_id is null
2516: and mdd.delivery_detail_id = mda.delivery_detail_id

Line 2527: MST_DELIVERY_ASSIGNMENTS MDA

2523: /*SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
2524: INTO l_total_orders
2525: FROM MST_DELIVERY_DETAILS MDD,
2526: MST_DELIVERIES MD,
2527: MST_DELIVERY_ASSIGNMENTS MDA
2528: WHERE MD.PLAN_ID = MDA.PLAN_ID
2529: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2530: AND MD.DELIVERY_ID IN
2531: (SELECT MDL.DELIVERY_ID

Line 2548: MST_DELIVERY_ASSIGNMENTS MDA

2544: from (
2545: SELECT mdd.SOURCE_HEADER_NUMBER
2546: FROM MST_DELIVERY_DETAILS MDD,
2547: MST_DELIVERIES MD,
2548: MST_DELIVERY_ASSIGNMENTS MDA
2549: WHERE MD.PLAN_ID = MDA.PLAN_ID
2550: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2551: AND MD.DELIVERY_ID IN
2552: (SELECT MDL.DELIVERY_ID

Line 2563: MST_DELIVERY_ASSIGNMENTS MDA

2559: union all
2560: SELECT mdd.SOURCE_HEADER_NUMBER
2561: FROM MST_DELIVERY_DETAILS MDD,
2562: MST_DELIVERIES MD,
2563: MST_DELIVERY_ASSIGNMENTS MDA
2564: WHERE MD.PLAN_ID = MDA.PLAN_ID
2565: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2566: AND not exists
2567: (SELECT 1

Line 2645: , mst_delivery_assignments mda

2641:
2642: select sum(nvl(mdd.net_weight,0))
2643: into l_total_weight
2644: from mst_delivery_details mdd
2645: , mst_delivery_assignments mda
2646: , mst_deliveries md
2647: where md.plan_id = mda.plan_id
2648: and md.delivery_id = mda.delivery_id
2649: and mda.plan_id = mdd.plan_id

Line 2694: , mst_delivery_assignments mda

2690:
2691: select sum(nvl(mdd.volume,0))
2692: into l_total_cube
2693: from mst_delivery_details mdd
2694: , mst_delivery_assignments mda
2695: , mst_deliveries md
2696: where md.plan_id = mda.plan_id
2697: and md.delivery_id = mda.delivery_id
2698: and mda.plan_id = mdd.plan_id

Line 2744: , mst_delivery_assignments mda

2740:
2741: select sum(ceil(nvl(mdd.number_of_pallets,0)))
2742: into l_total_pallets
2743: from mst_delivery_details mdd
2744: , mst_delivery_assignments mda
2745: , mst_deliveries md
2746: where md.plan_id = mda.plan_id
2747: and md.delivery_id = mda.delivery_id
2748: and mda.plan_id = mdd.plan_id

Line 2795: , mst_delivery_assignments mda

2791:
2792: select sum(nvl(mdd.requested_quantity,0))
2793: into l_total_pieces
2794: from mst_delivery_details mdd
2795: , mst_delivery_assignments mda
2796: , mst_deliveries md
2797: where md.plan_id = mda.plan_id
2798: and md.delivery_id = mda.delivery_id
2799: and mda.plan_id = mdd.plan_id

Line 2826: mst_delivery_assignments mda

2822: /***
2823: select count(1)
2824: into l_total_orders
2825: from mst_delivery_details mdd,
2826: mst_delivery_assignments mda
2827: where mdd.plan_id = p_plan_id
2828: and decode(p_facility_type, 0, mdd.customer_id, mdd.supplier_id) = p_cust_or_supp_id
2829: and (mdd.ship_from_location_id = p_location_id or
2830: mdd.ship_to_location_id = p_location_id)

Line 2850: MST_DELIVERY_ASSIGNMENTS MDA

2846: FROM (
2847: SELECT mdd.SOURCE_HEADER_NUMBER
2848: FROM MST_DELIVERY_DETAILS MDD,
2849: MST_DELIVERIES MD,
2850: MST_DELIVERY_ASSIGNMENTS MDA
2851: WHERE MD.PLAN_ID = MDA.PLAN_ID
2852: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2853: AND MDA.PLAN_ID = MDD.PLAN_ID
2854: AND MDA.DELIVERY_DETAIL_ID = MDD.DELIVERY_DETAIL_ID

Line 2870: MST_DELIVERY_ASSIGNMENTS MDA

2866: union ALL
2867: SELECT mdd.SOURCE_HEADER_NUMBER
2868: FROM MST_DELIVERY_DETAILS MDD,
2869: MST_DELIVERIES MD,
2870: MST_DELIVERY_ASSIGNMENTS MDA
2871: WHERE MD.PLAN_ID = MDA.PLAN_ID
2872: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2873: AND MDA.PLAN_ID = MDD.PLAN_ID
2874: AND MDA.DELIVERY_DETAIL_ID = MDD.DELIVERY_DETAIL_ID

Line 2888: MST_DELIVERY_ASSIGNMENTS MDA

2884: FROM (
2885: SELECT mdd.SOURCE_HEADER_NUMBER
2886: FROM MST_DELIVERY_DETAILS MDD,
2887: MST_DELIVERIES MD,
2888: MST_DELIVERY_ASSIGNMENTS MDA
2889: WHERE MD.PLAN_ID = MDA.PLAN_ID
2890: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2891: AND MDA.PLAN_ID = MDD.PLAN_ID
2892: AND MDA.DELIVERY_DETAIL_ID = MDD.DELIVERY_DETAIL_ID

Line 2908: MST_DELIVERY_ASSIGNMENTS MDA

2904: union ALL
2905: SELECT mdd.SOURCE_HEADER_NUMBER
2906: FROM MST_DELIVERY_DETAILS MDD,
2907: MST_DELIVERIES MD,
2908: MST_DELIVERY_ASSIGNMENTS MDA
2909: WHERE MD.PLAN_ID = MDA.PLAN_ID
2910: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
2911: AND MDA.PLAN_ID = MDD.PLAN_ID
2912: AND MDA.DELIVERY_DETAIL_ID = MDD.DELIVERY_DETAIL_ID

Line 3337: FROM mst_delivery_assignments mda,

3333: FROM mst_delivery_details mdd
3334: WHERE mdd.plan_id = p_plan_id
3335: AND mdd.delivery_detail_id IN
3336: (SELECT mda.delivery_detail_id
3337: FROM mst_delivery_assignments mda,
3338: mst_trips mt,
3339: mst_trip_stops mts,
3340: mst_delivery_legs mdl,
3341: mst_deliveries md

Line 3369: FROM mst_delivery_assignments mda,

3365: FROM mst_delivery_details mdd
3366: WHERE mdd.plan_id = p_plan_id
3367: AND mdd.delivery_detail_id IN
3368: ( SELECT mda.delivery_detail_id
3369: FROM mst_delivery_assignments mda,
3370: mst_deliveries md,
3371: mst_trips mt,
3372: mst_delivery_legs mdl
3373: WHERE mda.plan_id = mdd.plan_id

Line 3397: FROM mst_delivery_assignments mda,

3393: FROM mst_delivery_details mdd
3394: WHERE mdd.plan_id = p_plan_id
3395: AND mdd.delivery_detail_id IN
3396: ( SELECT mda.delivery_detail_id
3397: FROM mst_delivery_assignments mda,
3398: mst_deliveries md,
3399: mst_trips mt,
3400: mst_delivery_legs mdl
3401: WHERE mda.plan_id = mdd.plan_id

Line 3424: FROM mst_delivery_assignments mda,

3420: FROM mst_delivery_details mdd
3421: WHERE mdd.plan_id = p_plan_id
3422: AND mdd.delivery_detail_id IN
3423: ( SELECT mda.delivery_detail_id
3424: FROM mst_delivery_assignments mda,
3425: mst_deliveries md,
3426: mst_trips mt,
3427: mst_delivery_legs mdl
3428: WHERE mda.plan_id = mdd.plan_id

Line 3450: mst_delivery_assignments mda

3446: select count(distinct mdd.source_header_number)
3447: into l_total_orders
3448: from mst_delivery_details mdd,
3449: mst_deliveries md,
3450: mst_delivery_assignments mda
3451: where md.plan_id = mda.plan_id
3452: and md.delivery_id = mda.delivery_id
3453: and md.delivery_id in
3454: (select mdl.delivery_id

Line 3481: mst_delivery_assignments mda

3477: mst_trip_stops mts,
3478: mst_delivery_legs mdl,
3479: mst_deliveries md,
3480: mst_delivery_details mdd,
3481: mst_delivery_assignments mda
3482: where mt.plan_id = p_plan_id
3483: and mt.mode_of_transport = p_mode
3484: and mt.trip_id = mts.trip_id
3485: and mt.trip_id = mdl.trip_id

Line 3509: mst_delivery_assignments mda

3505: mst_trip_stops mts,
3506: mst_delivery_legs mdl,
3507: mst_deliveries md,
3508: mst_delivery_details mdd,
3509: mst_delivery_assignments mda
3510: where mt.plan_id = p_plan_id
3511: and mt.mode_of_transport = p_mode
3512: and mt.trip_id = mts.trip_id
3513: and mt.trip_id = mdl.trip_id

Line 3526: MST_DELIVERY_ASSIGNMENTS MDA

3522: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
3523: INTO l_total_orders
3524: FROM MST_DELIVERY_DETAILS MDD,
3525: MST_DELIVERIES MD,
3526: MST_DELIVERY_ASSIGNMENTS MDA
3527: WHERE MD.PLAN_ID = MDA.PLAN_ID
3528: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
3529: AND MD.DELIVERY_ID IN
3530: (SELECT MDL.DELIVERY_ID

Line 3561: mst_delivery_assignments mda

3557: mst_trip_stops mts,
3558: mst_delivery_legs mdl,
3559: mst_deliveries md,
3560: mst_delivery_details mdd,
3561: mst_delivery_assignments mda
3562: where mt.plan_id = p_plan_id
3563: and mt.mode_of_transport = p_mode
3564: and mt.trip_id = mts.trip_id
3565: and mt.trip_id = mdl.trip_id

Line 3577: MST_DELIVERY_ASSIGNMENTS MDA

3573: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
3574: INTO l_total_orders
3575: FROM MST_DELIVERY_DETAILS MDD,
3576: MST_DELIVERIES MD,
3577: MST_DELIVERY_ASSIGNMENTS MDA
3578: WHERE MD.PLAN_ID = MDA.PLAN_ID
3579: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
3580: AND MD.DELIVERY_ID IN
3581: (SELECT MDL.DELIVERY_ID

Line 5215: MST_DELIVERY_ASSIGNMENTS MDA

5211: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5212: INTO l_total_orders
5213: FROM MST_DELIVERY_DETAILS MDD,
5214: MST_DELIVERIES MD,
5215: MST_DELIVERY_ASSIGNMENTS MDA
5216: WHERE MD.PLAN_ID = MDA.PLAN_ID
5217: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
5218: AND MD.DELIVERY_ID IN
5219: (SELECT MDL.DELIVERY_ID

Line 5240: MST_DELIVERY_ASSIGNMENTS MDA

5236: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5237: INTO l_total_orders
5238: FROM MST_DELIVERY_DETAILS MDD,
5239: MST_DELIVERIES MD,
5240: MST_DELIVERY_ASSIGNMENTS MDA
5241: WHERE MD.PLAN_ID = MDA.PLAN_ID
5242: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
5243: AND MD.DELIVERY_ID IN
5244: (SELECT MDL.DELIVERY_ID

Line 5266: MST_DELIVERY_ASSIGNMENTS MDA

5262: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5263: INTO l_total_orders
5264: FROM MST_DELIVERY_DETAILS MDD,
5265: MST_DELIVERIES MD,
5266: MST_DELIVERY_ASSIGNMENTS MDA
5267: WHERE MD.PLAN_ID = MDA.PLAN_ID
5268: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
5269: AND MD.DELIVERY_ID IN
5270: (SELECT MDL.DELIVERY_ID

Line 5300: MST_DELIVERY_ASSIGNMENTS MDA

5296: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5297: INTO l_total_orders
5298: FROM MST_DELIVERY_DETAILS MDD,
5299: MST_DELIVERIES MD,
5300: MST_DELIVERY_ASSIGNMENTS MDA
5301: WHERE MD.PLAN_ID = MDA.PLAN_ID
5302: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
5303: AND MD.DELIVERY_ID IN
5304: (SELECT MDL.DELIVERY_ID

Line 5324: mst_delivery_assignments mda

5320: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5321: INTO l_total_orders
5322: FROM mst_delivery_details mdd,
5323: mst_deliveries md,
5324: mst_delivery_assignments mda
5325: WHERE md.plan_id = p_plan_id
5326: AND md.plan_id = mda.plan_id
5327: AND md.delivery_id = mda.delivery_id
5328: AND mda.plan_id = mdd.plan_id

Line 5346: mst_delivery_assignments mda

5342: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5343: INTO l_total_orders
5344: FROM mst_delivery_details mdd,
5345: mst_deliveries md,
5346: mst_delivery_assignments mda
5347: WHERE md.plan_id = p_plan_id
5348: AND md.plan_id = mda.plan_id
5349: AND md.delivery_id = mda.delivery_id
5350: AND mda.plan_id = mdd.plan_id

Line 5371: MST_DELIVERY_ASSIGNMENTS MDA

5367: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5368: INTO l_total_orders
5369: FROM MST_DELIVERY_DETAILS MDD,
5370: MST_DELIVERIES MD,
5371: MST_DELIVERY_ASSIGNMENTS MDA
5372: WHERE MD.PLAN_ID = MDA.PLAN_ID
5373: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
5374: AND MD.DELIVERY_ID IN
5375: (SELECT MDL.DELIVERY_ID

Line 5398: MST_DELIVERY_ASSIGNMENTS MDA

5394: SELECT COUNT(DISTINCT mdd.SOURCE_HEADER_NUMBER)
5395: INTO l_total_orders
5396: FROM MST_DELIVERY_DETAILS MDD,
5397: MST_DELIVERIES MD,
5398: MST_DELIVERY_ASSIGNMENTS MDA
5399: WHERE MD.PLAN_ID = MDA.PLAN_ID
5400: AND MD.DELIVERY_ID = MDA.DELIVERY_ID
5401: AND MD.DELIVERY_ID IN
5402: (SELECT MDL.DELIVERY_ID