[Home] [Help]
SELECT '_LA:HIST.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING', HIST.PNOTE_STATUS_DATE , PER.PARTY_NUMBER , PER.PERSON_FIRST_NAME , PER.PERSON_LAST_NAME , PER.PERSON_MIDDLE_NAME , FMAST.FUND_CODE , FMAST.DESCRIPTION , AWDY.ALTERNATE_CODE , LOANS.LOAN_NUMBER , LOANS.LOAN_PER_BEGIN_DATE , LOANS.LOAN_PER_END_DATE , '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING', HIST.LOAN_ID , LOR.P_PERSON_ID , HIST.DLPNH_ID , HIST.CREATED_BY , HIST.CREATION_DATE , HIST.LAST_UPDATED_BY , HIST.LAST_UPDATE_DATE FROM IGF_SL_PNOTE_STAT_H HIST, IGF_SL_LOR_ALL LOR, IGF_SL_LOANS_ALL LOANS, IGF_AW_AWARD_ALL AWARDS, IGF_AW_FUND_MAST_ALL FMAST, IGS_CA_INST_ALL AWDY, HZ_PARTIES PER WHERE HIST.LOAN_ID = LOR.LOAN_ID AND LOR.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 AND LOR.P_PERSON_ID = PER.PARTY_ID (+) WITH READ ONLY
SELECT '_LA:HIST.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING'
, HIST.PNOTE_STATUS_DATE
, PER.PARTY_NUMBER
, PER.PERSON_FIRST_NAME
, PER.PERSON_LAST_NAME
, PER.PERSON_MIDDLE_NAME
, FMAST.FUND_CODE
, FMAST.DESCRIPTION
, AWDY.ALTERNATE_CODE
, LOANS.LOAN_NUMBER
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, HIST.LOAN_ID
, LOR.P_PERSON_ID
, HIST.DLPNH_ID
, HIST.CREATED_BY
, HIST.CREATION_DATE
, HIST.LAST_UPDATED_BY
, HIST.LAST_UPDATE_DATE
FROM IGF_SL_PNOTE_STAT_H HIST
, IGF_SL_LOR_ALL LOR
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AW_FUND_MAST_ALL FMAST
, IGS_CA_INST_ALL AWDY
, HZ_PARTIES PER
WHERE HIST.LOAN_ID = LOR.LOAN_ID
AND LOR.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
AND LOR.P_PERSON_ID = PER.PARTY_ID (+) WITH READ ONLY
|
|
|
|