Product: | GMS - Grants Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMS_INSTALLMENTS_V |
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