VIEW: APPS.AS_SECOND_INTERESTS_ACTIVE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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