APPS.MRP_REL_PLAN_PUB dependencies on MRP_PLANS

Line 39: -- log in org and using it when it is not same as mrp_plans.organization_id.

35: -- Modified by APATANKA. Bug # 371223. A multi-org plan in an org in which
36: -- it is not defined would generate orders in all orgs.
37: --
38: -- Fix includes adding one more parameter -- parameter.org_id which is the
39: -- log in org and using it when it is not same as mrp_plans.organization_id.
40: --
41: -- 8/13/96: Changed the name back to MRP_RELEASE_PLAN_SC
42: --
43: -- 8/26/96: Changing the code.

Line 140: FROM mrp_plans mp,

136: end if;
137:
138: SELECT sched.demand_class
139: INTO var_demand_class
140: FROM mrp_plans mp,
141: mrp_schedule_designators sched
142: WHERE sched.organization_id (+)= mp.organization_id
143: AND sched.schedule_designator (+)= mp.compile_designator
144: AND mp.organization_id = arg_org_id