DBA Data[Home] [Help]

APPS.MRP_UPDATE_MRP_INFO_PK dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 224: mrp_plan_organizations_v plans

220: desig.organization_id),
221: desig.schedule_designator
222: from
223: mrp_schedule_designators desig,
224: mrp_plan_organizations_v plans
225: WHERE
226: NVL(desig.disable_date, TRUNC(SYSDATE)+1)>TRUNC(SYSDATE)
227: AND desig.mps_relief = 1
228: AND desig.schedule_type = 2

Line 259: mrp_plan_organizations_v plans

255: (select plans.compile_designator ,
256: plans.planned_organization
257: from
258: mrp_designators_view desig,
259: mrp_plan_organizations_v plans
260: where
261: NVL(desig.disable_date, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
262: AND desig.organization_id = plans.organization_id
263: AND desig.designator = plans.compile_designator