VIEW: APPS.IGFBV_DL_PLUS_PROM_NOTES

Source

View Text - Preformatted

SELECT PPNOTE.BATCH_SEQ_NUM , PPNOTE.LOAN_NUMBER , PPNOTE.LOAN_AMT_OFFERED , PPNOTE.LOAN_AMT_ACCEPTED , PPNOTE.LOAN_PER_BEGIN_DATE , PPNOTE.LOAN_PER_END_DATE , PPNOTE.S_SSN , PPNOTE.S_FIRST_NAME , PPNOTE.S_LAST_NAME , PPNOTE.S_MIDDLE_NAME , PPNOTE.S_DATE_OF_BIRTH , '_LA:PPNOTE.S_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING', PPNOTE.S_ALIEN_REG_NUMBER , PPNOTE.S_LICENSE_NUM , PPNOTE.S_LICENSE_STATE , PPNOTE.S_PERMT_ADDR1 , PPNOTE.S_PERMT_ADDR2 , PPNOTE.S_PERMT_CITY , PPNOTE.S_PERMT_STATE , PPNOTE.S_PERMT_PROVINCE , PPNOTE.S_PERMT_COUNTY , PPNOTE.S_PERMT_COUNTRY , PPNOTE.S_PERMT_ZIP , PPNOTE.S_EMAIL_ADDR , PPNOTE.S_PHONE , PPNOTE.P_SSN , PPNOTE.P_FIRST_NAME , PPNOTE.P_LAST_NAME , PPNOTE.P_MIDDLE_NAME , PPNOTE.P_DATE_OF_BIRTH , '_LA:PPNOTE.P_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING', PPNOTE.P_ALIEN_REG_NUM , PPNOTE.P_LICENSE_NUM , PPNOTE.P_LICENSE_STATE , PPNOTE.P_PERMT_ADDR1 , PPNOTE.P_PERMT_ADDR2 , PPNOTE.P_PERMT_CITY , PPNOTE.P_PERMT_STATE , PPNOTE.P_PERMT_PROVINCE , PPNOTE.P_PERMT_COUNTY , PPNOTE.P_PERMT_COUNTRY , PPNOTE.P_PERMT_ZIP , PPNOTE.P_EMAIL_ADDR , PPNOTE.P_PHONE , PPNOTE.STATUS , PPNOTE.LOAN_ID , PPNOTE.PERSON_ID , PPNOTE.P_PERSON_ID , PPNOTE.PNPP_ID , PPNOTE.CREATED_BY , PPNOTE.CREATION_DATE , PPNOTE.LAST_UPDATED_BY , PPNOTE.LAST_UPDATE_DATE FROM IGF_SL_DL_PNOTE_P_P_ALL PPNOTE WITH READ ONLY

View Text - HTML Formatted

SELECT PPNOTE.BATCH_SEQ_NUM
, PPNOTE.LOAN_NUMBER
, PPNOTE.LOAN_AMT_OFFERED
, PPNOTE.LOAN_AMT_ACCEPTED
, PPNOTE.LOAN_PER_BEGIN_DATE
, PPNOTE.LOAN_PER_END_DATE
, PPNOTE.S_SSN
, PPNOTE.S_FIRST_NAME
, PPNOTE.S_LAST_NAME
, PPNOTE.S_MIDDLE_NAME
, PPNOTE.S_DATE_OF_BIRTH
, '_LA:PPNOTE.S_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
, PPNOTE.S_ALIEN_REG_NUMBER
, PPNOTE.S_LICENSE_NUM
, PPNOTE.S_LICENSE_STATE
, PPNOTE.S_PERMT_ADDR1
, PPNOTE.S_PERMT_ADDR2
, PPNOTE.S_PERMT_CITY
, PPNOTE.S_PERMT_STATE
, PPNOTE.S_PERMT_PROVINCE
, PPNOTE.S_PERMT_COUNTY
, PPNOTE.S_PERMT_COUNTRY
, PPNOTE.S_PERMT_ZIP
, PPNOTE.S_EMAIL_ADDR
, PPNOTE.S_PHONE
, PPNOTE.P_SSN
, PPNOTE.P_FIRST_NAME
, PPNOTE.P_LAST_NAME
, PPNOTE.P_MIDDLE_NAME
, PPNOTE.P_DATE_OF_BIRTH
, '_LA:PPNOTE.P_CITIZENSHIP_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_CITIZENSHIP_STAT:MEANING'
, PPNOTE.P_ALIEN_REG_NUM
, PPNOTE.P_LICENSE_NUM
, PPNOTE.P_LICENSE_STATE
, PPNOTE.P_PERMT_ADDR1
, PPNOTE.P_PERMT_ADDR2
, PPNOTE.P_PERMT_CITY
, PPNOTE.P_PERMT_STATE
, PPNOTE.P_PERMT_PROVINCE
, PPNOTE.P_PERMT_COUNTY
, PPNOTE.P_PERMT_COUNTRY
, PPNOTE.P_PERMT_ZIP
, PPNOTE.P_EMAIL_ADDR
, PPNOTE.P_PHONE
, PPNOTE.STATUS
, PPNOTE.LOAN_ID
, PPNOTE.PERSON_ID
, PPNOTE.P_PERSON_ID
, PPNOTE.PNPP_ID
, PPNOTE.CREATED_BY
, PPNOTE.CREATION_DATE
, PPNOTE.LAST_UPDATED_BY
, PPNOTE.LAST_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_P_P_ALL PPNOTE WITH READ ONLY