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

VIEW: APPS.AMS_PERSON_INTEREST_V

Object Details
Object Name: AMS_PERSON_INTEREST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_PERSON_INTEREST_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_INTEREST_ID NUMBER (15) Yes Unique identifier of the person's interest
PARTY_ID NUMBER (15) Yes Identifier for the party. Foreign key to the HZ_PARTIES table.
INTEREST_NAME VARCHAR2 (240) Yes A text field that lets you assign a descriptive name to an interest. For example, pets, dogs, baseball, or sports car racing.
LEVEL_OF_INTEREST VARCHAR2 (30)
User-defined level number or name to rate the amount of interest in the activity. For example, high, medium, or low.
LEVEL_OF_PARTICIPATION VARCHAR2 (30)
User-defined level number or name to indicate if the person participates and to what extent
INTEREST_TYPE_CODE VARCHAR2 (30)
A code to classify interests for evaluation
SUB_INTEREST_TYPE_CODE VARCHAR2 (30)
A code to classify subinterests of the interest type code.
TEAM VARCHAR2 (240)
Any team the person likes to watch or play for.
SINCE DATE

Approximate date the person became involved in this activity
Query Text

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


SELECT PERSON_INTEREST_ID
,      PARTY_ID
,      INTEREST_NAME
,      LEVEL_OF_INTEREST
,      LEVEL_OF_PARTICIPATION
,      INTEREST_TYPE_CODE
,      SUB_INTEREST_TYPE_CODE
,      TEAM
,      SINCE
FROM APPS.AMS_PERSON_INTEREST_V;

Dependencies

[top of page]

APPS.AMS_PERSON_INTEREST_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_PERSON_INTEREST

APPS.AMS_PERSON_INTEREST_V is not referenced by any database object