VIEW: APPS.IGF_GR_YTD_ORIG

Source

View Text - Preformatted

SELECT GRYTDORG.ROWID ROW_ID ,GRYTDORG.YTDOR_ID ,GRYTDORG.ORIGINATION_ID ,GRYTDORG.ORIGINAL_SSN ,GRYTDORG.ORIGINAL_NAME_CD ,GRYTDORG.ATTEND_PELL_ID ,GRYTDORG.ED_USE ,GRYTDORG.INST_CROSS_REF_CODE ,GRYTDORG.ACTION_CODE ,GRYTDORG.ACCPT_AWD_AMT ,GRYTDORG.ACCPT_DISB_DT1 ,GRYTDORG.ACCPT_DISB_DT2 ,GRYTDORG.ACCPT_DISB_DT3 ,GRYTDORG.ACCPT_DISB_DT4 ,GRYTDORG.ACCPT_DISB_DT5 ,GRYTDORG.ACCPT_DISB_DT6 ,GRYTDORG.ACCPT_DISB_DT7 ,GRYTDORG.ACCPT_DISB_DT8 ,GRYTDORG.ACCPT_DISB_DT9 ,GRYTDORG.ACCPT_DISB_DT10 ,GRYTDORG.ACCPT_DISB_DT11 ,GRYTDORG.ACCPT_DISB_DT12 ,GRYTDORG.ACCPT_DISB_DT13 ,GRYTDORG.ACCPT_DISB_DT14 ,GRYTDORG.ACCPT_DISB_DT15 ,GRYTDORG.ACCPT_ENRL_DT ,GRYTDORG.ACCPT_LOW_TUT_FLG ,GRYTDORG.ACCPT_VER_STAT_FLG ,GRYTDORG.ACCPT_INCR_PELL_CD ,GRYTDORG.ACCPT_TRAN_NUM ,GRYTDORG.ACCPT_EFC ,GRYTDORG.ACCPT_SEC_EFC ,GRYTDORG.ACCPT_ACAD_CAL ,GRYTDORG.ACCPT_PYMT_METHOD ,GRYTDORG.ACCPT_COA ,GRYTDORG.ACCPT_ENRL_STAT ,GRYTDORG.ACCPT_WKS_INST_PYMT ,GRYTDORG.WK_INST_TIME_CALC_PYMT ,GRYTDORG.ACCPT_WKS_ACAD ,GRYTDORG.ACCPT_CR_ACAD_YR ,GRYTDORG.INST_SEQ_NUM ,GRYTDORG.SCH_FULL_TIME_PELL ,GRYTDORG.STUD_NAME ,GRYTDORG.SSN ,GRYTDORG.STUD_DOB ,GRYTDORG.CPS_VER_SEL_CD ,GRYTDORG.YTD_DISB_AMT ,GRYTDORG.BATCH_ID ,GRYTDORG.PROCESS_DATE ,GRYTDORG.CREATED_BY ,GRYTDORG.CREATION_DATE ,GRYTDORG.LAST_UPDATED_BY ,GRYTDORG.LAST_UPDATE_DATE ,GRYTDORG.LAST_UPDATE_LOGIN ,GRYTDORG.REQUEST_ID ,GRYTDORG.PROGRAM_APPLICATION_ID ,GRYTDORG.PROGRAM_ID ,GRYTDORG.PROGRAM_UPDATE_DATE ,GRYTDORG.ORG_ID ,GRYTDORG.CI_CAL_TYPE ,GRYTDORG.CI_SEQUENCE_NUMBER FROM IGF_GR_YTD_ORIG_ALL GRYTDORG WHERE NVL ( GRYTDORG.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)

View Text - HTML Formatted

SELECT GRYTDORG.ROWID ROW_ID
, GRYTDORG.YTDOR_ID
, GRYTDORG.ORIGINATION_ID
, GRYTDORG.ORIGINAL_SSN
, GRYTDORG.ORIGINAL_NAME_CD
, GRYTDORG.ATTEND_PELL_ID
, GRYTDORG.ED_USE
, GRYTDORG.INST_CROSS_REF_CODE
, GRYTDORG.ACTION_CODE
, GRYTDORG.ACCPT_AWD_AMT
, GRYTDORG.ACCPT_DISB_DT1
, GRYTDORG.ACCPT_DISB_DT2
, GRYTDORG.ACCPT_DISB_DT3
, GRYTDORG.ACCPT_DISB_DT4
, GRYTDORG.ACCPT_DISB_DT5
, GRYTDORG.ACCPT_DISB_DT6
, GRYTDORG.ACCPT_DISB_DT7
, GRYTDORG.ACCPT_DISB_DT8
, GRYTDORG.ACCPT_DISB_DT9
, GRYTDORG.ACCPT_DISB_DT10
, GRYTDORG.ACCPT_DISB_DT11
, GRYTDORG.ACCPT_DISB_DT12
, GRYTDORG.ACCPT_DISB_DT13
, GRYTDORG.ACCPT_DISB_DT14
, GRYTDORG.ACCPT_DISB_DT15
, GRYTDORG.ACCPT_ENRL_DT
, GRYTDORG.ACCPT_LOW_TUT_FLG
, GRYTDORG.ACCPT_VER_STAT_FLG
, GRYTDORG.ACCPT_INCR_PELL_CD
, GRYTDORG.ACCPT_TRAN_NUM
, GRYTDORG.ACCPT_EFC
, GRYTDORG.ACCPT_SEC_EFC
, GRYTDORG.ACCPT_ACAD_CAL
, GRYTDORG.ACCPT_PYMT_METHOD
, GRYTDORG.ACCPT_COA
, GRYTDORG.ACCPT_ENRL_STAT
, GRYTDORG.ACCPT_WKS_INST_PYMT
, GRYTDORG.WK_INST_TIME_CALC_PYMT
, GRYTDORG.ACCPT_WKS_ACAD
, GRYTDORG.ACCPT_CR_ACAD_YR
, GRYTDORG.INST_SEQ_NUM
, GRYTDORG.SCH_FULL_TIME_PELL
, GRYTDORG.STUD_NAME
, GRYTDORG.SSN
, GRYTDORG.STUD_DOB
, GRYTDORG.CPS_VER_SEL_CD
, GRYTDORG.YTD_DISB_AMT
, GRYTDORG.BATCH_ID
, GRYTDORG.PROCESS_DATE
, GRYTDORG.CREATED_BY
, GRYTDORG.CREATION_DATE
, GRYTDORG.LAST_UPDATED_BY
, GRYTDORG.LAST_UPDATE_DATE
, GRYTDORG.LAST_UPDATE_LOGIN
, GRYTDORG.REQUEST_ID
, GRYTDORG.PROGRAM_APPLICATION_ID
, GRYTDORG.PROGRAM_ID
, GRYTDORG.PROGRAM_UPDATE_DATE
, GRYTDORG.ORG_ID
, GRYTDORG.CI_CAL_TYPE
, GRYTDORG.CI_SEQUENCE_NUMBER
FROM IGF_GR_YTD_ORIG_ALL GRYTDORG
WHERE NVL ( GRYTDORG.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)