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

VIEW: APPS.IGS_PE_PERSON_ADDR

Object Details
Object Name: IGS_PE_PERSON_ADDR
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PE_PERSON_ADDR
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


IGS_PE_PERSON_ADDR describes the address information of a person


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Unique identifier of each record in the database
PERSON_ID NUMBER (15) Yes Unique identifier of each person in tne system
PERSON_NUMBER VARCHAR2 (30) Yes Unique number assigned to each person that is displayed to the user
PARTY_SITE_ID NUMBER (15) Yes Unique identifier of each party site
LOCATION_ID NUMBER (15) Yes Unique identifier of each location
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program
PROGRAM_APPLICATION_ID NUMBER (15)
Program application identifier of last concurrent program
PROGRAM_UPDATE_DATE DATE

Last update data of the concurrent program
WH_UPDATE_DATE DATE

Obsolete
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard Descriptive Flexfield attribute column
ATTRIBUTE1 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE2 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE3 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE4 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE5 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE6 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE7 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE8 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE9 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE10 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE11 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE12 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE13 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE14 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE15 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE16 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE17 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE18 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE19 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ATTRIBUTE20 VARCHAR2 (150)
Standard Descriptive Flexfield attribute column
ORIG_SYSTEM_REFERENCE VARCHAR2 (240)
Origin system reference
START_DT DATE

Start Date of the Address used by the person, being selected from IGS extension table
END_DT DATE

End Date of the Address used by the person, being selected from IGS extension table
ADDRESS_EFFECTIVE_DATE DATE

Date from that the address is effective
ADDRESS_EXPIRATION_DATE DATE

Date from that the address is expired
MAILSTOP VARCHAR2 (60)
Mailstop of the location
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (1) Yes Flag indicates that the address has been identified or not
PARTY_SITE_LANGUAGE VARCHAR2 (30)
Language used at the party site
STATUS VARCHAR2 (1) Yes Status, Active or Inactive, of the Party Site
PARTY_SITE_NAME VARCHAR2 (240)
Name of the party site
ADDRESS_KEY VARCHAR2 (500)
Address key
ADDRESS_STYLE VARCHAR2 (30)
Style of the address
VALIDATED_FLAG VARCHAR2 (1)
Flag indicates the address has been validated or not
ADDRESS_LINES_PHONETIC VARCHAR2 (560)
Phonetic of the address lines
PO_BOX_NUMBER VARCHAR2 (50)
Post box number of the address
HOUSE_NUMBER VARCHAR2 (50)
House number
STREET_SUFFIX VARCHAR2 (50)
Suffix name of the location
STREET VARCHAR2 (50)
Name of the street
STREET_NUMBER VARCHAR2 (50)
Street number
FLOOR VARCHAR2 (50)
The floor that the person lives
SUITE VARCHAR2 (50)
Describes the suite
POSTAL_PLUS4_CODE VARCHAR2 (10)
Postal code
POSITION VARCHAR2 (50)
Describes the position of the location
LOCATION_DIRECTIONS VARCHAR2 (640)
Describes the directions to the locations
CLLI_CODE VARCHAR2 (60)
CLLI code
LOCATION_LANGUAGE VARCHAR2 (4)
Language used at the location
SHORT_DESCRIPTION VARCHAR2 (240)
Short description of the location
DESCRIPTION VARCHAR2 (2000)
Detailed description of the location
LOCATION_CONTENT_SOURCE_TYPE VARCHAR2 (30) Yes Location content source type
SALES_TAX_GEOCODE VARCHAR2 (30)
Sales tax geological code
SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2 (30)
Sales tax inside the city limits
DATE_LAST_VERIFIED DATE

Obsolete
CORRESPONDENCE_IND VARCHAR2 (1) Yes Flag indicates whether this address could be used for correspondence
ADDR_TYPE VARCHAR2 (30)
Address type of the address
ADDR_LINE_1 VARCHAR2 (240) Yes Line 1 of the address
ADDR_LINE_2 VARCHAR2 (240)
Line 2 of the address
ADDR_LINE_3 VARCHAR2 (240)
Line 3 of the address
ADDR_LINE_4 VARCHAR2 (240)
Line 4 of the address
CITY VARCHAR2 (60)
Name of the city
STATE VARCHAR2 (60)
Name of the state
PROVINCE VARCHAR2 (60)
Name of the province
COUNTY VARCHAR2 (60)
Name of the county
COUNTRY VARCHAR2 (60) Yes Name of the country
POSTAL_CODE VARCHAR2 (60)
Postal code of the address
DELIVERY_POINT_CODE VARCHAR2 (50)
Delivery point code
OTHER_DETAILS_1 VARCHAR2 (0)
Obsolete
OTHER_DETAILS_2 VARCHAR2 (0)
Obsolete
OTHER_DETAILS_3 VARCHAR2 (0)
Obsolete
LOCATION_OVN NUMBER

Object Version Number of HZ_LOCATIONS
PARTY_SITE_OVN NUMBER

Object Version Number of HZ_PARTY_SITES
Query Text

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


SELECT ROW_ID
,      PERSON_ID
,      PERSON_NUMBER
,      PARTY_SITE_ID
,      LOCATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ORIG_SYSTEM_REFERENCE
,      START_DT
,      END_DT
,      ADDRESS_EFFECTIVE_DATE
,      ADDRESS_EXPIRATION_DATE
,      MAILSTOP
,      IDENTIFYING_ADDRESS_FLAG
,      PARTY_SITE_LANGUAGE
,      STATUS
,      PARTY_SITE_NAME
,      ADDRESS_KEY
,      ADDRESS_STYLE
,      VALIDATED_FLAG
,      ADDRESS_LINES_PHONETIC
,      PO_BOX_NUMBER
,      HOUSE_NUMBER
,      STREET_SUFFIX
,      STREET
,      STREET_NUMBER
,      FLOOR
,      SUITE
,      POSTAL_PLUS4_CODE
,      POSITION
,      LOCATION_DIRECTIONS
,      CLLI_CODE
,      LOCATION_LANGUAGE
,      SHORT_DESCRIPTION
,      DESCRIPTION
,      LOCATION_CONTENT_SOURCE_TYPE
,      SALES_TAX_GEOCODE
,      SALES_TAX_INSIDE_CITY_LIMITS
,      DATE_LAST_VERIFIED
,      CORRESPONDENCE_IND
,      ADDR_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      DELIVERY_POINT_CODE
,      OTHER_DETAILS_1
,      OTHER_DETAILS_2
,      OTHER_DETAILS_3
,      LOCATION_OVN
,      PARTY_SITE_OVN
FROM APPS.IGS_PE_PERSON_ADDR;

Dependencies

[top of page]

APPS.IGS_PE_PERSON_ADDR references the following:

SchemaAPPS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_PARTY_SITE_USES
SynonymIGS_PE_HZ_PTY_SITES
APPS.IGS_PE_PERSON_ADDR is referenced by following:

SchemaAPPS
Package BodyIGF_SL_CL_ORIG_ACK - show dependent code
Package BodyIGR_VAL_EAP - show dependent code
Package BodyIGS_AD_ADM_REQ - show dependent code
Package BodyIGS_AD_GEN_007 - show dependent code
Package BodyIGS_AD_PRC_TAC_OFFER - show dependent code
Package BodyIGS_AS_GEN_006 - show dependent code
Package BodyIGS_EN_NSC_PKG - show dependent code
Package BodyIGS_GE_GEN_004 - show dependent code
ViewIGS_PE_PERSON_ADDR_GOVT_PERM_V
ViewIGS_PE_PERSON_ADDR_GOVT_POST_V
ViewIGS_SS_PERSON_SEARCH_V