DBA Data[Home] [Help]

VIEW: APPS.OKC_LAUNCH_KHIST_GRID_V

Source

View Text - Preformatted

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

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