View: AST_CONT_CLASSIFICATION_INT_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_CONT_CLASSIFICATION_INT_V

View Text

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'

Columns