APPS.MRP_UPDATE_PLAN_OPTIONS_PK dependencies on MRP_PLAN_ORGANIZATIONS

Line 83: INTO mrp_plan_organizations

79:
80: COMMIT;
81:
82: INSERT
83: INTO mrp_plan_organizations
84: (organization_id,
85: compile_designator,
86: planned_organization,
87: plan_level,

Line 110: FROM mrp_plan_organizations orgs

106: net_wip,
107: net_reservations,
108: net_purchasing,
109: plan_safety_stock
110: FROM mrp_plan_organizations orgs
111: WHERE orgs.organization_id = arg_org_id
112: AND orgs.compile_designator = arg_compile_desig
113: AND orgs.plan_level = LAST_SUBMITTED
114: AND NOT EXISTS

Line 116: from mrp_plan_organizations orgs1

112: AND orgs.compile_designator = arg_compile_desig
113: AND orgs.plan_level = LAST_SUBMITTED
114: AND NOT EXISTS
115: (SELECT null
116: from mrp_plan_organizations orgs1
117: where orgs1.organization_id = orgs.organization_id
118: and orgs1.compile_designator = orgs.compile_designator
119: and orgs1.plan_level = LAST_LAST_SUBMITTED
120: and orgs1.planned_organization =

Line 124: DELETE FROM mrp_plan_organizations

120: and orgs1.planned_organization =
121: orgs.planned_organization);
122: COMMIT;
123:
124: DELETE FROM mrp_plan_organizations
125: WHERE organization_id = arg_org_id
126: AND compile_designator = arg_compile_desig
127: AND plan_level = LAST_SUBMITTED;
128:

Line 139: INTO mrp_plan_organizations

135:
136: COMMIT;
137:
138: INSERT
139: INTO mrp_plan_organizations
140: (organization_id,
141: compile_designator,
142: planned_organization,
143: plan_level,

Line 166: FROM mrp_plan_organizations

162: net_wip,
163: net_reservations,
164: net_purchasing,
165: plan_safety_stock
166: FROM mrp_plan_organizations
167: WHERE organization_id = arg_org_id
168: AND compile_designator = arg_compile_desig
169: AND plan_level = CURRENT_LEVEL;
170:

Line 231: DELETE from mrp_plan_organizations

227: AND compile_designator = arg_compile_desig;
228:
229: if var_org_selection <> SINGLE_ORG
230: THEN
231: DELETE from mrp_plan_organizations
232: WHERE organization_id = arg_org_id
233: AND compile_designator = arg_compile_desig
234: AND plan_level = LAST_LAST_SUBMITTED;
235: end if;