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

VIEW: APPS.IGS_PE_PERSON_ADDR_V

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

View Type

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


IGS_PE_PERSON_ADDR_V describes the person address details


[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
PERSON_NUMBER VARCHAR2 (30) Yes Unique number for each person
PARTY_SITE_ID NUMBER (15) Yes Uniquer 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 date of the concurrent program
WH_UPDATE_DATE DATE

Obsolete
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard attribute column, describing Flexfield
ATTRIBUTE1 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE2 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE3 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE4 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE5 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE6 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE7 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE8 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE9 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE10 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE11 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE12 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE13 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE14 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE15 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE16 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE17 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE18 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE19 VARCHAR2 (150)
Standard attribute column, describing Flexfield
ATTRIBUTE20 VARCHAR2 (150)
Standard attribute column, describing Flexfield
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 that the address becomes effective
ADDRESS_EXPIRATION_DATE DATE

Date that the address is expired
MAILSTOP VARCHAR2 (60)
Mail stop of the address
IDENTIFYING_ADDRESS_FLAG VARCHAR2 (1) Yes Flag to identify the address
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)
Key of the address
ADDRESS_STYLE VARCHAR2 (30)
Style of the address
VALIDATED_FLAG VARCHAR2 (1)
Flag indicates if 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
HOUSE_NUMBER VARCHAR2 (50)
House number
STREET_SUFFIX VARCHAR2 (50)
Suffix of the street
STREET VARCHAR2 (50)
Street name of the address
STREET_NUMBER VARCHAR2 (50)
Number of the street
FLOOR VARCHAR2 (50)
Name of the floor
SUITE VARCHAR2 (50)
Name of the suite
POSTAL_PLUS4_CODE VARCHAR2 (10)
Postal code
POSITION VARCHAR2 (50)
Position of the address
LOCATION_DIRECTIONS VARCHAR2 (640)
Directions for the location
CLLI_CODE VARCHAR2 (60)
CLLI code
LOCATION_LANGUAGE VARCHAR2 (4)
Language at the location
SHORT_DESCRIPTION VARCHAR2 (240)
Short description of the address
DESCRIPTION VARCHAR2 (2000)
Description of the address
LOCATION_CONTENT_SOURCE_TYPE VARCHAR2 (30) Yes Source type of the location content
SALES_TAX_GEOCODE VARCHAR2 (30)
Geological code of the sales tax
SALES_TAX_INSIDE_CITY_LIMITS VARCHAR2 (30)
Sales tax inside city limits
DATE_LAST_VERIFIED DATE

Obsolete
CORRESPONDENCE_IND VARCHAR2 (1) Yes Flag indicates if the address could be used for correspondence
ADDR_TYPE VARCHAR2 (30)
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
COUNTRY_DESC VARCHAR2 (80) Yes Country Description that is visible to the user.
POSTAL_CODE VARCHAR2 (60)
Postal code of the address
DELIVERY_POINT_CODE VARCHAR2 (50)
Delivery point code of the address
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
,      COUNTRY_DESC
,      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_V;

Dependencies

[top of page]

APPS.IGS_PE_PERSON_ADDR_V references the following:

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

SchemaAPPS
Package BodyIGS_AD_IMP_002 - show dependent code
Package BodyIGS_AD_PRC_TAC_OFFER - show dependent code
Package BodyIGS_GE_GEN_001 - show dependent code
Package BodyIGS_GE_GEN_002 - show dependent code