FND_DESCR_FLEX_CONTEXTS

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEX_CONTEXT_CODE ENABLED_FLAG GLOBAL_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.APPLICATION_ID APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME, B.CONTEXT_CODE DESCRIPTIVE_FLEX_CONTEXT_CODE, B.ENABLED_FLAG ENABLED_FLAG, SUBSTR('N', 1, 1) GLOBAL_FLAG, 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_DF_CONTEXTS_B B UNION SELECT B.ROWID ROW_ID, B.APPLICATION_ID APPLICATION_ID, B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 30), 'Global Data Elements') DESCRIPTIVE_FLEX_CONTEXT_CODE, SUBSTR('Y', 1, 1) ENABLED_FLAG, SUBSTR('Y', 1, 1) GLOBAL_FLAG, 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_DF_FLEXFIELDS_B B