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

Object Details

Object Name:	HRBV_LOCATION
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A Business Intelligence System view

Shared HRMS base view on HR_LOCATIONS_ALL for use in Discoverer shared HRMS end user layer

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_NAME	VARCHAR2	(60)	Yes	Translated location name
DESCRIPTION	VARCHAR2	(240)		Translated description of the location.
ADDRESS_LINE_1	VARCHAR2	(240)		1st line of location address.
ADDRESS_LINE_2	VARCHAR2	(240)		2nd line of location address.
ADDRESS_LINE_3	VARCHAR2	(240)		3rd line of location address.
TOWN_OR_CITY	VARCHAR2	(30)		Town or city.
REGION_1	VARCHAR2	(120)		County (US, UK); Province (CA).
REGION_2	VARCHAR2	(120)		State (US); Province of work (CA).
REGION_3	VARCHAR2	(120)		Additional address segment - not used by seeded address structures.
COUNTRY	VARCHAR2	(60)		Country.
POSTAL_CODE	VARCHAR2	(30)		Postal code.
TELEPHONE_NUMBER_1	VARCHAR2	(60)		Telephone number.
TELEPHONE_NUMBER_2	VARCHAR2	(60)		Telephone number.
TELEPHONE_NUMBER_3	VARCHAR2	(60)		Telephone number.
LOC_INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
INACTIVE_DATE	DATE			Date after which this location is no longer valid.
TAX_NAME	VARCHAR2	(15)		Default tax code for this location.
DERIVED_LOCALE	VARCHAR2	(240)		derived locale
BILL_TO_SITE_FLAG	VARCHAR2	(4000)
INTERNAL_SITE_FLAG	VARCHAR2	(4000)
RECEIVING_SITE_FLAG	VARCHAR2	(4000)
OFFICE_SITE_FLAG	VARCHAR2	(4000)
SHIP_TO_LOCATION_FLAG	VARCHAR2	(4000)
LEGAL_ADDRESS_FLAG	VARCHAR2	(4000)
BILL_TO_SITE_FLAG_CODE	VARCHAR2	(30)
INTERNAL_SITE_FLAG_CODE	VARCHAR2	(30)
RECEIVING_SITE_FLAG_CODE	VARCHAR2	(30)
OFFICE_SITE_FLAG_CODE	VARCHAR2	(30)
SHIP_TO_LOCATION_FLAG_CODE	VARCHAR2	(30)
ADDRESS_STYLE_CODE	VARCHAR2	(7)
LEGAL_ADDRESS_FLAG_CODE	VARCHAR2	(30)
_DF:LCA	CHAR	(24)
_DF:ADL	CHAR	(28)
_DF:JHR	CHAR	(26)
ENTERED_BY	NUMBER	(15)	Yes
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)
LAST_UPDATE_DATE	DATE
LAST_UDAPTED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATED_DATE	DATE
BG_SECURITY_FLAG_CODE	CHAR	(1)

Query Text

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


SELECT LOCATION_NAME
,      DESCRIPTION
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_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
,      LOC_INFORMATION18
,      LOC_INFORMATION19
,      LOC_INFORMATION20
,      INACTIVE_DATE
,      TAX_NAME
,      DERIVED_LOCALE
,      BILL_TO_SITE_FLAG
,      INTERNAL_SITE_FLAG
,      RECEIVING_SITE_FLAG
,      OFFICE_SITE_FLAG
,      SHIP_TO_LOCATION_FLAG
,      LEGAL_ADDRESS_FLAG
,      BILL_TO_SITE_FLAG_CODE
,      INTERNAL_SITE_FLAG_CODE
,      RECEIVING_SITE_FLAG_CODE
,      OFFICE_SITE_FLAG_CODE
,      SHIP_TO_LOCATION_FLAG_CODE
,      ADDRESS_STYLE_CODE
,      LEGAL_ADDRESS_FLAG_CODE
,      _DF:LCA
,      _DF:ADL
,      _DF:JHR
,      ENTERED_BY
,      BUSINESS_GROUP_ID
,      DESIGNATED_RECEIVER_ID
,      INVENTORY_ORGANIZATION_ID
,      LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UDAPTED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATED_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_LOCATION;

Dependencies

[top of page]

APPS.HRBV_LOCATION references the following:

APPS: HR_BIS - show dependent code; HR_LOCATIONS_ALL; HR_LOCATIONS_ALL_TL

APPS.HRBV_LOCATION is not referenced by any database object