VIEW: APPS.IGF_AW_AWD_APT_V

Source

View Text - Preformatted

SELECT AP.ROWID, AP.CI_CAL_TYPE, AP.CI_SEQUENCE_NUMBER, AY.ALTERNATE_CODE, AY.START_DT, AY.END_DT, AP.AWARD_PRD_CD, AP.AWARD_PRD_DESC, AP.BBAY_FLAG, APT.LD_CAL_TYPE, APT.LD_SEQUENCE_NUMBER, LD.ALTERNATE_CODE, LD.START_DT, LD.END_DT, AP.CREATED_BY, AP.CREATION_DATE, AP.LAST_UPDATED_BY, AP.LAST_UPDATE_DATE, AP.LAST_UPDATE_LOGIN FROM IGF_AW_AWARD_PRD AP, IGF_AW_AWD_PRD_TERM APT, IGS_CA_INST AY, 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

View Text - HTML Formatted

SELECT AP.ROWID
, AP.CI_CAL_TYPE
, AP.CI_SEQUENCE_NUMBER
, AY.ALTERNATE_CODE
, AY.START_DT
, AY.END_DT
, AP.AWARD_PRD_CD
, AP.AWARD_PRD_DESC
, AP.BBAY_FLAG
, APT.LD_CAL_TYPE
, APT.LD_SEQUENCE_NUMBER
, LD.ALTERNATE_CODE
, LD.START_DT
, LD.END_DT
, AP.CREATED_BY
, AP.CREATION_DATE
, AP.LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN
FROM IGF_AW_AWARD_PRD AP
, IGF_AW_AWD_PRD_TERM APT
, IGS_CA_INST AY
, 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