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

VIEW: HR.HR_H2PI_ADDRESSES#

Object Details
Object Name: HR_H2PI_ADDRESSES#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LAST_UPD_DATE DATE

BUSINESS_GROUP_ID NUMBER (15) Yes
CLIENT_ID NUMBER (15) Yes
ADDRESS_ID NUMBER (15) Yes
PERSON_ID NUMBER (10) Yes
STYLE VARCHAR2 (30) Yes
DATE_FROM DATE
Yes
DATE_TO DATE

ADDRESS_TYPE VARCHAR2 (30)
ADDRESS_LINE1 VARCHAR2 (240)
ADDRESS_LINE2 VARCHAR2 (240)
ADDRESS_LINE3 VARCHAR2 (240)
TOWN_OR_CITY VARCHAR2 (30)
REGION_1 VARCHAR2 (120)
REGION_2 VARCHAR2 (120)
REGION_3 VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
TELEPHONE_NUMBER_1 VARCHAR2 (60)
TELEPHONE_NUMBER_2 VARCHAR2 (60)
TELEPHONE_NUMBER_3 VARCHAR2 (60)
ADD_INFORMATION13 VARCHAR2 (150)
ADD_INFORMATION14 VARCHAR2 (150)
ADD_INFORMATION15 VARCHAR2 (150)
ADD_INFORMATION16 VARCHAR2 (150)
ADD_INFORMATION17 VARCHAR2 (150)
ADD_INFORMATION18 VARCHAR2 (150)
ADD_INFORMATION19 VARCHAR2 (150)
ADD_INFORMATION20 VARCHAR2 (150)
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ADDR_ATTRIBUTE1 VARCHAR2 (150)
ADDR_ATTRIBUTE2 VARCHAR2 (150)
ADDR_ATTRIBUTE3 VARCHAR2 (150)
ADDR_ATTRIBUTE4 VARCHAR2 (150)
ADDR_ATTRIBUTE5 VARCHAR2 (150)
ADDR_ATTRIBUTE6 VARCHAR2 (150)
ADDR_ATTRIBUTE7 VARCHAR2 (150)
ADDR_ATTRIBUTE8 VARCHAR2 (150)
ADDR_ATTRIBUTE9 VARCHAR2 (150)
ADDR_ATTRIBUTE10 VARCHAR2 (150)
ADDR_ATTRIBUTE11 VARCHAR2 (150)
ADDR_ATTRIBUTE12 VARCHAR2 (150)
ADDR_ATTRIBUTE13 VARCHAR2 (150)
ADDR_ATTRIBUTE14 VARCHAR2 (150)
ADDR_ATTRIBUTE15 VARCHAR2 (150)
ADDR_ATTRIBUTE16 VARCHAR2 (150)
ADDR_ATTRIBUTE17 VARCHAR2 (150)
ADDR_ATTRIBUTE18 VARCHAR2 (150)
ADDR_ATTRIBUTE19 VARCHAR2 (150)
ADDR_ATTRIBUTE20 VARCHAR2 (150)
STATUS VARCHAR2 (1)
Query Text

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


SELECT LAST_UPD_DATE
,      BUSINESS_GROUP_ID
,      CLIENT_ID
,      ADDRESS_ID
,      PERSON_ID
,      STYLE
,      DATE_FROM
,      DATE_TO
,      ADDRESS_TYPE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      TOWN_OR_CITY
,      REGION_1
,      REGION_2
,      REGION_3
,      POSTAL_CODE
,      COUNTRY
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      ADD_INFORMATION13
,      ADD_INFORMATION14
,      ADD_INFORMATION15
,      ADD_INFORMATION16
,      ADD_INFORMATION17
,      ADD_INFORMATION18
,      ADD_INFORMATION19
,      ADD_INFORMATION20
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ADDR_ATTRIBUTE16
,      ADDR_ATTRIBUTE17
,      ADDR_ATTRIBUTE18
,      ADDR_ATTRIBUTE19
,      ADDR_ATTRIBUTE20
,      STATUS
FROM HR.HR_H2PI_ADDRESSES#;

Dependencies

[top of page]

HR.HR_H2PI_ADDRESSES# references the following:

SchemaHR
TableHR_H2PI_ADDRESSES
HR.HR_H2PI_ADDRESSES# is referenced by following:

SchemaAPPS
SynonymHR_H2PI_ADDRESSES