SELECT TO_CHAR(interest_type_ID) ID , interest_type VALUE , interest_type_ID interest_type_ID , interest_type interest_type from as_interest_types_v WHERE expected_purchase_flag = 'Y' and master_enabled_flag = 'Y'
View Text - HTML Formatted
SELECT TO_CHAR(INTEREST_TYPE_ID) ID , INTEREST_TYPE VALUE , INTEREST_TYPE_ID INTEREST_TYPE_ID , INTEREST_TYPE INTEREST_TYPE FROM AS_INTEREST_TYPES_V WHERE EXPECTED_PURCHASE_FLAG = 'Y' AND MASTER_ENABLED_FLAG = 'Y'