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_DETAILS

Line 276: FROM mst_delivery_details dd,

272: RETURN NUMBER IS
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

Line 602: from mst_delivery_details mdd

598:
599: begin
600: select sum(mdd.net_weight)
601: into l_order_weight
602: from mst_delivery_details mdd
603: where mdd.source_code = p_source_code
604: and mdd.source_header_number = p_source_header_number;
605:
606: return l_order_weight;

Line 621: from mst_delivery_details mdd

617:
618: begin
619: select sum(mdd.volume)
620: into l_order_cube
621: from mst_delivery_details mdd
622: where mdd.source_code = p_source_code
623: and mdd.source_header_number = p_source_header_number;
624:
625: return l_order_cube;

Line 640: from mst_delivery_details mdd

636:
637: begin
638: select sum(ceil(mdd.number_of_pallets))
639: into l_order_pallets
640: from mst_delivery_details mdd
641: where mdd.source_code = p_source_code
642: and mdd.source_header_number = p_source_header_number;
643:
644: return l_order_pallets;

Line 659: from mst_delivery_details mdd

655:
656: begin
657: select sum(mdd.requested_quantity)
658: into l_order_pieces
659: from mst_delivery_details mdd
660: where mdd.source_code = p_source_code
661: and mdd.source_header_number = p_source_header_number;
662:
663: return l_order_pieces;

Line 1048: FROM MST_DELIVERY_DETAILS MDD,

1044: -- ----------------------------------
1045: /*********************************************
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

Line 1081: FROM mst_delivery_details mdd,

1077: -- for unload and load.
1078: -- ----------------------------------------------------------------------------
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

Line 1108: FROM mst_delivery_details mdd,

1104: l_carrier_orders := 0;
1105:
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

Line 1351: from mst_delivery_details mdd

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

Line 1398: from mst_delivery_details mdd

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

Line 1443: from mst_delivery_details mdd

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

Line 1490: from mst_delivery_details mdd

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

Line 1524: from mst_delivery_details mdd,

1520: /***
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

Line 1538: FROM MST_DELIVERY_DETAILS MDD,

1534: );
1535: ***/
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

Line 1559: FROM MST_DELIVERY_DETAILS MDD,

1555: SELECT COUNT(DISTINCT dd.SOURCE_HEADER_NUMBER)
1556: INTO l_total_orders
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

Line 1574: FROM MST_DELIVERY_DETAILS MDD,

1570: AND MD.PLAN_ID = p_PLAN_ID
1571: AND MD.CUSTOMER_ID = p_customer_id
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

Line 2140: FROM mst_delivery_details mdd

2136: FROM fte_location_parameters fte
2137: WHERE fte.location_id IN
2138: (SELECT DECODE(mdd.source_code, OE , mdd.ship_to_location_id,
2139: RFC, mdd.ship_from_location_id) location_id
2140: FROM mst_delivery_details mdd
2141: WHERE mdd.plan_id = p_plan_id
2142: AND mdd.customer_id = p_customer_id
2143: AND mdd.source_code IN (OE, RFC) );
2144: /*cursor customer_facilities is

Line 2149: from mst_delivery_details, fte_location_parameters fte

2145: select distinct decode(source_code, OE, ship_to_location_id,
2146: RFC, ship_from_location_id) customer_facility_id,
2147: fte.facility_code facility_code,
2148: fte.description description
2149: from mst_delivery_details, fte_location_parameters fte
2150: where plan_id = p_plan_id
2151: and customer_id = p_customer_id
2152: and source_code in (OE, RFC)
2153: and decode(source_code, RFC, ship_from_location_id, ship_to_location_id) = fte.location_id;*/

Line 2181: FROM mst_delivery_details mdd

2177: FROM fte_location_parameters fte
2178: WHERE fte.location_id in
2179: (SELECT DECODE(mdd.source_code, RTV, mdd.ship_to_location_id,
2180: PO, mdd.ship_from_location_id) location_id
2181: FROM mst_delivery_details mdd
2182: WHERE mdd.plan_id = p_plan_id
2183: AND mdd.supplier_id = p_supplier_id
2184: AND mdd.source_code in (PO, RTV));
2185: /*cursor supplier_facilities is

Line 2190: from mst_delivery_details, fte_location_parameters fte

2186: select distinct decode(source_code, RTV, ship_to_location_id,
2187: PO, ship_from_location_id) supplier_facility_id,
2188: fte.facility_code facility_code,
2189: fte.description description
2190: from mst_delivery_details, fte_location_parameters fte
2191: where plan_id = p_plan_id
2192: and supplier_id = p_supplier_id
2193: and source_code in (PO, RTV)
2194: and decode(source_code, RTV, ship_to_location_id, PO, ship_from_location_id) = fte.location_id;*/

Line 2340: from mst_delivery_details mdd

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

Line 2386: from mst_delivery_details mdd

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

Line 2432: from mst_delivery_details mdd

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

Line 2478: from mst_delivery_details mdd

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

Line 2511: from mst_delivery_details mdd,

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

Line 2525: FROM MST_DELIVERY_DETAILS MDD,

2521: );
2522: ***/
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

Line 2546: FROM MST_DELIVERY_DETAILS MDD,

2542: SELECT COUNT(DISTINCT dd.SOURCE_HEADER_NUMBER)
2543: INTO l_total_orders
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

Line 2561: FROM MST_DELIVERY_DETAILS MDD,

2557: AND MD.PLAN_ID = p_PLAN_ID
2558: AND MD.SUPPLIER_ID = p_supplier_id
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

Line 2644: from mst_delivery_details mdd

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

Line 2693: from mst_delivery_details mdd

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

Line 2743: from mst_delivery_details mdd

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

Line 2794: from mst_delivery_details mdd

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

Line 2825: from mst_delivery_details mdd,

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

Line 2848: FROM MST_DELIVERY_DETAILS MDD,

2844: SELECT COUNT(DISTINCT dd.SOURCE_HEADER_NUMBER)
2845: INTO l_total_orders
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

Line 2868: FROM MST_DELIVERY_DETAILS MDD,

2864: OR MDL.DROP_OFF_STOP_ID = MTS.STOP_ID)
2865: AND MTS.STOP_LOCATION_ID = P_LOCATION_ID)
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

Line 2886: FROM MST_DELIVERY_DETAILS MDD,

2882: SELECT COUNT(DISTINCT dd.SOURCE_HEADER_NUMBER)
2883: INTO l_total_orders
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

Line 2906: FROM MST_DELIVERY_DETAILS MDD,

2902: OR MDL.DROP_OFF_STOP_ID = MTS.STOP_ID)
2903: AND MTS.STOP_LOCATION_ID = P_LOCATION_ID)
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

Line 3333: FROM mst_delivery_details mdd

3329: -- up (by other trip).
3330: -- -------------------------------------------
3331: SELECT COUNT(DISTINCT mdd.source_header_number)
3332: INTO l_orders
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,

Line 3365: FROM mst_delivery_details mdd

3361: -- or destination is my facility:
3362: -- ------------------------------
3363: SELECT COUNT(DISTINCT mdd.source_header_number)
3364: INTO l_orders
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,

Line 3393: FROM mst_delivery_details mdd

3389: -- is my facility:
3390: -- ------------------------------
3391: SELECT COUNT(DISTINCT mdd.source_header_number)
3392: INTO l_orders
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,

Line 3420: FROM mst_delivery_details mdd

3416: -- is my facility:
3417: -- ------------------------------
3418: SELECT COUNT(DISTINCT mdd.source_header_number)
3419: INTO l_orders
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,

Line 3448: from mst_delivery_details mdd,

3444: --total orders for a given facility location
3445: if (p_activity_type is null and p_mode is null) then
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

Line 3480: mst_delivery_details mdd,

3476: from mst_trips mt,
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

Line 3508: mst_delivery_details mdd,

3504: from mst_trips mt,
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

Line 3524: FROM MST_DELIVERY_DETAILS MDD,

3520: and mdd.split_from_delivery_detail_id is null;*/
3521:
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

Line 3560: mst_delivery_details mdd,

3556: from mst_trips mt,
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

Line 3575: FROM MST_DELIVERY_DETAILS MDD,

3571: and mda.parent_delivery_detail_id is null
3572: and mdd.split_from_delivery_detail_id is null;*/
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

Line 5213: FROM MST_DELIVERY_DETAILS MDD,

5209: -- -------------------------------------
5210: /*
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

Line 5238: FROM MST_DELIVERY_DETAILS MDD,

5234: AND MD.PLAN_ID = P_PLAN_ID;
5235: */
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

Line 5264: FROM MST_DELIVERY_DETAILS MDD,

5260: l_total_orders := 0;
5261:
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

Line 5298: FROM MST_DELIVERY_DETAILS MDD,

5294: -- ------------------------------------------ -
5295: /*******
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

Line 5322: FROM mst_delivery_details mdd,

5318: AND MD.PLAN_ID = P_PLAN_ID;
5319: ***********/
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

Line 5344: FROM mst_delivery_details mdd,

5340: l_total_orders := 0;
5341:
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

Line 5369: FROM MST_DELIVERY_DETAILS MDD,

5365: -- Distinct orders instead of raw orders. -
5366: -- ------------------------------------------ -
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

Line 5396: FROM MST_DELIVERY_DETAILS MDD,

5392: -- Distinct orders instead of raw orders. -
5393: -- ------------------------------------------ -
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

Line 5781: -- p_location_id = MST_DELIVERY_DETAILS.ship_to_location_id

5777:
5778:
5779: -- Used by view definitions of Delivery Line grids:
5780: -- 1. Call this function when source_code = OE for the Destination Company Name:
5781: -- p_location_id = MST_DELIVERY_DETAILS.ship_to_location_id
5782: -- p_customer_id = MST_DELIVERY_DETAILS.customer_id
5783: -- 2. Call this function when source_code = OE for the Origin Company Name:
5784: -- p_location_id = MST_DELIVERY_DETAILS.ship_from_location_id
5785: -- p_customer_id = null

Line 5782: -- p_customer_id = MST_DELIVERY_DETAILS.customer_id

5778:
5779: -- Used by view definitions of Delivery Line grids:
5780: -- 1. Call this function when source_code = OE for the Destination Company Name:
5781: -- p_location_id = MST_DELIVERY_DETAILS.ship_to_location_id
5782: -- p_customer_id = MST_DELIVERY_DETAILS.customer_id
5783: -- 2. Call this function when source_code = OE for the Origin Company Name:
5784: -- p_location_id = MST_DELIVERY_DETAILS.ship_from_location_id
5785: -- p_customer_id = null
5786:

Line 5784: -- p_location_id = MST_DELIVERY_DETAILS.ship_from_location_id

5780: -- 1. Call this function when source_code = OE for the Destination Company Name:
5781: -- p_location_id = MST_DELIVERY_DETAILS.ship_to_location_id
5782: -- p_customer_id = MST_DELIVERY_DETAILS.customer_id
5783: -- 2. Call this function when source_code = OE for the Origin Company Name:
5784: -- p_location_id = MST_DELIVERY_DETAILS.ship_from_location_id
5785: -- p_customer_id = null
5786:
5787: function get_owner_name_for_del_line(p_location_id IN number, p_customer_id IN number)
5788: return varchar2 is

Line 5808: -- p_party_id is orgnization_id from mst_delivery_details

5804: hz_parties hzp
5805: where hzc.cust_account_id = p_customer_id
5806: and hzc.party_id = hzp.party_id;
5807:
5808: -- p_party_id is orgnization_id from mst_delivery_details
5809: elsif l_location_source_code = 'HR' then
5810: l_owner_name := fnd_profile.value('MST_COMPANY_NAME');
5811: end if;
5812: return l_owner_name;