VIEW: APPS.IGF_AW_AWD_CERT_RESPS_V

Source

View Text - Preformatted

SELECT awceinst.rowid, awceinst.ci_cal_type, awceinst.ci_sequence_number, ca.alternate_code, awceinst.award_prd_cd, ap.award_prd_desc, awceinst.base_id, awceinst.awd_cert_code, awcert.awd_cert_desc, awcert.update_funds_auth_flag, awceinst.response_txt, awceinst.created_by, awceinst.creation_date, awceinst.last_updated_by, awceinst.last_update_date, awceinst.last_update_login, awceinst.object_version_number FROM igf_aw_award_certs awcert, igf_aw_awd_cert_resps awceinst, igf_aw_award_prd ap, igs_ca_inst ca, igf_ap_fa_base_rec_all fa WHERE ca.cal_type = awceinst.ci_cal_type AND ca.sequence_number = awceinst.ci_sequence_number AND ap.ci_cal_type = awceinst.ci_cal_type AND ap.ci_sequence_number = awceinst.ci_sequence_number AND ap.award_prd_cd = awceinst.award_prd_cd AND fa.base_id = awceinst.base_id AND awcert.ci_cal_type = awceinst.ci_cal_type AND awcert.ci_sequence_number = awceinst.ci_sequence_number AND awcert.awd_cert_code = awceinst.awd_cert_code AND fa.ci_cal_type = awceinst.ci_cal_type AND fa.ci_sequence_number = awceinst.ci_sequence_number

View Text - HTML Formatted

SELECT AWCEINST.ROWID
, AWCEINST.CI_CAL_TYPE
, AWCEINST.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, AWCEINST.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AWCEINST.BASE_ID
, AWCEINST.AWD_CERT_CODE
, AWCERT.AWD_CERT_DESC
, AWCERT.UPDATE_FUNDS_AUTH_FLAG
, AWCEINST.RESPONSE_TXT
, AWCEINST.CREATED_BY
, AWCEINST.CREATION_DATE
, AWCEINST.LAST_UPDATED_BY
, AWCEINST.LAST_UPDATE_DATE
, AWCEINST.LAST_UPDATE_LOGIN
, AWCEINST.OBJECT_VERSION_NUMBER
FROM IGF_AW_AWARD_CERTS AWCERT
, IGF_AW_AWD_CERT_RESPS AWCEINST
, IGF_AW_AWARD_PRD AP
, IGS_CA_INST CA
, IGF_AP_FA_BASE_REC_ALL FA
WHERE CA.CAL_TYPE = AWCEINST.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = AWCEINST.CI_SEQUENCE_NUMBER
AND AP.CI_CAL_TYPE = AWCEINST.CI_CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = AWCEINST.CI_SEQUENCE_NUMBER
AND AP.AWARD_PRD_CD = AWCEINST.AWARD_PRD_CD
AND FA.BASE_ID = AWCEINST.BASE_ID
AND AWCERT.CI_CAL_TYPE = AWCEINST.CI_CAL_TYPE
AND AWCERT.CI_SEQUENCE_NUMBER = AWCEINST.CI_SEQUENCE_NUMBER
AND AWCERT.AWD_CERT_CODE = AWCEINST.AWD_CERT_CODE
AND FA.CI_CAL_TYPE = AWCEINST.CI_CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER = AWCEINST.CI_SEQUENCE_NUMBER