VIEW: APPS.AST_CONTACT_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 , ftv.territory_short_name, loc.address1 , loc.address2 , loc.address3 , loc.address4, inttype.company_classification_flag, inttype.contact_interest_flag FROM AS_INTERESTS INTEREST, AS_INTEREST_CODES_V INTCODE1, AS_INTEREST_TYPES_VL INTTYPE, AS_LOOKUPS LKPCODE1, HZ_LOCATIONS LOC, HZ_PARTY_SITES SITE, AS_INTEREST_CODES_V INTCODE2, FND_TERRITORIES_VL FTV 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.address_id = site.party_site_id(+) AND site.location_id = loc.location_id(+) AND loc.country = ftv.territory_code(+)

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
, FTV.TERRITORY_SHORT_NAME
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, INTTYPE.COMPANY_CLASSIFICATION_FLAG
, INTTYPE.CONTACT_INTEREST_FLAG
FROM AS_INTERESTS INTEREST
, AS_INTEREST_CODES_V INTCODE1
, AS_INTEREST_TYPES_VL INTTYPE
, AS_LOOKUPS LKPCODE1
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES SITE
, AS_INTEREST_CODES_V INTCODE2
, FND_TERRITORIES_VL FTV
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.ADDRESS_ID = SITE.PARTY_SITE_ID(+)
AND SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND LOC.COUNTRY = FTV.TERRITORY_CODE(+)