eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: GMS_XLA_AWARD_REF_V

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

View Text

SELECT ADL.AWARD_SET_ID
, AWD.AWARD_ID
, AWD.AWARD_NUMBER
, AWD.AWARD_SHORT_NAME
, AWD.AWARD_ORGANIZATION_ID
, AWD.TYPE
, ADL.DOCUMENT_TYPE
, ADL.EXPENDITURE_ITEM_ID
, ADL.PO_DISTRIBUTION_ID
, ADL.DISTRIBUTION_ID
, ADL.INVOICE_DISTRIBUTION_ID
, AWD.AWARD_PURPOSE_CODE
, AWD.ATTRIBUTE_CATEGORY
, AWD.ATTRIBUTE1
, AWD.ATTRIBUTE2
, AWD.ATTRIBUTE3
, AWD.ATTRIBUTE4
, AWD.ATTRIBUTE5
, AWD.ATTRIBUTE6
, AWD.ATTRIBUTE7
, AWD.ATTRIBUTE8
, AWD.ATTRIBUTE9
, AWD.ATTRIBUTE10
, AWD.ATTRIBUTE11
, AWD.ATTRIBUTE12
, AWD.ATTRIBUTE13
, AWD.ATTRIBUTE14
, AWD.ATTRIBUTE15
FROM GMS_AWARD_DISTRIBUTIONS ADL
, GMS_AWARDS_ALL AWD
WHERE AWD.AWARD_ID = ADL.AWARD_ID
AND ADL.ADL_STATUS = 'A'
AND ADL.ADL_LINE_NUM = 1

Columns

Name
AWARD_SET_ID
AWARD_ID
AWARD_NUMBER
AWARD_SHORT_NAME
AWARD_ORGANIZATION_ID
AWARD_TYPE
DOCUMENT_TYPE
EXPENDITURE_ITEM_ID
PO_DISTRIBUTION_ID
REQ_DISTRIBUTION_ID
INVOICE_DISTRIBUTION_ID
AWARD_PURPOSE_CODE
AWARD_ATTRIBUTE_CATEGORY
AWARD_ATTRIBUTE1
AWARD_ATTRIBUTE2
AWARD_ATTRIBUTE3
AWARD_ATTRIBUTE4
AWARD_ATTRIBUTE5
AWARD_ATTRIBUTE6
AWARD_ATTRIBUTE7
AWARD_ATTRIBUTE8
AWARD_ATTRIBUTE9
AWARD_ATTRIBUTE10
AWARD_ATTRIBUTE11
AWARD_ATTRIBUTE12
AWARD_ATTRIBUTE13
AWARD_ATTRIBUTE14
AWARD_ATTRIBUTE15