VIEW: APPS.AS_PRIMARY_INTERESTS_ACTIVE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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