DBA Data[Home] [Help]

APPS.MSC_ATP_ALLOC dependencies on MSC_ALLOC_SUPPLIES

Line 584: 1. Copy the supply demand records from msc_alloc_supplies and msc_alloc_demands

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

Line 586: 2. We copy from_demand_class for stealing records from MSC_ALLOC_SUPPLIES.

582:
583: /*
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).

Line 589: and msc_alloc_supplies/msc_alloc_demands ensures we chose only request date demand classes.

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

Line 591: This is required only for 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: */
593:
594: IF PG_DEBUG in ('Y', 'C') THEN
595: msc_sch_wb.atp_debug('Compute_Allocation_Details: ' || 'Before copying supply/demand records from alloc into temp tables.');

Line 716: MSC_ALLOC_SUPPLIES SA,

712: MTP.PARTNER_NAME col22, --bug3684383
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