View: OKL_SERVICE_FEES_UV

Product:	OKL - Lease and Finance Management
Description:	UI View for OKL Service Fee setup screens
Implementation/DBA Data:	APPS.OKL_SERVICE_FEES_UV

View Text

SELECT SVFB.ID ID
, SVFB.SRV_CODE SRV_CODE
, LOKU.MEANING MEANING
, SVFB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SVFTL.DESCRIPTION DESCRIPTION
, SVFB.AMOUNT AMOUNT
, SVFB.START_DATE START_DATE
, SVFB.END_DATE END_DATE
, DECODE(NVL(SVFB.END_DATE
, NULL)
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(SVFB.END_DATE
, SYSDATE))
, 1
, 'ACTIVE'
, 'INACTIVE')) STATUS
, SVFB.ORGANIZATION_ID ORGANIZATION_ID
, SVFB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SVFB.ATTRIBUTE1 ATTRIBUTE1
, SVFB.ATTRIBUTE2 ATTRIBUTE2
, SVFB.ATTRIBUTE3 ATTRIBUTE3
, SVFB.ATTRIBUTE4 ATTRIBUTE4
, SVFB.ATTRIBUTE5 ATTRIBUTE5
, SVFB.ATTRIBUTE6 ATTRIBUTE6
, SVFB.ATTRIBUTE7 ATTRIBUTE7
, SVFB.ATTRIBUTE8 ATTRIBUTE8
, SVFB.ATTRIBUTE9 ATTRIBUTE9
, SVFB.ATTRIBUTE10 ATTRIBUTE10
, SVFB.ATTRIBUTE11 ATTRIBUTE11
, SVFB.ATTRIBUTE12 ATTRIBUTE12
, SVFB.ATTRIBUTE13 ATTRIBUTE13
, SVFB.ATTRIBUTE14 ATTRIBUTE14
, SVFB.ATTRIBUTE15 ATTRIBUTE15
, SVFB.CREATED_BY CREATED_BY
, SVFB.CREATION_DATE CREATION_DATE
, SVFB.LAST_UPDATED_BY LAST_UPDATED_BY
, SVFB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SVFB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_SERVICE_FEES_TL SVFTL
, FND_LOOKUPS LOKU
, OKL_SERVICE_FEES_B SVFB
WHERE SVFB.ID = SVFTL.ID
AND SVFTL.LANGUAGE = USERENV('LANG')
AND LOKU.LOOKUP_TYPE = 'OKL_SERVICE_FEES'
AND LOKU.LOOKUP_CODE = SVFB.SRV_CODE

Columns