APPS.MRP_EXP_WF dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 35: FROM mrp_exception_details_v exp, mrp_plan_organizations_v mpo

31: exp.end_order_number,
32: exp.department_line_code,
33: exp.resource_code,
34: exp.utilization_rate
35: FROM mrp_exception_details_v exp, mrp_plan_organizations_v mpo
36: WHERE exp.exception_type in (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20)
37: AND mpo.organization_id = p_owning_org_id
38: AND mpo.compile_designator = p_designator
39: AND exp.organization_id = mpo.planned_organization

Line 1722: FROM mrp_plan_organizations_v

1718: if (l_order_type in (1, 2, 3, 13)) then -- po, req, discrete, repetitve
1719:
1720: SELECT organization_id
1721: INTO l_owning_org_id
1722: FROM mrp_plan_organizations_v
1723: WHERE planned_organization = l_organization_id
1724: AND compile_designator = l_compile_designator;
1725:
1726: SELECT mrp_workbench_query_s.nextval,