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

Product:	BOM - Bills of Material
Description:	Item attribute values
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT V.DATABASE_OBJECT_NAME
, V.KEY_VALUE1
, V.KEY_VALUE2
, V.KEY_VALUE3
, V.KEY_VALUE4
, V.KEY_VALUE5
, V.KEY_VALUE6
, V.KEY_VALUE7
, V.KEY_VALUE8
, V.KEY_VALUE9
, V.KEY_VALUE10
, V.ATTRIBUTE_APPLICATION_ID
, V.ATTRIBUTE_CODE
, AK.DATA_TYPE
, DECODE(UPPER(AK.DATA_TYPE)
, 'VARCHAR2'
, VALUE_VARCHAR2
, 'NUMBER'
, VALUE_NUMBER
, -999)
FROM AK_ATTRIBUTES_VL AK
, AK_OBJECT_ATTRIBUTES O
, AK_INST_ATTRIBUTE_VALUES V
WHERE V.ATTRIBUTE_APPLICATION_ID = 702
AND V.DATABASE_OBJECT_NAME = 'MTL_SYSTEM_ITEMS_KFV'
AND O.DATABASE_OBJECT_NAME = V.DATABASE_OBJECT_NAME
AND O.ATTRIBUTE_APPLICATION_ID = V.ATTRIBUTE_APPLICATION_ID
AND O.ATTRIBUTE_CODE = V.ATTRIBUTE_CODE
AND AK.ATTRIBUTE_CODE = O.ATTRIBUTE_CODE
AND AK.ATTRIBUTE_APPLICATION_ID = 702

Columns

Name
DATABASE_OBJECT_NAME
KEY_VALUE1
KEY_VALUE2
KEY_VALUE3
KEY_VALUE4
KEY_VALUE5
KEY_VALUE6
KEY_VALUE7
KEY_VALUE8
KEY_VALUE9
KEY_VALUE10
ATTRIBUTE_APPLICATION_ID
ATTRIBUTE_CODE
DATA_TYPE
ATTRIBUTE_VALUE