View: HZ_CLASS_CATEGORIES_V

Product:	AR - Receivables
Description:	Translation view for classification categories
Implementation/DBA Data:	APPS.HZ_CLASS_CATEGORIES_V

View Text

SELECT LOOKUP.MEANING
, CLASS.CLASS_CATEGORY
FROM HZ_CLASS_CATEGORIES CLASS
, HZ_CLASS_CATEGORY_USES USE
, FND_LOOKUP_TYPES_VL LOOKUP
WHERE CLASS.CLASS_CATEGORY = USE.CLASS_CATEGORY
AND CLASS.CLASS_CATEGORY = LOOKUP.LOOKUP_TYPE
AND CLASS.ALLOW_MULTI_PARENT_FLAG = 'N'
AND USE.OWNER_TABLE = 'HZ_PARTIES' ORDER BY LOOKUP.MEANING

Columns