FND_DESCRIPTIVE

Details

Schema: EBS
Object owner: FND
Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID DESCRIPTIVE_FLEXFIELD_NAME CONCATENATED_SEGMENT_DELIMITER FREEZE_FLEX_DEFINITION_FLAG PROTECTED_FLAG TABLE_APPLICATION_ID APPLICATION_TABLE_NAME CONCATENATED_SEGS_VIEW_NAME CONTEXT_COLUMN_NAME CONTEXT_REQUIRED_FLAG CONTEXT_USER_OVERRIDE_FLAG DEFAULT_CONTEXT_FIELD_NAME DEFAULT_CONTEXT_VALUE CONTEXT_DEFAULT_TYPE CONTEXT_DEFAULT_VALUE CONTEXT_OVERRIDE_VALUE_SET_ID CONTEXT_RUNTIME_PROPERTY_FUNCT CONTEXT_SYNCHRONIZATION_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Name

ROW_ID

APPLICATION_ID

DESCRIPTIVE_FLEXFIELD_NAME

CONCATENATED_SEGMENT_DELIMITER

FREEZE_FLEX_DEFINITION_FLAG

PROTECTED_FLAG

TABLE_APPLICATION_ID

APPLICATION_TABLE_NAME

CONCATENATED_SEGS_VIEW_NAME

CONTEXT_COLUMN_NAME

CONTEXT_REQUIRED_FLAG

CONTEXT_USER_OVERRIDE_FLAG

DEFAULT_CONTEXT_FIELD_NAME

DEFAULT_CONTEXT_VALUE

CONTEXT_DEFAULT_TYPE

CONTEXT_DEFAULT_VALUE

CONTEXT_OVERRIDE_VALUE_SET_ID

CONTEXT_RUNTIME_PROPERTY_FUNCT

CONTEXT_SYNCHRONIZATION_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.DELIMITER CONCATENATED_SEGMENT_DELIMITER, SUBSTR('Y', 1, 1) FREEZE_FLEX_DEFINITION_FLAG, SUBSTR('N', 1, 1) PROTECTED_FLAG, -999 TABLE_APPLICATION_ID, TU.TABLE_NAME APPLICATION_TABLE_NAME, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 30), NULL) CONCATENATED_SEGS_VIEW_NAME, CU.COLUMN_NAME CONTEXT_COLUMN_NAME, FDS.REQUIRED_FLAG CONTEXT_REQUIRED_FLAG, SUBSTR(DECODE(FDS.DISPLAY_TYPE, 'HIDDEN','N','Y'),1,1) CONTEXT_USER_OVERRIDE_FLAG, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 200), NULL) DEFAULT_CONTEXT_FIELD_NAME, FDS.DEFAULT_VALUE DEFAULT_CONTEXT_VALUE, SUBSTR(DECODE(FDS.DEFAULT_TYPE,'CONSTANT','C',null),1,1) CONTEXT_DEFAULT_TYPE, FDS.DEFAULT_VALUE CONTEXT_DEFAULT_VALUE, FDS.VALUE_SET_ID CONTEXT_OVERRIDE_VALUE_SET_ID, DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE, NULL, RPAD(' ', 2000), NULL) CONTEXT_RUNTIME_PROPERTY_FUNCT, SUBSTR('N', 1, 1) CONTEXT_SYNCHRONIZATION_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, (SELECT FU.TABLE_NAME, FU.TABLE_USAGE_CODE, FU.APPLICATION_ID, FU.DESCRIPTIVE_FLEXFIELD_CODE FROM FND_DF_TABLE_USAGES FU, FND_TABLES FT, FND_DF_FLEX_USAGES_B DFU WHERE DFU.USAGE_TYPE = 'D' AND DFU.DESCRIPTIVE_FLEXFIELD_CODE = FU.DESCRIPTIVE_FLEXFIELD_CODE AND DFU.APPLICATION_ID = FU.APPLICATION_ID AND DFU.FLEXFIELD_USAGE_CODE = FU.FLEXFIELD_USAGE_CODE 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 = 'DFF' AND FCU.COLUMN_USAGE_TYPE = 'CONTEXT' AND FT.TABLE_NAME = FCU.TABLE_NAME AND FC.TABLE_ID = FT.TABLE_ID AND FC.COLUMN_NAME = FCU.COLUMN_NAME) CU, FND_DF_SEGMENTS_B FDS WHERE TU.APPLICATION_ID = B.APPLICATION_ID AND TU.DESCRIPTIVE_FLEXFIELD_CODE = B.DESCRIPTIVE_FLEXFIELD_CODE AND CU.TABLE_NAME = TU.TABLE_NAME AND CU.TABLE_USAGE_CODE = TU.TABLE_USAGE_CODE AND FDS.APPLICATION_ID = B.APPLICATION_ID AND FDS.DESCRIPTIVE_FLEXFIELD_CODE = B.DESCRIPTIVE_FLEXFIELD_CODE AND FDS.CONTEXT_CODE = 'Context Data Element' AND FDS.SEGMENT_CODE = 'Context Segment' AND FDS.COLUMN_NAME = CU.COLUMN_NAME AND FDS.SEQUENCE_NUMBER = 1

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.APPLICATION_ID APPLICATION_ID,

B.DESCRIPTIVE_FLEXFIELD_CODE DESCRIPTIVE_FLEXFIELD_NAME,

B.DELIMITER CONCATENATED_SEGMENT_DELIMITER,

SUBSTR('Y', 1, 1) FREEZE_FLEX_DEFINITION_FLAG,

SUBSTR('N', 1, 1) PROTECTED_FLAG,

-999 TABLE_APPLICATION_ID,

TU.TABLE_NAME APPLICATION_TABLE_NAME,

DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE,

NULL, RPAD(' ', 30),

NULL) CONCATENATED_SEGS_VIEW_NAME,

CU.COLUMN_NAME CONTEXT_COLUMN_NAME,

FDS.REQUIRED_FLAG CONTEXT_REQUIRED_FLAG,

SUBSTR(DECODE(FDS.DISPLAY_TYPE,

'HIDDEN','N','Y'),1,1) CONTEXT_USER_OVERRIDE_FLAG,

DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE,

NULL, RPAD(' ', 200),

NULL) DEFAULT_CONTEXT_FIELD_NAME,

FDS.DEFAULT_VALUE DEFAULT_CONTEXT_VALUE,

SUBSTR(DECODE(FDS.DEFAULT_TYPE,'CONSTANT','C',null),1,1) CONTEXT_DEFAULT_TYPE,

FDS.DEFAULT_VALUE CONTEXT_DEFAULT_VALUE,

FDS.VALUE_SET_ID CONTEXT_OVERRIDE_VALUE_SET_ID,

DECODE(B.DESCRIPTIVE_FLEXFIELD_CODE,

NULL, RPAD(' ', 2000),

NULL) CONTEXT_RUNTIME_PROPERTY_FUNCT,

SUBSTR('N', 1, 1) CONTEXT_SYNCHRONIZATION_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,

(SELECT FU.TABLE_NAME,

FU.TABLE_USAGE_CODE,

FU.APPLICATION_ID,

FU.DESCRIPTIVE_FLEXFIELD_CODE

FROM FND_DF_TABLE_USAGES FU,

FND_TABLES FT,

FND_DF_FLEX_USAGES_B DFU

WHERE DFU.USAGE_TYPE = 'D'

AND DFU.DESCRIPTIVE_FLEXFIELD_CODE = FU.DESCRIPTIVE_FLEXFIELD_CODE

AND DFU.APPLICATION_ID = FU.APPLICATION_ID

AND DFU.FLEXFIELD_USAGE_CODE = FU.FLEXFIELD_USAGE_CODE

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 = 'DFF'

AND FCU.COLUMN_USAGE_TYPE = 'CONTEXT'

AND FT.TABLE_NAME = FCU.TABLE_NAME

AND FC.TABLE_ID = FT.TABLE_ID

AND FC.COLUMN_NAME = FCU.COLUMN_NAME) CU,

FND_DF_SEGMENTS_B FDS

WHERE TU.APPLICATION_ID = B.APPLICATION_ID

AND TU.DESCRIPTIVE_FLEXFIELD_CODE = B.DESCRIPTIVE_FLEXFIELD_CODE

AND CU.TABLE_NAME = TU.TABLE_NAME

AND CU.TABLE_USAGE_CODE = TU.TABLE_USAGE_CODE

AND FDS.APPLICATION_ID = B.APPLICATION_ID

AND FDS.DESCRIPTIVE_FLEXFIELD_CODE = B.DESCRIPTIVE_FLEXFIELD_CODE

AND FDS.CONTEXT_CODE = 'Context Data Element'

AND FDS.SEGMENT_CODE = 'Context Segment'

AND FDS.COLUMN_NAME = CU.COLUMN_NAME

AND FDS.SEQUENCE_NUMBER = 1