[Home] [Help]
1262: MRP_UTIL.MRP_LOG (mrp_kanban_plan_pk.g_log_message);
1263: END IF;
1264:
1265: -- now update the mrp_low_level_codes table with operation_yield
1266: -- and net_planning_percent from the bom_operation_sequences table.
1267: -- We did this separately after inserting all that we wanted to
1268: -- insert only to make the code a little cleaner. We tried doing
1269: -- this in the above sql statement itself but obviously if got
1270: -- kinda ugly trying to achieve it.
1268: -- insert only to make the code a little cleaner. We tried doing
1269: -- this in the above sql statement itself but obviously if got
1270: -- kinda ugly trying to achieve it.
1271:
1272: -- bom_inventory_components and bom_operation_sequences are linked
1273: -- by the operation sequence number and for a particular operation
1274: -- sequence we have the net_planning_percent and the operation_yield
1275: -- (actually the reverse_cumulative_yield column) stored in
1276: -- bom_operation_sequences table
1272: -- bom_inventory_components and bom_operation_sequences are linked
1273: -- by the operation sequence number and for a particular operation
1274: -- sequence we have the net_planning_percent and the operation_yield
1275: -- (actually the reverse_cumulative_yield column) stored in
1276: -- bom_operation_sequences table
1277:
1278: UPDATE mrp_low_level_codes mllc
1279: SET (mllc.operation_yield,mllc.net_planning_percent) =
1280: (SELECT min(bos.reverse_cumulative_yield),
1278: UPDATE mrp_low_level_codes mllc
1279: SET (mllc.operation_yield,mllc.net_planning_percent) =
1280: (SELECT min(bos.reverse_cumulative_yield),
1281: min(bos.net_planning_percent)
1282: FROM bom_operation_sequences bos,
1283: bom_operational_routings bor,
1284: bom_inventory_components mrp_bic,
1285: bom_bill_of_materials bbom
1286: WHERE bbom.assembly_item_id = mllc.assembly_item_id