View: OKL_CS_TAX_SUMMARY_UV

Product:	OKL - Lease and Finance Management
Description:	This view is used by Lease Center screen to display tax summary information for a tax schedule.
Implementation/DBA Data:	APPS.OKL_CS_TAX_SUMMARY_UV

View Text

SELECT TXS.ID TX_SOURCE_ID
, TXL.ID TX_LINE_ID
, TXS.TRX_ID
, TXS.TRX_LINE_ID
, TXL.TAX_DETERMINATION_DATE TAX_DATE
, TXL.TAX_RATE_CODE TAX_CODE
, TYP.NAME STREAM_TYPE
, TXL.TAX_RATE
, TXL.TAXABLE_AMOUNT
, TXL.TAX_AMOUNT
, TXS.TRX_BUSINESS_CATEGORY TBC
FROM OKL_TAX_SOURCES TXS
, OKL_TAX_TRX_DETAILS TXL
, OKL_STRM_TYPE_TL TYP
, OKL_STREAMS_V STRM
, OKL_STRM_ELEMENTS_V SELM
WHERE TXS.ID = TXL.TXS_ID
AND TXS.SEL_ID = SELM.ID
AND SELM.STM_ID = STRM.ID
AND STRM.STY_ID = TYP.ID
AND TYP.LANGUAGE = USERENV('LANG')

Columns