VIEW: APPS.AST_CONT_CLASSIFICATION_INT_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.PRODUCT_CATEGORY_ID, INTEREST.PRODUCT_CAT_SET_ID, interest.contact_id, interest.customer_id, interest.address_id, interest.status_code, interest.description, nvl(DENORM.CONCAT_CAT_PARENTAGE,interest.PRODUCT_CATEGORY_ID), 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 FROM AS_INTERESTS_ALL INTEREST, AS_LOOKUPS LKPCODE1, HZ_LOCATIONS LOC, HZ_PARTY_SITES SITE, FND_TERRITORIES_VL FTV, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM WHERE INTEREST.PRODUCT_CATEGORY_ID = DENORM.CATEGORY_ID(+) and INTEREST.PRODUCT_CAT_SET_ID = DENORM.CATEGORY_SET_ID(+) and DENORM.LANGUAGE(+) = userenv('LANG') and interest.status_code= lkpcode1.lookup_code(+) and lkpcode1.lookup_type(+) = 'INTEREST_STATUS' and interest.address_id = site.party_site_id(+) and site.location_id = loc.location_id(+) and loc.country = ftv.territory_code(+) and INTEREST.INTEREST_USE_CODE = 'CONTACT_INTEREST'

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.PRODUCT_CATEGORY_ID
, INTEREST.PRODUCT_CAT_SET_ID
, INTEREST.CONTACT_ID
, INTEREST.CUSTOMER_ID
, INTEREST.ADDRESS_ID
, INTEREST.STATUS_CODE
, INTEREST.DESCRIPTION
, NVL(DENORM.CONCAT_CAT_PARENTAGE
, INTEREST.PRODUCT_CATEGORY_ID)
, 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
FROM AS_INTERESTS_ALL INTEREST
, AS_LOOKUPS LKPCODE1
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES SITE
, FND_TERRITORIES_VL FTV
, ENI_PROD_DEN_HRCHY_PARENTS_V DENORM
WHERE INTEREST.PRODUCT_CATEGORY_ID = DENORM.CATEGORY_ID(+)
AND INTEREST.PRODUCT_CAT_SET_ID = DENORM.CATEGORY_SET_ID(+)
AND DENORM.LANGUAGE(+) = USERENV('LANG')
AND INTEREST.STATUS_CODE= LKPCODE1.LOOKUP_CODE(+)
AND LKPCODE1.LOOKUP_TYPE(+) = 'INTEREST_STATUS'
AND INTEREST.ADDRESS_ID = SITE.PARTY_SITE_ID(+)
AND SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND LOC.COUNTRY = FTV.TERRITORY_CODE(+)
AND INTEREST.INTEREST_USE_CODE = 'CONTACT_INTEREST'