VIEW: APPS.IGF_SP_AWARD_V

Source

View Text - Preformatted

SELECT DISTINCT AWD.ROW_ID, AWD.AWARD_ID, FMAST.CI_CAL_TYPE, FMAST.CI_SEQUENCE_NUMBER, ADISB.LD_CAL_TYPE, ADISB.LD_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, FMAST.FUND_CODE, FCAT.FED_FUND_CODE, FCAT.SYS_FUND_TYPE, AWD.FUND_ID, FMAST.DESCRIPTION, AWD.BASE_ID, AWD.ACCEPTED_AMT, AWD.PAID_AMT, AWD.MANUAL_UPDATE, AWD.AWARD_DATE, AWD.AWARD_STATUS, 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 FROM IGF_AW_AWD_DISB ADISB, IGF_AW_AWARD AWD, IGF_AW_FUND_MAST FMAST, IGF_AW_FUND_CAT FCAT, IGS_CA_INST CI WHERE ADISB.AWARD_ID = AWD.AWARD_ID AND AWD.FUND_ID = FMAST.FUND_ID AND FMAST.FUND_CODE = FCAT.FUND_CODE AND ADISB.LD_CAL_TYPE = CI.CAL_TYPE AND ADISB.LD_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT DISTINCT AWD.ROW_ID
, AWD.AWARD_ID
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, ADISB.LD_CAL_TYPE
, ADISB.LD_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FCAT.FED_FUND_CODE
, FCAT.SYS_FUND_TYPE
, AWD.FUND_ID
, FMAST.DESCRIPTION
, AWD.BASE_ID
, AWD.ACCEPTED_AMT
, AWD.PAID_AMT
, AWD.MANUAL_UPDATE
, AWD.AWARD_DATE
, AWD.AWARD_STATUS
, 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
FROM IGF_AW_AWD_DISB ADISB
, IGF_AW_AWARD AWD
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGS_CA_INST CI
WHERE ADISB.AWARD_ID = AWD.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND FMAST.FUND_CODE = FCAT.FUND_CODE
AND ADISB.LD_CAL_TYPE = CI.CAL_TYPE
AND ADISB.LD_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER