DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on MRP_PLAN_SCHEDULES_V

Line 45: mrp_plan_schedules_v pln_sched

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,
49: org_v.organization_id) = p_owning_org_id

Line 140: FROM mrp_plan_schedules_v pln_sched,

136: sysdate,
137: 1,
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