View: OKL_ST_PRORATE_TRANSLATIONS_UV

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

View Text

SELECT CONV.PRORATE_CONVENTION_CODE NAME
, 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
, SGTB.VALUE VALUE
, 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
, FA_CONVENTION_TYPES CONV
WHERE SGTB.JTOT_OBJECT1_CODE = 'FA_CONVENTION_TYPES'
AND SGTB.OBJECT1_ID1 = CONV.PRORATE_CONVENTION_CODE

Columns