VIEW: APPS.OKL_CNTRCT_STRMS_SUM_UV

Source

View Text - Preformatted

SELECT STMB.KHR_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, STMB.SAY_CODE ACTIVITY_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY',STMB.SAY_CODE) ACTIVITY, STYT.NAME NAME, STYB.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE', STYB.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE, STMB.PURPOSE_CODE PURPOSE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE', STMB.PURPOSE_CODE) PURPOSE, SUM(SELB.AMOUNT) AMOUNT, STYB.ID FROM OKL_STRM_TYPE_TL STYT,OKL_STRM_TYPE_B STYB,OKL_STRM_ELEMENTS SELB,OKL_STREAMS STMB,OKC_K_HEADERS_B CHRB WHERE STMB.KLE_ID IS NULL AND STMB.STY_ID = STYB.ID AND STYB.ID = STYT.ID AND STYT.LANGUAGE = USERENV('LANG') AND SELB.STM_ID = STMB.ID AND CHRB.ID = STMB.KHR_ID GROUP BY NAME, STYB.STREAM_TYPE_PURPOSE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE', STYB.STREAM_TYPE_PURPOSE), OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY',STMB.SAY_CODE), STMB.KHR_ID, CHRB.CONTRACT_NUMBER, STMB.SAY_CODE, STMB.PURPOSE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE',STMB.PURPOSE_CODE),STYB.ID

View Text - HTML Formatted

SELECT STMB.KHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, STMB.SAY_CODE ACTIVITY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE) ACTIVITY
, STYT.NAME NAME
, STYB.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STYB.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
, STMB.PURPOSE_CODE PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE) PURPOSE
, SUM(SELB.AMOUNT) AMOUNT
, STYB.ID
FROM OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
, OKC_K_HEADERS_B CHRB
WHERE STMB.KLE_ID IS NULL
AND STMB.STY_ID = STYB.ID
AND STYB.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')
AND SELB.STM_ID = STMB.ID
AND CHRB.ID = STMB.KHR_ID GROUP BY NAME
, STYB.STREAM_TYPE_PURPOSE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STYB.STREAM_TYPE_PURPOSE)
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE)
, STMB.KHR_ID
, CHRB.CONTRACT_NUMBER
, STMB.SAY_CODE
, STMB.PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE)
, STYB.ID