[Home] [Help]
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
Name |
AWARD_ID |
AWARD_NAME |
ACTUAL_PROJECT_ID |
ORG_ID |