[Home] [Help]
View: GMS_SSA_AWARD_EXPTYPE_V
View Text
SELECT GA.AWARD_ID AWARD_ID
, GA.AWARD_NUMBER AWARD_NUMBER
, GA.ALLOWABLE_SCHEDULE_ID ALLOWABLE_SCHEDULE_ID
, GAE.EXPENDITURE_TYPE EXPENDITURE_TYPE
, GA.ORG_ID
FROM GMS_AWARDS GA
, GMS_ALLOWABLE_EXPENDITURES GAE
WHERE GA.ALLOWABLE_SCHEDULE_ID = GAE.ALLOWABILITY_SCHEDULE_ID
Columns
Name |
AWARD_ID |
AWARD_NUMBER |
ALLOWABLE_SCHEDULE_ID |
EXPENDITURE_TYPE |
ORG_ID |