View: IGSFV_USEC_X_LISTED_GROUPS

Product:	IGS - Student System
Description:	This is the base view which describes Unit Sections that are part of the Unit Section Cross-Listed Group.
Implementation/DBA Data:	APPS.IGSFV_USEC_X_LISTED_GROUPS

View Text

SELECT US.USEC_X_LISTED_GROUP_MEM_ID
, US.UOO_ID UNI_SECTION_ID
, US.PARENT PARENT_INDICATOR
, USX.USEC_X_LISTED_GROUP_NAME
, US.USEC_X_LISTED_GROUP_ID
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_X_GRPMEM US
, IGS_PS_USEC_X_GRP USX
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE US.USEC_X_LISTED_GROUP_ID = USX.USEC_X_LISTED_GROUP_ID
AND UN.UOO_ID = US.UOO_ID WITH READ ONLY

Columns