PAY_TASKS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

TASK_ID BASE_TASK_ID BASE_TASK_NAME OBJECT_VERSION_NUMBER TASK_TYPE MODULE_ID DEF_CATEGORY_TYPE DEF_SUB_CATEGORY_TYPE DEFAULT_CHECKLIST_NAME LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID NAME_SPACE DEST_UI_URL LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE AUTOMATIC_FLAG ACTION_FREEZE_FLAG TASK_NAME DESCRIPTION START_SCH_TIME_DEF_ID START_SCH_FORMULA_ID SUBMITTING_USER_FLAG ESS_REQUEST_CATEGORY HIDE_INCOMPLT_ACTION_FLAG

Query

SQL_Statement

SELECT b.TASK_ID, b.BASE_TASK_ID, b.BASE_TASK_NAME, b.OBJECT_VERSION_NUMBER, b.TASK_TYPE, b.MODULE_ID, b.DEF_CATEGORY_TYPE, b.DEF_SUB_CATEGORY_TYPE, b.DEFAULT_CHECKLIST_NAME, b.LEGISLATIVE_DATA_GROUP_ID, b.LEGISLATION_CODE, b.ENTERPRISE_ID, b.NAME_SPACE, b.DEST_UI_URL, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.CREATED_BY, b.CREATION_DATE, b.AUTOMATIC_FLAG, b.ACTION_FREEZE_FLAG, tl.TASK_NAME, tl.DESCRIPTION, b.start_sch_time_def_id , b.start_sch_formula_id, b.SUBMITTING_USER_FLAG, b.ESS_REQUEST_CATEGORY, b.HIDE_INCOMPLT_ACTION_FLAG FROM PAY_TASKS b, PAY_TASKS_TL tl WHERE b.TASK_ID = tl.TASK_ID AND USERENV('LANG') = tl.LANGUAGE