VIEW: APPS.IGFFV_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 , '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING', FMAST.DESCRIPTION , AWDY.ALTERNATE_CODE , 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, IGF_SL_LOANS_ALL LOANS, IGF_AW_AWARD_ALL AWARDS, IGF_AW_FUND_MAST_ALL FMAST, IGS_CA_INST_ALL AWDY WHERE PPNOTE.LOAN_ID = LOANS.LOAN_ID AND LOANS.AWARD_ID = AWARDS.AWARD_ID AND AWARDS.FUND_ID = FMAST.FUND_ID AND FMAST.CI_CAL_TYPE = AWDY.CAL_TYPE AND FMAST.CI_SEQUENCE_NUMBER = AWDY.SEQUENCE_NUMBER 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
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, FMAST.DESCRIPTION
, AWDY.ALTERNATE_CODE
, 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
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWDY
WHERE PPNOTE.LOAN_ID = LOANS.LOAN_ID
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.FUND_ID = FMAST.FUND_ID
AND FMAST.CI_CAL_TYPE = AWDY.CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = AWDY.SEQUENCE_NUMBER WITH READ ONLY