FND_ID_FLEX_STRUCTURES

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

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.APPLICATION_ID APPLICATION_ID, B.KEY_FLEXFIELD_CODE ID_FLEX_CODE, B.STRUCTURE_INSTANCE_NUMBER ID_FLEX_NUM, B.STRUCTURE_INSTANCE_CODE ID_FLEX_STRUCTURE_CODE, B.ENABLED_FLAG ENABLED_FLAG, SUBSTR('Y', 1, 1) FREEZE_FLEX_DEFINITION_FLAG, S.DELIMITER CONCATENATED_SEGMENT_DELIMITER, B.DYNAMIC_COMBO_CREATION_FLAG DYNAMIC_INSERTS_ALLOWED_FLAG, SUBSTR('N', 1, 1) CROSS_SEGMENT_VALIDATION_FLAG, SUBSTR('N', 1, 1) FREEZE_STRUCTURED_HIER_FLAG, SUBSTR('N', 1, 1) SHORTHAND_ENABLED_FLAG, 15 SHORTHAND_LENGTH, DECODE(B.KEY_FLEXFIELD_CODE, NULL, RPAD(' ', 30), NULL) STRUCTURE_VIEW_NAME, 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_KF_STR_INSTANCES_B B, FND_KF_STRUCTURES_B S, FND_KF_FLEXFIELDS_B F WHERE S.STRUCTURE_ID = B.STRUCTURE_ID AND F.APPLICATION_ID = B.APPLICATION_ID AND F.KEY_FLEXFIELD_CODE = B.KEY_FLEXFIELD_CODE