DBA Data[Home] [Help]

APPS.MSC_ATP_ALLOC dependencies on MSC_SUPPLIES

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 1425: MSC_SUPPLIES S,

1421: l_null_date col24 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
1422: FROM
1423: -- Bug 3823042
1424: --MSC_CALENDAR_DATES C,
1425: MSC_SUPPLIES S,
1426: MSC_ALLOC_TEMP TEMP
1427: WHERE
1428: S.PLAN_ID = p_plan_id
1429: AND S.SR_INSTANCE_ID = p_instance_id

Line 1717: MSC_SUPPLIES S,

1713: l_null_char col23, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
1714: l_null_date col24 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
1715: FROM
1716: MSC_CALENDAR_DATES C,
1717: MSC_SUPPLIES S,
1718: MSC_ALLOC_TEMP TEMP
1719: WHERE
1720: S.PLAN_ID = p_plan_id
1721: AND S.SR_INSTANCE_ID = p_instance_id

Line 1744: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'No s/d records could be inserted from msc_supplies/demands tables into temp table');

1740: END IF;
1741:
1742: IF (l_insert_count = 0) THEN
1743: IF PG_DEBUG in ('Y', 'C') THEN
1744: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'No s/d records could be inserted from msc_supplies/demands tables into temp table');
1745: END IF;
1746:
1747: -- bug 2763784 (ssurendr)
1748: -- Should not error out if no s/d record found

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 2407: MSC_SUPPLIES S,

2403: l_null_date COL29 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
2404: FROM
2405: -- Bug 3823042
2406: --MSC_CALENDAR_DATES C,
2407: MSC_SUPPLIES S,
2408: MSC_ALLOC_HIERARCHY_TEMP TEMP
2409: WHERE
2410: S.PLAN_ID = p_plan_id
2411: AND S.SR_INSTANCE_ID = p_instance_id

Line 2709: MSC_SUPPLIES S,

2705: l_null_char col28, --bug3263368 ORIG_DEMAND_CLASS --Bug 3875786
2706: l_null_date COL29 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
2707: FROM
2708: MSC_CALENDAR_DATES C,
2709: MSC_SUPPLIES S,
2710: MSC_ALLOC_HIERARCHY_TEMP TEMP
2711: WHERE
2712: S.PLAN_ID = p_plan_id
2713: AND S.SR_INSTANCE_ID = p_instance_id

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. */