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 2419: | - Additional join with MSC_PLANS in the SQLs on supplies and demands to

2415: | o Differences from non summary SQL are :
2416: | - Additional union with MSC_ATP_SUMMARY_SD
2417: | - Decode in quantity in SQL on msc_alloc_demands to consider unscheduled
2418: | orders as dummy supplies
2419: | - Additional join with MSC_PLANS in the SQLs on supplies and demands to
2420: | filter records based on refresh number
2421: | - Filter on allocated_quantity=0 and origination_type=51 removed in the
2422: | demands SQL so as to consider copy SOs and dummy supplies respectiviely.
2423: +-------------------------------------------------------------------------------*/

Line 2470: MSC_PLANS P -- For summary enhancement

2466: 0, OLD_ALLOCATED_QUANTITY, -- For summary enhancement
2467: -1 * AD.ALLOCATED_QUANTITY) SD_QTY
2468: FROM MSC_ALLOC_DEMANDS AD,
2469: MSC_SYSTEM_ITEMS I,
2470: MSC_PLANS P -- For summary enhancement
2471: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2472: AND I.ORGANIZATION_ID = p_org_id
2473: AND I.SR_INSTANCE_ID = p_instance_id
2474: AND I.PLAN_ID = p_plan_id

Line 2491: MSC_PLANS P -- For summary enhancement

2487: SELECT TRUNC(SA.SUPPLY_DATE) SD_DATE,
2488: SA.ALLOCATED_QUANTITY SD_QTY
2489: FROM MSC_ALLOC_SUPPLIES SA,
2490: MSC_SYSTEM_ITEMS I,
2491: MSC_PLANS P -- For summary enhancement
2492: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
2493: AND I.ORGANIZATION_ID = p_org_id
2494: AND I.SR_INSTANCE_ID = p_instance_id
2495: AND I.PLAN_ID = p_plan_id

Line 5451: MSC_PLANS P -- For summary enhancement

5447: decode(AD.ALLOCATED_QUANTITY, -- Consider unscheduled orders as dummy supplies
5448: 0, OLD_ALLOCATED_QUANTITY,-- For summary enhancement
5449: -1 * AD.ALLOCATED_QUANTITY) SD_QTY
5450: FROM MSC_ALLOC_DEMANDS AD,
5451: MSC_PLANS P -- For summary enhancement
5452: WHERE AD.PLAN_ID = p_plan_id
5453: AND AD.SR_INSTANCE_ID = p_instance_id
5454: AND AD.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5455: AND AD.ORGANIZATION_ID = p_org_id

Line 5471: MSC_PLANS P -- For summary enhancement

5467: decode(SA.ALLOCATED_QUANTITY, -- Consider deleted stealing records as dummy demands
5468: 0, -1 * OLD_ALLOCATED_QUANTITY, -- For summary enhancement
5469: SA.ALLOCATED_QUANTITY) SD_QTY
5470: FROM MSC_ALLOC_SUPPLIES SA,
5471: MSC_PLANS P -- For summary enhancement
5472: WHERE SA.PLAN_ID = p_plan_id
5473: AND SA.SR_INSTANCE_ID = p_instance_id
5474: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5475: AND SA.ORGANIZATION_ID = p_org_id

Line 5909: MSC_PLANS P -- For summary enhancement

5905: 0, nvl(OLD_ALLOCATED_QUANTITY,0), --4658238 -- For summary enhancement
5906: -1 * AD.ALLOCATED_QUANTITY) SD_QTY,
5907: AD.DEMAND_CLASS
5908: FROM MSC_ALLOC_DEMANDS AD,
5909: MSC_PLANS P -- For summary enhancement
5910: WHERE AD.PLAN_ID = p_plan_id
5911: AND AD.SR_INSTANCE_ID = p_instance_id
5912: AND AD.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5913: AND AD.ORGANIZATION_ID = p_org_id

Line 5932: MSC_PLANS P -- For summary enhancement

5928: 0, -1 * OLD_ALLOCATED_QUANTITY, -- For summary enhancement
5929: SA.ALLOCATED_QUANTITY) SD_QTY ,
5930: SA.DEMAND_CLASS
5931: FROM MSC_ALLOC_SUPPLIES SA,
5932: MSC_PLANS P -- For summary enhancement
5933: WHERE SA.PLAN_ID = p_plan_id
5934: AND SA.SR_INSTANCE_ID = p_instance_id
5935: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)
5936: AND SA.ORGANIZATION_ID = p_org_id

Line 8892: FROM msc_plans mp,

8888:
8889: --bug3663487 start SQL ID 9426916 and 9426907
8890: SELECT c2.calendar_date,i2.organization_id,i2.sr_instance_id,i2.inventory_item_id
8891: BULK COLLECT INTO l_atf_date,l_organization_id,l_sr_instance_id,l_inventory_item_id
8892: FROM msc_plans mp,
8893: msc_plan_organizations po,
8894: msc_system_items i2,
8895: msc_trading_partners tp,
8896: msc_atp_rules r,

Line 8963: msc_plans mp,

8959: FROM msc_calendar_dates c2,
8960: msc_calendar_dates c1,
8961: msc_atp_rules r,
8962: msc_trading_partners tp,
8963: msc_plans mp,
8964: msc_system_items i2
8965: WHERE i2.inventory_item_id = i.inventory_item_id
8966: AND i2.organization_id = i.organization_id
8967: AND i2.sr_instance_id = i.sr_instance_id

Line 9263: FROM msc_plans

9259: msc_util.msc_log('l_share_partition := ' || l_share_partition);
9260:
9261: SELECT NVL(summary_flag,1), compile_designator
9262: INTO l_summary_flag, l_plan_name
9263: FROM msc_plans
9264: WHERE plan_id = p_plan_id;
9265:
9266: IF NVL(l_summary_flag,1) = 2 THEN
9267: msc_util.msc_log('Another session is running post-plan allocation program for this plan');

Line 9321: update msc_plans

9317: END IF;
9318: END LOOP;
9319:
9320: BEGIN
9321: update msc_plans
9322: set summary_flag = 2
9323: where plan_id = p_plan_id;
9324: commit;
9325: EXCEPTION

Line 10065: update msc_plans

10061: RAISE FND_API.G_EXC_ERROR;
10062: END IF;
10063:
10064: BEGIN
10065: update msc_plans
10066: set summary_flag = 3
10067: where plan_id = p_plan_id;
10068: END;
10069:

Line 10082: update msc_plans

10078: msc_util.msc_log(sqlerrm);
10079: ERRBUF := sqlerrm;
10080:
10081: BEGIN
10082: update msc_plans
10083: set summary_flag = 1
10084: where plan_id = p_plan_id;
10085: commit;
10086: END;