View: OKL_TAX_LINES_UV

Product:	OKL - Lease and Finance Management
Description:	Tax Line Information
Implementation/DBA Data:	APPS.OKL_TAX_LINES_UV

View Text

SELECT TAX_HDR.ID
, TAX_HDR.KHR_ID CONTRACT_ID
, TAX_HDR.KLE_ID CONTRACT_LINE_ID
, TAX_HDR.LINE_NAME ASSET_NUMBER
, NULL LINE_TYPE
, TYP.NAME STREAM_TYPE
, SELM.ID STREAM_ELEMENT_ID
, SELM.AMOUNT STREAM_AMOUNT
, SELM.STREAM_ELEMENT_DATE DUE_DATE
, (SELECT DISTINCT BILLED_YN
FROM OKL_TAX_TRX_DETAILS
WHERE TXS_ID = TAX_HDR.ID
AND ROWNUM < 2) ACTUAL_YN
, NULL TAX_RATE_CODE
, TAX_HDR.ASSESSABLE_VALUE TAXABLE_AMOUNT
, NULL TAX_RATE
, TAX_HDR.TOTAL_TAX TAX_AMOUNT
, TAX_HDR.TRX_ID TRQ_ID
, CHR.CURRENCY_CODE
, TAX_HDR.CREATED_BY
, TAX_HDR.CREATION_DATE
, TAX_HDR.LAST_UPDATED_BY
, TAX_HDR.LAST_UPDATE_DATE
, TAX_HDR.LAST_UPDATE_LOGIN
, TAX_HDR.TRX_LINE_ID TRX_LINE_ID
, TAX_HDR.TAX_LINE_STATUS_CODE
, TAX_HDR.TRX_LEVEL_TYPE
, TAX_HDR.APPLICATION_ID
, TAX_HDR.ENTITY_CODE
, TAX_HDR.EVENT_CLASS_CODE
, TAX_HDR.TAX_CALL_TYPE_CODE
FROM OKL_TAX_SOURCES TAX_HDR
, OKC_K_HEADERS_B CHR
, OKL_STRM_TYPE_TL TYP
, OKL_STREAMS_V STRM
, OKL_STRM_ELEMENTS_V SELM
WHERE TAX_HDR.KHR_ID = CHR.ID
AND TAX_HDR.SEL_ID = SELM.ID
AND SELM.STM_ID = STRM.ID
AND STRM.STY_ID = TYP.ID
AND TYP.LANGUAGE = USERENV('LANG')
AND TAX_HDR.TAX_LINE_STATUS_CODE = 'ACTIVE'
AND TAX_HDR.TRX_LEVEL_TYPE = 'LINE'
AND TAX_HDR.TAX_CALL_TYPE_CODE = 'TAX_SCHEDULE'
AND TAX_HDR.ENTITY_CODE = 'TAX_SCHEDULE_REQUESTS'
AND TAX_HDR.APPLICATION_ID = 540
AND TAX_HDR.EVENT_CLASS_CODE = 'TAX_SCHEDULE'

Columns