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_CONTACTS_V

Object Details

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

View Type

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

Describes the institution Contact Details

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Indicates the Row Identifier
CONTACT_ID	NUMBER			No longer Used
REL_PARTY_ID	NUMBER	(15)		Indicates the party identifier for the relationship created between person and organization and is stored as party identifier in HZ_PARTIES
STATUS	VARCHAR2	(1)	Yes	Indicates the Contact Person's Status
ORIG_SYSTEM_REFERENCE	VARCHAR2	(0)		No longer Used
PERSON_NUMBER	VARCHAR2	(30)	Yes	Indicates the Contact Person's Number
FULL_NAME	VARCHAR2	(450)		Indicates the Contact Person's Full Name
TITLE	VARCHAR2	(30)		Indicates the Contact Person's Title
TITLE_MEANING	VARCHAR2	(0)		Indicates the Contact Person's Title
MAIL_STOP	VARCHAR2	(60)		Indicates the Contact Person's Mailing address
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flex field structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flex field segment column
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flex field segment column
REFERENCE_USE_FLAG	VARCHAR2	(1)		Indicates the reference usage
CONTACT_NUMBER	VARCHAR2	(30)		Indicates the Organization Contact Number
PRIMARY_ROLE	VARCHAR2	(0)		No longer Used
EMAIL_ADDRESS	VARCHAR2	(2000)		Indicates the Contact Person's Email Address
CONTACT_PARTY_ID	NUMBER	(15)	Yes	Indicates the Contact Person's Person Identifier
ORG_CONTACT_ID	NUMBER	(15)	Yes	Indicates the Organization Contact Identifier
RELATIONSHIP_ID	NUMBER	(15)	Yes	Indicates therelationship identifier for the relationship created between person and organization and is stored as relationship identifier in HZ_RELATIONSHIPS
ORG_PARTY_ID	NUMBER	(15)	Yes	Indicates the organization party identifier
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
ORG_ROLE_OVN	NUMBER			No longer Used
REL_OVN	NUMBER			HZ_RELATIONSHIPS Object version number ,internally used for locking the record
REL_PARTY_OVN	NUMBER			HZ_PARTIES Object version number ,internally used for locking the record
ORG_CONT_OVN	NUMBER			HZ_ORG_CONTACTS Object version number ,internally used for locking the record

Query Text

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


SELECT ROW_ID
,      CONTACT_ID
,      REL_PARTY_ID
,      STATUS
,      ORIG_SYSTEM_REFERENCE
,      PERSON_NUMBER
,      FULL_NAME
,      TITLE
,      TITLE_MEANING
,      MAIL_STOP
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      REFERENCE_USE_FLAG
,      CONTACT_NUMBER
,      PRIMARY_ROLE
,      EMAIL_ADDRESS
,      CONTACT_PARTY_ID
,      ORG_CONTACT_ID
,      RELATIONSHIP_ID
,      ORG_PARTY_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ROLE_OVN
,      REL_OVN
,      REL_PARTY_OVN
,      ORG_CONT_OVN
FROM APPS.IGS_OR_CONTACTS_V;

Dependencies

[top of page]

APPS.IGS_OR_CONTACTS_V references the following:

APPS: HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS; IGS_PE_PERSON_BASE_V

APPS.IGS_OR_CONTACTS_V is referenced by following:

APPS: IGS_OR_INST_IMP_003_PKG - show dependent code