VIEW: APPS.IGF_SL_DL_PNOTE_P_P

Source

View Text - Preformatted

SELECT PNPP.ROWID, PNPP.PNPP_ID, PNPP.BATCH_SEQ_NUM, PNPP.LOAN_ID, PNPP.LOAN_NUMBER, PNPP.LOAN_AMT_OFFERED, PNPP.LOAN_AMT_ACCEPTED, PNPP.LOAN_PER_BEGIN_DATE, PNPP.LOAN_PER_END_DATE, PNPP.PERSON_ID, PNPP.S_SSN, PNPP.S_FIRST_NAME, PNPP.S_LAST_NAME, PNPP.S_MIDDLE_NAME, PNPP.S_DATE_OF_BIRTH, PNPP.S_CITIZENSHIP_STATUS, PNPP.S_ALIEN_REG_NUMBER, PNPP.S_LICENSE_NUM, PNPP.S_LICENSE_STATE, PNPP.S_PERMT_ADDR1, PNPP.S_PERMT_ADDR2, PNPP.S_PERMT_CITY, PNPP.S_PERMT_STATE, PNPP.S_PERMT_PROVINCE, PNPP.S_PERMT_COUNTY, PNPP.S_PERMT_COUNTRY, PNPP.S_PERMT_ZIP, PNPP.S_EMAIL_ADDR, PNPP.S_PHONE, PNPP.P_PERSON_ID, PNPP.P_SSN, PNPP.P_LAST_NAME, PNPP.P_FIRST_NAME, PNPP.P_MIDDLE_NAME, PNPP.P_DATE_OF_BIRTH, PNPP.P_CITIZENSHIP_STATUS, PNPP.P_ALIEN_REG_NUM, PNPP.P_LICENSE_NUM, PNPP.P_LICENSE_STATE, PNPP.P_PERMT_ADDR1, PNPP.P_PERMT_ADDR2, PNPP.P_PERMT_CITY, PNPP.P_PERMT_STATE, PNPP.P_PERMT_PROVINCE, PNPP.P_PERMT_COUNTY, PNPP.P_PERMT_COUNTRY, PNPP.P_PERMT_ZIP, PNPP.P_EMAIL_ADDR, PNPP.P_PHONE, PNPP.STATUS, PNPP.ORG_ID, PNPP.CREATED_BY, PNPP.CREATION_DATE, PNPP.LAST_UPDATED_BY, PNPP.LAST_UPDATE_DATE, PNPP.LAST_UPDATE_LOGIN, PNPP.REQUEST_ID, PNPP.PROGRAM_APPLICATION_ID, PNPP.PROGRAM_ID, PNPP.PROGRAM_UPDATE_DATE FROM IGF_SL_DL_PNOTE_P_P_ALL PNPP WHERE NVL(PNPP.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 PNPP.ROWID
, PNPP.PNPP_ID
, PNPP.BATCH_SEQ_NUM
, PNPP.LOAN_ID
, PNPP.LOAN_NUMBER
, PNPP.LOAN_AMT_OFFERED
, PNPP.LOAN_AMT_ACCEPTED
, PNPP.LOAN_PER_BEGIN_DATE
, PNPP.LOAN_PER_END_DATE
, PNPP.PERSON_ID
, PNPP.S_SSN
, PNPP.S_FIRST_NAME
, PNPP.S_LAST_NAME
, PNPP.S_MIDDLE_NAME
, PNPP.S_DATE_OF_BIRTH
, PNPP.S_CITIZENSHIP_STATUS
, PNPP.S_ALIEN_REG_NUMBER
, PNPP.S_LICENSE_NUM
, PNPP.S_LICENSE_STATE
, PNPP.S_PERMT_ADDR1
, PNPP.S_PERMT_ADDR2
, PNPP.S_PERMT_CITY
, PNPP.S_PERMT_STATE
, PNPP.S_PERMT_PROVINCE
, PNPP.S_PERMT_COUNTY
, PNPP.S_PERMT_COUNTRY
, PNPP.S_PERMT_ZIP
, PNPP.S_EMAIL_ADDR
, PNPP.S_PHONE
, PNPP.P_PERSON_ID
, PNPP.P_SSN
, PNPP.P_LAST_NAME
, PNPP.P_FIRST_NAME
, PNPP.P_MIDDLE_NAME
, PNPP.P_DATE_OF_BIRTH
, PNPP.P_CITIZENSHIP_STATUS
, PNPP.P_ALIEN_REG_NUM
, PNPP.P_LICENSE_NUM
, PNPP.P_LICENSE_STATE
, PNPP.P_PERMT_ADDR1
, PNPP.P_PERMT_ADDR2
, PNPP.P_PERMT_CITY
, PNPP.P_PERMT_STATE
, PNPP.P_PERMT_PROVINCE
, PNPP.P_PERMT_COUNTY
, PNPP.P_PERMT_COUNTRY
, PNPP.P_PERMT_ZIP
, PNPP.P_EMAIL_ADDR
, PNPP.P_PHONE
, PNPP.STATUS
, PNPP.ORG_ID
, PNPP.CREATED_BY
, PNPP.CREATION_DATE
, PNPP.LAST_UPDATED_BY
, PNPP.LAST_UPDATE_DATE
, PNPP.LAST_UPDATE_LOGIN
, PNPP.REQUEST_ID
, PNPP.PROGRAM_APPLICATION_ID
, PNPP.PROGRAM_ID
, PNPP.PROGRAM_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_P_P_ALL PNPP
WHERE NVL(PNPP.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)