FND Design Data [Home] [Help]

View: IGFFV_DL_PROM_NOTE_RESPONSES

Product: IGF - Financial Aid
Description: Full View for the Entity that holds Financial Aid Direct Loan Promissory Note Responses
Implementation/DBA Data: ViewAPPS.IGFFV_DL_PROM_NOTE_RESPONSES
View Text

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

Columns

Name
DISBURSEMENT_GROSS_AMOUNT
PROM_NOTE_ACK_DATE
PROM_NOTE_BATCH_ID
LOAN_NUMBER
"_LA:PROM_NOTE_STATUS"
"_LA:PNOTE_REJECTION_REASONS"
MASTER_PROM_NOTE_INDICATOR
PROM_NOTE_ACCEPTED_AMOUNT
"_LA:RECORD_STATUS"
ELEC_MPN_INDICATOR
BATCH_FILE_ID
BATCH_FILE_CREATION_DATE
"_LA:BATCH_REJECTION_CODE"
BATCH_TYPE
BATCH_FILE_TYPE
"_LA:BATCH_STATUS"
BATCH_ID
DISBURSEMENT_NUMBER
RESPONSE_RECORD_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE