eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_LOCATIONS

Product:	IGS - Student System (Obsolete)
Description:	This entity describes available physical locations
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT LOC.LOCATION_CD LOCATION_CODE
, LOC.DESCRIPTION
, LOC.LOCATION_TYPE
, LOC.MAIL_DLVRY_WRK_DAYS MAIL_DELIVERY_WORKING_DAYS
, LOC.CLOSED_IND CLOSED_INDICATOR
, LOC.REV_ACCOUNT_CD REVENUE_ACCOUNT_CODE
, '_DF:IGS:IGS_OR_LOC_FLEX:LOC'
, LOT.DESCRIPTION LOCATION_TYPE_DESC
, '_LA:LOT.S_LOCATION_TYPE:IGS_LOOKUP_VALUES:LOCATION_TYPE:MEANING'
, HP.PARTY_NUMBER COORDINATE_PERSON_NUMBER
, ACC.DESCRIPTION REVENUE_ACCOUNT_DESC
, LOC.COORD_PERSON_ID COORDINATE_PERSON_ID
, LOC.CREATED_BY
, LOC.CREATION_DATE
, LOC.LAST_UPDATED_BY
, LOC.LAST_UPDATE_DATE
FROM IGS_AD_LOCATION_ALL LOC
, HZ_PARTIES HP
, IGS_AD_LOCATION_TYPE_ALL LOT
, IGS_FI_ACC_ALL ACC
WHERE LOC.COORD_PERSON_ID = HP.PARTY_ID(+)
AND LOC.LOCATION_TYPE = LOT.LOCATION_TYPE
AND LOC.REV_ACCOUNT_CD = ACC.ACCOUNT_CD(+) WITH READ ONLY

Columns

Name
LOCATION_CODE
DESCRIPTION
LOCATION_TYPE
MAIL_DELIVERY_WORKING_DAYS
CLOSED_INDICATOR
REVENUE_ACCOUNT_CODE
"_DF"
LOCATION_TYPE_DESC
"_LA:SYSTEM_LOCATION_TYPE"
COORDINATE_PERSON_NUMBER
REVENUE_ACCOUNT_DESC
COORDINATE_PERSON_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE