VIEW: APPS.IGF_SL_DL_LOR_CRRESP

Source

View Text - Preformatted

SELECT DLLORCRR.ROWID, DLLORCRR.LOR_RESP_NUM , DLLORCRR.DBTH_ID , DLLORCRR.LOAN_NUMBER , DLLORCRR.CREDIT_OVERRIDE , DLLORCRR.CREDIT_DECISION_DATE , DLLORCRR.STATUS , DLLORCRR.CREATED_BY , DLLORCRR.CREATION_DATE , DLLORCRR.LAST_UPDATED_BY , DLLORCRR.LAST_UPDATE_DATE , DLLORCRR.LAST_UPDATE_LOGIN , DLLORCRR.REQUEST_ID , DLLORCRR.PROGRAM_APPLICATION_ID , DLLORCRR.PROGRAM_ID , DLLORCRR.PROGRAM_UPDATE_DATE , DLLORCRR.ORG_ID, DLLORCRR.ENDORSER_AMOUNT, DLLORCRR.MPN_STATUS, DLLORCRR.MPN_ID, DLLORCRR.MPN_TYPE, DLLORCRR.MPN_INDICATOR FROM IGF_SL_DL_LOR_CRRESP_ALL DLLORCRR WHERE NVL(DLLORCRR.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 DLLORCRR.ROWID
, DLLORCRR.LOR_RESP_NUM
, DLLORCRR.DBTH_ID
, DLLORCRR.LOAN_NUMBER
, DLLORCRR.CREDIT_OVERRIDE
, DLLORCRR.CREDIT_DECISION_DATE
, DLLORCRR.STATUS
, DLLORCRR.CREATED_BY
, DLLORCRR.CREATION_DATE
, DLLORCRR.LAST_UPDATED_BY
, DLLORCRR.LAST_UPDATE_DATE
, DLLORCRR.LAST_UPDATE_LOGIN
, DLLORCRR.REQUEST_ID
, DLLORCRR.PROGRAM_APPLICATION_ID
, DLLORCRR.PROGRAM_ID
, DLLORCRR.PROGRAM_UPDATE_DATE
, DLLORCRR.ORG_ID
, DLLORCRR.ENDORSER_AMOUNT
, DLLORCRR.MPN_STATUS
, DLLORCRR.MPN_ID
, DLLORCRR.MPN_TYPE
, DLLORCRR.MPN_INDICATOR
FROM IGF_SL_DL_LOR_CRRESP_ALL DLLORCRR
WHERE NVL(DLLORCRR.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)