Product: | IGF - Financial Aid |
---|---|
Description: | Base view for the entity that holds Direct Loan Promissory Note Manifests |
Implementation/DBA Data: | APPS.IGFBV_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'
, MANIFEST.LOAN_ID
, MANIFEST.PNMN_ID
, MANIFEST.CREATED_BY
, MANIFEST.CREATION_DATE
, MANIFEST.LAST_UPDATED_BY
, MANIFEST.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_SL_DL_MANIFEST_ALL MANIFEST
, IGF_SL_LOANS_ALL LOANS
, IGF_AW_AWARD_ALL AWARDS
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE MANIFEST.LOAN_ID = LOANS.LOAN_ID
AND LOANS.AWARD_ID = AWARDS.AWARD_ID
AND AWARDS.BASE_ID = FABASE.BASE_ID WITH READ ONLY