[Home] [Help]
View: INV_BIS_ITEM_COSTS
Product: | INV - Inventory |
Description: | Cost for Inventory Items with standard cost, and items with average cost using |
Implementation/DBA Data: |
APPS.INV_BIS_ITEM_COSTS
|
View Text
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
Columns
Name |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
ITEM_COST |