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 DISTINCT 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(HSTB.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
, DECODE(HSTB.CLE_ID
, NULL
, 'HEADER'
, DECODE(OKCL.LSE_ID
, '1'
, 'LINE'
, '14'
, 'LINE'
, '19'
, 'LINE'
, '12'
, 'LINE'
, '46'
, 'LINE'
, 'SUBLINE')) CHANGE_LEVEL
, DECODE(HSTB.CLE_ID
, NULL
, NULL
, DECODE(OKCL.LSE_ID
, '1'
, OKCL.LINE_NUMBER
, '14'
, OKCL.LINE_NUMBER
, '19'
, OKCL.LINE_NUMBER
, '12'
, OKCL.LINE_NUMBER
, '46'
, OKCL.LINE_NUMBER
, (SELECT OKC.LINE_NUMBER || '.' ||OKCL.LINE_NUMBER
FROM OKC_K_LINES_B OKC
WHERE OKC.ID = OKCL.CLE_ID)))LINE_NUMBER
FROM OKC_K_LINES_B OKCL
, 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
AND OKCL.DNZ_CHR_ID = HSTB.CHR_ID
AND OKCL.ID = NVL(HSTB.CLE_ID
, OKCL.ID)

Columns