View: OKC_LAUNCH_KHIST_GRID_V

Product:	OKC - Contracts Core
Description:	View for Launchpad overview tab - contract status change history
Implementation/DBA Data:	APPS.OKC_LAUNCH_KHIST_GRID_V

View Text

SELECT HSTB.ID ID
, HSTB.CHR_ID CHR_ID
, HSTB.CLE_ID CLE_ID
, HSTB.CREATION_DATE CREATION_DATE
, ST1.MEANING FROM_STATUS
, ST2.MEANING TO_STATUS
, DECODE(TRN_CODE
, NULL
, NVL(FND.MEANING
, FND4.MEANING)
, FND2.MEANING) REASON_MEANING
, HSTL.COMMENTS COMMENTS
, HSTB.CONTRACT_VERSION CONTRACT_VERSION
, FND3.MEANING MANUAL_YN
, USR.USER_NAME USER_NAME
FROM FND_USER USR
, OKC_K_HISTORY_B HSTB
, OKC_K_HISTORY_TL HSTL
, OKC_STATUSES_TL ST2
, FND_LOOKUPS FND
, OKC_STATUSES_TL ST1
, FND_LOOKUPS FND2
, FND_LOOKUPS FND3
, FND_LOOKUPS FND4
WHERE HSTB.ID = HSTL.ID
AND HSTL.LANGUAGE = USERENV('LANG')
AND ST1.CODE(+) = HSTB.STS_CODE_FROM
AND ST1.LANGUAGE(+) = USERENV('LANG')
AND ST2.CODE(+) = HSTB.STS_CODE_TO
AND ST2.LANGUAGE = USERENV('LANG')
AND HSTB.CREATED_BY = USR.USER_ID
AND FND.LOOKUP_TYPE (+) = 'OKC_STS_CHG_REASON'
AND FND.LOOKUP_CODE (+)= HSTB.REASON_CODE
AND FND2.LOOKUP_TYPE (+) = 'OKC_TERMINATION_REASON'
AND FND2.LOOKUP_CODE (+) = HSTB.TRN_CODE
AND FND3.LOOKUP_TYPE (+) = 'YES_NO'
AND FND3.LOOKUP_CODE (+) = HSTB.MANUAL_YN
AND FND4.LOOKUP_TYPE (+) = 'OKS_CANCEL_REASON'
AND FND4.LOOKUP_CODE(+) = HSTB.REASON_CODE

Columns