OKC_K_APPROVAL_HISTORY_WF_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: OKC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
APPROVALHISTORYID APPROVALHISTORYMAJORVERSION APPROVALHISTORYVERSIONTYPE APPROVALHISTOBJVERSIONNUM APPROVALHISTORYCREATEDBY APPROVALHISTORYCREATIONDATE APPROVALHISTLASTUPDATEDBY APPROVALHISTLASTUPDATEDATE APPROVALHISTLASTUPDATELOGIN APPROVALHISTORYTASKID APPROVALHISTDATESUBMITTED WFTASKTASKID WFTASKASSIGNEES WFTASKASSIGNEESDISPLAYNAME WFTASKASSIGNEDDATE WFTASKSTATE WFTASKOUTCOME WFTASKENDDATE WFTASKUPDATEDATE |
問合せ
| 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 |