DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.HR_H2PI_LOCATIONS_V

Object Details
Object Name: HR_H2PI_LOCATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPER.HR_H2PI_LOCATIONS_V
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 Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

Last update date.
BUSINESS_GROUP_ID NUMBER (15)
Business Group ID associated with location.
LOCATION_ID NUMBER (15) Yes System-generated primary key column.
LOCATION_CODE VARCHAR2 (60)
Location name.
DESCRIPTION VARCHAR2 (240)
Brief 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.
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.
STYLE VARCHAR2 (7)
Address style - foreign key to FND_TERRITORIES.
INACTIVE_DATE DATE

Date after which this location is no longer valid.
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.
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.
TIMEZONE_CODE VARCHAR2 (50)
Query Text

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


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      LOCATION_ID
,      LOCATION_CODE
,      DESCRIPTION
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      STYLE
,      INACTIVE_DATE
,      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
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      TIMEZONE_CODE
FROM APPS.HR_H2PI_LOCATIONS_V;

Dependencies

[top of page]

APPS.HR_H2PI_LOCATIONS_V references the following:

SchemaAPPS
SynonymHR_LOCATIONS_ALL
APPS.HR_H2PI_LOCATIONS_V is referenced by following:

SchemaAPPS
Package BodyHR_H2PI_MAPPING_SETUP - show dependent code
SchemaPUBLIC
SynonymHR_H2PI_LOCATIONS_V