FND_FLEX_VALIDATION_TABLES

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

FLEX_VALUE_SET_ID TABLE_APPLICATION_ID APPLICATION_TABLE_NAME VALUE_COLUMN_NAME VALUE_COLUMN_TYPE VALUE_COLUMN_SIZE ID_COLUMN_NAME ID_COLUMN_TYPE ID_COLUMN_SIZE MEANING_COLUMN_NAME MEANING_COLUMN_TYPE MEANING_COLUMN_SIZE ENABLED_COLUMN_NAME START_DATE_COLUMN_NAME END_DATE_COLUMN_NAME SUMMARY_COLUMN_NAME COMPILED_ATTRIBUTE_COLUMN_NAME HIERARCHY_LEVEL_COLUMN_NAME SUMMARY_ALLOWED_FLAG ADDITIONAL_WHERE_CLAUSE ADDITIONAL_QUICKPICK_COLUMNS 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, TO_NUMBER(NULL) TABLE_APPLICATION_ID, B.FROM_CLAUSE APPLICATION_TABLE_NAME, B.VALUE_COLUMN_NAME VALUE_COLUMN_NAME, DECODE(B.VALUE_COLUMN_TYPE, 'VARCHAR2', 'V', 'NUMBER', 'N', 'DATE', 'D', 'TIMESTAMP', 'D', 'V') VALUE_COLUMN_TYPE, B.VALUE_COLUMN_LENGTH VALUE_COLUMN_SIZE, B.ID_COLUMN_NAME ID_COLUMN_NAME, DECODE(B.ID_COLUMN_TYPE, null, null, 'VARCHAR2', 'V', 'NUMBER', 'N', 'DATE', 'D', 'TIMESTAMP', 'D', 'V') ID_COLUMN_TYPE, B.ID_COLUMN_LENGTH ID_COLUMN_SIZE, B.DESCRIPTION_COLUMN_NAME MEANING_COLUMN_NAME, DECODE(B.DESCRIPTION_COLUMN_TYPE, null, null, 'VARCHAR2', 'V', 'NUMBER', 'N', 'DATE', 'D', 'TIMESTAMP', 'D', 'V') MEANING_COLUMN_TYPE, B.DESCRIPTION_COLUMN_LENGTH MEANING_COLUMN_SIZE, NVL(B.ENABLED_FLAG_COLUMN_NAME, '''Y''') ENABLED_COLUMN_NAME, NVL(B.START_DATE_COLUMN_NAME, 'TO_DATE(NULL)') START_DATE_COLUMN_NAME, NVL(B.END_DATE_COLUMN_NAME, 'TO_DATE(NULL)') END_DATE_COLUMN_NAME, DECODE(B.VALUE_COLUMN_NAME, NULL, B.VALUE_COLUMN_NAME, '''N''') SUMMARY_COLUMN_NAME, DECODE(B.VALUE_COLUMN_NAME, NULL, B.VALUE_COLUMN_NAME, 'NULL') COMPILED_ATTRIBUTE_COLUMN_NAME, DECODE(B.VALUE_COLUMN_NAME, NULL, B.VALUE_COLUMN_NAME, 'NULL') HIERARCHY_LEVEL_COLUMN_NAME, SUBSTR('N', 1, 1) SUMMARY_ALLOWED_FLAG, REGEXP_REPLACE( REGEXP_REPLACE( REGEXP_REPLACE( DECODE(B.WHERE_CLAUSE, NULL, NULL, 'WHERE ' || B.WHERE_CLAUSE) || DECODE(B.WHERE_CLAUSE || B.ORDER_BY_CLAUSE, NULL, NULL, ' ') || DECODE(B.ORDER_BY_CLAUSE, NULL, NULL, 'ORDER BY ' || B.ORDER_BY_CLAUSE), ':{SEGMENT\.(.*?)}', ':$FLEX$.\1'), ':{VALUESET\.(.*?)}', ':$FLEX$.\1'), ':{FLEXFIELD\.(.*?)}', ':$FLEX$.$\1$') ADDITIONAL_WHERE_CLAUSE, DECODE(B.VALUE_COLUMN_NAME, NULL, B.VALUE_COLUMN_NAME, NULL) ADDITIONAL_QUICKPICK_COLUMNS, 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_VT_TABLE_EXT B, FND_VS_VALUE_SETS V WHERE B.VALUE_SET_ID = V.VALUE_SET_ID