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.

[Home] [Help]

View: INVBV_ITEM_CATEGORY_TYPE_ASGNS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_ITEM_CATEGORY_TYPE_ASGNS

View Text

SELECT CASET.CATEGORY_SET_NAME
, '_KF:INV:MCAT:CA'
, CASEVA.CATEGORY_SET_ID
, CASEVA.CATEGORY_ID
, CASEVA.LAST_UPDATE_DATE
, CASEVA.LAST_UPDATED_BY
, CASEVA.CREATION_DATE
, CASEVA.CREATED_BY
FROM MTL_CATEGORY_SETS CASET
, MTL_CATEGORIES CA
, MTL_CATEGORY_SET_VALID_CATS CASEVA
WHERE CASEVA.CATEGORY_ID = CA.CATEGORY_ID
AND CASEVA.CATEGORY_SET_ID = CASET.CATEGORY_SET_ID WITH READ ONLY

Columns

Name
CATEGORY_TYPE_NAME
"_KF:ITEM_CATEGORY_NAME"
CATEGORY_ID
CATEGORY_SET_ID
LAST_UPDATED_DATE
LAST_UPDATED_BY
CREATED_DATE
CREATED_BY