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_DA_XML_PERSON_V

Object Details

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

View Type

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

XML element PersonType

[View Source]

Columns

Name	Datatype	Length	Comments
PERSON_CODE_QUALIFIER	VARCHAR2	(10)	Contains a value indicating the type of PersonIdCode being passed.
PERSON_ID_CODE	VARCHAR2	(30)	Contains the value of the Person ID
NAME_TYPE	VARCHAR2	(30)	Contains a value indicating the type of PersonName being passed.
NAME_TITLE	VARCHAR2	(30)	Contains the title of the person.
NAME_FIRST	VARCHAR2	(150)	Contains the first name of the person.
NAME_MIDDLE	VARCHAR2	(60)	Contains the middle name of the person.
NAME_LAST	VARCHAR2	(150)	Contains the surname of the person.
NAME_SUFFIX	VARCHAR2	(30)	Contains the suffix of the person.
ADDRESS_TYPE	VARCHAR2	(30)	Contains a value indicating the type of address.
ADDRESS_LINE_1	VARCHAR2	(240)	Contains the first line of the address.
ADDRESS_LINE_2	VARCHAR2	(240)	Contains the second line of the address
ADDRESS_LINE_3	VARCHAR2	(240)	Contains the third line of the address.
ADDRESS_LINE_4	VARCHAR2	(240)	Contains the fourth line of the address.
ADDRESS_CITY	VARCHAR2	(60)	Contains the city of the address.
ADDRESS_STATE_PROVINCE	VARCHAR2	(120)	Contains the state or province of the address.
ADDRESS_POSTAL_CODE	VARCHAR2	(60)	Contains the postal code of the address.
ADDRESS_COUNTRY	VARCHAR2	(60)	Contains the country of the address.
BATCH_ID	NUMBER		Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID	NUMBER	(15)	Describes the details of the person ID code that is being passed.

Query Text

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


SELECT PERSON_CODE_QUALIFIER
,      PERSON_ID_CODE
,      NAME_TYPE
,      NAME_TITLE
,      NAME_FIRST
,      NAME_MIDDLE
,      NAME_LAST
,      NAME_SUFFIX
,      ADDRESS_TYPE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      ADDRESS_LINE_4
,      ADDRESS_CITY
,      ADDRESS_STATE_PROVINCE
,      ADDRESS_POSTAL_CODE
,      ADDRESS_COUNTRY
,      BATCH_ID
,      PERSON_ID
FROM APPS.IGS_DA_XML_PERSON_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_PERSON_V references the following:

APPS: HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_PARTY_SITE_USES; IGS_DA_REQ_FTRS; IGS_DA_REQ_STDNTS; IGS_DA_RQST; IGS_DA_SETUP; IGS_PE_ALT_PERS_ID; IGS_PE_HZ_PTY_SITES

APPS.IGS_DA_XML_PERSON_V is referenced by following:

APPS: IGS_DA_XML_PKG - show dependent code