[Home] [Help]
View: GMS_BIS_AWD_GR_RPT_V
Product: | GMS - Grants Accounting |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AWARD_ORG_ID
, AWARD_ORG_NAME
, AWARD_PERSON_ID
, AWARD_PERSON_NAME
, SPONSOR_ID
, SPONSOR_NAME
, AWARD_ID
, AWARD_NUMBER
, INSTALLMENT_START_PERIOD_NAME
, INSTALLMENT_PERIOD_START_DATE
, PERIOD_TYPE
, TOTAL_AWARD_AMOUNT
, GMS_BIS_UTIL_PKG.GET_PREV_AWD_AMT(ADD_MONTHS(INSTALLMENT_PERIOD_START_DATE
, -12)
, AWARD_ORG_ID
, AWARD_ID
, AWARD_PERSON_ID
, SPONSOR_ID
, PERIOD_TYPE
, NULL)
FROM GMS_BIS_AWD_GR_SUMM
Columns
Name |
AWARD_ORG_ID |
AWARD_ORG_NAME |
AWARD_PERSON_ID |
AWARD_PERSON_NAME |
SPONSOR_ID |
SPONSOR_NAME |
AWARD_ID |
AWARD_NUMBER |
INSTALLMENT_START_PERIOD_NAME |
INSTALLMENT_PERIOD_START_DATE |
PERIOD_TYPE |
TOTAL_AWARD_CURR_AMOUNT |
TOTAL_AWARD_PREV_AMOUNT |