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_PF dependencies on MSC_PLANS

Line 2431: | - Additional join with MSC_PLANS in the SQLs on supplies and demands to

2427: | o Differences from non summary SQL are :
2428: | - Additional union with MSC_ATP_SUMMARY_SD
2429: | - Decode in quantity in SQL on msc_alloc_demands to consider unscheduled
2430: | orders as dummy supplies
2431: | - Additional join with MSC_PLANS in the SQLs on supplies and demands to
2432: | filter records based on refresh number
2433: | - Filter on allocated_quantity=0 and origination_type=51 removed in the
2434: | demands SQL so as to consider copy SOs and dummy supplies respectiviely.
2435: +-------------------------------------------------------------------------------*/

Line 2482: MSC_PLANS P -- For summary enhancement

2478: 0, OLD_ALLOCATED_QUANTITY, -- For summary enhancement
2479: -1 * AD.ALLOCATED_QUANTITY) SD_QTY
2480: FROM MSC_ALLOC_DEMANDS AD,
2481: MSC_SYSTEM_ITEMS I,
2482: MSC_PLANS P -- For summary enhancement
2483: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2484: AND I.ORGANIZATION_ID = p_org_id
2485: AND I.SR_INSTANCE_ID = p_instance_id
2486: AND I.PLAN_ID = p_plan_id

Line 2503: MSC_PLANS P -- For summary enhancement

2499: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
2500: SA.ALLOCATED_QUANTITY SD_QTY
2501: FROM MSC_ALLOC_SUPPLIES SA,
2502: MSC_SYSTEM_ITEMS I,
2503: MSC_PLANS P -- For summary enhancement
2504: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2505: AND I.ORGANIZATION_ID = p_org_id
2506: AND I.SR_INSTANCE_ID = p_instance_id
2507: AND I.PLAN_ID = p_plan_id

Line 5477: MSC_PLANS P -- For summary enhancement

5473: decode(AD.ALLOCATED_QUANTITY, -- Consider unscheduled orders as dummy supplies
5474: 0, OLD_ALLOCATED_QUANTITY,-- For summary enhancement
5475: -1 * AD.ALLOCATED_QUANTITY) SD_QTY
5476: FROM MSC_ALLOC_DEMANDS AD,
5477: MSC_PLANS P -- For summary enhancement
5478: WHERE AD.PLAN_ID = p_plan_id
5479: AND AD.SR_INSTANCE_ID = p_instance_id
5480: AND AD.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5481: AND AD.ORGANIZATION_ID = p_org_id

Line 5497: MSC_PLANS P -- For summary enhancement

5493: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
5494: 0, -1 * OLD_ALLOCATED_QUANTITY, -- For summary enhancement
5495: SA.ALLOCATED_QUANTITY) SD_QTY
5496: FROM MSC_ALLOC_SUPPLIES SA,
5497: MSC_PLANS P -- For summary enhancement
5498: WHERE SA.PLAN_ID = p_plan_id
5499: AND SA.SR_INSTANCE_ID = p_instance_id
5500: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5501: AND SA.ORGANIZATION_ID = p_org_id

Line 5935: MSC_PLANS P -- For summary enhancement

5931: 0, nvl(OLD_ALLOCATED_QUANTITY,0), --4658238 -- For summary enhancement
5932: -1 * AD.ALLOCATED_QUANTITY) SD_QTY,
5933: AD.DEMAND_CLASS
5934: FROM MSC_ALLOC_DEMANDS AD,
5935: MSC_PLANS P -- For summary enhancement
5936: WHERE AD.PLAN_ID = p_plan_id
5937: AND AD.SR_INSTANCE_ID = p_instance_id
5938: AND AD.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5939: AND AD.ORGANIZATION_ID = p_org_id

Line 5958: MSC_PLANS P -- For summary enhancement

5954: 0, -1 * OLD_ALLOCATED_QUANTITY, -- For summary enhancement
5955: SA.ALLOCATED_QUANTITY) SD_QTY ,
5956: SA.DEMAND_CLASS
5957: FROM MSC_ALLOC_SUPPLIES SA,
5958: MSC_PLANS P -- For summary enhancement
5959: WHERE SA.PLAN_ID = p_plan_id
5960: AND SA.SR_INSTANCE_ID = p_instance_id
5961: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5962: AND SA.ORGANIZATION_ID = p_org_id

Line 8918: FROM msc_plans mp,

8914:
8915: --bug3663487 start SQL ID 9426916 and 9426907
8916: SELECT c2.calendar_date,i2.organization_id,i2.sr_instance_id,i2.inventory_item_id
8917: BULK COLLECT INTO l_atf_date,l_organization_id,l_sr_instance_id,l_inventory_item_id
8918: FROM msc_plans mp,
8919: msc_plan_organizations po,
8920: msc_system_items i2,
8921: msc_trading_partners tp,
8922: msc_atp_rules r,

Line 8989: msc_plans mp,

8985: FROM msc_calendar_dates c2,
8986: msc_calendar_dates c1,
8987: msc_atp_rules r,
8988: msc_trading_partners tp,
8989: msc_plans mp,
8990: msc_system_items i2
8991: WHERE i2.inventory_item_id = i.inventory_item_id
8992: AND i2.organization_id = i.organization_id
8993: AND i2.sr_instance_id = i.sr_instance_id

Line 9289: FROM msc_plans

9285: msc_util.msc_log('l_share_partition := ' || l_share_partition);
9286:
9287: SELECT NVL(summary_flag,1), compile_designator
9288: INTO l_summary_flag, l_plan_name
9289: FROM msc_plans
9290: WHERE plan_id = p_plan_id;
9291:
9292: IF NVL(l_summary_flag,1) = 2 THEN
9293: msc_util.msc_log('Another session is running post-plan allocation program for this plan');

Line 9347: update msc_plans

9343: END IF;
9344: END LOOP;
9345:
9346: BEGIN
9347: update msc_plans
9348: set summary_flag = 2
9349: where plan_id = p_plan_id;
9350: commit;
9351: EXCEPTION

Line 10091: update msc_plans

10087: RAISE FND_API.G_EXC_ERROR;
10088: END IF;
10089:
10090: BEGIN
10091: update msc_plans
10092: set summary_flag = 3
10093: where plan_id = p_plan_id;
10094: END;
10095:

Line 10108: update msc_plans

10104: msc_util.msc_log(sqlerrm);
10105: ERRBUF := sqlerrm;
10106:
10107: BEGIN
10108: update msc_plans
10109: set summary_flag = 1
10110: where plan_id = p_plan_id;
10111: commit;
10112: END;