View: BIC_CUST_CATEGORY_V

Product:	BIC - Customer Intelligence (obsolete)
Description:	This view is based on the denormalized table for the customer category hierarchy.
Implementation/DBA Data:	APPS.BIC_CUST_CATEGORY_V

View Text

SELECT LOOKUP_CODE ID
, MEANING VALUE
, 'ALL' ALL_FK
, LOOKUP_CODE CUSTOMER_CATEGORY_CODE
, MEANING CUSTOMER_CATEGORY_NAME
, DESCRIPTION CUSTOMER_CATEGORY_DESC
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'CUSTOMER_CATEGORY'
AND ENABLED_FLAG = 'Y' WITH READ ONLY

Columns