[Home] [Help] [Dependency Information]
Object Name: | IGSBV_LOCATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_LOCATIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This entity describes available physical locations
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 systemRevenue Account Code is populated with the revenue account code when GL is not installed and system uses any other external account systems | |
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 |
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
, COORDINATE_PERSON_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSBV_LOCATIONS;
APPS.IGSBV_LOCATIONS is not referenced by any database object
|
|
|