FND Design Data [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