ERP二次开发
-
编辑 删除
DB触发器的应用实例
CREATE OR REPLACE TRIGGER CUX_BOM_TRI AFTER INSERT OR UPDATE ON CUX_WIP_BOM REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW when (NVL(NEW.WIP_SUPPLY_TYPE,1) = 6) DECLARE l_return_err VARCHAR2(80); BEGIN BEGIN insert into CUX_WIP_BOM1 nologging select distinct :new.Wip_Entity_Id ,bicv.item_num ,bbom.assembly_item_id ,msib.segment1 ,msib.description ,bbom.uom ,bicv.component_item_id ,msib1.segment1 com_segment1 ,msib1.description com_description ,bicv.primary_uom_code ,BICV.supply_subinventory --,m
