APPS.MRP_EXP_WF dependencies on MRP_PLANS

Line 263: FROM mrp_plans

259: SELECT NVL(plan_type, curr_plan_type),
260: NVL(organization_selection, 1)
261: INTO l_plan_type,
262: l_org_selection
263: FROM mrp_plans
264: WHERE organization_id = p_owning_org_id
265: AND compile_designator = p_designator;
266:
267: if (l_org_selection = 1) then -- single org

Line 340: UPDATE mrp_plans

336: l_max_exception_id := l_exception_id;
337:
338: CLOSE EXCEPTION_DETAILS_C;
339:
340: UPDATE mrp_plans
341: SET min_wf_except_id = l_min_exception_id,
342: max_wf_except_id = l_max_exception_id
343: WHERE organization_id = p_owning_org_id
344: AND compile_designator = p_designator;

Line 623: FROM mrp_plans_sc_v

619:
620: CURSOR CHK_PRODUCTION_C(p_compile_designator in varchar2,
621: p_organization_id in number) IS
622: SELECT production
623: FROM mrp_plans_sc_v
624: /** Bug 2286190 WHERE organization_id = p_organization_id **/
625: WHERE planned_organization = p_organization_id
626: AND compile_designator = p_compile_designator;
627:

Line 2008: FROM mrp_plans

2004: SELECT min_wf_except_id,
2005: max_wf_except_id
2006: INTO l_min_exception_id,
2007: l_max_exception_id
2008: FROM mrp_plans
2009: WHERE organization_id = arg_organization_id
2010: AND compile_designator = arg_compile_desig;
2011:
2012: if (l_min_exception_id is not null and l_max_exception_id is not null) then