VIEW: APPS.IGS_PS_USEC_X_GRPMEM_V

Source

View Text - Preformatted

SELECT usxgm.rowid row_id, SUBSTR (uoov.unit_cd || ' - ' || uoov.version_number || ' - ' || uoov.location_cd || ' - ' || uoov.unit_class || ' - ' || uc.unit_mode || ' - ' || ca.alternate_code, 1, 2000) unit_section, usxgm.usec_x_listed_group_mem_id usec_x_listed_group_mem_id, usxgm.usec_x_listed_group_id usec_x_listed_group_id, usxgm.uoo_id uoo_id, usxgm.parent parent, decode(usxg.max_enr_group,NULL,nvl(nvl(ulw.enrollment_maximum,uv.enrollment_maximum),0),null) enrollment_maximum, usxgm.created_by created_by, usxgm.creation_date creation_date, usxgm.last_updated_by last_updated_by, usxgm.last_update_date last_update_date, usxgm.last_update_login last_update_login, decode(usxg.max_ovr_group,NULL,nvl(nvl(ulw.override_enrollment_max,uv.override_enrollment_max),0),null) override_maximum, nvl(uoov.enrollment_actual,0) enrollment_actual FROM igs_ps_usec_x_grpmem usxgm, igs_ps_unit_ofr_opt uoov, igs_ps_unit_ver uv, igs_ps_usec_lim_wlst ulw, igs_ps_usec_x_grp usxg, igs_ca_inst ca, igs_as_unit_class uc WHERE uoov.uoo_id = ulw.uoo_id (+) AND uoov.uoo_id = usxgm.uoo_id AND uoov.cal_type=ca.cal_type AND uoov.ci_sequence_number=ca.sequence_number AND uoov.unit_class=uc.unit_class AND uoov.unit_cd = uv.unit_cd AND uoov.version_number = uv.version_number AND usxgm.usec_x_listed_group_id = usxg.usec_x_listed_group_id

View Text - HTML Formatted

SELECT USXGM.ROWID ROW_ID
, SUBSTR (UOOV.UNIT_CD || ' - ' || UOOV.VERSION_NUMBER || ' - ' || UOOV.LOCATION_CD || ' - ' || UOOV.UNIT_CLASS || ' - ' || UC.UNIT_MODE || ' - ' || CA.ALTERNATE_CODE
, 1
, 2000) UNIT_SECTION
, USXGM.USEC_X_LISTED_GROUP_MEM_ID USEC_X_LISTED_GROUP_MEM_ID
, USXGM.USEC_X_LISTED_GROUP_ID USEC_X_LISTED_GROUP_ID
, USXGM.UOO_ID UOO_ID
, USXGM.PARENT PARENT
, DECODE(USXG.MAX_ENR_GROUP
, NULL
, NVL(NVL(ULW.ENROLLMENT_MAXIMUM
, UV.ENROLLMENT_MAXIMUM)
, 0)
, NULL) ENROLLMENT_MAXIMUM
, USXGM.CREATED_BY CREATED_BY
, USXGM.CREATION_DATE CREATION_DATE
, USXGM.LAST_UPDATED_BY LAST_UPDATED_BY
, USXGM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USXGM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DECODE(USXG.MAX_OVR_GROUP
, NULL
, NVL(NVL(ULW.OVERRIDE_ENROLLMENT_MAX
, UV.OVERRIDE_ENROLLMENT_MAX)
, 0)
, NULL) OVERRIDE_MAXIMUM
, NVL(UOOV.ENROLLMENT_ACTUAL
, 0) ENROLLMENT_ACTUAL
FROM IGS_PS_USEC_X_GRPMEM USXGM
, IGS_PS_UNIT_OFR_OPT UOOV
, IGS_PS_UNIT_VER UV
, IGS_PS_USEC_LIM_WLST ULW
, IGS_PS_USEC_X_GRP USXG
, IGS_CA_INST CA
, IGS_AS_UNIT_CLASS UC
WHERE UOOV.UOO_ID = ULW.UOO_ID (+)
AND UOOV.UOO_ID = USXGM.UOO_ID
AND UOOV.CAL_TYPE=CA.CAL_TYPE
AND UOOV.CI_SEQUENCE_NUMBER=CA.SEQUENCE_NUMBER
AND UOOV.UNIT_CLASS=UC.UNIT_CLASS
AND UOOV.UNIT_CD = UV.UNIT_CD
AND UOOV.VERSION_NUMBER = UV.VERSION_NUMBER
AND USXGM.USEC_X_LISTED_GROUP_ID = USXG.USEC_X_LISTED_GROUP_ID