VIEW: APPS.IGF_SL_DL_PNOTE_P_P_V

Source

View Text - Preformatted

SELECT PNPPV.PNPP_ID, PNPPV.BATCH_SEQ_NUM, PNPPV.LOAN_ID, PNPPV.LOAN_NUMBER, PNPPV.LOAN_AMT_OFFERED, PNPPV.LOAN_AMT_ACCEPTED, PNPPV.LOAN_PER_BEGIN_DATE, PNPPV.LOAN_PER_END_DATE, PNPPV.PERSON_ID, PNPPV.S_SSN, PNPPV.S_FIRST_NAME, PNPPV.S_LAST_NAME, PNPPV.S_MIDDLE_NAME, PNPPV.S_DATE_OF_BIRTH, PNPPV.S_CITIZENSHIP_STATUS, igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', PNPPV.S_CITIZENSHIP_STATUS), PNPPV.S_ALIEN_REG_NUMBER, PNPPV.S_LICENSE_NUM, PNPPV.S_LICENSE_STATE, PNPPV.S_PERMT_ADDR1, PNPPV.S_PERMT_ADDR2, PNPPV.S_PERMT_CITY, PNPPV.S_PERMT_STATE, PNPPV.S_PERMT_PROVINCE, PNPPV.S_PERMT_COUNTY, PNPPV.S_PERMT_COUNTRY, PNPPV.S_PERMT_ZIP, PNPPV.S_EMAIL_ADDR, PNPPV.S_PHONE, PNPPV.P_PERSON_ID, PNPPV.P_SSN, PNPPV.P_LAST_NAME, PNPPV.P_FIRST_NAME, PNPPV.P_MIDDLE_NAME, PNPPV.P_DATE_OF_BIRTH, PNPPV.P_CITIZENSHIP_STATUS, igf_aw_gen.lookup_desc('IGF_SL_CITIZENSHIP_STAT', PNPPV.P_CITIZENSHIP_STATUS), PNPPV.P_ALIEN_REG_NUM, PNPPV.P_LICENSE_NUM, PNPPV.P_LICENSE_STATE, PNPPV.P_PERMT_ADDR1, PNPPV.P_PERMT_ADDR2, PNPPV.P_PERMT_CITY, PNPPV.P_PERMT_STATE, PNPPV.P_PERMT_PROVINCE, PNPPV.P_PERMT_COUNTY, PNPPV.P_PERMT_COUNTRY, PNPPV.P_PERMT_ZIP, PNPPV.P_EMAIL_ADDR, PNPPV.P_PHONE, igf_sl_gen.get_disb_date(PNPPV.LOAN_ID, 1), igf_sl_gen.get_disb_date(PNPPV.LOAN_ID, 2), igf_sl_gen.get_disb_date(PNPPV.LOAN_ID, 3), igf_sl_gen.get_disb_date(PNPPV.LOAN_ID, 4), PNPPV.STATUS, PNPPV.ORG_ID, PNPPV.CREATED_BY, PNPPV.CREATION_DATE, PNPPV.LAST_UPDATED_BY, PNPPV.LAST_UPDATE_DATE, PNPPV.LAST_UPDATE_LOGIN, PNPPV.REQUEST_ID, PNPPV.PROGRAM_APPLICATION_ID, PNPPV.PROGRAM_ID, PNPPV.PROGRAM_UPDATE_DATE FROM IGF_SL_DL_PNOTE_P_P PNPPV

View Text - HTML Formatted

SELECT PNPPV.PNPP_ID
, PNPPV.BATCH_SEQ_NUM
, PNPPV.LOAN_ID
, PNPPV.LOAN_NUMBER
, PNPPV.LOAN_AMT_OFFERED
, PNPPV.LOAN_AMT_ACCEPTED
, PNPPV.LOAN_PER_BEGIN_DATE
, PNPPV.LOAN_PER_END_DATE
, PNPPV.PERSON_ID
, PNPPV.S_SSN
, PNPPV.S_FIRST_NAME
, PNPPV.S_LAST_NAME
, PNPPV.S_MIDDLE_NAME
, PNPPV.S_DATE_OF_BIRTH
, PNPPV.S_CITIZENSHIP_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CITIZENSHIP_STAT'
, PNPPV.S_CITIZENSHIP_STATUS)
, PNPPV.S_ALIEN_REG_NUMBER
, PNPPV.S_LICENSE_NUM
, PNPPV.S_LICENSE_STATE
, PNPPV.S_PERMT_ADDR1
, PNPPV.S_PERMT_ADDR2
, PNPPV.S_PERMT_CITY
, PNPPV.S_PERMT_STATE
, PNPPV.S_PERMT_PROVINCE
, PNPPV.S_PERMT_COUNTY
, PNPPV.S_PERMT_COUNTRY
, PNPPV.S_PERMT_ZIP
, PNPPV.S_EMAIL_ADDR
, PNPPV.S_PHONE
, PNPPV.P_PERSON_ID
, PNPPV.P_SSN
, PNPPV.P_LAST_NAME
, PNPPV.P_FIRST_NAME
, PNPPV.P_MIDDLE_NAME
, PNPPV.P_DATE_OF_BIRTH
, PNPPV.P_CITIZENSHIP_STATUS
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CITIZENSHIP_STAT'
, PNPPV.P_CITIZENSHIP_STATUS)
, PNPPV.P_ALIEN_REG_NUM
, PNPPV.P_LICENSE_NUM
, PNPPV.P_LICENSE_STATE
, PNPPV.P_PERMT_ADDR1
, PNPPV.P_PERMT_ADDR2
, PNPPV.P_PERMT_CITY
, PNPPV.P_PERMT_STATE
, PNPPV.P_PERMT_PROVINCE
, PNPPV.P_PERMT_COUNTY
, PNPPV.P_PERMT_COUNTRY
, PNPPV.P_PERMT_ZIP
, PNPPV.P_EMAIL_ADDR
, PNPPV.P_PHONE
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 1)
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 2)
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 3)
, IGF_SL_GEN.GET_DISB_DATE(PNPPV.LOAN_ID
, 4)
, PNPPV.STATUS
, PNPPV.ORG_ID
, PNPPV.CREATED_BY
, PNPPV.CREATION_DATE
, PNPPV.LAST_UPDATED_BY
, PNPPV.LAST_UPDATE_DATE
, PNPPV.LAST_UPDATE_LOGIN
, PNPPV.REQUEST_ID
, PNPPV.PROGRAM_APPLICATION_ID
, PNPPV.PROGRAM_ID
, PNPPV.PROGRAM_UPDATE_DATE
FROM IGF_SL_DL_PNOTE_P_P PNPPV