Product: | IGS - Student System (Obsolete) |
---|---|
Description: | IGS_GR_AWD_CRM_US_GP_V is used to include group_title which is either the override_title or a derived value. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ACUSG.GRD_CAL_TYPE
, ACUSG.GRD_CI_SEQUENCE_NUMBER
, ACUSG.CEREMONY_NUMBER
, ACUSG.AWARD_COURSE_CD
, ACUSG.AWARD_CRS_VERSION_NUMBER
, ACUSG.AWARD_CD
, ACUSG.US_GROUP_NUMBER
, ACUSG.ORDER_IN_AWARD
, SUBSTR(NVL(ACUSG.OVERRIDE_TITLE
, IGS_GR_GEN_001.GRDP_GET_ACUSG_TITLE(ACUSG.GRD_CAL_TYPE
, ACUSG.GRD_CI_SEQUENCE_NUMBER
, ACUSG.CEREMONY_NUMBER
, ACUSG.AWARD_COURSE_CD
, ACUSG.AWARD_CRS_VERSION_NUMBER
, ACUSG.AWARD_CD
, ACUSG.US_GROUP_NUMBER))
, 1
, 90) GROUP_TITLE
, ACUSG.CLOSED_IND
, ACUSG.CREATED_BY
, ACUSG.CREATION_DATE
, ACUSG.LAST_UPDATED_BY
, ACUSG.LAST_UPDATE_DATE
, ACUSG.LAST_UPDATE_LOGIN
FROM IGS_GR_AWD_CRM_US_GP ACUSG