MSC_EIS_HIERARCHY_VL

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
EIS_HIERARCHY_ID HIERARCHY_NAME HIERARCHY_DESCRIPTION SOURCE_SYSTEM_ID STATUS LAST_RUN_DATE LAST_PROCESS_ID LAST_COLL_REQUEST_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT MSC_EIS_HIERARCHY_B.EIS_HIERARCHY_ID EIS_HIERARCHY_ID, MSC_EIS_HIERARCHY_TL.HIERARCHY_NAME HIERARCHY_NAME, MSC_EIS_HIERARCHY_TL.HIERARCHY_DESCRIPTION HIERARCHY_DESCRIPTION, MSC_EIS_HIERARCHY_B.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID, MSC_EIS_HIERARCHY_B.STATUS STATUS, MSC_EIS_HIERARCHY_B.LAST_RUN_DATE LAST_RUN_DATE, MSC_EIS_HIERARCHY_B.LAST_PROCESS_ID LAST_PROCESS_ID, MSC_EIS_HIERARCHY_B.LAST_COLL_REQUEST_ID LAST_COLL_REQUEST_ID, MSC_EIS_HIERARCHY_B.CREATED_BY CREATED_BY, MSC_EIS_HIERARCHY_B.CREATION_DATE CREATION_DATE, MSC_EIS_HIERARCHY_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_EIS_HIERARCHY_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_EIS_HIERARCHY_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_EIS_HIERARCHY_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM MSC_EIS_HIERARCHY_B, MSC_EIS_HIERARCHY_TL WHERE MSC_EIS_HIERARCHY_B.EIS_HIERARCHY_ID = MSC_EIS_HIERARCHY_TL.EIS_HIERARCHY_ID AND MSC_EIS_HIERARCHY_TL.LANGUAGE = USERENV('LANG')