VIEW: APPS.GMS_INSTALLMENTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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