POQ_ACTION_TASKS_VL
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: VIEW
Columns
Name |
---|
ACTION_TASK_ID TASK_NAME DESCRIPTION RESPONSIBLE_PARTY_CODE TASK_LEVEL_CODE TASK_STATUS_CODE TEMPLATE_FLAG GLOBAL_FLAG TASK_REUSE_FLAG PRC_BU_ID COMMENTS TASK_TEMPLATE_ID REQUESTER_ID TASK_OWNER_TYPE_CODE TASK_DUE_DATE SUPPLIER_ID SUPPLIER_SITE_ID ACTION_TASK_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY OBJECT_VERSION_NUMBER LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT B.ACTION_TASK_ID, T.TASK_NAME, T.DESCRIPTION, B.RESPONSIBLE_PARTY_CODE, B.TASK_LEVEL_CODE, B.TASK_STATUS_CODE, B.TEMPLATE_FLAG, B.GLOBAL_FLAG, B.TASK_REUSE_FLAG, B.PRC_BU_ID, B.COMMENTS, B.TASK_TEMPLATE_ID, B.REQUESTER_ID, B.TASK_OWNER_TYPE_CODE, B.TASK_DUE_DATE, B.SUPPLIER_ID, B.SUPPLIER_SITE_ID, B.ACTION_TASK_CODE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_LOGIN FROM POQ_ACTION_TASKS_B B, POQ_ACTION_TASKS_TL T WHERE T.ACTION_TASK_ID = B.ACTION_TASK_ID AND T.LANGUAGE = USERENV('LANG') |