DBA Data[Home] [Help]

APPS.MSC_WS_RP dependencies on MSC_PLANS

Line 72: FROM msc_plans plans, msc_designators desig

68: SELECT plans.compile_designator, plans.organization_id, plans.sr_instance_id--,
69: --desig.inventory_atp_flag, desig.production
70: INTO l_val_planname,l_val_orgid,l_val_instanceid--,l_val_inventory_atp_flag,
71: --l_val_production
72: FROM msc_plans plans, msc_designators desig
73: WHERE plans.curr_plan_type in (101,102,103,105)
74: AND plans.organization_id = desig.organization_id
75: AND plans.sr_instance_id = desig.sr_instance_id
76: AND plans.compile_designator = desig.designator