VIEW: APPS.IGS_GR_CRMN_ROUND_V

Source

View Text - Preformatted

SELECT GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_CD, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_COURSE_CD || ' ' || TO_CHAR(AWARD_CRS_VERSION_NUMBER) AS COURSE_VERSION, US_GROUP_NUMBER, IGS_GR_GEN_001.GRDP_GET_ACUSG_TITLE( GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_CD, US_GROUP_NUMBER) TITLE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS_GR_AWD_CRM_US_GP UNION SELECT GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, AWARD_CD, AWARD_COURSE_CD, AWARD_CRS_VERSION_NUMBER, AWARD_COURSE_CD || ' ' || TO_CHAR(AWARD_CRS_VERSION_NUMBER) AS COURSE_VERSION, TO_NUMBER(''), '', CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS_GR_AWD_CEREMONY UNION SELECT GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, CEREMONY_NUMBER, '', '', TO_NUMBER(''), '', TO_NUMBER(''), '', CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS_GR_CRMN UNION SELECT GRD_CAL_TYPE, GRD_CI_SEQUENCE_NUMBER, TO_NUMBER(''), '', '', TO_NUMBER(''), '', TO_NUMBER(''), '', CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN FROM IGS_GR_CRMN_ROUND

View Text - HTML Formatted

SELECT GRD_CAL_TYPE
, GRD_CI_SEQUENCE_NUMBER
, CEREMONY_NUMBER
, AWARD_CD
, AWARD_COURSE_CD
, AWARD_CRS_VERSION_NUMBER
, AWARD_COURSE_CD || ' ' || TO_CHAR(AWARD_CRS_VERSION_NUMBER) AS COURSE_VERSION
, US_GROUP_NUMBER
, IGS_GR_GEN_001.GRDP_GET_ACUSG_TITLE( GRD_CAL_TYPE
, GRD_CI_SEQUENCE_NUMBER
, CEREMONY_NUMBER
, AWARD_COURSE_CD
, AWARD_CRS_VERSION_NUMBER
, AWARD_CD
, US_GROUP_NUMBER) TITLE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_GR_AWD_CRM_US_GP UNION SELECT GRD_CAL_TYPE
, GRD_CI_SEQUENCE_NUMBER
, CEREMONY_NUMBER
, AWARD_CD
, AWARD_COURSE_CD
, AWARD_CRS_VERSION_NUMBER
, AWARD_COURSE_CD || ' ' || TO_CHAR(AWARD_CRS_VERSION_NUMBER) AS COURSE_VERSION
, TO_NUMBER('')
, ''
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_GR_AWD_CEREMONY UNION SELECT GRD_CAL_TYPE
, GRD_CI_SEQUENCE_NUMBER
, CEREMONY_NUMBER
, ''
, ''
, TO_NUMBER('')
, ''
, TO_NUMBER('')
, ''
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_GR_CRMN UNION SELECT GRD_CAL_TYPE
, GRD_CI_SEQUENCE_NUMBER
, TO_NUMBER('')
, ''
, ''
, TO_NUMBER('')
, ''
, TO_NUMBER('')
, ''
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS_GR_CRMN_ROUND