VIEW: APPS.OKC_K_HISTORY_V

Source

View Text - Preformatted

SELECT HSTB.ROWID ROW_ID, HSTB.ID ID, HSTB.CHR_ID CHR_ID, HSTB.CLE_ID CLE_ID, HSTB.CONTRACT_VERSION CONTRACT_VERSION, HSTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HSTB.OPN_CODE OPN_CODE, HSTB.STS_CODE_FROM STS_CODE_FROM, HSTB.STS_CODE_TO STS_CODE_TO, HSTB.REASON_CODE REASON_CODE, HSTB.TRN_CODE TRN_CODE, HSTB.MANUAL_YN MANUAL_YN, HSTT.COMMENTS COMMENTS, HSTB.CREATED_BY CREATED_BY, HSTB.CREATION_DATE CREATION_DATE, HSTB.LAST_UPDATED_BY LAST_UPDATED_BY, HSTB.LAST_UPDATE_DATE LAST_UPDATE_DATE, HSTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HSTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, HSTB.PROGRAM_ID PROGRAM_ID, HSTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, HSTB.REQUEST_ID REQUEST_ID FROM OKC_K_HISTORY_B HSTB,OKC_K_HISTORY_TL HSTT WHERE HSTB.ID = HSTT.ID and HSTT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT HSTB.ROWID ROW_ID
, HSTB.ID ID
, HSTB.CHR_ID CHR_ID
, HSTB.CLE_ID CLE_ID
, HSTB.CONTRACT_VERSION CONTRACT_VERSION
, HSTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, HSTB.OPN_CODE OPN_CODE
, HSTB.STS_CODE_FROM STS_CODE_FROM
, HSTB.STS_CODE_TO STS_CODE_TO
, HSTB.REASON_CODE REASON_CODE
, HSTB.TRN_CODE TRN_CODE
, HSTB.MANUAL_YN MANUAL_YN
, HSTT.COMMENTS COMMENTS
, HSTB.CREATED_BY CREATED_BY
, HSTB.CREATION_DATE CREATION_DATE
, HSTB.LAST_UPDATED_BY LAST_UPDATED_BY
, HSTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HSTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, HSTB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, HSTB.PROGRAM_ID PROGRAM_ID
, HSTB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, HSTB.REQUEST_ID REQUEST_ID
FROM OKC_K_HISTORY_B HSTB
, OKC_K_HISTORY_TL HSTT
WHERE HSTB.ID = HSTT.ID
AND HSTT.LANGUAGE = USERENV('LANG')