View: IGF_SL_RESP_DTLS_V

Product:	IGF - Financial Aid
Description:	View containing the response details for all the XML Documents received for the Direct Loans
Implementation/DBA Data:	APPS.IGF_SL_RESP_DTLS_V

View Text

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 )

Columns