FND_BPM_TASK_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

DOMAIN TASK_ID TASK_NUMBER TASK_QNAME TASK_DEFINITION_NAME TASK_DEFINITION_ID TASK_TITLE ROOT_TASK_ID PARENT_TASK_ID IDENTIFICATION_KEY DUE_DATE EXPIRATION_DATE INITIATED_BY INITIATED_DATE COMPLETED_BY COMPLETED_DATE STATUS_CODE OUTCOME_CODE OUTCOME CATEGORY_CODE CATEGORY COMPOSITE_NAME COMPOSITE_VERSION COMPOSITE_INSTANCE_ID ASSIGNMENT_CONTEXT PACKAGE_NAME APPROVERS CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.DOMAIN , B.TASK_ID , B.TASK_NUMBER , B.TASK_QNAME , B.TASK_DEFINITION_NAME , B.TASK_DEFINITION_ID, T.TASK_TITLE, B.ROOT_TASK_ID , B.PARENT_TASK_ID , B.IDENTIFICATION_KEY , B.DUE_DATE , B.EXPIRATION_DATE , B.INITIATED_BY , B.INITIATED_DATE , B.COMPLETED_BY , B.COMPLETED_DATE , B.STATUS_CODE , B.OUTCOME_CODE , T.OUTCOME , B.CATEGORY_CODE , T.CATEGORY, B.COMPOSITE_NAME , B.COMPOSITE_VERSION , B.COMPOSITE_INSTANCE_ID, B.ASSIGNMENT_CONTEXT, B.PACKAGE_NAME, B.APPROVERS, B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN FROM FND_BPM_TASK_TL T, FND_BPM_TASK_B B WHERE B.DOMAIN = T.DOMAIN AND B.TASK_ID = T.TASK_ID AND T.LANGUAGE = USERENV('LANG')