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: TablePER.HR_LOCATIONS_ALL
Subobject Name:
Status: VALID

Work location definitions.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_LOCATIONS_PK
  1. ColumnLOCATION_ID
Unique Key: HR_LOCATIONS_UK2
  1. ColumnLOCATION_CODE
  2. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_LOCATIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
HR_LOCATIONS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_CODE
ColumnBUSINESS_GROUP_ID
SYS_IL0000043583C00090$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000043583C00091$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
HR_LOCATIONS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ORGANIZATION_ID
HR_LOCATIONS_N1 DOMAIN NONUNIQUE Tablespace ColumnDERIVED_LOCALE
HR_LOCATIONS_SPT DOMAIN NONUNIQUE Tablespace ColumnGEOMETRY
HR_LOCATIONS_UK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnECE_TP_LOCATION_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
TableHR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK3 HR_LOCATIONS_ALL HR_ALL_ORGANIZATION_UNITS LOCATION_ID
TableHR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK4 HR_LOCATIONS_ALL HR_ALL_POSITIONS_F LOCATION_ID
TableHR_LOCATION_EXTRA_INFO HR_LOCATION_EXTRA_INFO_FK2 HR_LOCATIONS_ALL HR_LOCATION_EXTRA_INFO LOCATION_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK8 HR_LOCATIONS_ALL PAY_ELEMENT_LINKS_F LOCATION_ID
TablePAY_WCI_ACCOUNTS PAY_WCI_ACCOUNTS_FK3 HR_LOCATIONS_ALL PAY_WCI_ACCOUNTS LOCATION_ID
TablePAY_WC_FUNDS PAY_WC_FUNDS_FK3 HR_LOCATIONS_ALL PAY_WC_FUNDS LOCATION_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK8 HR_LOCATIONS_ALL PER_ALL_ASSIGNMENTS_F LOCATION_ID
TablePER_ALL_POSITIONS PER_POSITIONS_FK6 HR_LOCATIONS_ALL PER_ALL_POSITIONS LOCATION_ID
TablePER_ALL_VACANCIES PER_VACANCIES_FK8 HR_LOCATIONS_ALL PER_ALL_VACANCIES LOCATION_ID
TablePER_EVENTS PER_EVENTS_FK2 HR_LOCATIONS_ALL PER_EVENTS LOCATION_ID
TablePER_SALARY_SURVEY_MAPPINGS PER_SURVEY_MAPPINGS_FK2 HR_LOCATIONS_ALL PER_SALARY_SURVEY_MAPPINGS LOCATION_ID
TablePQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK4 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:

SchemaMDSYS
TYPESDO_GEOMETRY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
HR.HR_LOCATIONS_ALL is referenced by following:

SchemaAPPS
SynonymHR_LOCATIONS_ALL
TriggerHR_LOCATIONS_ALL_OVN
TriggerHR_LOCATIONS_ALL_WHO
Materialized ViewHR_MBS_WRKFC_JCX_MV
Materialized ViewHR_MBS_WRKFC_JCX_SUPH_MV
Package BodyJL_CO_GL_MG_MEDIA_PKG - show dependent code
SchemaHR
TriggerDR$HR_LOCATIONS_N1TC
SchemaPUBLIC
SynonymHR_LOCATIONS_ALL