Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Financial Aid Direct Loan Promissory Note Responses |
Implementation/DBA Data: | APPS.IGFFV_DL_PROM_NOTE_RESPONSES |
SELECT PDETRESP.DISB_GROSS_AMT
, PNOTERESP.PNOTE_ACK_DATE
, PNOTERESP.PNOTE_BATCH_ID
, PNOTERESP.LOAN_NUMBER
, '_LA:PNOTERESP.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_PNOTE_STATUS:MEANING'
, '_LA:PNOTERESP.PNOTE_REJ_CODES:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_REJ_CODES:MEANING'
, PNOTERESP.MPN_IND
, PNOTERESP.PNOTE_ACCEPT_AMT
, '_LA:PNOTERESP.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_DL_RESP_STATUS:MEANING'
, PNOTERESP.ELEC_MPN_IND
, 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'
, BATCH.DBTH_ID
, PDETRESP.DLPDR_ID
, PDETRESP.DLPNR_ID
, PDETRESP.CREATED_BY
, PDETRESP.CREATION_DATE
, PDETRESP.LAST_UPDATED_BY
, PDETRESP.LAST_UPDATE_DATE
FROM IGF_SL_DL_PDET_RESP PDETRESP
, IGF_SL_DL_PNOTE_RESP_ALL PNOTERESP
, IGF_SL_DL_BATCH_ALL BATCH
WHERE PDETRESP.DLPNR_ID = PNOTERESP.DLPNR_ID
AND PNOTERESP.DBTH_ID = BATCH.DBTH_ID WITH READ ONLY