View: IGF_AW_AWD_CERT_RESPS_V

Product:	IGF - Financial Aid
Description:	Award Certification Texts Response
Implementation/DBA Data:	APPS.IGF_AW_AWD_CERT_RESPS_V

View Text

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

Columns