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.HR_LOCATIONS_ALL_LOV_V

Object Details

Object Name:	HR_LOCATIONS_ALL_LOV_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HR_LOCATIONS_ALL_LOV_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

HR_LOCATIONS_LOV_V is a view used by the Web Offers offer page. It
selects locations that the hiring manger can choose for a candidate. It does not include TCA locations.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_ID	NUMBER	(15)	Yes	location identifier
LOCATION_CODE	VARCHAR2	(60)	Yes	location code
LOCATION_USE	CHAR	(2)		location usage
BUSINESS_GROUP_ID	NUMBER	(15)		business group ID of the location
DESCRIPTION	VARCHAR2	(240)		Translated description of the location
INACTIVE_DATE	DATE			inactive date
SHIP_TO_LOCATION_ID	NUMBER	(15)		ship-to location
SHIP_TO_SITE_FLAG	VARCHAR2	(30)		ship-to-site flag
STYLE	VARCHAR2	(7)		address style
ADDRESS	VARCHAR2	(1208)		address
TELEPHONE_NUMBER_1	VARCHAR2	(60)		telephone number of the location
TELEPHONE_NUMBER_2	VARCHAR2	(60)		telephone number of the location
TELEPHONE_NUMBER_3	VARCHAR2	(60)		telephone number of the location
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated object version number of the row. Increments by one with each update
TIMEZONE_CODE	VARCHAR2	(50)		Time Zone Code of the location

Query Text

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


SELECT LOCATION_ID
,      LOCATION_CODE
,      LOCATION_USE
,      BUSINESS_GROUP_ID
,      DESCRIPTION
,      INACTIVE_DATE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_SITE_FLAG
,      STYLE
,      ADDRESS
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      OBJECT_VERSION_NUMBER
,      TIMEZONE_CODE
FROM APPS.HR_LOCATIONS_ALL_LOV_V;

Dependencies

[top of page]

APPS.HR_LOCATIONS_ALL_LOV_V references the following:

APPS: HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL

APPS.HR_LOCATIONS_ALL_LOV_V is referenced by following:

PUBLIC: HR_LOCATIONS_ALL_LOV_V