VIEW: APPS.FND_DESCRIPTIVE_FLEXS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.CONCATENATED_SEGS_VIEW_NAME, B.APPLICATION_ID, B.APPLICATION_TABLE_NAME, B.DESCRIPTIVE_FLEXFIELD_NAME, B.TABLE_APPLICATION_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.CONTEXT_REQUIRED_FLAG, B.CONTEXT_COLUMN_NAME, B.CONTEXT_USER_OVERRIDE_FLAG, B.CONCATENATED_SEGMENT_DELIMITER, B.FREEZE_FLEX_DEFINITION_FLAG, B.PROTECTED_FLAG, B.DEFAULT_CONTEXT_FIELD_NAME, B.DEFAULT_CONTEXT_VALUE, B.CONTEXT_DEFAULT_TYPE, B.CONTEXT_DEFAULT_VALUE, B.CONTEXT_OVERRIDE_VALUE_SET_ID, B.CONTEXT_RUNTIME_PROPERTY_FUNCT, B.CONTEXT_SYNCHRONIZATION_FLAG, T.TITLE, T.FORM_CONTEXT_PROMPT, T.DESCRIPTION from FND_DESCRIPTIVE_FLEXS_TL T, FND_DESCRIPTIVE_FLEXS B where B.APPLICATION_ID = T.APPLICATION_ID and B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.CONCATENATED_SEGS_VIEW_NAME
, B.APPLICATION_ID
, B.APPLICATION_TABLE_NAME
, B.DESCRIPTIVE_FLEXFIELD_NAME
, B.TABLE_APPLICATION_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CONTEXT_REQUIRED_FLAG
, B.CONTEXT_COLUMN_NAME
, B.CONTEXT_USER_OVERRIDE_FLAG
, B.CONCATENATED_SEGMENT_DELIMITER
, B.FREEZE_FLEX_DEFINITION_FLAG
, B.PROTECTED_FLAG
, B.DEFAULT_CONTEXT_FIELD_NAME
, B.DEFAULT_CONTEXT_VALUE
, B.CONTEXT_DEFAULT_TYPE
, B.CONTEXT_DEFAULT_VALUE
, B.CONTEXT_OVERRIDE_VALUE_SET_ID
, B.CONTEXT_RUNTIME_PROPERTY_FUNCT
, B.CONTEXT_SYNCHRONIZATION_FLAG
, T.TITLE
, T.FORM_CONTEXT_PROMPT
, T.DESCRIPTION
FROM FND_DESCRIPTIVE_FLEXS_TL T
, FND_DESCRIPTIVE_FLEXS B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.DESCRIPTIVE_FLEXFIELD_NAME = T.DESCRIPTIVE_FLEXFIELD_NAME
AND T.LANGUAGE = USERENV('LANG')