PER_TASK_ACTIONS

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
TASK_ACTION_ID TASK_ACTION_CODE TASK_ACTION_NAME DESCRIPTION TASK_TYPE TASK_PERFORMER TASKFLOW_ID TASKFLOW_PARAMS MODULE_ID SEED_DATA_SOURCE ENTERPRISE_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBSOLETE_FLAG

Name

TASK_ACTION_ID

TASK_ACTION_CODE

TASK_ACTION_NAME

DESCRIPTION

TASK_TYPE

TASK_PERFORMER

TASKFLOW_ID

TASKFLOW_PARAMS

MODULE_ID

SEED_DATA_SOURCE

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBSOLETE_FLAG

Query

SQL_Statement
SELECT B.TASK_ACTION_ID, B.TASK_ACTION_CODE, T.TASK_ACTION_NAME, T.DESCRIPTION, B.TASK_TYPE, B.TASK_PERFORMER, B.TASKFLOW_ID, B.TASKFLOW_PARAMS, B.MODULE_ID, B.SEED_DATA_SOURCE, B.ENTERPRISE_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBSOLETE_FLAG FROM PER_TASK_ACTIONS_B B, PER_TASK_ACTIONS_TL T WHERE B.TASK_ACTION_ID = T.TASK_ACTION_ID AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.TASK_ACTION_ID,

B.TASK_ACTION_CODE,

T.TASK_ACTION_NAME,

T.DESCRIPTION,

B.TASK_TYPE,

B.TASK_PERFORMER,

B.TASKFLOW_ID,

B.TASKFLOW_PARAMS,

B.MODULE_ID,

B.SEED_DATA_SOURCE,

B.ENTERPRISE_ID,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBSOLETE_FLAG

FROM

PER_TASK_ACTIONS_B B,

PER_TASK_ACTIONS_TL T

WHERE

B.TASK_ACTION_ID = T.TASK_ACTION_ID AND T.LANGUAGE = USERENV('LANG')