View: OKL_TRX_LINE_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_TRX_LINE_UV

View Text

SELECT OTCL.ID ID
, OTCL.LINE_NUMBER LINE_NUMBER
, OTCL.DESCRIPTION DESCRIPTION
, OTCL.AMOUNT AMOUNT
, OTCL.CURRENCY_CODE CURRENCY_CODE
, OST.NAME STREAM_TYPE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, OST.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
, OTCL.TCN_ID TRANSACTION_ID
, 'OKL_TXL_CNTRCT_LNS' SOURCE_TABLE
, OTCL.KHR_ID KHR_ID
FROM OKL_TXL_CNTRCT_LNS OTCL
, OKL_STRM_TYPE_V OST
WHERE OTCL.STY_ID = OST.ID(+) UNION ALL SELECT ASL.ID ID
, ASL.LINE_NUMBER LINE_NUMBER
, ASL.MANUFACTURER_NAME DESCRIPTION
, ASL.MATCH_AMOUNT AMOUNT
, ASL.CURRENCY_CODE CURRENCY_CODE
, NULL STREAM_TYPE
, NULL STREAM_TYPE_PURPOSE
, ASL.TAS_ID TRANSACTION_ID
, 'OKL_TXL_ASSETS_B' SOURCE_TABLE
, ASL.DNZ_KHR_ID KHR_ID
FROM OKL_TXL_ASSETS_B ASL

Columns