View: GMS_FUNDING_AWARDS_V

Product:	GMS - Grants Accounting
Description:	Projects that are funded by a particular award
Implementation/DBA Data:	APPS.GMS_FUNDING_AWARDS_V

View Text

SELECT GA.AWARD_ID AWARD_ID
, GA.AWARD_SHORT_NAME AWARD_NAME
, PP.PROJECT_ID ACTUAL_PROJECT_ID
, GA.ORG_ID
FROM GMS_AWARDS GA
, GMS_SUMMARY_PROJECT_FUNDINGS GF
, GMS_INSTALLMENTS GI
, PA_PROJECTS_ALL PP
WHERE GF.PROJECT_ID = PP.PROJECT_ID
AND GF.INSTALLMENT_ID = GI.INSTALLMENT_ID
AND GI.AWARD_ID = GA.AWARD_ID GROUP BY GA.AWARD_ID
, GA.AWARD_SHORT_NAME
, PP.PROJECT_ID
, GA.ORG_ID

Columns