Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds FFELP Disbursement Response Details |
Implementation/DBA Data: | APPS.IGFFV_FFELP_DISB_RESP_DETAILS |
SELECT RESP8.DISB_DATE
, RESP8.DISB_GROSS_AMT
, RESP8.ORIG_FEE
, RESP8.GUARANTEE_FEE
, RESP8.ORIG_FEE_PAID
, RESP8.GUARNT_FEE_PAID
, RESP8.NET_DISB_AMT
, '_LA:RESP8.DISB_HOLD_REL_IND:IGF_LOOKUPS_VIEW:IGF_SL_CL_DB_HOLD_REL_IND:MEANING'
, '_LA:RESP8.DISB_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CL_DISB_STATUS:MEANING'
, RESP8.RESP_RECORD_STATUS
, RESP1.LOAN_NUMBER
, RESP1.B_FIRST_NAME
, RESP1.B_LAST_NAME
, RESP1.B_MIDDLE_NAME
, RESP1.B_SSN
, RESP8.CLRP1_ID
, RESP8.CLRP8_ID
, RESP8.CREATED_BY
, RESP8.CREATION_DATE
, RESP8.LAST_UPDATED_BY
, RESP8.LAST_UPDATE_DATE
FROM IGF_SL_CL_RESP_R8_ALL RESP8
, IGF_SL_CL_RESP_R1_ALL RESP1
WHERE RESP1.CLRP1_ID = RESP8.CLRP1_ID WITH READ ONLY