Product: | AS - Sales Foundation |
---|---|
Description: | Interests view |
Implementation/DBA Data: | APPS.AS_INTERESTS_V |
SELECT INTEREST.ROWID
, INTEREST.INTEREST_ID
, INTEREST.LAST_UPDATE_DATE
, INTEREST.LAST_UPDATED_BY
, INTEREST.CREATION_DATE
, INTEREST.CREATED_BY
, INTEREST.LAST_UPDATE_LOGIN
, INTEREST.REQUEST_ID
, INTEREST.PROGRAM_APPLICATION_ID
, INTEREST.PROGRAM_ID
, INTEREST.PROGRAM_UPDATE_DATE
, INTEREST.INTEREST_USE_CODE
, INTEREST.INTEREST_TYPE_ID
, INTEREST.CONTACT_ID
, INTEREST.CUSTOMER_ID
, INTEREST.ADDRESS_ID
, INTEREST.PRIMARY_INTEREST_CODE_ID
, INTEREST.SECONDARY_INTEREST_CODE_ID
, INTEREST.STATUS_CODE
, INTEREST.DESCRIPTION
, INTTYPE.INTEREST_TYPE
, INTCODE1.CODE
, INTCODE2.CODE
, LKPCODE1.MEANING
, INTEREST.ATTRIBUTE_CATEGORY
, INTEREST.ATTRIBUTE1
, INTEREST.ATTRIBUTE2
, INTEREST.ATTRIBUTE3
, INTEREST.ATTRIBUTE4
, INTEREST.ATTRIBUTE5
, INTEREST.ATTRIBUTE6
, INTEREST.ATTRIBUTE7
, INTEREST.ATTRIBUTE8
, INTEREST.ATTRIBUTE9
, INTEREST.ATTRIBUTE10
, INTEREST.ATTRIBUTE11
, INTEREST.ATTRIBUTE12
, INTEREST.ATTRIBUTE13
, INTEREST.ATTRIBUTE14
, INTEREST.ATTRIBUTE15
FROM AS_LOOKUPS LKPCODE1
, AS_INTEREST_CODES_V INTCODE1
, AS_INTEREST_CODES_V INTCODE2
, AS_INTEREST_TYPES_VL INTTYPE
, AS_INTERESTS INTEREST
WHERE INTCODE1.INTEREST_CODE_ID(+) = INTEREST.PRIMARY_INTEREST_CODE_ID
AND INTCODE2.INTEREST_CODE_ID(+) = INTEREST.SECONDARY_INTEREST_CODE_ID
AND INTEREST.STATUS_CODE = LKPCODE1.LOOKUP_CODE(+)
AND LKPCODE1.LOOKUP_TYPE(+) = 'INTEREST_STATUS'
AND INTEREST.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID