VIEW: APPS.IGF_DB_DL_DISB_RESP

Source

View Text - Preformatted

SELECT DLRESP.ROWID ROW_ID ,DLRESP.DDRP_ID ,DLRESP.DBTH_ID ,DLRESP.LOAN_NUMBER ,DLRESP.DISB_NUM ,DLRESP.DISB_ACTIVITY ,DLRESP.TRANSACTION_DATE ,DLRESP.DISB_SEQ_NUM ,DLRESP.DISB_GROSS_AMT ,DLRESP.FEE_1 ,DLRESP.DISB_NET_AMT ,DLRESP.INT_REBATE_AMT ,DLRESP.USER_IDENT ,DLRESP.DISB_BATCH_ID ,DLRESP.SCHOOL_ID ,DLRESP.SCH_CODE_STATUS ,DLRESP.LOAN_NUM_STATUS ,DLRESP.DISB_NUM_STATUS ,DLRESP.DISB_ACTIVITY_STATUS ,DLRESP.TRANS_DATE_STATUS ,DLRESP.DISB_SEQ_NUM_STATUS ,DLRESP.LOC_DISB_GROSS_AMT ,DLRESP.LOC_FEE_1 ,DLRESP.LOC_DISB_NET_AMT ,DLRESP.SERVICER_REFUND_AMT ,DLRESP.LOC_INT_REBATE_AMT ,DLRESP.LOC_NET_BOOKED_LOAN ,DLRESP.ACK_DATE ,DLRESP.AFFIRM_FLAG ,DLRESP.STATUS ,DLRESP.CREATED_BY ,DLRESP.CREATION_DATE ,DLRESP.LAST_UPDATED_BY ,DLRESP.LAST_UPDATE_DATE ,DLRESP.LAST_UPDATE_LOGIN ,DLRESP.REQUEST_ID ,DLRESP.PROGRAM_APPLICATION_ID ,DLRESP.PROGRAM_ID ,DLRESP.PROGRAM_UPDATE_DATE ,DLRESP.ORG_ID FROM IGF_DB_DL_DISB_RESP_ALL DLRESP WHERE NVL (DLRESP.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 DLRESP.ROWID ROW_ID
, DLRESP.DDRP_ID
, DLRESP.DBTH_ID
, DLRESP.LOAN_NUMBER
, DLRESP.DISB_NUM
, DLRESP.DISB_ACTIVITY
, DLRESP.TRANSACTION_DATE
, DLRESP.DISB_SEQ_NUM
, DLRESP.DISB_GROSS_AMT
, DLRESP.FEE_1
, DLRESP.DISB_NET_AMT
, DLRESP.INT_REBATE_AMT
, DLRESP.USER_IDENT
, DLRESP.DISB_BATCH_ID
, DLRESP.SCHOOL_ID
, DLRESP.SCH_CODE_STATUS
, DLRESP.LOAN_NUM_STATUS
, DLRESP.DISB_NUM_STATUS
, DLRESP.DISB_ACTIVITY_STATUS
, DLRESP.TRANS_DATE_STATUS
, DLRESP.DISB_SEQ_NUM_STATUS
, DLRESP.LOC_DISB_GROSS_AMT
, DLRESP.LOC_FEE_1
, DLRESP.LOC_DISB_NET_AMT
, DLRESP.SERVICER_REFUND_AMT
, DLRESP.LOC_INT_REBATE_AMT
, DLRESP.LOC_NET_BOOKED_LOAN
, DLRESP.ACK_DATE
, DLRESP.AFFIRM_FLAG
, DLRESP.STATUS
, DLRESP.CREATED_BY
, DLRESP.CREATION_DATE
, DLRESP.LAST_UPDATED_BY
, DLRESP.LAST_UPDATE_DATE
, DLRESP.LAST_UPDATE_LOGIN
, DLRESP.REQUEST_ID
, DLRESP.PROGRAM_APPLICATION_ID
, DLRESP.PROGRAM_ID
, DLRESP.PROGRAM_UPDATE_DATE
, DLRESP.ORG_ID
FROM IGF_DB_DL_DISB_RESP_ALL DLRESP
WHERE NVL (DLRESP.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)