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.MSC_ATP_ALLOC dependencies on MSC_ALLOC_DEMANDS

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 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 666: MSC_ALLOC_DEMANDS AD,

662: MTP.PARTNER_NAME col22, --bug3263368
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