View: FND_ID_FLEX_STRUCTURES_VL

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_ID_FLEX_STRUCTURES_VL

View Text

SELECT B.ROWID ROW_ID
, B.APPLICATION_ID
, B.ID_FLEX_CODE
, B.ID_FLEX_NUM
, B.ID_FLEX_STRUCTURE_CODE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CONCATENATED_SEGMENT_DELIMITER
, B.CROSS_SEGMENT_VALIDATION_FLAG
, B.DYNAMIC_INSERTS_ALLOWED_FLAG
, B.ENABLED_FLAG
, B.FREEZE_FLEX_DEFINITION_FLAG
, B.FREEZE_STRUCTURED_HIER_FLAG
, B.SHORTHAND_ENABLED_FLAG
, B.SHORTHAND_LENGTH
, B.STRUCTURE_VIEW_NAME
, T.ID_FLEX_STRUCTURE_NAME
, T.DESCRIPTION
, T.SHORTHAND_PROMPT
FROM FND_ID_FLEX_STRUCTURES_TL T
, FND_ID_FLEX_STRUCTURES B
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND B.ID_FLEX_CODE = T.ID_FLEX_CODE
AND B.ID_FLEX_NUM = T.ID_FLEX_NUM
AND T.LANGUAGE = USERENV('LANG')

Columns