VIEW: APPS.IGS_PS_UNIT_X_GRPMEM_V

Source

View Text - Preformatted

SELECT uxgm.rowid row_id, uv.unit_cd || ' - ' || uv.version_number || ' - ' || uv.title unit, uxgm.unit_x_listed_group_mem_id unit_x_listed_group_mem_id, uxgm.unit_x_listed_group_id unit_x_listed_group_id, uxgm.unit_cd unit_cd, uxgm.version_number version_number, uxgm.parent parent, decode(uxg.max_enr_group,NULL,nvl(uv.enrollment_maximum,0),null) enrollment_maximum, uxgm.created_by created_by, uxgm.creation_date creation_date, uxgm.last_updated_by last_updated_by, uxgm.last_update_date last_update_date, uxgm.last_update_login last_update_login, decode(uxg.max_ovr_group,NULL,nvl(uv.override_enrollment_max,0),null) override_maximum FROM igs_ps_unit_x_grpmem uxgm, igs_ps_unit_ver uv, igs_ps_unit_x_grp uxg WHERE uv.unit_cd = uxgm.unit_cd AND uv.version_number = uxgm.version_number and uxgm.unit_x_listed_group_id = uxg.unit_x_listed_group_id

View Text - HTML Formatted

SELECT UXGM.ROWID ROW_ID
, UV.UNIT_CD || ' - ' || UV.VERSION_NUMBER || ' - ' || UV.TITLE UNIT
, UXGM.UNIT_X_LISTED_GROUP_MEM_ID UNIT_X_LISTED_GROUP_MEM_ID
, UXGM.UNIT_X_LISTED_GROUP_ID UNIT_X_LISTED_GROUP_ID
, UXGM.UNIT_CD UNIT_CD
, UXGM.VERSION_NUMBER VERSION_NUMBER
, UXGM.PARENT PARENT
, DECODE(UXG.MAX_ENR_GROUP
, NULL
, NVL(UV.ENROLLMENT_MAXIMUM
, 0)
, NULL) ENROLLMENT_MAXIMUM
, UXGM.CREATED_BY CREATED_BY
, UXGM.CREATION_DATE CREATION_DATE
, UXGM.LAST_UPDATED_BY LAST_UPDATED_BY
, UXGM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UXGM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DECODE(UXG.MAX_OVR_GROUP
, NULL
, NVL(UV.OVERRIDE_ENROLLMENT_MAX
, 0)
, NULL) OVERRIDE_MAXIMUM
FROM IGS_PS_UNIT_X_GRPMEM UXGM
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_X_GRP UXG
WHERE UV.UNIT_CD = UXGM.UNIT_CD
AND UV.VERSION_NUMBER = UXGM.VERSION_NUMBER
AND UXGM.UNIT_X_LISTED_GROUP_ID = UXG.UNIT_X_LISTED_GROUP_ID