APPS.MSC_ATP_ALLOC dependencies on MSC_DEMANDS

Line 1037: 1. Copy the supply demand records from msc_supplies and msc_demands

1033: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'l_org_code'|| l_org_code);
1034: END IF;
1035:
1036: /*
1037: 1. Copy the supply demand records from msc_supplies and msc_demands
1038: into mrp_atp_details_temp. Perform allocation in the process.
1039: 2. Forward consumtion logic is such that individual stealing acts cannot be recorded,
1040: therefore, we do not select from_demand_class.
1041: 3. MSC_ALLOC_TEMP here stores allocation demand classes. We make a cartesian to split the supplies/demands

Line 1045: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Before copying supply/demand records from msc_supplies/msc_demands into temp tables.');

1041: 3. MSC_ALLOC_TEMP here stores allocation demand classes. We make a cartesian to split the supplies/demands
1042: 4. Finally we put only those records where allocated_quantity <> 0
1043: */
1044: IF PG_DEBUG in ('Y', 'C') THEN
1045: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Before copying supply/demand records from msc_supplies/msc_demands into temp tables.');
1046: END IF;
1047:
1048: -- time_phased_atp changes begin
1049: IF l_time_phased_atp = 'Y' THEN

Line 1299: MSC_DEMANDS D,

1295: DECODE(D.ORDER_DATE_TYPE_CODE,2,
1296: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col24 --bug3263368
1297:
1298: FROM
1299: MSC_DEMANDS D,
1300: --Bug 3823042, donot use msc_calendar_dates
1301: --MSC_CALENDAR_DATES C,
1302: MSC_ALLOC_TEMP TEMP,
1303: MSC_TRADING_PARTNERS MTP, --bug3263368

Line 1610: MSC_DEMANDS D,

1606: DECODE(D.ORDER_DATE_TYPE_CODE,2,
1607: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col24 --bug3263368
1608:
1609: FROM
1610: MSC_DEMANDS D,
1611: MSC_CALENDAR_DATES C,
1612: MSC_ALLOC_TEMP TEMP,
1613: MSC_TRADING_PARTNERS MTP, --bug3263368
1614: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

Line 1765: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'After copying supply/demand records from msc_supplies/msc_demands into temp tables.');

1761: END IF;
1762: ELSE
1763:
1764: IF PG_DEBUG in ('Y', 'C') THEN
1765: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'After copying supply/demand records from msc_supplies/msc_demands into temp tables.');
1766: END IF;
1767:
1768: /* Bulk Collect Allocated Supply, Total Supply,
1769: Allocated Demand, Stolen Demand, Total Demand, Net into PL/SQL Period table. */

Line 2020: 1. Copy the supply demand records from msc_supplies and msc_demands

2016: END IF;
2017:
2018:
2019: /*
2020: 1. Copy the supply demand records from msc_supplies and msc_demands
2021: into mrp_atp_details_temp in case of Customer Class Allocated ATP.
2022: 2. Forward consumtion logic is such that individual stealing acts cannot be recorded,
2023: therefore, we do not select from_demand_class.
2024: But we select partner_id and partner_site_id, class and demand_class.

Line 2030: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Before copying supply/demand records from msc_supplies/msc_demands into temp tables.');

2026: */
2027:
2028:
2029: IF PG_DEBUG in ('Y', 'C') THEN
2030: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Before copying supply/demand records from msc_supplies/msc_demands into temp tables.');
2031: END IF;
2032:
2033: /* time_phased_atp changes begin */
2034: IF l_time_phased_atp = 'Y' THEN

Line 2281: MSC_DEMANDS D,

2277: D.DEMAND_CLASS col28, --bug3263368
2278: DECODE(D.ORDER_DATE_TYPE_CODE,2,
2279: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col29 --bug3263368
2280: FROM
2281: MSC_DEMANDS D,
2282: -- Bug 3823042
2283: --MSC_CALENDAR_DATES C,
2284: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2285: MSC_TRADING_PARTNERS MTP,--bug3263368

Line 2592: MSC_DEMANDS D,

2588: D.DEMAND_CLASS col28, --bug3263368
2589: DECODE(D.ORDER_DATE_TYPE_CODE,2,
2590: D.REQUEST_DATE,D.REQUEST_SHIP_DATE) col29 --bug3263368
2591: FROM
2592: MSC_DEMANDS D,
2593: MSC_CALENDAR_DATES C,
2594: MSC_ALLOC_HIERARCHY_TEMP TEMP,
2595: MSC_TRADING_PARTNERS MTP,--bug3263368
2596: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

Line 2759: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'After copying supply/demand records from msc_supplies/msc_demands into temp tables.');

2755: END IF;
2756: ELSE
2757:
2758: IF PG_DEBUG in ('Y', 'C') THEN
2759: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'After copying supply/demand records from msc_supplies/msc_demands into temp tables.');
2760: END IF;
2761:
2762: /* Bulk Collect Allocated Supply, Total Supply,
2763: Allocated Demand, Stolen Demand, Total Demand, Net into PL/SQL Period table. */