View: OKL_ST_ACCRUAL_STREAMS_UV

Product:	OKL - Lease and Finance Management
Description:	Mapping between stream type and its associated accrual stream types
Implementation/DBA Data:	APPS.OKL_ST_ACCRUAL_STREAMS_UV

View Text

SELECT SGTB.ID ID
, SGTB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, SGTB.OBJECT1_ID1 OBJECT1_ID1
, SGTB.OBJECT1_ID2 OBJECT1_ID2
, SGTB.SGN_CODE SGN_CODE
, STYB.CODE STREAM_TYPE_NAME
, SGTB.VALUE VALUE
, STYB1.CODE VALUE_TYPE_NAME
, SGTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SGTB.DEFAULT_VALUE DEFAULT_VALUE
, SGTB.ACTIVE_YN ACTIVE_YN
, SGTB.START_DATE START_DATE
, SGTB.END_DATE END_DATE
, SGTB.ATTRIBUTE1 ATTRIBUTE1
, SGTB.ATTRIBUTE2 ATTRIBUTE2
, SGTB.ATTRIBUTE3 ATTRIBUTE3
, SGTB.ATTRIBUTE4 ATTRIBUTE4
, SGTB.ATTRIBUTE5 ATTRIBUTE5
, SGTB.ATTRIBUTE6 ATTRIBUTE6
, SGTB.ATTRIBUTE7 ATTRIBUTE7
, SGTB.ATTRIBUTE8 ATTRIBUTE8
, SGTB.ATTRIBUTE9 ATTRIBUTE9
, SGTB.ATTRIBUTE10 ATTRIBUTE10
, SGTB.ATTRIBUTE11 ATTRIBUTE11
, SGTB.ATTRIBUTE12 ATTRIBUTE12
, SGTB.ATTRIBUTE13 ATTRIBUTE13
, SGTB.ATTRIBUTE14 ATTRIBUTE14
, SGTB.ATTRIBUTE15 ATTRIBUTE15
FROM OKL_SGN_TRANSLATIONS SGTB
, OKL_STRM_TYPE_B STYB
, OKL_STRM_TYPE_B STYB1
WHERE SGTB.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
AND SGTB.OBJECT1_ID1 = TO_CHAR(STYB.ID)
AND SGTB.VALUE = TO_CHAR(STYB1.ID)

Columns