VIEW: APPS.INV_BIS_ITEM_COSTS

Source

View Text - Preformatted

SELECT organization_id ORGANIZATION_ID, inventory_item_id INVENTORY_ITEM_ID, item_cost ITEM_COST FROM cst_item_costs WHERE cost_type_id = 1 UNION SELECT organization_id ORGANIZATION_ID, inventory_item_id INVENTORY_ITEM_ID, item_cost ITEM_COST FROM cst_quantity_layers WHERE cost_group_id =1

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_COST ITEM_COST
FROM CST_ITEM_COSTS
WHERE COST_TYPE_ID = 1 UNION SELECT ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_COST ITEM_COST
FROM CST_QUANTITY_LAYERS
WHERE COST_GROUP_ID =1