VIEW: APPS.IGFFV_PELL_MULT_REPORT_RECORDS

Source

View Text - Preformatted

SELECT GMRR.RECORD_TYPE, GMRR.MRR_CODE1, GMRR.MRR_CODE2, GMRR.MR_STUD_ID, GMRR.MR_INST_PELL_ID, GMRR.STUD_ORIG_SSN, GMRR.ORIG_NAME_CD, GMRR.INST_PELL_ID, GMRR.INST_NAME, GMRR.INST_ADDR1, GMRR.INST_ADDR2, GMRR.INST_CITY, GMRR.INST_STATE, GMRR.ZIP_CODE, GMRR.FAA_NAME, GMRR.FAA_TEL, GMRR.FAA_FAX, GMRR.FAA_INTERNET_ADDR, GMRR.SCHD_PELL_GRANT, GMRR.ORIG_AWD_AMT, GMRR.TRAN_NUM, GMRR.EFC, GMRR.ENRL_DT, GMRR.ORIG_CREATION_DT, GMRR.DISB_ACCEPTED_AMT, GMRR.LAST_ACTIVE_DT, GMRR.NEXT_EST_DISB_DT, GMRR.ELIGIBILITY_USED, GMRR.ED_USE_FLAGS, GMRR.STUD_LAST_NAME, GMRR.STUD_FIRST_NAME, GMRR.STUD_MIDDLE_NAME, GMRR.STUD_DOB, GMRR.REQ_INST_PELL_ID, GMRR.MRR_ID, GMRR.CREATED_BY, GMRR.CREATION_DATE, GMRR.LAST_UPDATED_BY, GMRR.LAST_UPDATE_DATE FROM IGF_GR_MRR_ALL GMRR WITH READ ONLY

View Text - HTML Formatted

SELECT GMRR.RECORD_TYPE
, GMRR.MRR_CODE1
, GMRR.MRR_CODE2
, GMRR.MR_STUD_ID
, GMRR.MR_INST_PELL_ID
, GMRR.STUD_ORIG_SSN
, GMRR.ORIG_NAME_CD
, GMRR.INST_PELL_ID
, GMRR.INST_NAME
, GMRR.INST_ADDR1
, GMRR.INST_ADDR2
, GMRR.INST_CITY
, GMRR.INST_STATE
, GMRR.ZIP_CODE
, GMRR.FAA_NAME
, GMRR.FAA_TEL
, GMRR.FAA_FAX
, GMRR.FAA_INTERNET_ADDR
, GMRR.SCHD_PELL_GRANT
, GMRR.ORIG_AWD_AMT
, GMRR.TRAN_NUM
, GMRR.EFC
, GMRR.ENRL_DT
, GMRR.ORIG_CREATION_DT
, GMRR.DISB_ACCEPTED_AMT
, GMRR.LAST_ACTIVE_DT
, GMRR.NEXT_EST_DISB_DT
, GMRR.ELIGIBILITY_USED
, GMRR.ED_USE_FLAGS
, GMRR.STUD_LAST_NAME
, GMRR.STUD_FIRST_NAME
, GMRR.STUD_MIDDLE_NAME
, GMRR.STUD_DOB
, GMRR.REQ_INST_PELL_ID
, GMRR.MRR_ID
, GMRR.CREATED_BY
, GMRR.CREATION_DATE
, GMRR.LAST_UPDATED_BY
, GMRR.LAST_UPDATE_DATE
FROM IGF_GR_MRR_ALL GMRR WITH READ ONLY