View: CLN_ITEMMST_ITEMVALUE_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View for the Item Value section of the Sync Item XML message
Implementation/DBA Data:	APPS.CLN_ITEMMST_ITEMVALUE_V

View Text

SELECT DISTINCT CIC.INVENTORY_ITEM_ID
, CIC.ORGANIZATION_ID
, CIC.ITEM_COST
, CCT.COST_TYPE
FROM CST_ITEM_COSTS CIC
, CST_COST_TYPES CCT
WHERE CIC.COST_TYPE_ID = CCT.COST_TYPE_ID

Columns