VIEW: APPS.AS_SITE_CLASSIFICATION_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 ,loc.city ,loc.postal_code ,loc.state ,loc.province ,loc.county ,loc.country ,loc.address1 ,loc.address2 ,loc.address3 ,loc.address4 from as_interest_codes_v intcode1 , as_interests interest , as_interest_types_vl inttype , as_lookups lkpcode1 , hz_locations loc , hz_party_sites site , as_interest_codes_v intcode2 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 and interest.interest_use_code = 'COMPANY_CLASSIFICATION' and interest.address_id = site.party_site_id(+) and site.location_id = loc.location_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
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, LOC.COUNTY
, LOC.COUNTRY
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
FROM AS_INTEREST_CODES_V INTCODE1
, AS_INTERESTS INTEREST
, AS_INTEREST_TYPES_VL INTTYPE
, AS_LOOKUPS LKPCODE1
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES SITE
, AS_INTEREST_CODES_V INTCODE2
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
AND INTEREST.INTEREST_USE_CODE = 'COMPANY_CLASSIFICATION'
AND INTEREST.ADDRESS_ID = SITE.PARTY_SITE_ID(+)
AND SITE.LOCATION_ID = LOC.LOCATION_ID(+)