View: IGF_GR_RESP_DTLS_V

Product:	IGF - Financial Aid
Description:	View for Pell response details
Implementation/DBA Data:	APPS.IGF_GR_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
, 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

Columns