Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_ELEC_STAT_SUM |
SELECT GRSUM.ROWID ROW_ID
, GRSUM.ESS_ID
, GRSUM.REP_PELL_ID
, GRSUM.DUNS_ID
, GRSUM.GAPS_AWARD_NUM
, GRSUM.ACCT_SCHEDULE_NUMBER
, GRSUM.ACCT_SCHEDULE_DATE
, GRSUM.PREV_OBLIGATION_AMT
, GRSUM.OBLIGATION_ADJ_AMT
, GRSUM.CURR_OBLIGATION_AMT
, GRSUM.PREV_OBLIGATION_PYMT_AMT
, GRSUM.OBLIGATION_PYMT_ADJ_AMT
, GRSUM.CURR_OBLIGATION_PYMT_AMT
, GRSUM.YTD_TOTAL_RECP
, GRSUM.YTD_ACCEPTED_DISB_AMT
, GRSUM.YTD_POSTED_DISB_AMT
, GRSUM.YTD_ADMIN_COST_ALLOWANCE
, GRSUM.CAPS_DRWN_DN_PYMTS
, GRSUM.GAPS_LAST_DATE
, GRSUM.LAST_PYMT_NUMBER
, GRSUM.CREATED_BY
, GRSUM.CREATION_DATE
, GRSUM.LAST_UPDATED_BY
, GRSUM.LAST_UPDATE_DATE
, GRSUM.LAST_UPDATE_LOGIN
, GRSUM.PROGRAM_APPLICATION_ID
, GRSUM.PROGRAM_ID
, GRSUM.PROGRAM_UPDATE_DATE
, GRSUM.REQUEST_ID
, GRSUM.ORG_ID
FROM IGF_GR_ELEC_STAT_SUM_ALL GRSUM
WHERE NVL (GRSUM.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)