DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AMS_ORG_CONTACT_DETAILS_V

Object Details
Object Name: AMS_ORG_CONTACT_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_ORG_CONTACT_DETAILS_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
CONTACT_ID NUMBER (15) Yes Contact Indetifier
ORGANIZATION_ID NUMBER (15) Yes Organization Identifier
PARTY_ID NUMBER (15)
Party Identifier
CONTACT_NUMBER VARCHAR2 (30)
Contact Number
PARTY_CONTACT_NUMBER VARCHAR2 (30) Yes Party Contact Number
PARTY_CONTACT_NAME VARCHAR2 (360) Yes Name of the party contact
PARTY_TYPE VARCHAR2 (30) Yes The party type can only be Person, Organization, Group or Relationship.
VALIDATED_FLAG VARCHAR2 (1)
Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
PARTY_SITE_ID NUMBER (15)
Site Identifier Of the Party
STATUS VARCHAR2 (1) Yes Party status flag.
RELATIONSHIP_TYPE VARCHAR2 (30) Yes The party type can only be Person, Organization, Group or Relationship.
RELATIONSHIP_CODE VARCHAR2 (30) Yes code used to describe relationships. For example, CUSTOMER_OF
EMAIL_ADDRESS VARCHAR2 (2000)
E-mail address
DECISION_MAKER_FLAG VARCHAR2 (1)
Indicates if this contact is a decision maker. Y for a decision maker, N for someone who is not the decision maker.
REFERENCE_USE_FLAG VARCHAR2 (1)
Indicates if this contact can be used as a reference. Y for a contact who will act as a reference, N for a contact who cannot act as a reference.
RANK VARCHAR2 (30)
Importance of the contact relative to other contacts
CUSTOMER_KEY VARCHAR2 (500)
Derived key used to facilitate fuzzy searches
SIC_CODE VARCHAR2 (30)
Standard Industry Classification (SIC) code
SIC_CODE_TYPE VARCHAR2 (30)
Version of Standard Industry Classification (SIC) code
TITLE VARCHAR2 (80)
A professional or family title. For example, Don or The Right Honorable.
JOB_TITLE VARCHAR2 (100)
Job title of the contact
JOB_TITLE_CODE VARCHAR2 (30)
Code given to the job title
DEPARTMENT VARCHAR2 (60)
Free form text used to name the department
DEPARTMENT_CODE VARCHAR2 (30)
List of values for possible department codes
MANAGED_BY NUMBER (15)
Full name of the person's manager. Foreign key to the HZ_PARTIES table.
MAILING_ADDRESS_ID NUMBER (15)
Identifier of the contact's preferred private mailing address.
MAIL_STOP VARCHAR2 (60)
Mail Stop
URL VARCHAR2 (2000)
Uniform resource locator
SALUTATION VARCHAR2 (60)
Phrase used to address a party in any correspondence.
PERSON_PRE_NAME_ADJUNCT VARCHAR2 (30)
Salutary introduction, such as Mr. or Herr
PERSON_FIRST_NAME VARCHAR2 (150)
First name of the person
PERSON_MIDDLE_NAME VARCHAR2 (60)
Middle name of the person
PERSON_LAST_NAME VARCHAR2 (150)
Last name of the person
PERSON_NAME_SUFFIX VARCHAR2 (30)
Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
PERSON_TITLE VARCHAR2 (60)
A professional or family title. For example, Don or The Right Honorable.
PERSON_ACADEMIC_TITLE VARCHAR2 (30)
Academic title that is part of a person's name, such as Dr. John Smith.
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous last or surname of the person
KNOWN_AS VARCHAR2 (240)
An alias or other name by which a party is known
PERSON_IDEN_TYPE VARCHAR2 (30)
Lookup representing most common personal identification number in a country. For example, Social Security Number in the US
PERSON_IDENTIFIER VARCHAR2 (60)
Identity reference field for things like Social Security, tax identity number, or driver's license number.
ADDRESS1 VARCHAR2 (240)
First line of the Identifying address
ADDRESS2 VARCHAR2 (240)
Second line of the Identifying address
ADDRESS3 VARCHAR2 (240)
Third line of the Identifying address
ADDRESS4 VARCHAR2 (240)
Fourth line of the Identifying address
CITY VARCHAR2 (60)
Cisty
STATE VARCHAR2 (60)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
PROVINCE VARCHAR2 (60)
Province of the Identifying address
COUNTY VARCHAR2 (60)
County of the Identifying address
COUNTRY VARCHAR2 (60)
Country of the Identifying address
COUNTRY_NAME CHAR (1)
Country Name of the Identifying address
DUNS_NUMBER NUMBER

The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet
HQ_BRANCH_IND VARCHAR2 (30)
Status of this site. Identifies if the location is the headquarters, a branch, or a single location.
TAX_NAME VARCHAR2 (60)
The name for the party that is recognized by the tax authority.
TAX_REFERENCE VARCHAR2 (50)
Taxpayer identification number
GROUP_TYPE VARCHAR2 (30)
Lookup for group type
MATCH_GROUP_ID NUMBER (15)
Identifier of the group of contact records that represents the same person
NATIVE_LANGUAGE VARCHAR2 (30)
Language spoken by the contact
OTHER_LANGUAGE_1 VARCHAR2 (30)
Mailing language
OTHER_LANGUAGE_2 VARCHAR2 (30)
Mailing language
JGZZ_FISCAL_CODE VARCHAR2 (20)
Provides the fiscal code for an organization. This code is used in some European countries.
RELATIONSHIP_ID NUMBER (15) Yes Relationship Identifier
ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Customer identifier from foreign system. May not be unique.
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATED_BY_NAME NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATED_BY_NAME NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN_NAME NUMBER (15)
Standard Who column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last date this record was updated by a concurrent program
WH_UPDATE_DATE DATE

Date when the record was entered or changed in a data warehouse
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure definition
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Reserved for country-specific functionality
GENDER VARCHAR2 (30)
PHONE_COUNTRY_CODE VARCHAR2 (10)
PHONE_AREA_CODE VARCHAR2 (10)
PHONE_NUMBER VARCHAR2 (40)
PHONE_EXTENSION VARCHAR2 (20)
ROLE_TYPE VARCHAR2 (30)
PERSON_PARTY_ID NUMBER (15) Yes
ORGANIZATION_PARTY_NAME VARCHAR2 (360) Yes
Query Text

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


SELECT CONTACT_ID
,      ORGANIZATION_ID
,      PARTY_ID
,      CONTACT_NUMBER
,      PARTY_CONTACT_NUMBER
,      PARTY_CONTACT_NAME
,      PARTY_TYPE
,      VALIDATED_FLAG
,      PARTY_SITE_ID
,      STATUS
,      RELATIONSHIP_TYPE
,      RELATIONSHIP_CODE
,      EMAIL_ADDRESS
,      DECISION_MAKER_FLAG
,      REFERENCE_USE_FLAG
,      RANK
,      CUSTOMER_KEY
,      SIC_CODE
,      SIC_CODE_TYPE
,      TITLE
,      JOB_TITLE
,      JOB_TITLE_CODE
,      DEPARTMENT
,      DEPARTMENT_CODE
,      MANAGED_BY
,      MAILING_ADDRESS_ID
,      MAIL_STOP
,      URL
,      SALUTATION
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      PERSON_ACADEMIC_TITLE
,      PERSON_PREVIOUS_LAST_NAME
,      KNOWN_AS
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      POSTAL_CODE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      COUNTRY_NAME
,      DUNS_NUMBER
,      HQ_BRANCH_IND
,      TAX_NAME
,      TAX_REFERENCE
,      GROUP_TYPE
,      MATCH_GROUP_ID
,      NATIVE_LANGUAGE
,      OTHER_LANGUAGE_1
,      OTHER_LANGUAGE_2
,      JGZZ_FISCAL_CODE
,      RELATIONSHIP_ID
,      ORIG_SYSTEM_REFERENCE
,      CREATION_DATE
,      CREATED_BY
,      CREATED_BY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATED_BY_NAME
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_LOGIN_NAME
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UPDATE_DATE
,      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
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GENDER
,      PHONE_COUNTRY_CODE
,      PHONE_AREA_CODE
,      PHONE_NUMBER
,      PHONE_EXTENSION
,      ROLE_TYPE
,      PERSON_PARTY_ID
,      ORGANIZATION_PARTY_NAME
FROM APPS.AMS_ORG_CONTACT_DETAILS_V;

Dependencies

[top of page]

APPS.AMS_ORG_CONTACT_DETAILS_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymHZ_CONTACT_POINTS
SynonymHZ_ORG_CONTACTS
SynonymHZ_ORG_CONTACT_ROLES
SynonymHZ_PARTIES
SynonymHZ_PERSON_PROFILES
SynonymHZ_RELATIONSHIPS

APPS.AMS_ORG_CONTACT_DETAILS_V is not referenced by any database object