FND_FLEX_VALUE_SETS

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

FLEX_VALUE_SET_ID FLEX_VALUE_SET_NAME DESCRIPTION PROTECTED_FLAG SECURITY_ENABLED_FLAG VALIDATION_TYPE LONGLIST_FLAG PARENT_FLEX_VALUE_SET_ID DEPENDANT_DEFAULT_VALUE DEPENDANT_DEFAULT_MEANING FORMAT_TYPE MAXIMUM_SIZE NUMBER_PRECISION ALPHANUMERIC_ALLOWED_FLAG UPPERCASE_ONLY_FLAG NUMERIC_MODE_ENABLED_FLAG MINIMUM_VALUE MAXIMUM_VALUE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.VALUE_SET_ID FLEX_VALUE_SET_ID, B.VALUE_SET_CODE FLEX_VALUE_SET_NAME, B.DESCRIPTION DESCRIPTION, SUBSTR('N', 1, 1) PROTECTED_FLAG, DECODE(B.SECURITY_ENABLED_FLAG, 'Y', 'Y', 'N') SECURITY_ENABLED_FLAG, DECODE(B.VALIDATION_TYPE, 'FORMAT', 'N', 'INDEP', DECODE(B.VALUE_DATA_TYPE || '.' || B.VALUE_SUBTYPE, 'VARCHAR2.TRANSLATED', 'X', 'I'), 'DEP', DECODE(B.VALUE_DATA_TYPE || '.' || B.VALUE_SUBTYPE, 'VARCHAR2.TRANSLATED', 'Y', 'D'), 'TABLE', 'F', 'SUBSET', 'S', 'VIEW_OBJECT', 'V', 'E') VALIDATION_TYPE, SUBSTR('N', 1, 1) LONGLIST_FLAG, B.INDEPENDENT_VALUE_SET_ID PARENT_FLEX_VALUE_SET_ID, DECODE(B.VALUE_SET_CODE, NULL, RPAD(' ', 60), NULL) DEPENDANT_DEFAULT_VALUE, DECODE(B.VALUE_SET_CODE, NULL, RPAD(' ', 240), NULL) DEPENDANT_DEFAULT_MEANING, DECODE(B.VALUE_DATA_TYPE, 'VARCHAR2', DECODE(B.VALUE_SUBTYPE, 'TIME_HM', 'I', 'TIME_HMS', 'I', 'C'), 'NUMBER', 'N', 'DATE', 'X', 'TIMESTAMP', 'Y', 'C') FORMAT_TYPE, NVL( DECODE(B.VALIDATION_TYPE, 'TABLE', (SELECT DECODE(T.VALUE_COLUMN_TYPE, 'DATE', 11, 'TIMESTAMP', 20, 'NUMBER', DECODE(T.VALUE_COLUMN_LENGTH, 0, 38, T.VALUE_COLUMN_LENGTH), T.VALUE_COLUMN_LENGTH) FROM FND_VS_VT_TABLE_EXT T WHERE T.VALUE_SET_ID = B.VALUE_SET_ID), DECODE(B.VALUE_DATA_TYPE, 'DATE', 11, 'TIMESTAMP', 20, 'NUMBER', NVL(B.PRECISION, 38), DECODE(B.VALUE_SUBTYPE, 'TIME_HM', 5, 'TIME_HMS', 8, B.MAXIMUM_LENGTH))), 0) MAXIMUM_SIZE, B.SCALE NUMBER_PRECISION, DECODE(B.VALUE_DATA_TYPE, 'NUMBER', 'N', 'VARCHAR2', DECODE(B.VALUE_SUBTYPE, 'NUMERIC', 'N', 'Y'), 'Y') ALPHANUMERIC_ALLOWED_FLAG, DECODE(B.UPPERCASE_ONLY_FLAG, 'Y', 'Y', 'N') UPPERCASE_ONLY_FLAG, DECODE(B.ZERO_FILL_FLAG, 'Y', 'Y', 'N') NUMERIC_MODE_ENABLED_FLAG, B.MINIMUM_VALUE MINIMUM_VALUE, B.MAXIMUM_VALUE MAXIMUM_VALUE, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM FND_VS_VALUE_SETS B