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]

TABLE: HR.HR_LOCATIONS_ALL

Object Details

Object Name:	HR_LOCATIONS_ALL
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_LOCATIONS_ALL
Subobject Name:
Status:	VALID

Work location definitions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_LOCATIONS_PK

LOCATION_ID

Unique Key: HR_LOCATIONS_UK2

LOCATION_CODE
BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_LOCATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_ID
HR_LOCATIONS_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOCATION_CODE BUSINESS_GROUP_ID
SYS_IL0000043583C00090$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000043583C00091$$	LOB	UNIQUE	APPS_TS_TX_DATA
HR_LOCATIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ORGANIZATION_ID
HR_LOCATIONS_N1	DOMAIN	NONUNIQUE		DERIVED_LOCALE
HR_LOCATIONS_SPT	DOMAIN	NONUNIQUE		GEOMETRY
HR_LOCATIONS_UK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ECE_TP_LOCATION_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
HR_ALL_ORGANIZATION_UNITS	HR_LOCATIONS_ALL	HR_ALL_ORGANIZATION_UNITS LOCATION_ID
HR_ALL_POSITIONS_F	HR_LOCATIONS_ALL	HR_ALL_POSITIONS_F LOCATION_ID
HR_LOCATION_EXTRA_INFO	HR_LOCATIONS_ALL	HR_LOCATION_EXTRA_INFO LOCATION_ID
PAY_ELEMENT_LINKS_F	HR_LOCATIONS_ALL	PAY_ELEMENT_LINKS_F LOCATION_ID
PAY_WCI_ACCOUNTS	HR_LOCATIONS_ALL	PAY_WCI_ACCOUNTS LOCATION_ID
PAY_WC_FUNDS	HR_LOCATIONS_ALL	PAY_WC_FUNDS LOCATION_ID
PER_ALL_ASSIGNMENTS_F	HR_LOCATIONS_ALL	PER_ALL_ASSIGNMENTS_F LOCATION_ID
PER_ALL_POSITIONS	HR_LOCATIONS_ALL	PER_ALL_POSITIONS LOCATION_ID
PER_ALL_VACANCIES	HR_LOCATIONS_ALL	PER_ALL_VACANCIES LOCATION_ID
PER_EVENTS	HR_LOCATIONS_ALL	PER_EVENTS LOCATION_ID
PER_SALARY_SURVEY_MAPPINGS	HR_LOCATIONS_ALL	PER_SALARY_SURVEY_MAPPINGS LOCATION_ID
PQH_POSITION_TRANSACTIONS	HR_LOCATIONS_ALL	PQH_POSITION_TRANSACTIONS LOCATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LOCATION_ID	NUMBER	(15)	Yes	System-generated primary key column.
LOCATION_CODE	VARCHAR2	(60)		Location name.
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group ID associated with location.
DESCRIPTION	VARCHAR2	(240)		Brief description of the location.
SHIP_TO_LOCATION_ID	NUMBER	(15)		Ship-to location foreign key.
SHIP_TO_SITE_FLAG	VARCHAR2	(30)		Indicates whether items can be shipped to this location.
RECEIVING_SITE_FLAG	VARCHAR2	(30)		Indicates whether this location can be used as a receiving site.
BILL_TO_SITE_FLAG	VARCHAR2	(30)		Indicates whether you can bill items to this location.
IN_ORGANIZATION_FLAG	VARCHAR2	(30)		Indicates whether this location is an internal site.
OFFICE_SITE_FLAG	VARCHAR2	(30)		Indicates whether this location can be used as an office site.
DESIGNATED_RECEIVER_ID	NUMBER	(15)		Person foreign key - the contact person for this location.
INVENTORY_ORGANIZATION_ID	NUMBER	(15)		Inventory organization foreign key.
TAX_NAME	VARCHAR2	(15)		Default tax code for this location.
INACTIVE_DATE	DATE			Date after which this location is no longer valid.
STYLE	VARCHAR2	(7)		Address style - foreign key to FND_TERRITORIES.
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.
COUNTRY	VARCHAR2	(60)		Country.
POSTAL_CODE	VARCHAR2	(30)		Postal code.
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.
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.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Global descriptive flexlield structure defining colunm
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield colunm
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
ENTERED_BY	NUMBER	(15)	Yes	Applications user who created this location; same as CREATED_BY.
TP_HEADER_ID	NUMBER			Unsupported in Oracle Human Resources. Used by Oracle EDI Gateway.
ECE_TP_LOCATION_CODE	VARCHAR2	(35)		Unsupported in Oracle Human Resources. Used by Oracle EDI Gateway.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of row. Increments by one with each update.
GEOMETRY	SDO_GEOMETRY	(1)
LOC_INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
LOC_INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
DERIVED_LOCALE	VARCHAR2	(240)		derived locale
LEGAL_ADDRESS_FLAG	VARCHAR2	(30)
TIMEZONE_CODE	VARCHAR2	(50)

Query Text

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


SELECT LOCATION_ID
,      LOCATION_CODE
,      BUSINESS_GROUP_ID
,      DESCRIPTION
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_SITE_FLAG
,      RECEIVING_SITE_FLAG
,      BILL_TO_SITE_FLAG
,      IN_ORGANIZATION_FLAG
,      OFFICE_SITE_FLAG
,      DESIGNATED_RECEIVER_ID
,      INVENTORY_ORGANIZATION_ID
,      TAX_NAME
,      INACTIVE_DATE
,      STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      LOC_INFORMATION13
,      LOC_INFORMATION14
,      LOC_INFORMATION15
,      LOC_INFORMATION16
,      LOC_INFORMATION17
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ENTERED_BY
,      TP_HEADER_ID
,      ECE_TP_LOCATION_CODE
,      OBJECT_VERSION_NUMBER
,      GEOMETRY
,      LOC_INFORMATION18
,      LOC_INFORMATION19
,      LOC_INFORMATION20
,      DERIVED_LOCALE
,      LEGAL_ADDRESS_FLAG
,      TIMEZONE_CODE
FROM HR.HR_LOCATIONS_ALL;

Dependencies

[top of page]

HR.HR_LOCATIONS_ALL references the following:

MDSYS: SDO_GEOMETRY
SYS: STANDARD - show dependent code

HR.HR_LOCATIONS_ALL is referenced by following:

HR: DR$HR_LOCATIONS_N1TC; HR_LOCATIONS_ALL#