View: AK_CATEGORY_USAGES_V

Product:	AK - Common Modules-AK
Description:	view of AK_CATEGORY_USAGES table, for framework use
Implementation/DBA Data:	APPS.AK_CATEGORY_USAGES_V

View Text

SELECT ACU.REGION_CODE
, ACU.REGION_APPLICATION_ID
, ACU.ATTRIBUTE_CODE
, ACU.ATTRIBUTE_APPLICATION_ID
, AR.ITEM_NAME
, FDC.CATEGORY_ID
, ACU.CATEGORY_NAME
, FDC.USER_NAME
, FDC.APPLICATION_ID
, ACU.SHOW_ALL
FROM AK_CATEGORY_USAGES ACU
, AK_REGION_ITEMS AR
, FND_DOCUMENT_CATEGORIES_VL FDC
WHERE ACU.REGION_APPLICATION_ID = AR.REGION_APPLICATION_ID
AND ACU.REGION_CODE = AR.REGION_CODE
AND ACU.ATTRIBUTE_APPLICATION_ID = AR.ATTRIBUTE_APPLICATION_ID
AND ACU.ATTRIBUTE_CODE = AR.ATTRIBUTE_CODE
AND ACU.CATEGORY_ID = FDC.CATEGORY_ID

Columns