VIEW: APPS.IGF_AP_AWARD_YEAR_V

Source

View Text - Preformatted

SELECT ci.row_id ROW_ID, ci.cal_type CAL_TYPE, ci.sequence_number SEQUENCE_NUMBER, ci.start_dt START_DT, ci.end_dt END_DT, ci.cal_status CAL_STATUS, ci.alternate_code ALTERNATE_CODE, ci.sup_cal_status_differ_ind SUP_CAL_STATUS_DIFFER_IND, ci.prior_ci_sequence_number PRIOR_CI_SEQUENCE_NUMBER, ci.org_id ORG_ID, ci.created_by CREATED_BY, ci.creation_date CREATION_DATE, ci.last_updated_by LAST_UPDATED_BY, ci.last_update_date LAST_UPDATE_DATE, ci.last_update_login LAST_UPDATE_LOGIN, ci.description CAL_DESCRIPTION, bm.AWARD_YEAR_STATUS_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_YEAR_STATUS',BM.AWARD_YEAR_STATUS_CODE), BM.PELL_PARTICIPANT_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE',BM.PELL_PARTICIPANT_CODE), BM.DL_PARTICIPANT_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE',BM.DL_PARTICIPANT_CODE), bm.publish_in_ss_flag FROM IGS_CA_INST CI, IGF_AP_BATCH_AW_MAP_ALL BM WHERE BM.CI_CAL_TYPE = CI.CAL_TYPE AND BM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT CI.ROW_ID ROW_ID
, CI.CAL_TYPE CAL_TYPE
, CI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.START_DT START_DT
, CI.END_DT END_DT
, CI.CAL_STATUS CAL_STATUS
, CI.ALTERNATE_CODE ALTERNATE_CODE
, CI.SUP_CAL_STATUS_DIFFER_IND SUP_CAL_STATUS_DIFFER_IND
, CI.PRIOR_CI_SEQUENCE_NUMBER PRIOR_CI_SEQUENCE_NUMBER
, CI.ORG_ID ORG_ID
, CI.CREATED_BY CREATED_BY
, CI.CREATION_DATE CREATION_DATE
, CI.LAST_UPDATED_BY LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CI.DESCRIPTION CAL_DESCRIPTION
, BM.AWARD_YEAR_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_YEAR_STATUS'
, BM.AWARD_YEAR_STATUS_CODE)
, BM.PELL_PARTICIPANT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE'
, BM.PELL_PARTICIPANT_CODE)
, BM.DL_PARTICIPANT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_COD_PARTICIPANT_TYPE'
, BM.DL_PARTICIPANT_CODE)
, BM.PUBLISH_IN_SS_FLAG
FROM IGS_CA_INST CI
, IGF_AP_BATCH_AW_MAP_ALL BM
WHERE BM.CI_CAL_TYPE = CI.CAL_TYPE
AND BM.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER