PAY_CHECKLISTS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name
CHECKLIST_ID BASE_CHECKLIST_ID BASE_CHECKLIST_NAME MODULE_ID PARENT_CHECKLIST_ID BASE_FLOW_ID BASE_FLOW_TASK_ID CHECKLIST_TYPE OWNER_TYPE OWNER_ID RUN_SEQUENCE DEST_UI_URL LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY OBJECT_VERSION_NUMBER CREATION_DATE LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE ENTERPRISE_ID CATEGORY_TYPE SUB_CATEGORY_TYPE CHECKLIST_NAME DESCRIPTION SGUID

Query

SQL_Statement

SELECT B.CHECKLIST_ID, B.BASE_CHECKLIST_ID, B.BASE_CHECKLIST_NAME, B.MODULE_ID, B.PARENT_CHECKLIST_ID, B.BASE_FLOW_ID, B.BASE_FLOW_TASK_ID, B.CHECKLIST_TYPE, B.OWNER_TYPE, B.OWNER_ID, B.RUN_SEQUENCE, B.DEST_UI_URL, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.CREATED_BY, B.OBJECT_VERSION_NUMBER, B.CREATION_DATE, B.LEGISLATIVE_DATA_GROUP_ID, B.LEGISLATION_CODE, B.ENTERPRISE_ID, B.CATEGORY_TYPE, B.SUB_CATEGORY_TYPE, TL.CHECKLIST_NAME, TL.DESCRIPTION, B.SGUID SGUID FROM PAY_CHECKLISTS B, PAY_CHECKLISTS_TL TL WHERE B.CHECKLIST_ID = TL.CHECKLIST_ID AND USERENV('LANG') = TL.LANGUAGE