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.

[Home] [Help]

View: AS_SECOND_INTERESTS_ACTIVE_V

Product:	AS - Sales Foundation
Description:	Active secondary interests view
Implementation/DBA Data:	APPS.AS_SECOND_INTERESTS_ACTIVE_V

View Text

SELECT SIC.INTEREST_CODE_ID
, SIC.PARENT_INTEREST_CODE_ID
, SIC.CODE
, SIC.INTEREST_TYPE_ID
, INTTYPE.INTEREST_TYPE
, SIC.DESCRIPTION
, PIC.CODE
, INTTYPE.COMPANY_CLASSIFICATION_FLAG
, INTTYPE.CONTACT_INTEREST_FLAG
, INTTYPE.LEAD_CLASSIFICATION_FLAG
, INTTYPE.EXPECTED_PURCHASE_FLAG
, INTTYPE.CURRENT_ENVIRONMENT_FLAG
, SIC.PF_ITEM_ID
, SIC.PF_ORGANIZATION_ID
, SIC.PRICE
FROM AS_INTEREST_TYPES_VL INTTYPE
, AS_INTEREST_CODES_V SIC
, AS_INTEREST_CODES_V PIC
WHERE SIC.MASTER_ENABLED_FLAG = 'Y'
AND PIC.MASTER_ENABLED_FLAG = 'Y'
AND INTTYPE.MASTER_ENABLED_FLAG = 'Y'
AND SIC.PARENT_INTEREST_CODE_ID = PIC.INTEREST_CODE_ID
AND SIC.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID

Columns

Name
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