MCT_CFG_TASK_FLOW_PARAMS

Details

Schema: FUSION
Object owner: MCT
Object type: VIEW

Columns

Name
TASK_FLOW_PARAM_GUID TASK_FLOW_GUID OBJECT_VERSION_NUMBER DEFAULT_VALUE PARAMETER_NAME TOKEN_GUID DATA_TYPE IS_REQUIRED SEQUENCE_NUM CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESC_TEXT SOURCE_LANG LANGUAGE

Name

TASK_FLOW_PARAM_GUID

TASK_FLOW_GUID

OBJECT_VERSION_NUMBER

DEFAULT_VALUE

PARAMETER_NAME

TOKEN_GUID

DATA_TYPE

IS_REQUIRED

SEQUENCE_NUM

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

DESC_TEXT

SOURCE_LANG

LANGUAGE

Query

SQL_Statement
SELECT MCT_CFG_TASK_FLOW_PARAMS_B.TASK_FLOW_PARAM_GUID TASK_FLOW_PARAM_GUID, MCT_CFG_TASK_FLOW_PARAMS_B.TASK_FLOW_GUID TASK_FLOW_GUID, MCT_CFG_TASK_FLOW_PARAMS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MCT_CFG_TASK_FLOW_PARAMS_B.DEFAULT_VALUE DEFAULT_VALUE, MCT_CFG_TASK_FLOW_PARAMS_B.PARAMETER_NAME PARAMETER_NAME, MCT_CFG_TASK_FLOW_PARAMS_B.TOKEN_GUID TOKEN_GUID, MCT_CFG_TASK_FLOW_PARAMS_B.DATA_TYPE DATA_TYPE, MCT_CFG_TASK_FLOW_PARAMS_B.IS_REQUIRED IS_REQUIRED, MCT_CFG_TASK_FLOW_PARAMS_B.SEQUENCE_NUM SEQUENCE_NUM, MCT_CFG_TASK_FLOW_PARAMS_B.CREATED_BY CREATED_BY, MCT_CFG_TASK_FLOW_PARAMS_B.CREATION_DATE CREATION_DATE, MCT_CFG_TASK_FLOW_PARAMS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MCT_CFG_TASK_FLOW_PARAMS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MCT_CFG_TASK_FLOW_PARAMS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MCT_CFG_TASK_FLOW_PARAMS_TL.DESC_TEXT DESC_TEXT, MCT_CFG_TASK_FLOW_PARAMS_TL.SOURCE_LANG SOURCE_LANG, MCT_CFG_TASK_FLOW_PARAMS_TL.LANGUAGE LANGUAGE FROM MCT_CFG_TASK_FLOW_PARAMS_B, MCT_CFG_TASK_FLOW_PARAMS_TL WHERE MCT_CFG_TASK_FLOW_PARAMS_B.TASK_FLOW_PARAM_GUID = MCT_CFG_TASK_FLOW_PARAMS_TL.TASK_FLOW_PARAM_GUID AND MCT_CFG_TASK_FLOW_PARAMS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

MCT_CFG_TASK_FLOW_PARAMS_B.TASK_FLOW_PARAM_GUID TASK_FLOW_PARAM_GUID,

MCT_CFG_TASK_FLOW_PARAMS_B.TASK_FLOW_GUID TASK_FLOW_GUID,

MCT_CFG_TASK_FLOW_PARAMS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

MCT_CFG_TASK_FLOW_PARAMS_B.DEFAULT_VALUE DEFAULT_VALUE,

MCT_CFG_TASK_FLOW_PARAMS_B.PARAMETER_NAME PARAMETER_NAME,

MCT_CFG_TASK_FLOW_PARAMS_B.TOKEN_GUID TOKEN_GUID,

MCT_CFG_TASK_FLOW_PARAMS_B.DATA_TYPE DATA_TYPE,

MCT_CFG_TASK_FLOW_PARAMS_B.IS_REQUIRED IS_REQUIRED,

MCT_CFG_TASK_FLOW_PARAMS_B.SEQUENCE_NUM SEQUENCE_NUM,

MCT_CFG_TASK_FLOW_PARAMS_B.CREATED_BY CREATED_BY,

MCT_CFG_TASK_FLOW_PARAMS_B.CREATION_DATE CREATION_DATE,

MCT_CFG_TASK_FLOW_PARAMS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MCT_CFG_TASK_FLOW_PARAMS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MCT_CFG_TASK_FLOW_PARAMS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MCT_CFG_TASK_FLOW_PARAMS_TL.DESC_TEXT DESC_TEXT,

MCT_CFG_TASK_FLOW_PARAMS_TL.SOURCE_LANG SOURCE_LANG,

MCT_CFG_TASK_FLOW_PARAMS_TL.LANGUAGE LANGUAGE

FROM

MCT_CFG_TASK_FLOW_PARAMS_B,

MCT_CFG_TASK_FLOW_PARAMS_TL

WHERE

MCT_CFG_TASK_FLOW_PARAMS_B.TASK_FLOW_PARAM_GUID = MCT_CFG_TASK_FLOW_PARAMS_TL.TASK_FLOW_PARAM_GUID AND MCT_CFG_TASK_FLOW_PARAMS_TL.LANGUAGE = USERENV('LANG')