MCT_CFG_SCRPOP_PLANS_VL

Details

• Schema: FUSION

• Object owner: MCT

• Object type: VIEW

Columns

Name
SCREEN_POP_PLAN_GUID OBJECT_VERSION_NUMBER STATUS_CODE GLOBAL_FUNCTION_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PLAN_NAME DESC_TEXT SOURCE_LANG LANGUAGE

Query

SQL_Statement

SELECT MCT_CFG_SCRPOP_PLANS_B.SCREEN_POP_PLAN_GUID SCREEN_POP_PLAN_GUID, MCT_CFG_SCRPOP_PLANS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MCT_CFG_SCRPOP_PLANS_B.STATUS_CODE STATUS_CODE, MCT_CFG_SCRPOP_PLANS_B.GLOBAL_FUNCTION_NAME GLOBAL_FUNCTION_NAME, MCT_CFG_SCRPOP_PLANS_B.CREATED_BY CREATED_BY, MCT_CFG_SCRPOP_PLANS_B.CREATION_DATE CREATION_DATE, MCT_CFG_SCRPOP_PLANS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MCT_CFG_SCRPOP_PLANS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MCT_CFG_SCRPOP_PLANS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MCT_CFG_SCRPOP_PLANS_TL.PLAN_NAME PLAN_NAME, MCT_CFG_SCRPOP_PLANS_TL.DESC_TEXT DESC_TEXT, MCT_CFG_SCRPOP_PLANS_TL.SOURCE_LANG SOURCE_LANG, MCT_CFG_SCRPOP_PLANS_TL.LANGUAGE LANGUAGE FROM MCT_CFG_SCRPOP_PLANS_B, MCT_CFG_SCRPOP_PLANS_TL WHERE MCT_CFG_SCRPOP_PLANS_B.SCREEN_POP_PLAN_GUID = MCT_CFG_SCRPOP_PLANS_TL.SCREEN_POP_PLAN_GUID AND MCT_CFG_SCRPOP_PLANS_TL.LANGUAGE = USERENV('LANG')