VIEW: APPS.IGF_GR_YTD_DISB

Source

View Text - Preformatted

SELECT GRYTDDB.ROWID ROW_ID ,GRYTDDB.YTDDS_ID ,GRYTDDB.ORIGINATION_ID ,GRYTDDB.INST_CROSS_REF_CODE ,GRYTDDB.ACTION_CODE ,GRYTDDB.DISB_REF_NUM ,GRYTDDB.DISB_ACCPT_AMT ,GRYTDDB.DB_CR_FLAG ,GRYTDDB.DISB_DT ,GRYTDDB.PYMT_PRD_START_DT ,GRYTDDB.DISB_BATCH_ID ,GRYTDDB.CREATED_BY ,GRYTDDB.CREATION_DATE ,GRYTDDB.LAST_UPDATED_BY ,GRYTDDB.LAST_UPDATE_DATE ,GRYTDDB.LAST_UPDATE_LOGIN ,GRYTDDB.REQUEST_ID ,GRYTDDB.PROGRAM_APPLICATION_ID ,GRYTDDB.PROGRAM_ID ,GRYTDDB.PROGRAM_UPDATE_DATE ,GRYTDDB.ORG_ID ,GRYTDDB.CI_CAL_TYPE ,GRYTDDB.CI_SEQUENCE_NUMBER ,GRYTDDB.STUDENT_NAME ,GRYTDDB.CURRENT_SSN_TXT ,GRYTDDB.STUDENT_BIRTH_DATE ,GRYTDDB.DISB_PROCESS_DATE ,GRYTDDB.ROUTING_ID_TXT ,GRYTDDB.FIN_AWARD_YEAR_NUM ,GRYTDDB.ATTEND_ENTITY_ID_TXT ,GRYTDDB.DISB_SEQ_NUM ,GRYTDDB.DISB_REL_IND ,GRYTDDB.PREV_DISB_SEQ_NUM FROM IGF_GR_YTD_DISB_ALL GRYTDDB WHERE NVL (GRYTDDB.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 GRYTDDB.ROWID ROW_ID
, GRYTDDB.YTDDS_ID
, GRYTDDB.ORIGINATION_ID
, GRYTDDB.INST_CROSS_REF_CODE
, GRYTDDB.ACTION_CODE
, GRYTDDB.DISB_REF_NUM
, GRYTDDB.DISB_ACCPT_AMT
, GRYTDDB.DB_CR_FLAG
, GRYTDDB.DISB_DT
, GRYTDDB.PYMT_PRD_START_DT
, GRYTDDB.DISB_BATCH_ID
, GRYTDDB.CREATED_BY
, GRYTDDB.CREATION_DATE
, GRYTDDB.LAST_UPDATED_BY
, GRYTDDB.LAST_UPDATE_DATE
, GRYTDDB.LAST_UPDATE_LOGIN
, GRYTDDB.REQUEST_ID
, GRYTDDB.PROGRAM_APPLICATION_ID
, GRYTDDB.PROGRAM_ID
, GRYTDDB.PROGRAM_UPDATE_DATE
, GRYTDDB.ORG_ID
, GRYTDDB.CI_CAL_TYPE
, GRYTDDB.CI_SEQUENCE_NUMBER
, GRYTDDB.STUDENT_NAME
, GRYTDDB.CURRENT_SSN_TXT
, GRYTDDB.STUDENT_BIRTH_DATE
, GRYTDDB.DISB_PROCESS_DATE
, GRYTDDB.ROUTING_ID_TXT
, GRYTDDB.FIN_AWARD_YEAR_NUM
, GRYTDDB.ATTEND_ENTITY_ID_TXT
, GRYTDDB.DISB_SEQ_NUM
, GRYTDDB.DISB_REL_IND
, GRYTDDB.PREV_DISB_SEQ_NUM
FROM IGF_GR_YTD_DISB_ALL GRYTDDB
WHERE NVL (GRYTDDB.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)