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_OR_ADDR

Object Details

Object Name:	IGS_OR_ADDR
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_OR_ADDR
Subobject Name:
Status:	VALID

View Type

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

IGS_OR_ADDR is used to capture the details of address

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Uniquely identifies a row
ORG_UNIT_CD	VARCHAR2	(30)		Organization unit code that uniquely identifies an organization
OU_START_DT	DATE			Start date of an organization unit association
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_TYPE	VARCHAR2	(30)		Address type of an address, for example, Postal or e-mail
ADDR_LINE_1	VARCHAR2	(240)	Yes	First line of address
ADDR_LINE_2	VARCHAR2	(240)		Second line of address
ADDR_LINE_3	VARCHAR2	(240)		Third line of address
ADDR_LINE_4	VARCHAR2	(240)		Fourth line of address
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
DATE_LAST_VERIFIED	DATE			Obsolete
CORRESPONDENCE_IND	VARCHAR2	(1)	Yes	Indicates if the address is a correspondence address or not
CITY	VARCHAR2	(60)		Captures the 'City' of address
STATE	VARCHAR2	(60)		Captures the address for a particular address type
PROVINCE	VARCHAR2	(60)		Captures the address for a particular address type
COUNTY	VARCHAR2	(60)		Captures the address for a particular address type
COUNTRY	VARCHAR2	(60)	Yes	Captures the address for a particular address type
POSTAL_CODE	VARCHAR2	(60)		Captures the address for a particular address type
DELIVERY_POINT_CODE	VARCHAR2	(50)		Captures the address for a particular address type
OTHER_DETAILS_1	VARCHAR2	(0)		Obsolete
OTHER_DETAILS_2	VARCHAR2	(0)		Obsolete
OTHER_DETAILS_3	VARCHAR2	(0)		Obsolete
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program
STATUS	VARCHAR2	(1)	Yes	Status, Active or Inactive, of the Party Site

Query Text

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


SELECT ROW_ID
,      ORG_UNIT_CD
,      OU_START_DT
,      START_DT
,      END_DT
,      ADDR_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DATE_LAST_VERIFIED
,      CORRESPONDENCE_IND
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      DELIVERY_POINT_CODE
,      OTHER_DETAILS_1
,      OTHER_DETAILS_2
,      OTHER_DETAILS_3
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      STATUS
FROM APPS.IGS_OR_ADDR;

Dependencies

[top of page]

APPS.IGS_OR_ADDR references the following:

APPS: HZ_LOCATIONS; HZ_PARTY_SITES; HZ_PARTY_SITE_USES; IGS_OR_INST_ORG_BASE_V; IGS_PE_HZ_PTY_SITES

APPS.IGS_OR_ADDR is referenced by following:

APPS: IGS_GE_GEN_001 - show dependent code; IGS_GE_GEN_002 - show dependent code; IGS_OR_ADDR_PKG - show dependent code; IGS_OR_VAL_OA - show dependent code