FND_ID_FLEXS

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name
APPLICATION_ID ID_FLEX_CODE ID_FLEX_NAME ALLOW_ID_VALUESETS DYNAMIC_INSERTS_FEASIBLE_FLAG INDEX_FLAG MAXIMUM_CONCATENATION_LEN CONCATENATION_LEN_WARNING DESCRIPTION TABLE_APPLICATION_ID APPLICATION_TABLE_NAME APPLICATION_TABLE_TYPE UNIQUE_ID_COLUMN_NAME SET_DEFINING_COLUMN_NAME CONCATENATED_SEGS_VIEW_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.APPLICATION_ID APPLICATION_ID, B.KEY_FLEXFIELD_CODE ID_FLEX_CODE, B.NAME ID_FLEX_NAME, B.ID_VALUE_SETS_FLAG ALLOW_ID_VALUESETS, B.DYNAMIC_COMBO_CREATION_FLAG DYNAMIC_INSERTS_FEASIBLE_FLAG, SUBSTR('N', 1, 1) INDEX_FLAG, 100 MAXIMUM_CONCATENATION_LEN, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 240), 'Warning - Maximum Concatenation Length Exceeded') CONCATENATION_LEN_WARNING, B.DESCRIPTION DESCRIPTION, -999 TABLE_APPLICATION_ID, TU.TABLE_NAME APPLICATION_TABLE_NAME, SUBSTR('G', 1, 1) APPLICATION_TABLE_TYPE, CU1.COLUMN_NAME UNIQUE_ID_COLUMN_NAME, CU2.COLUMN_NAME SET_DEFINING_COLUMN_NAME, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 30), NULL) CONCATENATED_SEGS_VIEW_NAME, 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_KF_FLEXFIELDS_VL B, (SELECT FU.TABLE_NAME, FU.TABLE_USAGE_CODE, FU.APPLICATION_ID, FU.KEY_FLEXFIELD_CODE FROM FND_KF_TABLE_USAGES FU, FND_TABLES FT WHERE FU.USAGE_TYPE = 'M' AND FT.TABLE_NAME = FU.TABLE_NAME) TU, (SELECT FCU.TABLE_NAME, FCU.TABLE_USAGE_CODE, FCU.COLUMN_NAME FROM FND_FF_COLUMN_USAGES FCU, FND_TABLES FT, FND_COLUMNS FC WHERE FCU.FLEXFIELD_TYPE = 'KFF' AND FCU.COLUMN_USAGE_TYPE = 'CCID' AND FT.TABLE_NAME = FCU.TABLE_NAME AND FC.TABLE_ID = FT.TABLE_ID AND FC.COLUMN_NAME = FCU.COLUMN_NAME) CU1, (SELECT FCU.TABLE_NAME, FCU.TABLE_USAGE_CODE, FCU.COLUMN_NAME FROM FND_FF_COLUMN_USAGES FCU, FND_TABLES FT, FND_COLUMNS FC WHERE FCU.FLEXFIELD_TYPE = 'KFF' AND FCU.COLUMN_USAGE_TYPE = 'SIN' AND FT.TABLE_NAME = FCU.TABLE_NAME AND FC.TABLE_ID = FT.TABLE_ID AND FC.COLUMN_NAME = FCU.COLUMN_NAME) CU2 WHERE TU.APPLICATION_ID = B.APPLICATION_ID AND TU.KEY_FLEXFIELD_CODE = B.KEY_FLEXFIELD_CODE AND CU1.TABLE_NAME = TU.TABLE_NAME AND CU1.TABLE_USAGE_CODE = TU.TABLE_USAGE_CODE AND CU2.TABLE_NAME(+) = TU.TABLE_NAME AND CU2.TABLE_USAGE_CODE(+) = TU.TABLE_USAGE_CODE