VIEW: APPS.IGF_GR_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, AST.ATD_SCHL_RESP_ID, AST.ATD_ENTITY_ID_TXT, AST.RESP_CODE, ST.STDNT_RESP_ID, ST.S_SSN, ST.FIRST_NAME, ST.S_LAST_NAME, ST.S_DATE_OF_BIRTH, ST.RESP_CODE, GR.PELL_RESP_ID, GR.FIN_AWD_YR, GR.CPS_TRANS_NUM, GR.AWARD_AMT, GR.NOTE_MESSAGE, GR.COA_AMT, GR.LOW_TUTION_FEE, GR.INCARC_FLAG, GR.VER_STATUS_CODE, GR.ENROLLMENT_DATE, GR.SEC_EFC_CODE, GR.YTD_DISB_AMT, GR.TOT_ELIG_USED, GR.SCHD_PELL_AMT, GR.NEG_PEND_AMT, GR.FSA_CODE_1, GR.FSA_CODE_2, GR.FSA_CODE_3, GR.CPS_VERIF_FLAG, GR.HIGH_CPS_TRANS_NUM, GR.RESP_CODE FROM IGF_SL_CR_RESP_DTLS CR, IGF_SL_AS_RESP_DTLS AST, IGF_SL_RS_RESP_DTLS RS, IGF_SL_ST_RESP_DTLS ST, IGF_GR_RESP_DTLS GR WHERE CR.DOCUMENT_ID_TXT = RS.DOCUMENT_ID_TXT AND RS.REP_SCHL_RESP_ID = AST.REP_SCHL_RESP_ID AND AST.ATD_SCHL_RESP_ID = ST.ATD_SCHL_RESP_ID AND GR.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
, AST.ATD_SCHL_RESP_ID
, AST.ATD_ENTITY_ID_TXT
, AST.RESP_CODE
, ST.STDNT_RESP_ID
, ST.S_SSN
, ST.FIRST_NAME
, ST.S_LAST_NAME
, ST.S_DATE_OF_BIRTH
, ST.RESP_CODE
, GR.PELL_RESP_ID
, GR.FIN_AWD_YR
, GR.CPS_TRANS_NUM
, GR.AWARD_AMT
, GR.NOTE_MESSAGE
, GR.COA_AMT
, GR.LOW_TUTION_FEE
, GR.INCARC_FLAG
, GR.VER_STATUS_CODE
, GR.ENROLLMENT_DATE
, GR.SEC_EFC_CODE
, GR.YTD_DISB_AMT
, GR.TOT_ELIG_USED
, GR.SCHD_PELL_AMT
, GR.NEG_PEND_AMT
, GR.FSA_CODE_1
, GR.FSA_CODE_2
, GR.FSA_CODE_3
, GR.CPS_VERIF_FLAG
, GR.HIGH_CPS_TRANS_NUM
, GR.RESP_CODE
FROM IGF_SL_CR_RESP_DTLS CR
, IGF_SL_AS_RESP_DTLS AST
, IGF_SL_RS_RESP_DTLS RS
, IGF_SL_ST_RESP_DTLS ST
, IGF_GR_RESP_DTLS GR
WHERE CR.DOCUMENT_ID_TXT = RS.DOCUMENT_ID_TXT
AND RS.REP_SCHL_RESP_ID = AST.REP_SCHL_RESP_ID
AND AST.ATD_SCHL_RESP_ID = ST.ATD_SCHL_RESP_ID
AND GR.STDNT_RESP_ID = ST.STDNT_RESP_ID