VIEW: APPS.AS_INTERESTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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