Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_GR_RFMS |
SELECT RFMS.ROWID
, RFMS.ORIGINATION_ID
, RFMS.CI_CAL_TYPE
, RFMS.CI_SEQUENCE_NUMBER
, RFMS.BASE_ID
, RFMS.AWARD_ID
, RFMS.RFMB_ID
, RFMS.SYS_ORIG_SSN
, RFMS.SYS_ORIG_NAME_CD
, RFMS.TRANSACTION_NUM
, RFMS.EFC
, RFMS.VER_STATUS_CODE
, RFMS.SECONDARY_EFC
, RFMS.SECONDARY_EFC_CD
, RFMS.PELL_AMOUNT
, NULL
, RFMS.ENROLLMENT_STATUS
, RFMS.ENROLLMENT_DT
, RFMS.COA_AMOUNT
, RFMS.ACADEMIC_CALENDAR
, RFMS.PAYMENT_METHOD
, RFMS.TOTAL_PYMT_PRDS
, RFMS.INCRCD_FED_PELL_RCP_CD
, RFMS.ATTENDING_CAMPUS_ID
, RFMS.EST_DISB_DT1
, RFMS.ORIG_ACTION_CODE
, RFMS.ORIG_STATUS_DT
, RFMS.ORIG_ED_USE_FLAGS
, RFMS.FT_PELL_AMOUNT
, RFMS.PREV_ACCPT_EFC
, RFMS.PREV_ACCPT_TRAN_NO
, RFMS.PREV_ACCPT_SEC_EFC_CD
, RFMS.PREV_ACCPT_COA
, RFMS.ORIG_REJECT_CODE
, RFMS.WK_INST_TIME_CALC_PYMT
, RFMS.WK_INT_TIME_PRG_DEF_YR
, RFMS.CR_CLK_HRS_PRDS_SCH_YR
, RFMS.CR_CLK_HRS_ACAD_YR
, RFMS.INST_CROSS_REF_CD
, RFMS.LOW_TUTION_FEE
, RFMS.REC_SOURCE
, RFMS.PENDING_AMOUNT
, RFMS.CREATED_BY
, RFMS.CREATION_DATE
, RFMS.LAST_UPDATED_BY
, RFMS.LAST_UPDATE_DATE
, RFMS.LAST_UPDATE_LOGIN
, RFMS.PROGRAM_APPLICATION_ID
, RFMS.PROGRAM_ID
, RFMS.PROGRAM_UPDATE_DATE
, RFMS.REQUEST_ID
, RFMS.BIRTH_DT
, RFMS.FIRST_NAME
, RFMS.MIDDLE_NAME
, RFMS.LAST_NAME
, RFMS.CURRENT_SSN
, RFMS.LEGACY_RECORD_FLAG
, RFMS.REPORTING_PELL_CD
, RFMS.DOCUMENT_ID_TXT
, RFMS.REP_ENTITY_ID_TXT
, RFMS.ATD_ENTITY_ID_TXT
, RFMS.NOTE_MESSAGE
, RFMS.FULL_RESP_CODE
FROM IGF_GR_RFMS_ALL RFMS
WHERE NVL (RFMS.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)