Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_MRR |
SELECT GRMRR.ROWID ROW_ID
, GRMRR.MRR_ID
, GRMRR.RECORD_TYPE
, GRMRR.REQ_INST_PELL_ID
, GRMRR.MRR_CODE1
, GRMRR.MRR_CODE2
, GRMRR.MR_STUD_ID
, GRMRR.MR_INST_PELL_ID
, GRMRR.STUD_ORIG_SSN
, GRMRR.ORIG_NAME_CD
, GRMRR.INST_PELL_ID
, GRMRR.INST_NAME
, GRMRR.INST_ADDR1
, GRMRR.INST_ADDR2
, GRMRR.INST_CITY
, GRMRR.INST_STATE
, GRMRR.ZIP_CODE
, GRMRR.FAA_NAME
, GRMRR.FAA_TEL
, GRMRR.FAA_FAX
, GRMRR.FAA_INTERNET_ADDR
, GRMRR.SCHD_PELL_GRANT
, GRMRR.ORIG_AWD_AMT
, GRMRR.TRAN_NUM
, GRMRR.EFC
, GRMRR.ENRL_DT
, GRMRR.ORIG_CREATION_DT
, GRMRR.DISB_ACCEPTED_AMT
, GRMRR.LAST_ACTIVE_DT
, GRMRR.NEXT_EST_DISB_DT
, GRMRR.ELIGIBILITY_USED
, GRMRR.ED_USE_FLAGS
, GRMRR.STUD_LAST_NAME
, GRMRR.STUD_FIRST_NAME
, GRMRR.STUD_MIDDLE_NAME
, GRMRR.STUD_DOB
, GRMRR.CREATED_BY
, GRMRR.CREATION_DATE
, GRMRR.LAST_UPDATED_BY
, GRMRR.LAST_UPDATE_DATE
, GRMRR.LAST_UPDATE_LOGIN
, GRMRR.REQUEST_ID
, GRMRR.PROGRAM_APPLICATION_ID
, GRMRR.PROGRAM_ID
, GRMRR.PROGRAM_UPDATE_DATE
, GRMRR.ORG_ID
, GRMRR.CURRENT_SSN
FROM IGF_GR_MRR_ALL GRMRR
WHERE NVL (GRMRR.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)