[Home] [Help]
View: GMS_FP_DISTRIBUTIONS_V
View Text
SELECT F.FUNDING_PATTERN_ID
, F.DISTRIBUTION_NUMBER
, F.AWARD_ID
, F.DISTRIBUTION_VALUE
, A.AWARD_NUMBER
, A.AWARD_SHORT_NAME
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATE_LOGIN
, A.ORG_ID
FROM GMS_AWARDS A
, GMS_FP_DISTRIBUTIONS F
WHERE A.AWARD_ID= F.AWARD_ID
Columns
Name |
FUNDING_PATTERN_ID |
DISTRIBUTION_NUMBER |
AWARD_ID |
DISTRIBUTION_VALUE |
AWARD_NUMBER |
AWARD_NAME |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
ORG_ID |