Details
Grants
References
Dependencies
Code
Details
Grants
References
Dependencies
Code
NAME | VALUE |
---|---|
OWNER | DWH_TIENDAS_ADM |
OBJECT_NAME | VENTAS_TR1 |
SUBOBJECT_NAME | null |
OBJECT_ID | 24676 |
DATA_OBJECT_ID | null |
OBJECT_TYPE | TRIGGER |
CREATED | 08/01/16 |
LAST_DDL_TIME | 08/01/16 |
TIMESTAMP | 2016-01-08:12:26:20 |
STATUS | VALID |
TEMPORARY | N |
GENERATED | N |
SECONDARY | N |
NAMESPACE | 3 |
EDITION_NAME | null |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
NAME | OWNER | TYPE | OBJECT_ID | STATUS | TYPE_LINK |
---|
NAME | OWNER | TYPE | OBJECT_ID | STATUS | TYPE_LINK |
---|---|---|---|---|---|
VENTAS | DWH_TIENDAS_ADM | TABLE | 24643 | VALID | TABLE |
ESTADISTICAS_DIRECCION | DWH_TIENDAS_ADM | TABLE | 24649 | VALID | TABLE |
PKG_EST_DIR | DWH_TIENDAS_ADM | PACKAGE | 24665 | VALID | PACKAGE |
TRIGGER VENTAS_TR1 AFTER DELETE ON VENTAS DECLARE rsp_temp STRING (200); BEGIN PKG_EST_DIR.ACTLZR_EST_GLOBAL(rsp_temp); END;