View: AS_PRIMARY_INTERESTS_ACTIVE_V

Product:	AS - Sales Foundation
Description:	Active primary interest codes view
Implementation/DBA Data:	APPS.AS_PRIMARY_INTERESTS_ACTIVE_V

View Text

SELECT IC.INTEREST_CODE_ID
, IC.CODE
, IC.INTEREST_TYPE_ID
, INTTYPE.INTEREST_TYPE
, IC.DESCRIPTION
, INTTYPE.COMPANY_CLASSIFICATION_FLAG
, INTTYPE.CONTACT_INTEREST_FLAG
, INTTYPE.LEAD_CLASSIFICATION_FLAG
, INTTYPE.EXPECTED_PURCHASE_FLAG
, INTTYPE.CURRENT_ENVIRONMENT_FLAG
FROM AS_INTEREST_TYPES_VL INTTYPE
, AS_INTEREST_CODES_V IC
WHERE IC.MASTER_ENABLED_FLAG = 'Y'
AND INTTYPE.MASTER_ENABLED_FLAG = 'Y'
AND IC.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID
AND IC.PARENT_INTEREST_CODE_ID IS NULL

Columns