VIEW: APPS.GMS_FUNDING_AWARDS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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