APPS.GMP_PLNG_DTL_REPORT_PKG dependencies on MSC_PLANS

Line 901: ' msc_plans mp '||

897: ' msc_supplies sup, '||
898: ' msc_trading_partners mtp, '||
899: ' msc_calendar_dates cal, '||
900: ' mfg_lookups l1, '||
901: ' msc_plans mp '||
902: ' WHERE cal.calendar_date BETWEEN TRUNC (sup.new_schedule_date) '||
903: ' AND NVL (TRUNC (sup.last_unit_completion_date), '||
904: ' TRUNC (sup.new_schedule_date) '||
905: ' ) '||

Line 999: ' msc_plans mp '||

995: ' msc_demands dem, '||
996: ' msc_trading_partners mtp, '||
997: ' msc_calendar_dates cal, '||
998: ' mfg_lookups l1, '||
999: ' msc_plans mp '||
1000: ' WHERE cal.calendar_date BETWEEN TRUNC (dem.using_assembly_demand_date) '||
1001: ' AND NVL (TRUNC (dem.assembly_demand_comp_date), '||
1002: ' TRUNC (dem.using_assembly_demand_date) '||
1003: ' ) '||

Line 1722: FROM msc_plans

1718: BEGIN
1719:
1720: SELECT compile_designator
1721: INTO plan_name
1722: FROM msc_plans
1723: WHERE plan_id = G_plan_id;
1724:
1725: RETURN plan_name;
1726: