VIEW: APPS.IGF_SL_RESP_DTLS_V

Source

View Text - Preformatted

SELECT CR.DOCUMENT_ID_TXT, CR.DOC_CREATED_DATE, CR.SOURCE_ENTITY_ID_TXT, CR.DEST_ENTITY_ID_TXT, CR.SOFT_PROVIDER, CR.SOFT_VERSION, CR.FULL_RESP_CODE, CR.RECEIPT_DATE, CR.DOC_TYPE_CODE, CR.DOC_STATUS_CODE, CR.PROCESS_DATE, RS.REP_SCHL_RESP_ID, RS.REP_ENTITY_ID_TXT, RS.RESP_CODE, ASH.ATD_SCHL_RESP_ID, ASH.ATD_ENTITY_ID_TXT, ASH.RESP_CODE, ST.STDNT_RESP_ID, ST.S_SSN, ST.FIRST_NAME, ST.S_LAST_NAME, ST.S_DATE_OF_BIRTH, ST.RESP_CODE, DI.DL_INFO_ID, DI.LOAN_KEY_NUM, DI.ORIG_FEE_PCT_NUM, DI.INT_REB_PCT_NUM, DI.PNOTE_PRINT_CODE, DI.DISCLOSURE_PRINT_CODE, DI.GRADE_LEVEL_CODE, DL.DL_LOAN_RESP_ID, DL.DL_LOAN_TYPE, DL.FIN_AWD_YR, DL.CPS_TRANS_NUM, DL.AWARD_AMT, DL.DEPNCY_STATUS, DL.DEFAULT_STATUS, DL.COD_AWARD_NUMBER_TXT, DL.LOAN_NUMBER_TXT, DL.AWARD_CREATE_DATE, DL.RESP_CODE, DL.B_RESP_CODE, DL.ELEC_MPN_FLAG, DL.PNOTE_MPN_ID, DL.MPN_STATUS_CODE, DL.MPN_LINK_FLAG, DL.PYMT_SERVICER_AMT, DL.PYMT_SERVICER_DATE, DL.BOOK_LOAN_AMT, DL.BOOK_LOAN_AMT_DATE, DL.ENDORSER_AMT, DL.CRDT_DECISION_STATUS, DL.CRDT_DECISION_DATE, DL.CRDT_DECISION_OVRD_CODE, CR.CREATED_BY, CR.CREATION_DATE, CR.LAST_UPDATED_BY, CR.LAST_UPDATE_DATE, CR.LAST_UPDATE_LOGIN, CR.PROGRAM_APPLICATION_ID, CR.PROGRAM_ID, CR.PROGRAM_UPDATE_DATE, CR.REQUEST_ID FROM IGF_SL_CR_RESP_DTLS CR, IGF_SL_AS_RESP_DTLS ASH, IGF_SL_RS_RESP_DTLS RS, IGF_SL_ST_RESP_DTLS ST, IGF_SL_DI_RESP_DTLS DI, IGF_SL_DL_RESP_DTLS DL WHERE CR.DOCUMENT_ID_TXT = RS.DOCUMENT_ID_TXT AND RS.REP_SCHL_RESP_ID = ASH.REP_SCHL_RESP_ID AND ASH.ATD_SCHL_RESP_ID = ST.ATD_SCHL_RESP_ID AND ST.STDNT_RESP_ID = DI.STDNT_RESP_ID AND ST.STDNT_RESP_ID = DL.STDNT_RESP_ID AND DI.LOAN_KEY_NUM = DL.LOAN_KEY_NUM UNION ALL SELECT CR.DOCUMENT_ID_TXT, CR.DOC_CREATED_DATE, CR.SOURCE_ENTITY_ID_TXT, CR.DEST_ENTITY_ID_TXT, CR.SOFT_PROVIDER, CR.SOFT_VERSION, CR.FULL_RESP_CODE, CR.RECEIPT_DATE, CR.DOC_TYPE_CODE, CR.DOC_STATUS_CODE, CR.PROCESS_DATE, RS.REP_SCHL_RESP_ID, RS.REP_ENTITY_ID_TXT, RS.RESP_CODE, ASH.ATD_SCHL_RESP_ID, ASH.ATD_ENTITY_ID_TXT, ASH.RESP_CODE, ST.STDNT_RESP_ID, ST.S_SSN, ST.FIRST_NAME, ST.S_LAST_NAME, ST.S_DATE_OF_BIRTH, ST.RESP_CODE, NULL DL_INFO_ID, NULL LOAN_KEY_NUM, NULL ORIG_FEE_PCT_NUM, NULL INT_REB_PCT_NUM, NULL PNOTE_PRINT_CODE, NULL DISCLOSURE_PRINT_CODE, NULL GRADE_LEVEL_CODE, DL.DL_LOAN_RESP_ID, DL.DL_LOAN_TYPE, DL.FIN_AWD_YR, DL.CPS_TRANS_NUM, DL.AWARD_AMT, DL.DEPNCY_STATUS, DL.DEFAULT_STATUS, DL.COD_AWARD_NUMBER_TXT, DL.LOAN_NUMBER_TXT, DL.AWARD_CREATE_DATE, DL.RESP_CODE, DL.B_RESP_CODE, DL.ELEC_MPN_FLAG, DL.PNOTE_MPN_ID, DL.MPN_STATUS_CODE, DL.MPN_LINK_FLAG, DL.PYMT_SERVICER_AMT, DL.PYMT_SERVICER_DATE, DL.BOOK_LOAN_AMT, DL.BOOK_LOAN_AMT_DATE, DL.ENDORSER_AMT, DL.CRDT_DECISION_STATUS, DL.CRDT_DECISION_DATE, DL.CRDT_DECISION_OVRD_CODE, CR.CREATED_BY, CR.CREATION_DATE, CR.LAST_UPDATED_BY, CR.LAST_UPDATE_DATE, CR.LAST_UPDATE_LOGIN, CR.PROGRAM_APPLICATION_ID, CR.PROGRAM_ID, CR.PROGRAM_UPDATE_DATE, CR.REQUEST_ID FROM IGF_SL_CR_RESP_DTLS CR, IGF_SL_AS_RESP_DTLS ASH, IGF_SL_RS_RESP_DTLS RS, IGF_SL_ST_RESP_DTLS ST, IGF_SL_DL_RESP_DTLS DL WHERE CR.DOCUMENT_ID_TXT = RS.DOCUMENT_ID_TXT AND RS.REP_SCHL_RESP_ID = ASH.REP_SCHL_RESP_ID AND ASH.ATD_SCHL_RESP_ID = ST.ATD_SCHL_RESP_ID AND ST.STDNT_RESP_ID = DL.STDNT_RESP_ID AND NOT EXISTS ( SELECT STDNT_RESP_ID FROM IGF_SL_DI_RESP_DTLS SLDI_2 WHERE SLDI_2.STDNT_RESP_ID = ST.STDNT_RESP_ID )

View Text - HTML Formatted

SELECT CR.DOCUMENT_ID_TXT
, CR.DOC_CREATED_DATE
, CR.SOURCE_ENTITY_ID_TXT
, CR.DEST_ENTITY_ID_TXT
, CR.SOFT_PROVIDER
, CR.SOFT_VERSION
, CR.FULL_RESP_CODE
, CR.RECEIPT_DATE
, CR.DOC_TYPE_CODE
, CR.DOC_STATUS_CODE
, CR.PROCESS_DATE
, RS.REP_SCHL_RESP_ID
, RS.REP_ENTITY_ID_TXT
, RS.RESP_CODE
, ASH.ATD_SCHL_RESP_ID
, ASH.ATD_ENTITY_ID_TXT
, ASH.RESP_CODE
, ST.STDNT_RESP_ID
, ST.S_SSN
, ST.FIRST_NAME
, ST.S_LAST_NAME
, ST.S_DATE_OF_BIRTH
, ST.RESP_CODE
, DI.DL_INFO_ID
, DI.LOAN_KEY_NUM
, DI.ORIG_FEE_PCT_NUM
, DI.INT_REB_PCT_NUM
, DI.PNOTE_PRINT_CODE
, DI.DISCLOSURE_PRINT_CODE
, DI.GRADE_LEVEL_CODE
, DL.DL_LOAN_RESP_ID
, DL.DL_LOAN_TYPE
, DL.FIN_AWD_YR
, DL.CPS_TRANS_NUM
, DL.AWARD_AMT
, DL.DEPNCY_STATUS
, DL.DEFAULT_STATUS
, DL.COD_AWARD_NUMBER_TXT
, DL.LOAN_NUMBER_TXT
, DL.AWARD_CREATE_DATE
, DL.RESP_CODE
, DL.B_RESP_CODE
, DL.ELEC_MPN_FLAG
, DL.PNOTE_MPN_ID
, DL.MPN_STATUS_CODE
, DL.MPN_LINK_FLAG
, DL.PYMT_SERVICER_AMT
, DL.PYMT_SERVICER_DATE
, DL.BOOK_LOAN_AMT
, DL.BOOK_LOAN_AMT_DATE
, DL.ENDORSER_AMT
, DL.CRDT_DECISION_STATUS
, DL.CRDT_DECISION_DATE
, DL.CRDT_DECISION_OVRD_CODE
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
, CR.PROGRAM_APPLICATION_ID
, CR.PROGRAM_ID
, CR.PROGRAM_UPDATE_DATE
, CR.REQUEST_ID
FROM IGF_SL_CR_RESP_DTLS CR
, IGF_SL_AS_RESP_DTLS ASH
, IGF_SL_RS_RESP_DTLS RS
, IGF_SL_ST_RESP_DTLS ST
, IGF_SL_DI_RESP_DTLS DI
, IGF_SL_DL_RESP_DTLS DL
WHERE CR.DOCUMENT_ID_TXT = RS.DOCUMENT_ID_TXT
AND RS.REP_SCHL_RESP_ID = ASH.REP_SCHL_RESP_ID
AND ASH.ATD_SCHL_RESP_ID = ST.ATD_SCHL_RESP_ID
AND ST.STDNT_RESP_ID = DI.STDNT_RESP_ID
AND ST.STDNT_RESP_ID = DL.STDNT_RESP_ID
AND DI.LOAN_KEY_NUM = DL.LOAN_KEY_NUM UNION ALL SELECT CR.DOCUMENT_ID_TXT
, CR.DOC_CREATED_DATE
, CR.SOURCE_ENTITY_ID_TXT
, CR.DEST_ENTITY_ID_TXT
, CR.SOFT_PROVIDER
, CR.SOFT_VERSION
, CR.FULL_RESP_CODE
, CR.RECEIPT_DATE
, CR.DOC_TYPE_CODE
, CR.DOC_STATUS_CODE
, CR.PROCESS_DATE
, RS.REP_SCHL_RESP_ID
, RS.REP_ENTITY_ID_TXT
, RS.RESP_CODE
, ASH.ATD_SCHL_RESP_ID
, ASH.ATD_ENTITY_ID_TXT
, ASH.RESP_CODE
, ST.STDNT_RESP_ID
, ST.S_SSN
, ST.FIRST_NAME
, ST.S_LAST_NAME
, ST.S_DATE_OF_BIRTH
, ST.RESP_CODE
, NULL DL_INFO_ID
, NULL LOAN_KEY_NUM
, NULL ORIG_FEE_PCT_NUM
, NULL INT_REB_PCT_NUM
, NULL PNOTE_PRINT_CODE
, NULL DISCLOSURE_PRINT_CODE
, NULL GRADE_LEVEL_CODE
, DL.DL_LOAN_RESP_ID
, DL.DL_LOAN_TYPE
, DL.FIN_AWD_YR
, DL.CPS_TRANS_NUM
, DL.AWARD_AMT
, DL.DEPNCY_STATUS
, DL.DEFAULT_STATUS
, DL.COD_AWARD_NUMBER_TXT
, DL.LOAN_NUMBER_TXT
, DL.AWARD_CREATE_DATE
, DL.RESP_CODE
, DL.B_RESP_CODE
, DL.ELEC_MPN_FLAG
, DL.PNOTE_MPN_ID
, DL.MPN_STATUS_CODE
, DL.MPN_LINK_FLAG
, DL.PYMT_SERVICER_AMT
, DL.PYMT_SERVICER_DATE
, DL.BOOK_LOAN_AMT
, DL.BOOK_LOAN_AMT_DATE
, DL.ENDORSER_AMT
, DL.CRDT_DECISION_STATUS
, DL.CRDT_DECISION_DATE
, DL.CRDT_DECISION_OVRD_CODE
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
, CR.PROGRAM_APPLICATION_ID
, CR.PROGRAM_ID
, CR.PROGRAM_UPDATE_DATE
, CR.REQUEST_ID
FROM IGF_SL_CR_RESP_DTLS CR
, IGF_SL_AS_RESP_DTLS ASH
, IGF_SL_RS_RESP_DTLS RS
, IGF_SL_ST_RESP_DTLS ST
, IGF_SL_DL_RESP_DTLS DL
WHERE CR.DOCUMENT_ID_TXT = RS.DOCUMENT_ID_TXT
AND RS.REP_SCHL_RESP_ID = ASH.REP_SCHL_RESP_ID
AND ASH.ATD_SCHL_RESP_ID = ST.ATD_SCHL_RESP_ID
AND ST.STDNT_RESP_ID = DL.STDNT_RESP_ID
AND NOT EXISTS ( SELECT STDNT_RESP_ID
FROM IGF_SL_DI_RESP_DTLS SLDI_2
WHERE SLDI_2.STDNT_RESP_ID = ST.STDNT_RESP_ID )