VIEW: APPS.IGF_AW_SS_AWD_V

Source

View Text - Preformatted

SELECT awd.award_id, awd.fund_id , awd.base_id , awd.offered_amt, awd.accepted_amt, awd.paid_amt , awd.packaging_type, awd.batch_id , awd.manual_update , awd.rules_override, awd.award_date , awd.award_status , awd.attribute_category, awd.attribute1, awd.attribute2, awd.attribute3, awd.attribute4, awd.attribute5, awd.attribute6, awd.attribute7, awd.attribute8, awd.attribute9, awd.attribute10, awd.attribute11, awd.attribute12, awd.attribute13, awd.attribute14, awd.attribute15, awd.attribute16, awd.attribute17, awd.attribute18, awd.attribute19, awd.attribute20, awd.created_by, awd.creation_date, awd.last_updated_by, awd.last_update_date, awd.last_update_login, awd.program_application_id, awd.program_id, awd.program_update_date, awd.request_id, awd.org_id, awd.rvsn_id, awd.alt_pell_schedule, awd.award_number_txt, awd.legacy_record_flag, awd.adplans_id , awd.lock_award_flag , awd.app_trans_num_txt , awd.awd_proc_status_code, awd.notification_status_code, awd.notification_status_date, awd.publish_in_ss_flag, aprd.award_prd_cd, aprd.ci_cal_type, aprd.ci_sequence_number, hz.party_number, ca.alternate_code, aprd.award_prd_desc FROM igf_aw_award_all awd, igf_aw_award_prd aprd, igf_ap_fa_base_rec_all fa, hz_parties hz, igs_ca_inst_all ca WHERE fa.base_id = awd.base_id AND fa.ci_cal_type = aprd.ci_cal_type AND fa.ci_sequence_number = aprd.ci_sequence_number AND fa.person_id = hz.party_id AND ca.cal_type = fa.ci_cal_type AND ca.sequence_number = fa.ci_sequence_number AND NVL (awd.publish_in_ss_flag, 'N') = 'Y' AND NOT EXISTS ( SELECT ld_cal_type, ld_sequence_number FROM igf_aw_awd_disb_all disb WHERE disb.award_id = awd.award_id MINUS SELECT ld_cal_type, ld_sequence_number FROM igf_aw_awd_prd_term apt WHERE aprd.ci_cal_type = apt.ci_cal_type AND aprd.ci_sequence_number = apt.ci_sequence_number AND aprd.award_prd_cd = apt.award_prd_cd) ORDER BY aprd.award_prd_cd, awd.award_id, aprd.ci_cal_type, aprd.ci_sequence_number

View Text - HTML Formatted

SELECT AWD.AWARD_ID
, AWD.FUND_ID
, AWD.BASE_ID
, AWD.OFFERED_AMT
, AWD.ACCEPTED_AMT
, AWD.PAID_AMT
, AWD.PACKAGING_TYPE
, AWD.BATCH_ID
, AWD.MANUAL_UPDATE
, AWD.RULES_OVERRIDE
, AWD.AWARD_DATE
, AWD.AWARD_STATUS
, AWD.ATTRIBUTE_CATEGORY
, AWD.ATTRIBUTE1
, AWD.ATTRIBUTE2
, AWD.ATTRIBUTE3
, AWD.ATTRIBUTE4
, AWD.ATTRIBUTE5
, AWD.ATTRIBUTE6
, AWD.ATTRIBUTE7
, AWD.ATTRIBUTE8
, AWD.ATTRIBUTE9
, AWD.ATTRIBUTE10
, AWD.ATTRIBUTE11
, AWD.ATTRIBUTE12
, AWD.ATTRIBUTE13
, AWD.ATTRIBUTE14
, AWD.ATTRIBUTE15
, AWD.ATTRIBUTE16
, AWD.ATTRIBUTE17
, AWD.ATTRIBUTE18
, AWD.ATTRIBUTE19
, AWD.ATTRIBUTE20
, AWD.CREATED_BY
, AWD.CREATION_DATE
, AWD.LAST_UPDATED_BY
, AWD.LAST_UPDATE_DATE
, AWD.LAST_UPDATE_LOGIN
, AWD.PROGRAM_APPLICATION_ID
, AWD.PROGRAM_ID
, AWD.PROGRAM_UPDATE_DATE
, AWD.REQUEST_ID
, AWD.ORG_ID
, AWD.RVSN_ID
, AWD.ALT_PELL_SCHEDULE
, AWD.AWARD_NUMBER_TXT
, AWD.LEGACY_RECORD_FLAG
, AWD.ADPLANS_ID
, AWD.LOCK_AWARD_FLAG
, AWD.APP_TRANS_NUM_TXT
, AWD.AWD_PROC_STATUS_CODE
, AWD.NOTIFICATION_STATUS_CODE
, AWD.NOTIFICATION_STATUS_DATE
, AWD.PUBLISH_IN_SS_FLAG
, APRD.AWARD_PRD_CD
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER
, HZ.PARTY_NUMBER
, CA.ALTERNATE_CODE
, APRD.AWARD_PRD_DESC
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWARD_PRD APRD
, IGF_AP_FA_BASE_REC_ALL FA
, HZ_PARTIES HZ
, IGS_CA_INST_ALL CA
WHERE FA.BASE_ID = AWD.BASE_ID
AND FA.CI_CAL_TYPE = APRD.CI_CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER = APRD.CI_SEQUENCE_NUMBER
AND FA.PERSON_ID = HZ.PARTY_ID
AND CA.CAL_TYPE = FA.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = FA.CI_SEQUENCE_NUMBER
AND NVL (AWD.PUBLISH_IN_SS_FLAG
, 'N') = 'Y'
AND NOT EXISTS ( SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_DISB_ALL DISB
WHERE DISB.AWARD_ID = AWD.AWARD_ID MINUS SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_PRD_TERM APT
WHERE APRD.CI_CAL_TYPE = APT.CI_CAL_TYPE
AND APRD.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER
AND APRD.AWARD_PRD_CD = APT.AWARD_PRD_CD) ORDER BY APRD.AWARD_PRD_CD
, AWD.AWARD_ID
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER