[Home] [Help]
View: GMS_BIS_AWD_ORG_RPT_V
Product: | GMS - Grants Accounting |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AWARD_ORG_ID
, AWARD_ORG_NAME
, INSTALLMENT_START_PERIOD_NAME
, INSTALLMENT_PERIOD_START_DATE
, PERIOD_TYPE
, TOTAL_AWARD_ROLLUP_AMOUNT
, GMS_BIS_UTIL_PKG.GET_PREV_AWD_AMT (ADD_MONTHS(INSTALLMENT_PERIOD_START_DATE
, -12)
, AWARD_ORG_ID
, NULL
, NULL
, NULL
, PERIOD_TYPE
, 'ROLL')
, TOTAL_AWARD_AMOUNT
, GMS_BIS_UTIL_PKG.GET_PREV_AWD_AMT ( ADD_MONTHS(INSTALLMENT_PERIOD_START_DATE
, -12)
, AWARD_ORG_ID
, NULL
, NULL
, NULL
, PERIOD_TYPE
, 'CURR')
FROM GMS_BIS_AWD_ORG_SUMM
Columns
Name |
AWARD_ORG_ID |
AWARD_ORG_NAME |
INSTALLMENT_START_PERIOD_NAME |
INSTALLMENT_PERIOD_START_DATE |
PERIOD_TYPE |
TOTAL_CURR_ROLLUP_AMOUNT |
TOTAL_PREV_ROLLUP_AMOUNT |
TOTAL_CURR_AMOUNT |
TOTAL_PREV_AMOUNT |