eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGS_PE_SS_ADDR_V

Object Details

Object Name:	IGS_PE_SS_ADDR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PE_SS_ADDR_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 Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This Entity stores the Address of a Person created from Self Service Application

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Identifier for the party. Foreign key to the HZ_PARTIES table.
PARTY_SITE_ID	NUMBER	(15)	Yes	Party site identifier
LOCATION_ID	NUMBER	(15)	Yes	Identifier for the party site. Foreign key to the HZ_LOCATIONS table.
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
ADDR_LINE_1	VARCHAR2	(240)	Yes	First line for address
ADDR_LINE_2	VARCHAR2	(240)		Second line for address
ADDR_LINE_3	VARCHAR2	(240)		Third line for address
ADDR_LINE_4	VARCHAR2	(240)		Fourth line for address
CITY	VARCHAR2	(60)		City
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
COUNTRY_CD	VARCHAR2	(60)	Yes	Country code from the TERRITORY_CODE column in the FND_TERRITORY table
ADDRESS_STYLE	VARCHAR2	(30)		Used as context value for Flexible Address Format descriptive flexfield. Do not use this column, join to the FND_TERRITORIES table via COUNTRY = TERRITORY_CODE to retrieve the address style for the country.
ADDRESS_LINES_PHONETIC	VARCHAR2	(560)		Phonetic or Kana representation of the Kanji address lines (used in Japan)
DELIVERY_POINT_CODE	VARCHAR2	(50)		No longer used
COUNTRY	VARCHAR2	(80)	Yes	Country
POSTAL_CODE	VARCHAR2	(60)		Postal Code or Zip Code
SITE_USE_TYPE	VARCHAR2	(30)	Yes	Usage that is associated with the Address
DATE_LAST_VERIFIED	DATE			Obsolete
CORRESPONDENCE	VARCHAR2	(1)	Yes	Indicates whether the Address is used for Correspondance
OTHER_DETAILS_1	VARCHAR2	(0)		Obsolete
OTHER_DETAILS_2	VARCHAR2	(0)		Obsolete
OTHER_DETAILS_3	VARCHAR2	(0)		Obsolete
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 to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application Identifier that modified this record
PROGRAM_ID	NUMBER	(15)		Program Id
PROGRAM_UPDATE_DATE	DATE			Program Update Date
STATUS	VARCHAR2	(1)	Yes	Status, Active or Inactive, of the Party Site
STATUS_MEANING	VARCHAR2	(80)	Yes	Meaning of the Status of the Party Site
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 PERSON_ID
,      PARTY_SITE_ID
,      LOCATION_ID
,      START_DT
,      END_DT
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY_CD
,      ADDRESS_STYLE
,      ADDRESS_LINES_PHONETIC
,      DELIVERY_POINT_CODE
,      COUNTRY
,      POSTAL_CODE
,      SITE_USE_TYPE
,      DATE_LAST_VERIFIED
,      CORRESPONDENCE
,      OTHER_DETAILS_1
,      OTHER_DETAILS_2
,      OTHER_DETAILS_3
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS
,      STATUS_MEANING
,      LOCATION_OVN
,      PARTY_SITE_OVN
FROM APPS.IGS_PE_SS_ADDR_V;

Dependencies

[top of page]

APPS.IGS_PE_SS_ADDR_V references the following:

APPS: FND_LOOKUP_VALUES; FND_TERRITORIES_VL; HZ_LOCATIONS; HZ_PARTY_SITES; HZ_PARTY_SITE_USES; IGS_PE_HZ_PTY_SITES

APPS.IGS_PE_SS_ADDR_V is not referenced by any database object