[Home] [Help]
VIEW: APPS.CLN_ITEMMST_ITEMVALUE_V
Source
View Text - Preformatted
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
View Text - HTML Formatted
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