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.EGO_ITEM_ATTRIBUTES_V

Source

View Text - Preformatted


SELECT C.USER_ATTRIBUTE_NAME_GUI ATTRIBUTE_DISP_NAME ,MFG1.MEANING CONTROL_LEVEL_MEANING ,MFG1.LOOKUP_CODE CONTROL_LEVEL_CODE ,C.ATTRIBUTE_NAME ATTRIBUTE_NAME FROM MTL_ITEM_ATTRIBUTES C ,MFG_LOOKUPS MFG1 WHERE MFG1.LOOKUP_TYPE = 'ITEM_STATUS_CONTROL' AND MFG1.LOOKUP_CODE = C.STATUS_CONTROL_CODE

View Text - HTML Formatted

SELECT C.USER_ATTRIBUTE_NAME_GUI ATTRIBUTE_DISP_NAME
, MFG1.MEANING CONTROL_LEVEL_MEANING
, MFG1.LOOKUP_CODE CONTROL_LEVEL_CODE
, C.ATTRIBUTE_NAME ATTRIBUTE_NAME
FROM MTL_ITEM_ATTRIBUTES C
, MFG_LOOKUPS MFG1
WHERE MFG1.LOOKUP_TYPE = 'ITEM_STATUS_CONTROL'
AND MFG1.LOOKUP_CODE = C.STATUS_CONTROL_CODE