VIEW: APPS.IGF_DB_YTD_DTL

Source

View Text - Preformatted

SELECT YTDD.ROWID, YTDD.YTDD_ID, YTDD.DL_VERSION, YTDD.RECORD_TYPE, YTDD.BATCH_ID, YTDD.SCHOOL_CODE, YTDD.STAT_END_DT, YTDD.PROCESS_DT, YTDD.LOAN_NUMBER, YTDD.LOAN_BKD_DT, YTDD.DISB_BKD_DT, YTDD.DISB_GROSS, YTDD.DISB_FEE, YTDD.DISB_INT_REBATE, YTDD.DISB_NET, YTDD.DISB_NET_ADJ, YTDD.DISB_NUM, YTDD.DISB_SEQ_NUM, YTDD.TRANS_TYPE, YTDD.TRANS_DT, YTDD.TOTAL_GROSS, YTDD.TOTAL_FEE, YTDD.TOTAL_INT_REBATE, YTDD.TOTAL_NET, YTDD.CREATED_BY, YTDD.CREATION_DATE, YTDD.LAST_UPDATED_BY, YTDD.LAST_UPDATE_DATE, YTDD.LAST_UPDATE_LOGIN, YTDD.REQUEST_ID , YTDD.PROGRAM_APPLICATION_ID, YTDD.PROGRAM_ID, YTDD.PROGRAM_UPDATE_DATE, YTDD.REGION_CODE, YTDD.STATE_CODE, YTDD.REC_COUNT FROM IGF_DB_YTD_DTL_ALL YTDD WHERE NVL (YTDD.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 YTDD.ROWID
, YTDD.YTDD_ID
, YTDD.DL_VERSION
, YTDD.RECORD_TYPE
, YTDD.BATCH_ID
, YTDD.SCHOOL_CODE
, YTDD.STAT_END_DT
, YTDD.PROCESS_DT
, YTDD.LOAN_NUMBER
, YTDD.LOAN_BKD_DT
, YTDD.DISB_BKD_DT
, YTDD.DISB_GROSS
, YTDD.DISB_FEE
, YTDD.DISB_INT_REBATE
, YTDD.DISB_NET
, YTDD.DISB_NET_ADJ
, YTDD.DISB_NUM
, YTDD.DISB_SEQ_NUM
, YTDD.TRANS_TYPE
, YTDD.TRANS_DT
, YTDD.TOTAL_GROSS
, YTDD.TOTAL_FEE
, YTDD.TOTAL_INT_REBATE
, YTDD.TOTAL_NET
, YTDD.CREATED_BY
, YTDD.CREATION_DATE
, YTDD.LAST_UPDATED_BY
, YTDD.LAST_UPDATE_DATE
, YTDD.LAST_UPDATE_LOGIN
, YTDD.REQUEST_ID
, YTDD.PROGRAM_APPLICATION_ID
, YTDD.PROGRAM_ID
, YTDD.PROGRAM_UPDATE_DATE
, YTDD.REGION_CODE
, YTDD.STATE_CODE
, YTDD.REC_COUNT
FROM IGF_DB_YTD_DTL_ALL YTDD
WHERE NVL (YTDD.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)