HMO_MODEL_PLANS_VL

Details

• Schema: FUSION

• Object owner: HMO

• Object type: VIEW

Columns

Name
MODEL_PLAN_ID ENTERPRISE_ID EFFECTIVE_DATE MODEL_PLAN_NAME DESCRIPTION MODEL_PLAN_STATUS MODEL_PLAN_TYPE ACTION_ID ACTION_REASON_ID AUTHOR_PERSON_ID TOP_MANAGER_ID TOP_MANAGER_ASSIGNMENT_ID TOP_MANAGER_TYPE ACCESS_TO_TOP_MANAGER MODEL_LOADER_BATCH_ID LAST_SYNC_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.MODEL_PLAN_ID MODEL_PLAN_ID, B.ENTERPRISE_ID ENTERPRISE_ID, B.EFFECTIVE_DATE EFFECTIVE_DATE, TL.MODEL_PLAN_NAME MODEL_PLAN_NAME, TL.DESCRIPTION DESCRIPTION, B.MODEL_PLAN_STATUS MODEL_PLAN_STATUS, B.MODEL_PLAN_TYPE MODEL_PLAN_TYPE, B.ACTION_ID ACTION_ID, B.ACTION_REASON_ID ACTION_REASON_ID, B.AUTHOR_PERSON_ID AUTHOR_PERSON_ID, B.TOP_MANAGER_ID TOP_MANAGER_ID, B.TOP_MANAGER_ASSIGNMENT_ID TOP_MANAGER_ASSIGNMENT_ID, B.TOP_MANAGER_TYPE TOP_MANAGER_TYPE, B.ACCESS_TO_TOP_MANAGER ACCESS_TO_TOP_MANAGER, B.MODEL_LOADER_BATCH_ID MODEL_LOADER_BATCH_ID, B.LAST_SYNC_DATE LAST_SYNC_DATE, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM HMO_MODEL_PLANS_B B, HMO_MODEL_PLANS_TL TL WHERE B.MODEL_PLAN_ID = TL.MODEL_PLAN_ID AND TL.LANGUAGE = USERENV('LANG')