DBA Data[Home] [Help]

APPS.MRP_SOURCING_RULE_PVT dependencies on MRP_SOURCING_RULES

Line 1170: UPDATE mrp_sourcing_rules

1166: (l_curr_rank <> l_Shipping_Org_tbl(I).rank)) /* Bug 2263575 */
1167: THEN
1168:
1169: IF l_curr_rco_index <> 0 AND l_tot_alloc_percent < 100 THEN
1170: UPDATE mrp_sourcing_rules
1171: SET planning_active = 2
1172: WHERE sourcing_rule_id =
1173: l_sourcing_rule_rec.sourcing_rule_id;
1174: END IF;

Line 1328: UPDATE mrp_sourcing_rules

1324:
1325: END LOOP;
1326:
1327: IF l_tot_alloc_percent < 100 THEN /* bug 2263575 : For the last record */
1328: UPDATE mrp_sourcing_rules
1329: SET planning_active = 2
1330: WHERE sourcing_rule_id =
1331: l_sourcing_rule_rec.sourcing_rule_id;
1332: END IF;