VIEW: APPS.IGS_PS_UNIT_LOCATION_V

Source

View Text - Preformatted

SELECT ul.rowid row_id, ul.unit_location_id unit_location_id, ul.unit_code unit_code, ul.unit_version_number unit_version_number, ul.location_code location_cd, loc.description location_description, ul.building_id building_id, bld.building_cd building_cd, bld.description building_description, ul.room_id room_id, rom.room_cd room_cd, rom.description room_description, ul.created_by created_by, ul.creation_date creation_date, ul.last_updated_by last_updated_by, ul.last_update_date last_update_date, ul.last_update_login last_update_login FROM igs_ps_unit_location ul, igs_ad_building bld, igs_ad_room rom, igs_ad_location loc WHERE ul.location_code = loc.location_cd AND ul.building_id = bld.building_id (+) AND ul.room_id = rom.room_id (+)

View Text - HTML Formatted

SELECT UL.ROWID ROW_ID
, UL.UNIT_LOCATION_ID UNIT_LOCATION_ID
, UL.UNIT_CODE UNIT_CODE
, UL.UNIT_VERSION_NUMBER UNIT_VERSION_NUMBER
, UL.LOCATION_CODE LOCATION_CD
, LOC.DESCRIPTION LOCATION_DESCRIPTION
, UL.BUILDING_ID BUILDING_ID
, BLD.BUILDING_CD BUILDING_CD
, BLD.DESCRIPTION BUILDING_DESCRIPTION
, UL.ROOM_ID ROOM_ID
, ROM.ROOM_CD ROOM_CD
, ROM.DESCRIPTION ROOM_DESCRIPTION
, UL.CREATED_BY CREATED_BY
, UL.CREATION_DATE CREATION_DATE
, UL.LAST_UPDATED_BY LAST_UPDATED_BY
, UL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_LOCATION UL
, IGS_AD_BUILDING BLD
, IGS_AD_ROOM ROM
, IGS_AD_LOCATION LOC
WHERE UL.LOCATION_CODE = LOC.LOCATION_CD
AND UL.BUILDING_ID = BLD.BUILDING_ID (+)
AND UL.ROOM_ID = ROM.ROOM_ID (+)