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.IGF_SL_ADDR_V

Object Details

Object Name:	IGF_SL_ADDR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_SL_ADDR_V
Subobject Name:
Status:	VALID

View Type

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

IGF_SL_ADDR_V selects all the details required to obtain the permanent and temporary addresses of a person from the TCA. The address attributes are used for the US only. The column value
SITE_USE_TYPE = HOME specifies the permanent address, and RESIDES AT will specifies the local address.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person identifier
SITE_USE_TYPE	VARCHAR2	(30)	Yes	Indicates whether person's address is permanent address or local address
ADDR_LINE_1	VARCHAR2	(240)	Yes	Indicates person's address line 1
ADDR_LINE_2	VARCHAR2	(240)		Indicates person's address line 2
ADDR_LINE_3	VARCHAR2	(240)		Indicates person's address line 3
ADDR_LINE_4	VARCHAR2	(240)		Indicates person's address line 4
CITY	VARCHAR2	(60)		Indicates person's address city
STATE	VARCHAR2	(60)		Indicates person's address state
PROVINCE	VARCHAR2	(60)		Indicates person's address province
COUNTY	VARCHAR2	(60)		Indicates person's address county
COUNTRY	VARCHAR2	(60)	Yes	Indicates person's address country
POSTAL_CODE	VARCHAR2	(60)		Indicates person's address zip code
LAST_UPDATE_DATE	DATE		Yes	Indicates date on which address details last changed

Query Text

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


SELECT PERSON_ID
,      SITE_USE_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      LAST_UPDATE_DATE
FROM APPS.IGF_SL_ADDR_V;

Dependencies

[top of page]

APPS.IGF_SL_ADDR_V references the following:

APPS: HZ_LOCATIONS; HZ_PARTY_SITES; HZ_PARTY_SITE_USES

APPS.IGF_SL_ADDR_V is referenced by following:

APPS: IGF_SL_LOCAL_INST_V; IGF_SL_LOR_DTLS_V; IGF_SL_PRK_LOAN_V