APPS.MRP_EPI dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 18: mrp_plan_organizations_v org

14:
15: CURSOR PLAN_BOUNDS_C(p_org_type IN NUMBER) IS
16: SELECT trunc(plan.data_start_date), trunc(plan.cutoff_date)
17: FROM mrp_plans plan,
18: mrp_plan_organizations_v org
19: WHERE DECODE(p_org_type, 1, org.planned_organization,
20: org.organization_id) = p_owning_org_id
21: AND org.compile_designator = p_designator
22: AND org.organization_id = plan.organization_id

Line 44: FROM mrp_plan_organizations_v org_v,

40:
41: CURSOR PLAN_ORGS_C(p_org_type IN NUMBER) IS
42: SELECT pln_sched.input_designator_name,
43: org_v.planned_organization
44: FROM mrp_plan_organizations_v org_v,
45: mrp_plan_schedules_v pln_sched
46: WHERE pln_sched.input_organization_id = org_v.planned_organization
47: AND pln_sched.compile_designator = org_v.compile_designator
48: AND DECODE(p_org_type, 1, org_v.planned_organization,

Line 142: mrp_plan_organizations_v org

138: sysdate,
139: 1
140: FROM mrp_plan_schedules_v pln_sched,
141: mrp_system_items sys,
142: mrp_plan_organizations_v org
143: WHERE sys.compile_designator = org.compile_designator
144: AND sys.organization_id = org.planned_organization
145: AND org.planned_organization = pln_sched.input_organization_id(+)
146: AND org.compile_designator = pln_sched.compile_designator(+)