FND_ID_FLEX_STRUCTURES_VL

Details

• Schema: EBS

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID APPLICATION_ID ID_FLEX_CODE ID_FLEX_NUM ID_FLEX_STRUCTURE_CODE ENABLED_FLAG FREEZE_FLEX_DEFINITION_FLAG CONCATENATED_SEGMENT_DELIMITER DYNAMIC_INSERTS_ALLOWED_FLAG CROSS_SEGMENT_VALIDATION_FLAG FREEZE_STRUCTURED_HIER_FLAG SHORTHAND_ENABLED_FLAG SHORTHAND_LENGTH STRUCTURE_VIEW_NAME CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ID_FLEX_STRUCTURE_NAME DESCRIPTION SHORTHAND_PROMPT

Query

SQL_Statement

SELECT B.ROW_ID ROW_ID, B.APPLICATION_ID, B.ID_FLEX_CODE, B.ID_FLEX_NUM, B.ID_FLEX_STRUCTURE_CODE, B.ENABLED_FLAG, B.FREEZE_FLEX_DEFINITION_FLAG, B.CONCATENATED_SEGMENT_DELIMITER, B.DYNAMIC_INSERTS_ALLOWED_FLAG, B.CROSS_SEGMENT_VALIDATION_FLAG, B.FREEZE_STRUCTURED_HIER_FLAG, B.SHORTHAND_ENABLED_FLAG, B.SHORTHAND_LENGTH, B.STRUCTURE_VIEW_NAME, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, T.ID_FLEX_STRUCTURE_NAME, T.DESCRIPTION, T.SHORTHAND_PROMPT FROM FND_ID_FLEX_STRUCTURES B, FND_ID_FLEX_STRUCTURES_TL T 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')