工单物料需求直接insert-SQL

l_requirement_operations.wip_supply_type        := rec_bom.wip_supply_type;

          l_requirement_operations.inventory_item_id      := rec_bom.component_item_id;

          l_requirement_operations.basis_type             := NULL;

          l_requirement_operations.organization_id        := rec.organization_id;

          l_requirement_operations.wip_entity_id          := rec.wip_entity_id;

          l_requirement_operations.operation_seq_num      := l_operation_seq_num;

          l_requirement_operations.repetitive_schedule_id := NULL;

          l_requirement_operations.last_update_date       := SYSDATE;

          l_requirement_operations.last_updated_by        := fnd_global.user_id;

          l_requirement_operations.creation_date          := SYSDATE;

          l_requirement_operations.created_by             := fnd_global.user_id;

          l_requirement_operations.last_update_login      := fnd_global.login_id;

          l_requirement_operations.department_id          := l_department_id;

          l_requirement_operations.wip_supply_type        := rec_bom.wip_supply_type;

          l_requirement_operations.date_required          := l_start_date;

          l_requirement_operations.required_quantity      := rec.start_quantity * rec_bom.extended_quantity;

          l_requirement_operations.quantity_issued        := 0;

          l_requirement_operations.quantity_per_assembly  := rec_bom.quantity;

          l_requirement_operations.component_yield_factor := rec_bom.component_yield_factor;

          l_requirement_operations.comments               := '系统新增需求';

          l_requirement_operations.supply_subinventory    := NULL;

          l_requirement_operations.supply_locator_id      := NULL;

          l_requirement_operations.mrp_net_flag           := 1;

          l_requirement_operations.mps_required_quantity  := NULL;

          l_requirement_operations.mps_date_required      := NULL;

          l_requirement_operations.attribute_category     := NULL;

          l_requirement_operations.attribute1             := NULL;

          l_requirement_operations.attribute2             := NULL;

          l_requirement_operations.attribute3             := NULL;

          l_requirement_operations.attribute4             := NULL;

          l_requirement_operations.attribute5             := NULL;

          l_requirement_operations.attribute6             := NULL;

          l_requirement_operations.attribute7             := NULL;

          l_requirement_operations.attribute8             := NULL;

          l_requirement_operations.attribute9             := NULL;

          l_requirement_operations.attribute10            := NULL;

          l_requirement_operations.attribute11            := NULL;

          l_requirement_operations.attribute12            := NULL;

          l_requirement_operations.attribute13            := NULL;

          l_requirement_operations.attribute14            := NULL;

          l_requirement_operations.attribute15            := 'Y';-

          l_requirement_operations.request_id             := fnd_global.conc_request_id;