eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AK_CATEGORY_USAGES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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