VIEW: FLM.FLM_SEQ_RULE_CONSTRAINTS#

Source

View Text - Preformatted

select RULE_ID RULE_ID, CONSTRAINT_NUMBER CONSTRAINT_NUMBER, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, PRIORITY PRIORITY, CONSTRAINT_TYPE CONSTRAINT_TYPE, CONSTRAINT_TYPE_VALUE1 CONSTRAINT_TYPE_VALUE1, CONSTRAINT_TYPE_VALUE2 CONSTRAINT_TYPE_VALUE2, CONSTRAINT_TYPE_VALUE3 CONSTRAINT_TYPE_VALUE3, ATTRIBUTE_ID ATTRIBUTE_ID, ATTRIBUTE_VALUE1_NAME ATTRIBUTE_VALUE1_NAME, ATTRIBUTE_VALUE2_NAME ATTRIBUTE_VALUE2_NAME, ATTRIBUTE_VALUE1_NUM ATTRIBUTE_VALUE1_NUM, ATTRIBUTE_VALUE2_NUM ATTRIBUTE_VALUE2_NUM, ATTRIBUTE_VALUE1_DATE ATTRIBUTE_VALUE1_DATE, ATTRIBUTE_VALUE2_DATE ATTRIBUTE_VALUE2_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, PARENT_CONSTRAINT_NUMBER PARENT_CONSTRAINT_NUMBER from "FLM"."FLM_SEQ_RULE_CONSTRAINTS"

View Text - HTML Formatted

SELECT RULE_ID RULE_ID
, CONSTRAINT_NUMBER CONSTRAINT_NUMBER
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, PRIORITY PRIORITY
, CONSTRAINT_TYPE CONSTRAINT_TYPE
, CONSTRAINT_TYPE_VALUE1 CONSTRAINT_TYPE_VALUE1
, CONSTRAINT_TYPE_VALUE2 CONSTRAINT_TYPE_VALUE2
, CONSTRAINT_TYPE_VALUE3 CONSTRAINT_TYPE_VALUE3
, ATTRIBUTE_ID ATTRIBUTE_ID
, ATTRIBUTE_VALUE1_NAME ATTRIBUTE_VALUE1_NAME
, ATTRIBUTE_VALUE2_NAME ATTRIBUTE_VALUE2_NAME
, ATTRIBUTE_VALUE1_NUM ATTRIBUTE_VALUE1_NUM
, ATTRIBUTE_VALUE2_NUM ATTRIBUTE_VALUE2_NUM
, ATTRIBUTE_VALUE1_DATE ATTRIBUTE_VALUE1_DATE
, ATTRIBUTE_VALUE2_DATE ATTRIBUTE_VALUE2_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, PARENT_CONSTRAINT_NUMBER PARENT_CONSTRAINT_NUMBER
FROM "FLM"."FLM_SEQ_RULE_CONSTRAINTS"