[Home] [Help]
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
Name |
REGION_CODE |
REGION_APPLICATION_ID |
ATTRIBUTE_CODE |
ATTRIBUTE_APPLICATION_ID |
ITEM_NAME |
CATEGORY_ID |
NAME |
USER_NAME |
APPLICATION_ID |
SHOW_ALL |