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

Object Details

Object Name:	AMS_PERSON_RELATIONSHIPS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_PERSON_RELATIONSHIPS_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

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Party identifier
PARTY_ID	NUMBER	(15)		Party identifier
PERSON_NAME	VARCHAR2	(360)	Yes	Person Name
LAST_NAME	VARCHAR2	(150)		Last Name of person.
FIRST_NAME	VARCHAR2	(150)		First Name of person.
MIDDLE_NAME	VARCHAR2	(60)		Middle name of person.
PREFERRED_NAME	VARCHAR2	(240)		Preferred name of person.
STATUS_CODE	VARCHAR2	(1)	Yes	Party status flag.
LAST_ORDER_DATE	DATE			Date of the most recent order
RELATED_PARTY_ID	NUMBER	(15)	Yes	The party identifier of the object in this relationship
RELATED_PARTY_TYPE	VARCHAR2	(30)	Yes	Object type of the relationship
RELATED_PARTY_NAME	VARCHAR2	(360)	Yes	Related party name
RELATIONSHIP_ID	NUMBER	(15)	Yes	The unique identifier of this relationship
RELATIONSHIP_TYPE	VARCHAR2	(30)	Yes	The relationship type name
CONCATENATED_PHONE	VARCHAR2	(88)		Concatenated phone for party
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Phone country code.
PHONE_AREA_CODE	VARCHAR2	(10)		Phone area code for party in relationship.
PHONE_NUMBER	VARCHAR2	(40)		Phone number for party in relationship.
PHONE_EXTENSION	VARCHAR2	(20)		Phone extension for party in relationship.
PHONE_TYPE	VARCHAR2	(30)		Phone type for party in relationship.
EMAIL_ADDRESS	VARCHAR2	(2000)		email address
CONCATENATED_ADDRESS	VARCHAR2	(1211)		Concatenated address
ADDRESS	VARCHAR2	(963)		address
ADDRESS1	VARCHAR2	(240)		First line of address for party in relationship.
ADDRESS2	VARCHAR2	(240)		Second line of address for party in relationship.
ADDRESS3	VARCHAR2	(240)		Third line of address for party in relationship.
ADDRESS4	VARCHAR2	(240)		Fourth line of address for party in relationship.
STATE	VARCHAR2	(60)		State of party in relationship.
CITY	VARCHAR2	(60)		City of party in relationship.
PROVINCE	VARCHAR2	(60)		Province of party in relationship.
COUNTY	VARCHAR2	(60)		County of party in relationship.
POSTAL_CODE	VARCHAR2	(60)		Postal code of party in relationship.
COUNTRY	VARCHAR2	(60)		Country of party in relationship.
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column

Query Text

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


SELECT PERSON_ID
,      PARTY_ID
,      PERSON_NAME
,      LAST_NAME
,      FIRST_NAME
,      MIDDLE_NAME
,      PREFERRED_NAME
,      STATUS_CODE
,      LAST_ORDER_DATE
,      RELATED_PARTY_ID
,      RELATED_PARTY_TYPE
,      RELATED_PARTY_NAME
,      RELATIONSHIP_ID
,      RELATIONSHIP_TYPE
,      CONCATENATED_PHONE
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      PHONE_TYPE
,      EMAIL_ADDRESS
,      CONCATENATED_ADDRESS
,      ADDRESS
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      STATE
,      CITY
,      PROVINCE
,      COUNTY
,      POSTAL_CODE
,      COUNTRY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
FROM APPS.AMS_PERSON_RELATIONSHIPS_V;

Dependencies

[top of page]

APPS.AMS_PERSON_RELATIONSHIPS_V references the following:

APPS: HZ_CONTACT_POINTS; HZ_ORG_CONTACTS; HZ_PARTIES; HZ_RELATIONSHIPS

APPS.AMS_PERSON_RELATIONSHIPS_V is not referenced by any database object