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: CSS_DEF_PRODUCTS_VL

Product:	CSS - Support (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT INVENTORY_ITEM_ID
, CONCATENATED_SEGMENTS
, DESCRIPTION
, REVISION_QTY_CONTROL_CODE
FROM MTL_SYSTEM_ITEMS_VL
WHERE ORGANIZATION_ID = ( SELECT CSS_DEF_MTL_API.GET_INV_ORGANIZATION_ID
FROM DUAL )
AND DEFECT_TRACKING_ON_FLAG = 'Y'

Columns

Name
PRODUCT_INV_ITEM_ID
PRODUCT_NUMBER
PRODUCT_DESCRIPTION
PRODUCT_REVISION_CONTROL_CODE