Product: | IGF - Financial Aid |
---|---|
Description: | Stores the data loaded through the year to date disbursement data file. |
Implementation/DBA Data: | APPS.IGF_DB_YTD_DTL |
SELECT YTDD.ROWID
, YTDD.YTDD_ID
, YTDD.DL_VERSION
, YTDD.RECORD_TYPE
, YTDD.BATCH_ID
, YTDD.SCHOOL_CODE
, YTDD.STAT_END_DT
, YTDD.PROCESS_DT
, YTDD.LOAN_NUMBER
, YTDD.LOAN_BKD_DT
, YTDD.DISB_BKD_DT
, YTDD.DISB_GROSS
, YTDD.DISB_FEE
, YTDD.DISB_INT_REBATE
, YTDD.DISB_NET
, YTDD.DISB_NET_ADJ
, YTDD.DISB_NUM
, YTDD.DISB_SEQ_NUM
, YTDD.TRANS_TYPE
, YTDD.TRANS_DT
, YTDD.TOTAL_GROSS
, YTDD.TOTAL_FEE
, YTDD.TOTAL_INT_REBATE
, YTDD.TOTAL_NET
, YTDD.CREATED_BY
, YTDD.CREATION_DATE
, YTDD.LAST_UPDATED_BY
, YTDD.LAST_UPDATE_DATE
, YTDD.LAST_UPDATE_LOGIN
, YTDD.REQUEST_ID
, YTDD.PROGRAM_APPLICATION_ID
, YTDD.PROGRAM_ID
, YTDD.PROGRAM_UPDATE_DATE
, YTDD.REGION_CODE
, YTDD.STATE_CODE
, YTDD.REC_COUNT
FROM IGF_DB_YTD_DTL_ALL YTDD
WHERE NVL (YTDD.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)