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

VIEW: APPS.AS_PRIMARY_INTERESTS_ACTIVE_V

Object Details
Object Name: AS_PRIMARY_INTERESTS_ACTIVE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_PRIMARY_INTERESTS_ACTIVE_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

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTEREST_CODE_ID NUMBER
Yes Interest code identifier
CODE VARCHAR2 (100) Yes Interest code
INTEREST_TYPE_ID NUMBER
Yes Interest type identifier
INTEREST_TYPE VARCHAR2 (80) Yes Type of interest item
DESCRIPTION VARCHAR2 (240)
Interest type description
COMPANY_CLASSIFICATION_FLAG VARCHAR2 (1)
Company classification flag
CONTACT_INTEREST_FLAG VARCHAR2 (1)
Contact interest flag
LEAD_CLASSIFICATION_FLAG VARCHAR2 (1)
Lead classification flag
EXPECTED_PURCHASE_FLAG VARCHAR2 (1)
Expected purchase flag
CURRENT_ENVIRONMENT_FLAG VARCHAR2 (1)
This column indicates if the corresponding primary interest code is valid in the current environment context
Query Text

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


SELECT INTEREST_CODE_ID
,      CODE
,      INTEREST_TYPE_ID
,      INTEREST_TYPE
,      DESCRIPTION
,      COMPANY_CLASSIFICATION_FLAG
,      CONTACT_INTEREST_FLAG
,      LEAD_CLASSIFICATION_FLAG
,      EXPECTED_PURCHASE_FLAG
,      CURRENT_ENVIRONMENT_FLAG
FROM APPS.AS_PRIMARY_INTERESTS_ACTIVE_V;

Dependencies

[top of page]

APPS.AS_PRIMARY_INTERESTS_ACTIVE_V references the following:

SchemaAPPS
ViewAS_INTEREST_CODES_V
ViewAS_INTEREST_TYPES_VL

APPS.AS_PRIMARY_INTERESTS_ACTIVE_V is not referenced by any database object