VIEW: APPS.IGFFV_FFELP_DISB_RESP_DETAILS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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