View: ASF_PRODUCT_INTERESTS_V

View Text

SELECT INT.INTEREST_ID
, INT.INTEREST_TYPE_ID
, INT.CUSTOMER_ID
, INT.ADDRESS_ID
, INT.CONTACT_ID
, INT.PRIMARY_INTEREST_CODE_ID
, INT.SECONDARY_INTEREST_CODE_ID
, TYP.INTEREST_TYPE
, INT.DESCRIPTION
, TYP.MASTER_ENABLED_FLAG
, TYP.CONTACT_INTEREST_FLAG
, INT.LAST_UPDATE_DATE
FROM AS_INTERESTS_ALL INT
, AS_INTEREST_TYPES_V TYP
, AS_INTEREST_CODES_V PRI
, AS_INTEREST_CODES_V SEC
WHERE INT.INTEREST_TYPE_ID = TYP.INTEREST_TYPE_ID
AND INT.PRIMARY_INTEREST_CODE_ID = PRI.INTEREST_CODE_ID (+)
AND INT.SECONDARY_INTEREST_CODE_ID = SEC.INTEREST_CODE_ID (+)
AND TYP.MASTER_ENABLED_FLAG = 'Y'
AND TYP.CONTACT_INTEREST_FLAG = 'Y'

Columns