Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Direct Loan Promissory Note Manifests |
Implementation/DBA Data: | APPS.IGFFV_DL_PROM_NOTE_MANIFESTS |
SELECT MANIFEST.BATCH_SEQ_NUM
, MANIFEST.LOAN_NUMBER
, MANIFEST.B_FIRST_NAME
, MANIFEST.B_LAST_NAME
, MANIFEST.B_MIDDLE_NAME
, MANIFEST.B_SSN
, '_LA:MANIFEST.STATUS:IGF_LOOKUPS_VIEW:IGF_SL_MANIFEST_PRINT_YES_NO:MEANING'
, FMAST.DESCRIPTION
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, AWARDS.ACCEPTED_AMT
, AWDY.ALTERNATE_CODE
, PER.PARTY_NUMBER
, PER.PERSON_FIRST_NAME
, PER.PERSON_LAST_NAME
, PER.PERSON_MIDDLE_NAME
, MANIFEST.LOAN_ID
, FABASE.PERSON_ID
, MANIFEST.PNMN_ID
, MANIFEST.CREATED_BY
, MANIFEST.CREATION_DATE
, MANIFEST.LAST_UPDATED_BY
, MANIFEST.LAST_UPDATE_DATE
FROM IGF_SL_DL_MANIFEST_ALL MANIFEST
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_AW_FUND_MAST_ALL FMAST
, HZ_PARTIES PER
, IGS_CA_INST_ALL AWDY
WHERE MANIFEST.LOAN_ID = LOANS.LOAN_ID
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.BASE_ID = FABASE.BASE_ID
AND FABASE.PERSON_ID = PER.PARTY_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