DBA Data[Home] [Help]

VIEW: APPS.OKC_LAUNCH_KHIST_GRID_V

Source

View Text - Preformatted

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)
View Text - HTML Formatted

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)