MSC_SEGMENT_ENTITY_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ENTITY_ID ENTITY SOURCE_TABLE DATA_TYPE ENTITY_NAME ENTITY_LOOKUP_TYPE SQL_STMT DIMENSION

Query

SQL_Statement

SELECT VL.ENTITY_ID ENTITY_ID, VL.ENTITY ENTITY, VL.SOURCE_TABLE SOURCE_TABLE, VL.DATA_TYPE DATA_TYPE, VL.ENTITY_NAME ENTITY_NAME, VL.ENTITY_LOOKUP_TYPE ENTITY_LOOKUP_TYPE, VL.SQL_STMT SQL_STMT, VL.DIMENSION DIMENSION FROM MSC_SEGMENT_ENTITY_VL VL WHERE VL.ENTITY_ID <= 1000 UNION SELECT B.ENTITY_ID ENTITY_ID, FLEX.COLUMN_NAME ENTITY, B.SOURCE_TABLE SOURCE_TABLE, B.DATA_TYPE DATA_TYPE, FLEX.NAME ENTITY_NAME, B.ENTITY_LOOKUP_TYPE ENTITY_LOOKUP_TYPE, B.SQL_STMT SQL_STMT, B.DIMENSION DIMENSION FROM MSC_SEGMENT_ENTITY_B B, (SELECT COLUMN_NAME, NAME FROM FND_DF_SEGMENTS_VL WHERE APPLICATION_ID=724 AND DESCRIPTIVE_FLEXFIELD_CODE = 'MSC_SYSTEM_ITEMS' AND CONTEXT_CODE ='Global Data Elements') FLEX WHERE FLEX.COLUMN_NAME = B.ENTITY