Product: | AS - Sales Foundation |
---|---|
Description: | Active secondary interests view |
Implementation/DBA Data: | APPS.AS_SECOND_INTERESTS_ACTIVE_V |
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