VCS_PLAN_SCENARIOS_VL

Details

• Schema: FUSION

• Object owner: VCS

• Object type: VIEW

Columns

Name
SCENARIO_ID PLAN_NAME PUBLISH_CYCLE_TYPE_CODE PUBLISH_CYCLE_FREQUENCY PUBLISH_CYCLE_DAY_CODE PUBLISH_START_TYPE_CODE PUBLISH_START_ORDINAL_CODE STATUS_CODE SOURCE_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PUBLISH_MONTHLY_START_DATE NAME

Query

SQL_Statement

SELECT B.SCENARIO_ID SCENARIO_ID, B.PLAN_NAME PLAN_NAME, B.PUBLISH_CYCLE_TYPE_CODE PUBLISH_CYCLE_TYPE_CODE, B.PUBLISH_CYCLE_FREQUENCY PUBLISH_CYCLE_FREQUENCY, B.PUBLISH_CYCLE_DAY_CODE PUBLISH_CYCLE_DAY_CODE, B.PUBLISH_START_TYPE_CODE, B.PUBLISH_START_ORDINAL_CODE, B.STATUS_CODE STATUS_CODE, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE, 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, B.PUBLISH_MONTHLY_START_DATE, T.NAME NAME FROM VCS_PLAN_SCENARIOS_B B INNER JOIN VCS_PLAN_SCENARIOS_TL T ON ( B.SCENARIO_ID = T.SCENARIO_ID AND T.LANGUAGE = USERENV('LANG'))