Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_ELEC_STAT_DET |
SELECT GRDET.ROWID ROW_ID
, GRDET.ESD_ID
, GRDET.REP_PELL_ID
, GRDET.DUNS_ID
, GRDET.GAPS_AWARD_NUM
, GRDET.TRANSACTION_DATE
, GRDET.DB_CR_FLAG
, GRDET.ADJ_AMT
, GRDET.GAPS_PROCESS_DATE
, GRDET.ADJ_BATCH_ID
, GRDET.CREATED_BY
, GRDET.CREATION_DATE
, GRDET.LAST_UPDATED_BY
, GRDET.LAST_UPDATE_DATE
, GRDET.LAST_UPDATE_LOGIN
, GRDET.REQUEST_ID
, GRDET.PROGRAM_APPLICATION_ID
, GRDET.PROGRAM_ID
, GRDET.PROGRAM_UPDATE_DATE
, GRDET.ORG_ID
FROM IGF_GR_ELEC_STAT_DET_ALL GRDET
WHERE NVL (GRDET.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)