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_US_LOCATIONS

Object Details

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

View Type

A Business Intelligence System view

This view shows locations with US addresses.

[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)
COUNTY	VARCHAR2	(120)
STATE_NAME	VARCHAR2	(4000)
STATE_CODE	VARCHAR2	(120)
COUNTRY	VARCHAR2	(60)
ZIP_CODE	VARCHAR2	(30)
TELEPHONE_NUMBER_1	VARCHAR2	(60)
TELEPHONE_NUMBER_2	VARCHAR2	(60)
TELEPHONE_NUMBER_3	VARCHAR2	(60)
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)
TIMEZONE_CODE	VARCHAR2	(50)

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
,      COUNTY
,      STATE_NAME
,      STATE_CODE
,      COUNTRY
,      ZIP_CODE
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      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
,      TIMEZONE_CODE
FROM APPS.HRFV_US_LOCATIONS;

Dependencies

[top of page]

APPS.HRFV_US_LOCATIONS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; 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_US_LOCATIONS is not referenced by any database object