[Home] [Help]
552: -- initialize l_level_id. level_id remains -1 for demand priority
553: l_level_id := -1;
554:
555: /* Find all the demand classes on the request date = next working day from SYSDATE
556: from materialized view and store them in msc_alloc_temp table.
557: If no demand class found on request date, dont proceed any further, flag an error. */
558: IF PG_DEBUG in ('Y', 'C') THEN
559: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Checking the demand classes on p_request_date.');
560: END IF;
558: IF PG_DEBUG in ('Y', 'C') THEN
559: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Checking the demand classes on p_request_date.');
560: END IF;
561:
562: INSERT INTO MSC_ALLOC_TEMP(DEMAND_CLASS)
563: SELECT mv.demand_class
564: FROM msc_item_hierarchy_mv mv
565: WHERE mv.inventory_item_id = l_item_to_use
566: AND mv.organization_id = p_organization_id
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: return;
578: END IF;
579: IF PG_DEBUG in ('Y', 'C') THEN
580: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Demand classes found and stored in msc_alloc_temp table');
581: END IF;
582:
583: /*
584: 1. Copy the supply demand records from msc_alloc_supplies and msc_alloc_demands
584: 1. Copy the supply demand records from msc_alloc_supplies and msc_alloc_demands
585: into mrp_atp_details_temp.
586: 2. We copy from_demand_class for stealing records from MSC_ALLOC_SUPPLIES.
587: 3. Allocated Qty <= Total Supply Demand Quantity.
588: 4. MSC_ALLOC_TEMP holds the demand classes on p_request_date. A join between MSC_ALLOC_TEMP
589: and msc_alloc_supplies/msc_alloc_demands ensures we chose only request date demand classes.
590: 5. Transform order types 46,47 (Supply/Demand due to Stealing) to 48 (Supply Adjustment).
591: This is required only for MSC_ALLOC_SUPPLIES.
592: */
663: AD.DEMAND_CLASS col23, --bug3263368
664: AD.REQUEST_DATE col24 --bug3263368
665: FROM
666: MSC_ALLOC_DEMANDS AD,
667: MSC_ALLOC_TEMP TEMP,
668: MSC_TRADING_PARTNERS MTP,--bug3263368
669: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
670: WHERE
671: AD.PLAN_ID = p_plan_id
713: SA.DEMAND_CLASS col23, --bug3684383
714: l_null_date col24 --bug3263368 ORIG_REQUEST_DATE -- Bug 3875786 - null removed
715: FROM
716: MSC_ALLOC_SUPPLIES SA,
717: MSC_ALLOC_TEMP TEMP,
718: MSC_TRADING_PARTNERS MTP,--bug3684383
719: MSC_TRADING_PARTNER_SITES MTPS --bug3684383
720: WHERE
721: SA.PLAN_ID = p_plan_id
910: --IF p_infinite_time_fence_date IS NOT NULL THEN -- Bug 3823042, as in PDS, p_infinite_time_fence_date is never NULL
911:
912: SELECT demand_class
913: BULK COLLECT INTO l_all_dc_list_tab
914: FROM MSC_ALLOC_TEMP;
915:
916: IF PG_DEBUG in ('Y', 'C') THEN
917: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'l_all_dc_list_tab.COUNT: ' || l_all_dc_list_tab.COUNT);
918: END IF;
987: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'We are in demand class allocation.');
988: END IF;
989:
990: /* Store all the demand classes on the request date = next working day from SYSDATE
991: and store them in msc_alloc_temp table.
992: If no demand class found on request date, dont proceed any further*/
993:
994: INSERT INTO MSC_ALLOC_TEMP(DEMAND_CLASS, PRIORITY, ALLOCATION_PERCENT)
995: SELECT mv.demand_class, mv.priority, mv.allocation_percent
990: /* Store all the demand classes on the request date = next working day from SYSDATE
991: and store them in msc_alloc_temp table.
992: If no demand class found on request date, dont proceed any further*/
993:
994: INSERT INTO MSC_ALLOC_TEMP(DEMAND_CLASS, PRIORITY, ALLOCATION_PERCENT)
995: SELECT mv.demand_class, mv.priority, mv.allocation_percent
996: FROM msc_item_hierarchy_mv mv
997: WHERE mv.inventory_item_id = l_item_to_use
998: AND mv.organization_id = p_organization_id
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
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.');
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
1304: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
1305: WHERE
1306: D.PLAN_ID = p_plan_id
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
1430: AND S.INVENTORY_ITEM_ID = l_item_to_use -- Bug 3823042
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
1615: WHERE
1616: D.PLAN_ID = p_plan_id
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
1722: AND S.INVENTORY_ITEM_ID = l_item_to_use
1750: --x_return_status := FND_API.G_RET_STS_ERROR;
1751: --return;
1752: SELECT demand_class
1753: BULK COLLECT INTO l_dc_list_tab
1754: FROM MSC_ALLOC_TEMP;
1755:
1756: l_dc_list_tab.Extend();
1757: l_dc_list_tab(l_dc_list_tab.COUNT) := G_UNALLOCATED_DC;
1758: