View: GMS_INSTALLMENTS_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_INSTALLMENTS_V

View Text

SELECT I.INSTALLMENT_ID
, I.INSTALLMENT_NUM
, I.AWARD_ID
, I.START_DATE_ACTIVE
, I.END_DATE_ACTIVE
, I.CLOSE_DATE
, I.DIRECT_COST
, I.INDIRECT_COST
, I.ACTIVE_FLAG
, I.BILLABLE_FLAG
, I.TYPE
, I.ISSUE_DATE
, I.DESCRIPTION
, LP.MEANING
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.CREATION_DATE
, I.CREATED_BY
, I.LAST_UPDATE_LOGIN
, I.ROWID
FROM GMS_INSTALLMENTS I
, GMS_LOOKUPS LP
WHERE LP.LOOKUP_TYPE = 'INSTALLMENT_TYPE'
AND LP.LOOKUP_CODE = I.TYPE

Columns