View: IGSFV_SUB_LOCATIONS

Product:	IGS - Student System
Description:	This entity describes relationship between locations to determine geographical equivalence between locations.
Implementation/DBA Data:	APPS.IGSFV_SUB_LOCATIONS

View Text

SELECT REL.LOCATION_CD LOCATION_CODE
, REL.SUB_LOCATION_CD SUB_LOCATION_CODE
, REL.DFLT_IND DEFAULT_INDICATOR
, LOC1.DESCRIPTION LOCATION_DESC
, LOC2.DESCRIPTION SUB_LOCATION_DESC
, REL.CREATED_BY
, REL.CREATION_DATE
, REL.LAST_UPDATED_BY
, REL.LAST_UPDATE_DATE
FROM IGS_AD_LOCATION_REL REL
, IGS_AD_LOCATION_ALL LOC1
, IGS_AD_LOCATION_ALL LOC2
WHERE REL.LOCATION_CD = LOC1.LOCATION_CD
AND REL.SUB_LOCATION_CD = LOC2.LOCATION_CD WITH READ ONLY

Columns