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

VIEW: APPS.HR_LOCATION_LEGAL_ADR_V

Object Details
Object Name: HR_LOCATION_LEGAL_ADR_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW ID of the row
LOCATION_ID NUMBER (15) Yes Location ID of the location
LOCATION_CODE VARCHAR2 (60)
Location Code
BUSINESS_GROUP_ID NUMBER

Business Group ID of the location
DESCRIPTION VARCHAR2 (240)
Brief description of the 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.
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.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
LEGAL_ADDRESS_FLAG VARCHAR2 (30)
Specifies whether the address is Legal Address or not
TIMEZONE_CODE VARCHAR2 (50)
Time Zone Code of the location
Query Text

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


SELECT ROW_ID
,      LOCATION_ID
,      LOCATION_CODE
,      BUSINESS_GROUP_ID
,      DESCRIPTION
,      INACTIVE_DATE
,      STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      COUNTRY
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      OBJECT_VERSION_NUMBER
,      LEGAL_ADDRESS_FLAG
,      TIMEZONE_CODE
FROM APPS.HR_LOCATION_LEGAL_ADR_V;

Dependencies

[top of page]

APPS.HR_LOCATION_LEGAL_ADR_V references the following:

SchemaAPPS
SynonymHR_LOCATIONS_ALL
APPS.HR_LOCATION_LEGAL_ADR_V is referenced by following:

SchemaPUBLIC
SynonymHR_LOCATION_LEGAL_ADR_V