APPS.MRP_PLANNER_PK dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 82: from mrp_plan_organizations_v

78: from mrp_form_query
79: WHERE query_id = arg_query_id))
80: AND organization_id in
81: (select planned_organization
82: from mrp_plan_organizations_v
83: where organization_id = arg_org_id
84: and compile_designator = arg_compile_desig)
85: AND schedule_designator = arg_compile_desig;
86:

Line 123: from mrp_plan_organizations_v

119: from mrp_form_query
120: WHERE query_id = arg_query_id))
121: AND organization_id in
122: (select planned_organization
123: from mrp_plan_organizations_v
124: where organization_id = arg_org_id
125: and compile_designator = arg_compile_desig)
126: AND schedule_designator = arg_compile_desig;
127:

Line 194: from mrp_plan_organizations_v

190: from mrp_form_query
191: WHERE query_id = arg_query_id))
192: AND organization_id in
193: (select planned_organization
194: from mrp_plan_organizations_v
195: where organization_id = arg_org_id
196: and compile_designator = arg_compile_desig)
197: AND schedule_designator = arg_compile_desig;
198:

Line 283: from mrp_plan_organizations_v

279: AND changes.inventory_item_id = data.inventory_item_id
280: AND changes.order_type IN (PLANNED_ORDER, REPETITVE_SCHEDULE)
281: AND data.mrp_planning_code IN (MPS_PLANNING, MPS_AND_DRP_PLANNING)
282: AND data.organization_id IN (select planned_organization
283: from mrp_plan_organizations_v
284: where organization_id = arg_org_id
285: and compile_designator = arg_compile_desig)
286: AND data.compile_designator = arg_compile_desig;
287:

Line 426: from mrp_plan_organizations_v

422: dates.mps_transaction_id
423: AND schedule_level = ORIG_SCHEDULE)
424: AND schedule_level = UPDATED_SCHEDULE
425: AND organization_id IN (select planned_organization
426: from mrp_plan_organizations_v
427: where organization_id = arg_org_id
428: and compile_designator = arg_sched_desig)
429: AND schedule_designator = arg_sched_desig;
430: