SCH_REC_TASKS_VL
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: VIEW
Columns
Name |
---|
TASK_ID TASK_CODE TASK_NAME TASK_ASSIGNMENT_LEVEL SEED_DATA_SOURCE OBJECT_VERSION_NUMBER REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT B.TASK_ID, B.TASK_CODE, T.TASK_NAME, B.TASK_ASSIGNMENT_LEVEL, B.SEED_DATA_SOURCE, B.OBJECT_VERSION_NUMBER, B.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN FROM SCH_REC_TASKS_B B, SCH_REC_TASKS_TL T WHERE B.TASK_ID = T.TASK_ID AND T.LANGUAGE = USERENV('LANG') |