View: OKL_STRM_TYPE_PURPOSE_UV

Product:	OKL - Lease and Finance Management
Description:	This view contains all the stream types in the system with the stream type purpose
Implementation/DBA Data:	APPS.OKL_STRM_TYPE_PURPOSE_UV

View Text

SELECT STRM.ROW_ID ROW_ID
, STRM.ID ID
, STRM.NAME NAME
, STRM.VERSION VERSION
, STRM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STRM.CODE CODE
, STRM.SFWT_FLAG SFWT_FLAG
, STRM.STREAM_TYPE_SCOPE STREAM_TYPE_SCOPE
, STRM.STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS
, STRM.STREAM_TYPE_PURPOSE STREAM_TYPE_PURPOSE_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_PURPOSE'
, STRM.STREAM_TYPE_PURPOSE) STREAM_TYPE_PURPOSE
, STRM.CONTINGENCY CONTINGENCY
, STRM.SHORT_DESCRIPTION SHORT_DESCRIPTION
, STRM.DESCRIPTION DESCRIPTION
, STRM.START_DATE START_DATE
, STRM.END_DATE END_DATE
, STRM.BILLABLE_YN BILLABLE_YN
, STRM.TAXABLE_DEFAULT_YN TAXABLE_DEFAULT_YN
, STRM.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
, STRM.FUNDABLE_YN FUNDABLE_YN
, STRM.PERIODIC_YN PERIODIC_YN
, STRM.STREAM_TYPE_CLASS STREAM_TYPE_CLASS
, STRM.CAPITALIZE_YN CAPITALIZE_YN
, STRM.ACCRUAL_YN ACCRUAL_YN
, STRM.ALLOCATION_FACTOR ALLOCATION_FACTOR
, STRM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, STRM.ATTRIBUTE1 ATTRIBUTE1
, STRM.ATTRIBUTE2 ATTRIBUTE2
, STRM.ATTRIBUTE3 ATTRIBUTE3
, STRM.ATTRIBUTE4 ATTRIBUTE4
, STRM.ATTRIBUTE5 ATTRIBUTE5
, STRM.ATTRIBUTE6 ATTRIBUTE6
, STRM.ATTRIBUTE7 ATTRIBUTE7
, STRM.ATTRIBUTE8 ATTRIBUTE8
, STRM.ATTRIBUTE9 ATTRIBUTE9
, STRM.ATTRIBUTE10 ATTRIBUTE10
, STRM.ATTRIBUTE11 ATTRIBUTE11
, STRM.ATTRIBUTE12 ATTRIBUTE12
, STRM.ATTRIBUTE13 ATTRIBUTE13
, STRM.ATTRIBUTE14 ATTRIBUTE14
, STRM.ATTRIBUTE15 ATTRIBUTE15
, STRM.CREATED_BY CREATED_BY
, STRM.CREATION_DATE CREATION_DATE
, STRM.LAST_UPDATED_BY LAST_UPDATED_BY
, STRM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, STRM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_STRM_TYPE_V STRM

Columns