工单物料需求直接update-SQL

UPDATE wip_requirement_operations t

               SET last_update_date       = SYSDATE,

                   last_updated_by        = fnd_global.user_id,

                   last_update_login      = fnd_global.login_id,

                  /* wip_supply_type        = rec_bom.wip_supply_type,*/

                   required_quantity      = 0,

                   quantity_per_assembly  = 0,

                  /*  component_yield_factor = rec_bom.component_yield_factor,*/

                   comments               = '系统BOM自动刷新',

                   quantity_backordered   = l_requirement_operations.required_quantity,

                   attribute15            = 'Y'

             WHERE t.wip_entity_id = rec_req.wip_entity_id

               AND t.inventory_item_id = rec_req.INVENTORY_ITEM_ID

               AND t.wip_supply_type = rec_req.wip_supply_type