VIEW: APPS.IGF_AW_FISAP_REP_V

Source

View Text - Preformatted

SELECT FISAP.BATCH_ID, FISAP.FISAP_DTLS_ID, BATCH.CI_CAL_TYPE, BATCH.CI_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, BATCH.DESCRIPTION, BATCH.REPORTED_TIME_TXT, FISAP.ISIR_ID, ISIR.TRANSACTION_NUM, ISIR.CURRENT_SSN, ISIR.FIRST_NAME, ISIR.LAST_NAME, FABASE.PERSON_ID, HZ.PARTY_NUMBER, FISAP.DEPENDENCY_STATUS, FISAP.CAREER_LEVEL, FISAP.AUTO_ZERO_EFC_FLAG, FISAP.FISAP_INCOME_AMT, FISAP.ENROLLMENT_STATUS, FISAP.PERKINS_DISB_AMT, FISAP.FWS_DISB_AMT, FISAP.FSEOG_DISB_AMT, FISAP.PART_II_SECTION_F_FLAG, FISAP.PART_VI_SECTION_A_FLAG, FISAP.CREATED_BY, FISAP.CREATION_DATE, FISAP.LAST_UPDATED_BY, FISAP.LAST_UPDATE_DATE, FISAP.LAST_UPDATE_LOGIN, FISAP.PROGRAM_APPLICATION_ID, FISAP.PROGRAM_ID, FISAP.PROGRAM_UPDATE_DATE, FISAP.REQUEST_ID FROM IGF_AW_FISAP_REP FISAP, IGF_AW_FISAP_BATCH BATCH, IGF_AP_ISIR_MATCHED ISIR, IGF_AP_FA_BASE_REC_ALL FABASE, IGS_CA_INST CA, HZ_PARTIES HZ WHERE FISAP.BATCH_ID = BATCH.BATCH_ID AND FISAP.ISIR_ID = ISIR.ISIR_ID AND ISIR.BASE_ID = FABASE.BASE_ID AND BATCH.CI_CAL_TYPE = CA.CAL_TYPE AND BATCH.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER AND FABASE.PERSON_ID = HZ.PARTY_ID

View Text - HTML Formatted

SELECT FISAP.BATCH_ID
, FISAP.FISAP_DTLS_ID
, BATCH.CI_CAL_TYPE
, BATCH.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, BATCH.DESCRIPTION
, BATCH.REPORTED_TIME_TXT
, FISAP.ISIR_ID
, ISIR.TRANSACTION_NUM
, ISIR.CURRENT_SSN
, ISIR.FIRST_NAME
, ISIR.LAST_NAME
, FABASE.PERSON_ID
, HZ.PARTY_NUMBER
, FISAP.DEPENDENCY_STATUS
, FISAP.CAREER_LEVEL
, FISAP.AUTO_ZERO_EFC_FLAG
, FISAP.FISAP_INCOME_AMT
, FISAP.ENROLLMENT_STATUS
, FISAP.PERKINS_DISB_AMT
, FISAP.FWS_DISB_AMT
, FISAP.FSEOG_DISB_AMT
, FISAP.PART_II_SECTION_F_FLAG
, FISAP.PART_VI_SECTION_A_FLAG
, FISAP.CREATED_BY
, FISAP.CREATION_DATE
, FISAP.LAST_UPDATED_BY
, FISAP.LAST_UPDATE_DATE
, FISAP.LAST_UPDATE_LOGIN
, FISAP.PROGRAM_APPLICATION_ID
, FISAP.PROGRAM_ID
, FISAP.PROGRAM_UPDATE_DATE
, FISAP.REQUEST_ID
FROM IGF_AW_FISAP_REP FISAP
, IGF_AW_FISAP_BATCH BATCH
, IGF_AP_ISIR_MATCHED ISIR
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGS_CA_INST CA
, HZ_PARTIES HZ
WHERE FISAP.BATCH_ID = BATCH.BATCH_ID
AND FISAP.ISIR_ID = ISIR.ISIR_ID
AND ISIR.BASE_ID = FABASE.BASE_ID
AND BATCH.CI_CAL_TYPE = CA.CAL_TYPE
AND BATCH.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND FABASE.PERSON_ID = HZ.PARTY_ID