Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Financial Aid Direct Loan Origination Changes |
Implementation/DBA Data: | APPS.IGFFV_DL_ORIGINATION_CHANGES |
SELECT CHG.LOAN_NUMBER
, CHG.CHG_CODE
, CHG.NEW_VALUE
, '_LA:CHG.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_CHG_STATUS:MEANING'
, BATCH.BATCH_ID
, BATCH.BTH_CREATION_DATE
, '_LA:BATCH.BATCH_REJ_CODE:IGF_LOOKUPS_VIEW:IGF_SL_DL_BATCH_REJ:MEANING'
, BATCH.BATCH_TYPE
, BATCH.SEND_RESP
, '_LA:BATCH.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_BATCH_STATUS:MEANING'
, CHG.DBTH_ID
, CHG.CHG_NUM
, CHG.CREATED_BY
, CHG.CREATION_DATE
, CHG.LAST_UPDATED_BY
, CHG.LAST_UPDATE_DATE
FROM IGF_SL_DL_CHG_SEND_ALL CHG
, IGF_SL_DL_BATCH_ALL BATCH
WHERE CHG.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY