[Home] [Help]
View: OKL_ASST_STRMS_SUM_UV
View Text
SELECT CHRB.ID CONTRACT_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, STMB.SAY_CODE ACTIVITY_CODE
, 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
, CLET.NAME LINE_NAME
, SUM(SELB.AMOUNT) AMOUNT
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE) ACTIVITY
, STMB.PURPOSE_CODE PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE) PURPOSE
, STYB.ID
FROM OKC_K_LINES_TL CLET
, OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
WHERE CLEB.DNZ_CHR_ID = CHRB.ID
AND CLEB.CHR_ID = CHRB.ID
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'FREE_FORM1'
AND CLET.ID = CLEB.ID
AND CLET.LANGUAGE = USERENV('LANG')
AND STMB.KHR_ID = CHRB.ID
AND STMB.KLE_ID = CLEB.ID
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 STYT.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)
, CHRB.ID
, CHRB.CONTRACT_NUMBER
, STMB.SAY_CODE
, CLET.NAME
, STMB.PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE)
, STYB.ID
Columns
Name |
CONTRACT_ID |
CONTRACT_NUMBER |
ACTIVITY_CODE |
NAME |
STREAM_TYPE_PURPOSE_CODE |
STREAM_TYPE_PURPOSE |
LINE_NAME |
AMOUNT |
ACTIVITY |
PURPOSE_CODE |
PURPOSE |
ID |