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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGSFV_LOCATIONS

Object Details

Object Name:	IGSFV_LOCATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGSFV_LOCATIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This entity describes available physical locations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_CODE	VARCHAR2	(10)	Yes	The institution-defined code of a physical location owned or used by the institution.
DESCRIPTION	VARCHAR2	(60)	Yes	The description of a physical location owned or used by an institution.
LOCATION_TYPE	VARCHAR2	(10)	Yes	Location type of the location. A location type is a classification or grouping of locations, such as Campus or Examination location.
MAIL_DELIVERY_WORKING_DAYS	NUMBER	(2)		The average number of working days required for correspondence to reach the location using standard mail.
CLOSED_INDICATOR	VARCHAR2	(1)	Yes	Indicates if the location is closed.
REVENUE_ACCOUNT_CODE	VARCHAR2	(40)		Revenue Account Code is populated with the revenue account code when GL is not installed and system uses any other external account systems
_DF	CHAR	(27)		Descriptive Flex Field
LOCATION_TYPE_DESC	VARCHAR2	(60)	Yes	Description of location type.
_LA:SYSTEM_LOCATION_TYPE	CHAR	(63)		System location type with which the location type is associated.
COORDINATE_PERSON_NUMBER	VARCHAR2	(30)		Identification Number of the person responsible for the coordination of the location. This person may be different from the contact person stored in the address details. In the case of examination locations, the coordinator may also be the supervisor-in-charge, particularly at external examination locations.
REVENUE_ACCOUNT_DESC	VARCHAR2	(60)		Description of Revenue Account Code.
COORDINATE_PERSON_ID	NUMBER	(15)		The person responsible for the coordination of the location. This person may be different from the contact person stored in the address details. In the case of examination locations, the coordinator may also be the supervisor-in-charge, particularly at external examination locations.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.IGSFV_LOCATIONS;

Dependencies

[top of page]

APPS.IGSFV_LOCATIONS references the following:

APPS: HZ_PARTIES; IGS_AD_LOCATION_ALL; IGS_AD_LOCATION_TYPE_ALL; IGS_FI_ACC_ALL

APPS.IGSFV_LOCATIONS is not referenced by any database object