Product: | OKL - Lease and Finance Management |
---|---|
Description: | Holds the definition of stream types. |
Implementation/DBA Data: | APPS.OKL_STREAM_TYPES_UV |
SELECT STYB.ROWID ROW_ID
, STYB.ID ID
, STYT.NAME NAME
, STYB.VERSION VERSION
, STYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STYB.CODE CODE
, STYT.SFWT_FLAG SFWT_FLAG
, STYB.STREAM_TYPE_SCOPE STREAM_TYPE_SCOPE
, STYB.STREAM_TYPE_SUBCLASS STREAM_TYPE_SUBCLASS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_SUBCLASS'
, STYB.STREAM_TYPE_SUBCLASS) STREAM_TYPE_SUBCLASS_MEANING
, 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_MEANING
, STYB.CONTINGENCY CONTINGENCY_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_CONTINGENCY'
, STYB.CONTINGENCY) CONTINGENCY_MEANING
, STYT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, STYT.DESCRIPTION DESCRIPTION
, STYB.START_DATE START_DATE
, STYB.END_DATE END_DATE
, STYB.BILLABLE_YN BILLABLE_YN
, STYB.TAXABLE_DEFAULT_YN TAXABLE_DEFAULT_YN
, STYB.CUSTOMIZATION_LEVEL CUSTOMIZATION_LEVEL
, STYB.FUNDABLE_YN FUNDABLE_YN
, STYB.PERIODIC_YN PERIODIC_YN
, STYB.STREAM_TYPE_CLASS STREAM_TYPE_CLASS_CODE
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_STREAM_TYPE_CLASS'
, STYB.STREAM_TYPE_CLASS) STREAM_TYPE_CLASS_MEANING
, STYB.CAPITALIZE_YN CAPITALIZE_YN
, STYB.ACCRUAL_YN ACCRUAL_YN
, STYB.ALLOCATION_FACTOR ALLOCATION_FACTOR
, STYB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, STYB.ATTRIBUTE1 ATTRIBUTE1
, STYB.ATTRIBUTE2 ATTRIBUTE2
, STYB.ATTRIBUTE3 ATTRIBUTE3
, STYB.ATTRIBUTE4 ATTRIBUTE4
, STYB.ATTRIBUTE5 ATTRIBUTE5
, STYB.ATTRIBUTE6 ATTRIBUTE6
, STYB.ATTRIBUTE7 ATTRIBUTE7
, STYB.ATTRIBUTE8 ATTRIBUTE8
, STYB.ATTRIBUTE9 ATTRIBUTE9
, STYB.ATTRIBUTE10 ATTRIBUTE10
, STYB.ATTRIBUTE11 ATTRIBUTE11
, STYB.ATTRIBUTE12 ATTRIBUTE12
, STYB.ATTRIBUTE13 ATTRIBUTE13
, STYB.ATTRIBUTE14 ATTRIBUTE14
, STYB.ATTRIBUTE15 ATTRIBUTE15
, STYB.CREATED_BY CREATED_BY
, STYB.CREATION_DATE CREATION_DATE
, STYB.LAST_UPDATED_BY LAST_UPDATED_BY
, STYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, STYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_TL STYT
WHERE STYB.ID = STYT.ID
AND STYT.LANGUAGE = USERENV('LANG')