APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on MSC_PLANS

Line 712: ' msc_plans mp '||

708: ' msc_supplies sup, '||
709: ' msc_trading_partners mtp, '||
710: ' msc_calendar_dates cal, '||
711: ' mfg_lookups l1, '||
712: ' msc_plans mp '||
713: ' WHERE cal.calendar_date BETWEEN TRUNC (sup.new_schedule_date) '||
714: ' AND NVL (TRUNC (sup.last_unit_completion_date), '||
715: ' TRUNC (sup.new_schedule_date) '||
716: ' ) '||

Line 810: ' msc_plans mp '||

806: ' msc_demands dem, '||
807: ' msc_trading_partners mtp, '||
808: ' msc_calendar_dates cal, '||
809: ' mfg_lookups l1, '||
810: ' msc_plans mp '||
811: ' WHERE cal.calendar_date BETWEEN TRUNC (dem.using_assembly_demand_date) '||
812: ' AND NVL (TRUNC (dem.assembly_demand_comp_date), '||
813: ' TRUNC (dem.using_assembly_demand_date) '||
814: ' ) '||

Line 1373: FROM msc_plans

1369: BEGIN
1370:
1371: SELECT compile_designator
1372: INTO plan_name
1373: FROM msc_plans
1374: WHERE plan_id = G_plan_id;
1375:
1376: RETURN plan_name;
1377: