VIEW: APPS.IGF_SL_DL_LOR_RESP

Source

View Text - Preformatted

SELECT DLLORRESP.ROWID ROW_ID ,DLLORRESP.LOR_RESP_NUM ,DLLORRESP.DBTH_ID ,DLLORRESP.ORIG_BATCH_ID ,DLLORRESP.LOAN_NUMBER ,DLLORRESP.ORIG_ACK_DATE ,DLLORRESP.ORIG_STATUS_FLAG ,DLLORRESP.ORIG_REJECT_REASONS ,DLLORRESP.PNOTE_STATUS ,DLLORRESP.PNOTE_ID ,DLLORRESP.PNOTE_ACCEPT_AMT ,DLLORRESP.LOAN_AMOUNT_ACCEPTED ,DLLORRESP.STATUS ,DLLORRESP.CREATED_BY ,DLLORRESP.CREATION_DATE ,DLLORRESP.LAST_UPDATED_BY ,DLLORRESP.LAST_UPDATE_DATE ,DLLORRESP.LAST_UPDATE_LOGIN ,DLLORRESP.REQUEST_ID ,DLLORRESP.PROGRAM_APPLICATION_ID ,DLLORRESP.PROGRAM_ID ,DLLORRESP.PROGRAM_UPDATE_DATE ,DLLORRESP.ORG_ID ,DLLORRESP.elec_mpn_ind FROM IGF_SL_DL_LOR_RESP_ALL DLLORRESP WHERE NVL (DLLORRESP.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 DLLORRESP.ROWID ROW_ID
, DLLORRESP.LOR_RESP_NUM
, DLLORRESP.DBTH_ID
, DLLORRESP.ORIG_BATCH_ID
, DLLORRESP.LOAN_NUMBER
, DLLORRESP.ORIG_ACK_DATE
, DLLORRESP.ORIG_STATUS_FLAG
, DLLORRESP.ORIG_REJECT_REASONS
, DLLORRESP.PNOTE_STATUS
, DLLORRESP.PNOTE_ID
, DLLORRESP.PNOTE_ACCEPT_AMT
, DLLORRESP.LOAN_AMOUNT_ACCEPTED
, DLLORRESP.STATUS
, DLLORRESP.CREATED_BY
, DLLORRESP.CREATION_DATE
, DLLORRESP.LAST_UPDATED_BY
, DLLORRESP.LAST_UPDATE_DATE
, DLLORRESP.LAST_UPDATE_LOGIN
, DLLORRESP.REQUEST_ID
, DLLORRESP.PROGRAM_APPLICATION_ID
, DLLORRESP.PROGRAM_ID
, DLLORRESP.PROGRAM_UPDATE_DATE
, DLLORRESP.ORG_ID
, DLLORRESP.ELEC_MPN_IND
FROM IGF_SL_DL_LOR_RESP_ALL DLLORRESP
WHERE NVL (DLLORRESP.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)