DBA Data[Home] [Help]

APPS.MRP_ADJUST_DATES_PK dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 165: from mrp_plan_organizations_v orgs

161: /*2285842 AND cal.calendar_date = dates.schedule_workdate*/
162: AND cal.calendar_date = dates.schedule_date
163: AND desig.organization_id
164: in (select organization_id
165: from mrp_plan_organizations_v orgs
166: where orgs.compile_designator =
167: dates.schedule_designator
168: and orgs.planned_organization =
169: dates.organization_id

Line 190: mrp_plan_organizations_v orgs

186: dates.schedule_date = schedule_workdate
187: WHERE ((organization_id, schedule_designator) IN
188: (SELECT org_id, desig.schedule_designator
189: FROM mrp_schedule_designators desig,
190: mrp_plan_organizations_v orgs
191: WHERE orgs.planned_organization (+) = org_id
192: AND desig.organization_id = NVL(orgs.organization_id,
193: org_id)
194: AND desig.schedule_designator =

Line 312: FROM mrp_plan_organizations_v

308: SET data_completion_date = NULL,
309: plan_completion_date = NULL
310: WHERE (compile_designator , organization_id) in
311: (SELECT compile_designator , organization_id
312: FROM mrp_plan_organizations_v
313: WHERE
314: planned_organization = org_id);
315:
316: COMMIT;