OKC_K_STATUS_HISTORY

Details

Schema: FUSION
Object owner: OKC
Object type: VIEW

Columns

Name
ID CONTRACT_ID MAJOR_VERSION STS_CODE USER_STATUS_CODE ASSIGNEE_ID ASSIGNEE_TYPE COMMENTS HISTORY_CREATION_DATE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY OBJECT_VERSION_NUMBER REQUEST_ID PROGRAM_NAME PROGRAM_APP_NAME

Name

ID

CONTRACT_ID

MAJOR_VERSION

STS_CODE

USER_STATUS_CODE

ASSIGNEE_ID

ASSIGNEE_TYPE

COMMENTS

HISTORY_CREATION_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

OBJECT_VERSION_NUMBER

REQUEST_ID

PROGRAM_NAME

PROGRAM_APP_NAME

Query

SQL_Statement
SELECT KHB.ID, KHB.CONTRACT_ID, KHB.MAJOR_VERSION, KHB.STS_CODE, KHB.USER_STATUS_CODE, KHB.ASSIGNEE_ID, KHB.ASSIGNEE_TYPE, KHTL.COMMENTS, KHB.HISTORY_CREATION_DATE, KHB.CREATED_BY, KHB.CREATION_DATE, KHB.LAST_UPDATE_DATE, KHB.LAST_UPDATE_LOGIN, KHB.LAST_UPDATED_BY, KHB.OBJECT_VERSION_NUMBER, KHB.REQUEST_ID, KHB.PROGRAM_NAME, KHB.PROGRAM_APP_NAME FROM OKC_K_STATUS_HISTORY_B KHB, OKC_K_STATUS_HISTORY_TL KHTL WHERE KHB.ID = KHTL.K_HIST_ID AND KHTL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

KHB.ID,

KHB.CONTRACT_ID,

KHB.MAJOR_VERSION,

KHB.STS_CODE,

KHB.USER_STATUS_CODE,

KHB.ASSIGNEE_ID,

KHB.ASSIGNEE_TYPE,

KHTL.COMMENTS,

KHB.HISTORY_CREATION_DATE,

KHB.CREATED_BY,

KHB.CREATION_DATE,

KHB.LAST_UPDATE_DATE,

KHB.LAST_UPDATE_LOGIN,

KHB.LAST_UPDATED_BY,

KHB.OBJECT_VERSION_NUMBER,

KHB.REQUEST_ID,

KHB.PROGRAM_NAME,

KHB.PROGRAM_APP_NAME

FROM

OKC_K_STATUS_HISTORY_B KHB,

OKC_K_STATUS_HISTORY_TL KHTL

WHERE

KHB.ID = KHTL.K_HIST_ID AND KHTL.LANGUAGE = USERENV('LANG')