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

Object Details

Object Name:	AS_SECOND_INTERESTS_ACTIVE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AS.AS_SECOND_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
PARENT_INTEREST_CODE_ID	NUMBER			Primary interest code identifier
CODE	VARCHAR2	(100)	Yes	Code describing the interest item
INTEREST_TYPE_ID	NUMBER		Yes	Interest type identifier
INTEREST_TYPE	VARCHAR2	(80)	Yes	Type of interest item
DESCRIPTION	VARCHAR2	(240)		Interest type description
PARENT_CODE	VARCHAR2	(100)	Yes	Code describing primary interest type
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 determines if the secondary interest code should be visible in the current environment context.
PF_ITEM_ID	NUMBER			Product Family item identifier
PF_ORGANIZATION_ID	NUMBER			Product Family organization
PRICE	NUMBER			price of secondary interest code

Query Text

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


SELECT INTEREST_CODE_ID
,      PARENT_INTEREST_CODE_ID
,      CODE
,      INTEREST_TYPE_ID
,      INTEREST_TYPE
,      DESCRIPTION
,      PARENT_CODE
,      COMPANY_CLASSIFICATION_FLAG
,      CONTACT_INTEREST_FLAG
,      LEAD_CLASSIFICATION_FLAG
,      EXPECTED_PURCHASE_FLAG
,      CURRENT_ENVIRONMENT_FLAG
,      PF_ITEM_ID
,      PF_ORGANIZATION_ID
,      PRICE
FROM APPS.AS_SECOND_INTERESTS_ACTIVE_V;

Dependencies

[top of page]

APPS.AS_SECOND_INTERESTS_ACTIVE_V references the following:

APPS: AS_INTEREST_CODES_V; AS_INTEREST_TYPES_VL

APPS.AS_SECOND_INTERESTS_ACTIVE_V is not referenced by any database object