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 7515: -- FROM msc_plans

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

Line 11463: msc_plans mp

11459: IF l_calendar_code = '@@@' THEN
11460: SELECT tp.calendar_code
11461: INTO l_calendar_code
11462: FROM msc_trading_partners tp,
11463: msc_plans mp
11464: WHERE mp.plan_id = p_sup_atp_info_rec.plan_id
11465: AND tp.sr_instance_id = mp.sr_instance_id
11466: AND tp.partner_type = 3
11467: AND tp.sr_tp_id = mp.organization_id;

Line 11497: FROM msc_plans plans

11493:
11494: -- Summary enhancement - check summary flag
11495: SELECT summary_flag
11496: INTO l_summary_flag
11497: FROM msc_plans plans
11498: WHERE plans.plan_id = p_sup_atp_info_rec.plan_id;
11499:
11500: IF PG_DEBUG in ('Y', 'C') THEN
11501: msc_sch_wb.atp_debug('Get_Supplier_Atp_Info: ' || 'l_summary_flag := ' || l_summary_flag);

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

11547: UNION ALL
11548:
11549: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11550: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11551: -- 2. MSC_PLANS included in the join to get latest refresh number
11552: -- 3. Filter records based on refresh_number
11553: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11554: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,
11555: 1, p.new_ship_date,

Line 11559: msc_plans pl -- For summary enhancement

11555: 1, p.new_ship_date,
11556: p.new_dock_date)) l_date, -- For ship_rec_cal
11557: (NVL(p.implement_quantity,0) - p.new_order_quantity) quantity
11558: FROM msc_supplies p,
11559: msc_plans pl -- For summary enhancement
11560: WHERE (p.order_type IN (5, 2,60)
11561: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
11562: AND p.order_type = 1 AND p.promised_date IS NULL))
11563: AND p.plan_id = p_sup_atp_info_rec.plan_id

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

11605: UNION ALL
11606:
11607: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11608: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11609: -- 2. MSC_PLANS included in the join to get latest refresh number
11610: -- 3. Filter records based on refresh_number
11611: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11612: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,
11613: 1, p.new_ship_date,

Line 11617: msc_plans pl -- For summary enhancement

11613: 1, p.new_ship_date,
11614: p.new_dock_date)) l_date, -- For ship_rec_cal
11615: (NVL(p.implement_quantity,0) - p.new_order_quantity) quantity
11616: FROM msc_supplies p,
11617: msc_plans pl -- For summary enhancement
11618: WHERE (p.order_type IN (5, 2, 60)
11619: OR (MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE = MSC_ATP_REQ.G_PROMISE_DATE
11620: AND p.order_type = 1 AND p.promised_date IS NULL))
11621: AND p.plan_id = p_sup_atp_info_rec.plan_id

Line 12648: msc_plans p

12644: s.volume_capacity volume
12645: FROM msc_calendar_dates c,
12646: msc_interorg_ship_methods s,
12647: msc_trading_partners tp,
12648: msc_plans p
12649: WHERE s.plan_id = p_plan_id
12650: AND s.from_organization_id = p_from_organization_id
12651: AND s.to_organization_id = p_to_organization_id
12652: AND s.ship_method = p_ship_method

Line 13046: msc_plans p

13042: FROM
13043: msc_calendar_dates c,
13044: msc_interorg_ship_methods s,
13045: msc_trading_partners tp,
13046: msc_plans p
13047: WHERE
13048: s.plan_id = p_plan_id
13049: AND s.from_organization_id = p_from_organization_id
13050: AND s.to_organization_id = p_to_organization_id

Line 13206: msc_plans p

13202: FROM
13203: msc_calendar_dates c,
13204: msc_interorg_ship_methods s,
13205: msc_trading_partners tp,
13206: msc_plans p
13207: WHERE
13208: s.plan_id = p_plan_id
13209: AND s.from_organization_id = p_from_organization_id
13210: AND s.to_organization_id = p_to_organization_id