VIEW: APPS.OKL_LINE_STREAMS_UV

Source

View Text - Preformatted

SELECT CHRB.ID CONTRACT_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CLEB.ID LINE_ID, STYA.NAME K_LINE_NAME, LSEB.LTY_CODE K_LINE_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, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE, SELB.AMOUNT AMOUNT, STMB.SAY_CODE ACTIVITY_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY', STMB.SAY_CODE) ACTIVITY , STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER , STMB.PURPOSE_CODE PURPOSE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE', STMB.PURPOSE_CODE) PURPOSE, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION, STYB.ID FROM OKC_K_LINES_TL CLET,OKC_K_HEADERS_B CHRB,OKC_K_LINES_B CLEB,OKC_LINE_STYLES_B LSEB,OKC_K_ITEMS CITM,OKL_STRM_TYPE_TL STYT,OKL_STRM_TYPE_B STYB,OKL_STRM_TYPE_TL STYA,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 = 'FEE' AND CITM.OBJECT1_ID1 = TO_CHAR(STYA.ID) AND CITM.CLE_ID = CLEB.ID 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 AND STYA.LANGUAGE = USERENV('LANG') UNION ALL SELECT CHRB.ID CONTRACT_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CLEB.ID LINE_ID, OSIB.NAME K_LINE_NAME, LSEB.LTY_CODE K_LINE_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, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE, SELB.AMOUNT AMOUNT, STMB.SAY_CODE ACTIVITY_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY', STMB.SAY_CODE) ACTIVITY , STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER , STMB.PURPOSE_CODE PURPOSE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE', STMB.PURPOSE_CODE) PURPOSE, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION, STYB.ID FROM OKC_K_LINES_TL CLET, OKC_K_HEADERS_B CHRB, OKC_K_LINES_B CLEB, OKC_LINE_STYLES_B LSEB, OKC_K_ITEMS CITM, OKL_STRM_TYPE_TL STYT, OKL_STRM_TYPE_B STYB, OKL_STRM_ELEMENTS SELB, OKL_STREAMS STMB, OKX_SYSTEM_ITEMS_V OSIB WHERE CLEB.DNZ_CHR_ID = CHRB.ID AND CLEB.CHR_ID = CHRB.ID AND CLEB.LSE_ID = LSEB.ID AND LSEB.LTY_CODE = 'SOLD_SERVICE' AND CITM.OBJECT1_ID1 = TO_CHAR(OSIB.ID1) AND CITM.OBJECT1_ID2 = TO_CHAR(OSIB.ID2 ) AND CITM.CLE_ID = CLEB.ID 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 UNION ALL SELECT CHRB.ID CONTRACT_ID, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER, CLEB.ID LINE_ID, STYT.NAME K_LINE_NAME, LSEB.LTY_CODE K_LINE_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, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE, SELB.AMOUNT AMOUNT, STMB.SAY_CODE ACTIVITY_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY',STMB.SAY_CODE) ACTIVITY , STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER , STMB.PURPOSE_CODE PURPOSE_CODE, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE', STMB.PURPOSE_CODE) PURPOSE, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION, STYB.ID FROM OKC_K_LINES_B CLEB, OKC_K_LINES_TL CLET, OKC_K_HEADERS_B CHRB, 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 = 'INSURANCE' 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

View Text - HTML Formatted

SELECT CHRB.ID CONTRACT_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CLEB.ID LINE_ID
, STYA.NAME K_LINE_NAME
, LSEB.LTY_CODE K_LINE_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
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, STMB.SAY_CODE ACTIVITY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE) ACTIVITY
, STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STMB.PURPOSE_CODE PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE) PURPOSE
, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, STYB.ID
FROM OKC_K_LINES_TL CLET
, OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS CITM
, OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYA
, 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 = 'FEE'
AND CITM.OBJECT1_ID1 = TO_CHAR(STYA.ID)
AND CITM.CLE_ID = CLEB.ID
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
AND STYA.LANGUAGE = USERENV('LANG') UNION ALL SELECT CHRB.ID CONTRACT_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CLEB.ID LINE_ID
, OSIB.NAME K_LINE_NAME
, LSEB.LTY_CODE K_LINE_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
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, STMB.SAY_CODE ACTIVITY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE) ACTIVITY
, STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STMB.PURPOSE_CODE PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE) PURPOSE
, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, STYB.ID
FROM OKC_K_LINES_TL CLET
, OKC_K_HEADERS_B CHRB
, OKC_K_LINES_B CLEB
, OKC_LINE_STYLES_B LSEB
, OKC_K_ITEMS CITM
, OKL_STRM_TYPE_TL STYT
, OKL_STRM_TYPE_B STYB
, OKL_STRM_ELEMENTS SELB
, OKL_STREAMS STMB
, OKX_SYSTEM_ITEMS_V OSIB
WHERE CLEB.DNZ_CHR_ID = CHRB.ID
AND CLEB.CHR_ID = CHRB.ID
AND CLEB.LSE_ID = LSEB.ID
AND LSEB.LTY_CODE = 'SOLD_SERVICE'
AND CITM.OBJECT1_ID1 = TO_CHAR(OSIB.ID1)
AND CITM.OBJECT1_ID2 = TO_CHAR(OSIB.ID2 )
AND CITM.CLE_ID = CLEB.ID
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 UNION ALL SELECT CHRB.ID CONTRACT_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CLEB.ID LINE_ID
, STYT.NAME K_LINE_NAME
, LSEB.LTY_CODE K_LINE_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
, SELB.STREAM_ELEMENT_DATE STREAM_ELEMENT_DATE
, SELB.AMOUNT AMOUNT
, STMB.SAY_CODE ACTIVITY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_ACTIVITY'
, STMB.SAY_CODE) ACTIVITY
, STMB.TRANSACTION_NUMBER TRANSACTION_NUMBER
, STMB.PURPOSE_CODE PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STRM_G_PURPOSE'
, STMB.PURPOSE_CODE) PURPOSE
, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, STYB.ID
FROM OKC_K_LINES_B CLEB
, OKC_K_LINES_TL CLET
, OKC_K_HEADERS_B CHRB
, 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 = 'INSURANCE'
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