1. Tables and Views for Sales and Fusion Service
  2. OKC_K_APPROVAL_HISTORY_WF_V

OKC_K_APPROVAL_HISTORY_WF_V

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

APPROVALHISTORYID

APPROVALHISTORYMAJORVERSION

APPROVALHISTORYVERSIONTYPE

APPROVALHISTOBJVERSIONNUM

APPROVALHISTORYCREATEDBY

APPROVALHISTORYCREATIONDATE

APPROVALHISTLASTUPDATEDBY

APPROVALHISTLASTUPDATEDATE

APPROVALHISTLASTUPDATELOGIN

APPROVALHISTORYTASKID

APPROVALHISTDATESUBMITTED

WFTASKTASKID

WFTASKASSIGNEES

WFTASKASSIGNEESDISPLAYNAME

WFTASKASSIGNEDDATE

WFTASKSTATE

WFTASKOUTCOME

WFTASKENDDATE

WFTASKUPDATEDATE

Query

SQL_Statement

SELECT

OKC_K_APPROVAL_HISTORY.ID ApprovalHistoryId,

OKC_K_APPROVAL_HISTORY.MAJOR_VERSION ApprovalHistoryMajorVersion,

OKC_K_APPROVAL_HISTORY.VERSION_TYPE ApprovalHistoryVersionType,

OKC_K_APPROVAL_HISTORY.OBJECT_VERSION_NUMBER ApprovalHistObjVersionNum,

OKC_K_APPROVAL_HISTORY.CREATED_BY ApprovalHistoryCreatedBy,

OKC_K_APPROVAL_HISTORY.CREATION_DATE ApprovalHistoryCreationDate,

OKC_K_APPROVAL_HISTORY.LAST_UPDATED_BY ApprovalHistLastUpdatedBy,

OKC_K_APPROVAL_HISTORY.LAST_UPDATE_DATE ApprovalHistLastUpdateDate,

OKC_K_APPROVAL_HISTORY.LAST_UPDATE_LOGIN ApprovalHistLastUpdateLogin,

OKC_K_APPROVAL_HISTORY.TASK_ID ApprovalHistoryTaskId,

OKC_K_APPROVAL_HISTORY.DATE_SUBMITTED ApprovalHistDateSubmitted,

WFTASK.TASKID WftaskTaskId,

WFTASK.ASSIGNEES WftaskAssignees,

WFTASK.ASSIGNEESDISPLAYNAME WftaskAssigneesDisplayName,

WFTASK.ASSIGNEDDATE WftaskAssignedDate,

WFTASK.STATE WftaskState,

WFTASK.OUTCOME WftaskOutcome,

WFTASK.ENDDATE WftaskEndDate,

WFTASK.UPDATEDDATE WftaskUpdateDate

FROM OKC_K_APPROVAL_HISTORY, fa_fusion_soainfra.WFTASK

WHERE OKC_K_APPROVAL_HISTORY.task_id = WFTASK.taskid