VIEW: APPS.IGF_AW_AWD_AP_V

Source

View Text - Preformatted

SELECT AP.CI_CAL_TYPE, AP.CI_SEQUENCE_NUMBER, AY.ALTERNATE_CODE, AP.AWARD_PRD_CD, AP.AWARD_PRD_DESC, AP.BBAY_FLAG, MIN(LD.START_DT) START_DT, MAX(LD.END_DT) END_DT ,ap.include_in_ss_flag, ap.default_flag FROM IGF_AW_AWARD_PRD AP, IGS_CA_INST AY, IGF_AW_AWD_PRD_TERM APT, IGS_CA_INST LD WHERE AP.CI_CAL_TYPE = APT.CI_CAL_TYPE AND AP.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER AND AP.AWARD_PRD_CD = APT.AWARD_PRD_CD AND AP.CI_CAL_TYPE = AY.CAL_TYPE AND AP.CI_SEQUENCE_NUMBER = AY.SEQUENCE_NUMBER AND APT.LD_CAL_TYPE = LD.CAL_TYPE AND APT.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER GROUP BY AP.CI_CAL_TYPE, AP.CI_SEQUENCE_NUMBER, AY.ALTERNATE_CODE, AP.AWARD_PRD_CD, AP.AWARD_PRD_DESC, AP.BBAY_FLAG ,ap.include_in_ss_flag, ap.default_flag

View Text - HTML Formatted

SELECT AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, AY.ALTERNATE_CODE
, AP.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AP.BBAY_FLAG
, MIN(LD.START_DT) START_DT
, MAX(LD.END_DT) END_DT
, AP.INCLUDE_IN_SS_FLAG
, AP.DEFAULT_FLAG
FROM IGF_AW_AWARD_PRD AP
, IGS_CA_INST AY
, IGF_AW_AWD_PRD_TERM APT
, IGS_CA_INST LD
WHERE AP.CI_CAL_TYPE = APT.CI_CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER
AND AP.AWARD_PRD_CD = APT.AWARD_PRD_CD
AND AP.CI_CAL_TYPE = AY.CAL_TYPE
AND AP.CI_SEQUENCE_NUMBER = AY.SEQUENCE_NUMBER
AND APT.LD_CAL_TYPE = LD.CAL_TYPE
AND APT.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER GROUP BY AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, AY.ALTERNATE_CODE
, AP.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AP.BBAY_FLAG
, AP.INCLUDE_IN_SS_FLAG
, AP.DEFAULT_FLAG