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

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

View Text

SELECT OB.NAME
, '_KF:INV:MSTK:SY'
, SY.DESCRIPTION
, PA.ORGANIZATION_CODE
, AL.NAME
, INAT.ATTRIBUTE_CODE
, AT.NAME
, AP.APPLICATION_NAME
, INAT.VALUE_VARCHAR2
, INAT.VALUE_NUMBER
, INAT.DATABASE_OBJECT_NAME
, INAT.ATTRIBUTE_APPLICATION_ID
, INAT.KEY_VALUE1
, INAT.KEY_VALUE2
, INAT.CREATION_DATE
, INAT.CREATED_BY
, INAT.LAST_UPDATE_DATE
, INAT.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
, FND_APPLICATION_VL AP
, AK_ATTRIBUTES_VL AT
, AK_OBJECTS_VL OB
, AK_INST_ATTRIBUTE_VALUES INAT
WHERE INAT.DATABASE_OBJECT_NAME = OB.DATABASE_OBJECT_NAME
AND INAT.ATTRIBUTE_CODE = AT.ATTRIBUTE_CODE
AND INAT.ATTRIBUTE_APPLICATION_ID = AT.ATTRIBUTE_APPLICATION_ID
AND INAT.ATTRIBUTE_APPLICATION_ID = AP.APPLICATION_ID
AND INAT.DATABASE_OBJECT_NAME = 'MTL_SYSTEM_ITEMS_KFV'
AND INAT.ATTRIBUTE_APPLICATION_ID = 702
AND INAT.KEY_VALUE2 = SY.INVENTORY_ITEM_ID
AND INAT.KEY_VALUE1 = SY.ORGANIZATION_ID
AND INAT.KEY_VALUE1 = PA.ORGANIZATION_ID
AND INAT.KEY_VALUE1 = AL.ORGANIZATION_ID
AND '_SEC:INAT.KEY_VALUE1' IS NOT NULL WITH READ ONLY

Columns

Name
OBJECT_NAME
"_KF:ITEM_NAME"
ITEM_DESCRIPTION
ORGANIZATION_CODE
ORGANIZATION_NAME
ATTRIBUTE_ID
ATTRIBUTE_NAME
ATTRIBUTE_APPLICATION_NAME
CHARACTER_VALUE
NUMBER_VALUE
DATABASE_OBJECT_NAME
ATTRIBUTE_APPLICATION_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY