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

Object Details

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

View Type

A Business Intelligence System view

This view shows all locations in the enterprise. Addresses are displayed in a generic format.

[View Source]

Columns

Name	Datatype	Length	Mandatory
BUSINESS_GROUP_NAME	VARCHAR2	(240)
LOCATION_NAME	VARCHAR2	(60)	Yes
LOCATION_DESCRIPTION	VARCHAR2	(240)
ADDRESS_LINE_1	VARCHAR2	(240)
ADDRESS_LINE_2	VARCHAR2	(240)
ADDRESS_LINE_3	VARCHAR2	(240)
CITY	VARCHAR2	(30)
REGION_1	VARCHAR2	(120)
REGION_2	VARCHAR2	(120)
REGION_3	VARCHAR2	(120)
COUNTRY	VARCHAR2	(60)
POSTAL_CODE	VARCHAR2	(30)
TELEPHONE_NUMBER_1	VARCHAR2	(60)
TELEPHONE_NUMBER_2	VARCHAR2	(60)
TELEPHONE_NUMBER_3	VARCHAR2	(60)
LOC_INFORMATION13	VARCHAR2	(150)
LOC_INFORMATION14	VARCHAR2	(150)
LOC_INFORMATION15	VARCHAR2	(150)
LOC_INFORMATION16	VARCHAR2	(150)
LOC_INFORMATION17	VARCHAR2	(150)
INACTIVE_DATE	DATE
ADDRESS_STYLE	VARCHAR2	(7)
DEFAULT_TAX_CODE	VARCHAR2	(15)
SHIP_TO_LOCATION	VARCHAR2	(60)
DESIGNATED_RECEIVER	VARCHAR2	(240)
INVENTORY_ORGANIZATION	VARCHAR2	(240)
_LA:BILL_TO_SITE_FLAG	CHAR	(51)
_LA:INTERNAL_SITE_FLAG	CHAR	(54)
_LA:RECEIVING_SITE_FLAG	CHAR	(53)
_LA:OFFICE_SITE_FLAG	CHAR	(50)
_LA:SHIP_TO_LOCATION_FLAG	CHAR	(51)
_DF	CHAR	(24)
BUSINESS_GROUP_ID	NUMBER	(15)
DESIGNATED_RECEIVER_ID	NUMBER	(15)
INVENTORY_ORGANIZATION_ID	NUMBER	(15)
LOCATION_ID	NUMBER	(15)	Yes
SHIP_TO_LOCATION_ID	NUMBER	(15)

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      LOCATION_NAME
,      LOCATION_DESCRIPTION
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      CITY
,      REGION_1
,      REGION_2
,      REGION_3
,      COUNTRY
,      POSTAL_CODE
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      INACTIVE_DATE
,      ADDRESS_STYLE
,      DEFAULT_TAX_CODE
,      SHIP_TO_LOCATION
,      DESIGNATED_RECEIVER
,      INVENTORY_ORGANIZATION
,      _LA:BILL_TO_SITE_FLAG
,      _LA:INTERNAL_SITE_FLAG
,      _LA:RECEIVING_SITE_FLAG
,      _LA:OFFICE_SITE_FLAG
,      _LA:SHIP_TO_LOCATION_FLAG
,      _DF
,      BUSINESS_GROUP_ID
,      DESIGNATED_RECEIVER_ID
,      INVENTORY_ORGANIZATION_ID
,      LOCATION_ID
,      SHIP_TO_LOCATION_ID
FROM APPS.HRFV_LOCATIONS;

Dependencies

[top of page]

APPS.HRFV_LOCATIONS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_PEOPLE_X

APPS.HRFV_LOCATIONS is not referenced by any database object