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

Line 1500: -- 5. MSC_PLANS included in the join to get latest refresh number

1496: -- 1. No union with MSC_NET_RES_AVAIL
1497: -- 2. Get the hours always from RESOURCE_HOURS - never from LOAD_RATE or DAILY_RESOURCE_HOURS
1498: -- 3. PARENT_ID removed from where clause. No difference between constrained and unconstrained plans
1499: -- 4. MSC_SYSTEM_ITEMS not included in the join because the filters on items is not applied for ATP records
1500: -- 5. MSC_PLANS included in the join to get latest refresh number
1501: -- 6. Filter records based on refresh_number
1502: -- Bug 3348095
1503: -- For ATP created records use end_date otherwise start_date
1504: SELECT TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)) SD_DATE,

Line 1509: MSC_PLANS P -- For summary enhancement

1505: -- End Bug 3348095
1506: -1 * REQ.RESOURCE_HOURS SD_QTY -- Summary enhancement: Need to bother only about ATP generated records
1507: FROM MSC_DEPARTMENT_RESOURCES DR,
1508: MSC_RESOURCE_REQUIREMENTS REQ,
1509: MSC_PLANS P -- For summary enhancement
1510: --bug3394866
1511: WHERE DR.PLAN_ID = p_plan_id
1512: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id
1513: AND DR.RESOURCE_ID = p_res_id

Line 1972: MSC_PLANS P -- For summary enhancement

1968: 0, nvl(D.OLD_DEMAND_QUANTITY,0), --4658238 -- For summary enhancement
1969: -1 * D.USING_REQUIREMENT_QUANTITY) SD_QTY
1970: FROM MSC_DEMANDS D,
1971: MSC_SYSTEM_ITEMS I,
1972: MSC_PLANS P -- For summary enhancement
1973: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1974: AND I.ORGANIZATION_ID = p_org_id
1975: AND I.SR_INSTANCE_ID = p_instance_id
1976: AND I.PLAN_ID = p_plan_id

Line 1997: MSC_PLANS P -- For summary enhancement

1993: SELECT TRUNC(NVL(S.FIRM_DATE,S.NEW_SCHEDULE_DATE)) SD_DATE,
1994: NVL(S.FIRM_QUANTITY,S.NEW_ORDER_QUANTITY) SD_QTY
1995: FROM MSC_SUPPLIES S,
1996: MSC_SYSTEM_ITEMS I,
1997: MSC_PLANS P -- For summary enhancement
1998: WHERE I.SR_INVENTORY_ITEM_ID = p_item_id
1999: AND I.ORGANIZATION_ID = p_org_id
2000: AND I.SR_INSTANCE_ID = p_instance_id
2001: AND I.PLAN_ID = p_plan_id

Line 4829: FROM msc_plans plans

4825: )
4826: ),
4827: summary_flag
4828: INTO MSC_ATP_PVT.G_OPTIMIZED_PLAN, l_summary_flag -- For summary enhancement
4829: FROM msc_plans plans
4830: WHERE plans.plan_id = p_mat_atp_info_rec.plan_id;
4831: EXCEPTION WHEN NO_DATA_FOUND THEN
4832: MSC_ATP_PVT.G_OPTIMIZED_PLAN := 2;
4833: END;

Line 5824: msc_plans plans

5820: ), 0),
5821: plans.summary_flag -- for summary enhancement
5822: INTO l_use_bor, MSC_ATP_PVT.G_OPTIMIZED_PLAN, l_constraint_plan, l_summary_flag
5823: FROM msc_designators desig,
5824: msc_plans plans
5825: WHERE plans.plan_id = p_plan_id
5826: AND desig.designator = plans.compile_designator
5827: AND desig.sr_instance_id = plans.sr_instance_id
5828: AND desig.organization_id = plans.organization_id;

Line 7511: -- FROM msc_plans

7507: -- Supplier Capacity and Lead Time (SCLT) Proj
7508: -- Commented out
7509: -- SELECT curr_cutoff_date, trunc(plan_start_date)
7510: -- INTO l_infinite_time_fence_date, l_plan_start_date
7511: -- FROM msc_plans
7512: -- WHERE plan_id = p_plan_id;
7513:
7514: -- Instead re-assigned local values using global variable
7515: l_plan_start_date := MSC_ATP_PVT.G_PLAN_INFO_REC.plan_start_date;

Line 11430: msc_plans mp

11426: IF l_calendar_code = '@@@' THEN
11427: SELECT tp.calendar_code
11428: INTO l_calendar_code
11429: FROM msc_trading_partners tp,
11430: msc_plans mp
11431: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
11432: AND tp.sr_instance_id = mp.sr_instance_id
11433: AND tp.partner_type = 3
11434: AND tp.sr_tp_id = mp.organization_id;

Line 11464: FROM msc_plans plans

11460:
11461: -- Summary enhancement - check summary flag
11462: SELECT summary_flag
11463: INTO l_summary_flag
11464: FROM msc_plans plans
11465: WHERE plans.plan_id = p_sup_atp_info_rec.plan_id;
11466:
11467: IF PG_DEBUG in ('Y', 'C') THEN
11468: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'l_summary_flag := ' || l_summary_flag);

Line 11518: -- 2. MSC_PLANS included in the join to get latest refresh number

11514: UNION ALL
11515:
11516: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11517: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11518: -- 2. MSC_PLANS included in the join to get latest refresh number
11519: -- 3. Filter records based on refresh_number
11520: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11521: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,
11522: 1, p.new_ship_date,

Line 11526: msc_plans pl -- For summary enhancement

11522: 1, p.new_ship_date,
11523: p.new_dock_date)) l_date, -- For ship_rec_cal
11524: (NVL(p.implement_quantity,0) - p.new_order_quantity) quantity
11525: FROM msc_supplies p,
11526: msc_plans pl -- For summary enhancement
11527: WHERE (p.order_type IN (5, 2,60)
11528: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
11529: AND p.order_type = 1 AND p.promised_date IS NULL))
11530: AND p.plan_id = p_sup_atp_info_rec.plan_id

Line 11576: -- 2. MSC_PLANS included in the join to get latest refresh number

11572: UNION ALL
11573:
11574: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11575: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11576: -- 2. MSC_PLANS included in the join to get latest refresh number
11577: -- 3. Filter records based on refresh_number
11578: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11579: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,
11580: 1, p.new_ship_date,

Line 11584: msc_plans pl -- For summary enhancement

11580: 1, p.new_ship_date,
11581: p.new_dock_date)) l_date, -- For ship_rec_cal
11582: (NVL(p.implement_quantity,0) - p.new_order_quantity) quantity
11583: FROM msc_supplies p,
11584: msc_plans pl -- For summary enhancement
11585: WHERE (p.order_type IN (5, 2, 60)
11586: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
11587: AND p.order_type = 1 AND p.promised_date IS NULL))
11588: AND p.plan_id = p_sup_atp_info_rec.plan_id

Line 12615: msc_plans p

12611: s.volume_capacity volume
12612: FROM msc_calendar_dates c,
12613: msc_interorg_ship_methods s,
12614: msc_trading_partners tp,
12615: msc_plans p
12616: WHERE s.plan_id = p_plan_id
12617: AND s.from_organization_id = p_from_organization_id
12618: AND s.to_organization_id = p_to_organization_id
12619: AND s.ship_method = p_ship_method

Line 13013: msc_plans p

13009: FROM
13010: msc_calendar_dates c,
13011: msc_interorg_ship_methods s,
13012: msc_trading_partners tp,
13013: msc_plans p
13014: WHERE
13015: s.plan_id = p_plan_id
13016: AND s.from_organization_id = p_from_organization_id
13017: AND s.to_organization_id = p_to_organization_id

Line 13173: msc_plans p

13169: FROM
13170: msc_calendar_dates c,
13171: msc_interorg_ship_methods s,
13172: msc_trading_partners tp,
13173: msc_plans p
13174: WHERE
13175: s.plan_id = p_plan_id
13176: AND s.from_organization_id = p_from_organization_id
13177: AND s.to_organization_id = p_to_organization_id