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_PERSONS_V

Object Details

Object Name:	AMS_PERSONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_PERSONS_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)	Yes	Party identifier
PERSON_NAME	VARCHAR2	(360)	Yes	Name of this person
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
CONCATENATED_PHONE	VARCHAR2	(88)		Concatenated phone number of person including country,area codes and number with extension.
PHONE_COUNTRY_CODE	VARCHAR2	(10)		Phone Country Code.
PHONE_AREA_CODE	VARCHAR2	(10)		Phone area code.
PHONE_NUMBER	VARCHAR2	(40)		A telephone number formatted in the local format. The number should not include area code, country code, or extension.
PHONE_EXTENSION	VARCHAR2	(20)		Additional number addressed after initial connection to an internal telephone system
PHONE_TYPE	VARCHAR2	(30)		Lookup code for the type of phone line. For example, general, fax, inbound, or outbound.
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address of the person
CONCATENATED_ADDRESS	VARCHAR2	(1211)		Concatenated address of person including all address lines,city ,country and postal code.
ADDRESS	VARCHAR2	(963)		Person address
ADDRESS1	VARCHAR2	(240)		First line pf person address
ADDRESS2	VARCHAR2	(240)		Second line of person address
ADDRESS3	VARCHAR2	(240)		Third line of person address
ADDRESS4	VARCHAR2	(240)		Fourth line of person address
STATE	VARCHAR2	(60)		State
CITY	VARCHAR2	(60)		City
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
POSTAL_CODE	VARCHAR2	(60)		Postal code
COUNTRY	VARCHAR2	(60)		Country
LAST_ORDER_DATE	DATE			Date of the most recent order
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
,      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
,      LAST_ORDER_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
FROM APPS.AMS_PERSONS_V;

Dependencies

[top of page]

APPS.AMS_PERSONS_V references the following:

APPS: HZ_CONTACT_POINTS; HZ_PARTIES

APPS.AMS_PERSONS_V is not referenced by any database object