FND_BPM_TASK_HISTORY_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

DOMAIN TASK_ID TASK_NUMBER VERSION VERSION_REASON ROOT_TASK_ID PARENT_TASK_ID WORKFLOWPATTERN_CODE TASK_GROUP_INSTANCE_ID SUB_TASK_GROUP_INSTANCE_ID IDENTIFICATION_KEY FROM_USER ACQUIRED_BY COMPLETED_DATE STATUS_CODE OUTCOME_CODE OUTCOME STAGE_CODE STAGE PARTICIPANT_CODE PARTICIPANT INITIATED_DATE COMPLETED_BY COMPOSITE_INSTANCE_ID ASSIGNMENT_CONTEXT APPROVERS PACKAGE_NAME 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.VERSION , B.VERSION_REASON , B.ROOT_TASK_ID , B.PARENT_TASK_ID , B.WORKFLOWPATTERN_CODE , B.TASK_GROUP_INSTANCE_ID , B.SUB_TASK_GROUP_INSTANCE_ID , B.IDENTIFICATION_KEY , B.FROM_USER , B.ACQUIRED_BY , B.COMPLETED_DATE , B.STATUS_CODE , B.OUTCOME_CODE , T.OUTCOME, B.STAGE_CODE , T.STAGE, B.PARTICIPANT_CODE , T.PARTICIPANT, B.INITIATED_DATE , B.COMPLETED_BY, B.COMPOSITE_INSTANCE_ID, B.ASSIGNMENT_CONTEXT, B.APPROVERS, B.PACKAGE_NAME, B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN FROM FND_BPM_TASK_HISTORY_TL T, FND_BPM_TASK_HISTORY_B B WHERE B.DOMAIN = T.DOMAIN AND B.TASK_ID = T.TASK_ID AND B.VERSION = T.VERSION AND T.LANGUAGE = USERENV('LANG')