FND Design Data [Home] [Help]

View: INVFV_ITEM_STATUS_ATTR_VALUES

Product: INV - Inventory
Description:
Implementation/DBA Data: ViewAPPS.INVFV_ITEM_STATUS_ATTR_VALUES
View Text

SELECT ST.INVENTORY_ITEM_STATUS_CODE
, IT.USER_ATTRIBUTE_NAME_GUI
, '_LA:ST.ATTRIBUTE_VALUE:FND_LOOKUPS:YES_NO:MEANING'
, ST.ATTRIBUTE_NAME
, ST.LAST_UPDATE_DATE
, ST.LAST_UPDATED_BY
, ST.CREATION_DATE
, ST.CREATED_BY
FROM MTL_ITEM_ATTRIBUTES IT
, MTL_STATUS_ATTRIBUTE_VALUES ST
WHERE ST.ATTRIBUTE_NAME = IT.ATTRIBUTE_NAME WITH READ ONLY

Columns

Name
ITEM_STATUS_CODE
ATTRIBUTE_NAME
"_LA:ATTRIBUTE_VALUE_FLAG"
ATTRIBUTE_CODE
LAST_UPDATED_DATE
LAST_UPDATED_BY
CREATED_DATE
CREATED_BY