[Home] [Help]
View: ASF_PRODUCT_INTERESTS_V
Product: | ASF - Sales Online |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
INTEREST_ID |
INTEREST_TYPE_ID |
CUSTOMER_ID |
ADDRESS_ID |
CONTACT_ID |
PRIMARY_INTEREST_CODE_ID |
SECONDARY_INTEREST_CODE_ID |
INTEREST_TYPE |
DESCRIPTION |
ENABLED_FLAG |
CONTACT_INTEREST_FLAG |
LAST_UPDATE_DATE |