ITPub博客

--建一備份TABLE記錄保留記錄CREATE TABLE GOBO_OM_RESERVATIONS( SUPPLY_SOURCE_HEADER_ID NUMBER, ORGANIZATION_ID NUMBER, INVENTORY_ITEM_ID NUMBER, DEMAND_SOURCE_TYPE_ID NUMBER, DEMAND_SOURCE_HEADER_ID NUMBER, DEMAND_SOURCE_LINE_ID NUMBER, RESERVATION_QUANTITY NUMBER, SUPPLY_SOURCE_TYPE_ID NUMBER, CREATION_DATE DATE, LAST_UPDATE_DATE DATE) CREATE OR REPLACE TRIGGER APPS.gobo_om_reservations_in after insert on mtl_reservations