View: IGS_AD_LOC_BLDG_V

Product:	IGS - Student System
Description:	Shows different buildings and their locations
Implementation/DBA Data:	APPS.IGS_AD_LOC_BLDG_V

View Text

SELECT BG.ROWID ROW_ID
, BG.BUILDING_ID BUILDING_ID
, BG.BUILDING_CD BUILDING_CD
, BG.DESCRIPTION BLDG_DESCRIPTION
, BG.CLOSED_IND BLDG_CLOSED_IND
, BG.LOCATION_CD LOCATION_CD
, LOC.DESCRIPTION LOC_DESCRIPTION
, LOC.CLOSED_IND LOC_CLOSED_IND
, BG.CREATED_BY CREATED_BY
, BG.CREATION_DATE CREATION_DATE
, BG.LAST_UPDATED_BY LAST_UPDATED_BY
, BG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_BUILDING BG
, IGS_AD_LOCATION LOC
WHERE BG.LOCATION_CD = LOC.LOCATION_CD

Columns