物料成本查询

–标准成本历史记录
SELECT cic.organization_id,
cic.inventory_item_id,
msi.segment1 “物料”,
msi.description “说明”,
msi.primary_uom_code “单位”,
cic.cost_type_id,
cct.cost_type “成本类型”,
cic.DEFAULTED_FLAG “使用默认控制”,
cic.INVENTORY_ASSET_FLAG “库存资产”,
cic.BASED_ON_ROLLUP_FLAG “基于累计”,
cic.LOT_SIZE “批量”,
cic.SHRINKAGE_RATE “制造消耗”,
cic.ITEM_COST “单位成本”,
cic.MATERIAL_COST “物料”,
cic.MATERIAL_OVERHEAD_COST “物料间接费用”,
cic.RESOURCE_COST “资源”,
cic.OUTSIDE_PROCESSING_COST “外协加工”,
cic.OVERHEAD_COST “制造费用”,
MSI.PLANNING_MAKE_BUY_CODE,
lu1.MEANING “制造/购买”
FROM cst_item_costs cic,
mtl_system_items_b msi,
cst_cost_types cct,
mfg_lookups lu1
WHERE 1 = 1
AND cic.inventory_item_id = msi.inventory_item_id
AND cic.organization_id = msi.organization_id
AND msi.costing_enabled_flag = ‘Y’
AND cic.cost_type_id = cct.cost_type_id
AND lu1.lookup_code(+) = msi.planning_make_buy_code
AND lu1.lookup_type(+) = ‘MTL_PLANNING_MAKE_BUY’
AND cic.inventory_item_id = 2330991
AND cic.organization_id = 1188
ORDER BY cct.cost_type;

–物料成本

SELECT cic.organization_id,
cic.inventory_item_id,
msi.segment1 “物料”,
msi.description “说明”,
msi.primary_uom_code “单位”,
cic.cost_type_id,
cct.cost_type “成本类型”,
cic.DEFAULTED_FLAG “使用默认控制”,
cic.INVENTORY_ASSET_FLAG “库存资产”,
cic.BASED_ON_ROLLUP_FLAG “基于累计”,
cic.LOT_SIZE “批量”,
cic.SHRINKAGE_RATE “制造消耗”,
cic.ITEM_COST “单位成本”,
cic.MATERIAL_COST “物料”,
cic.MATERIAL_OVERHEAD_COST “物料间接费用”,
cic.RESOURCE_COST “资源”,
cic.OUTSIDE_PROCESSING_COST “外协加工”,
cic.OVERHEAD_COST “制造费用”,
MSI.PLANNING_MAKE_BUY_CODE,
lu1.MEANING “制造/购买”
FROM cst_item_costs cic,
mtl_system_items_b msi,
cst_cost_types cct,
mfg_lookups lu1
WHERE 1 = 1
AND cic.inventory_item_id = msi.inventory_item_id
AND cic.organization_id = msi.organization_id
AND msi.costing_enabled_flag = ‘Y’
AND cic.cost_type_id = cct.cost_type_id
AND lu1.lookup_code(+) = msi.planning_make_buy_code
AND lu1.lookup_type(+) = ‘MTL_PLANNING_MAKE_BUY’
AND cic.inventory_item_id = 2330991
AND cic.organization_id = 1188
ORDER BY cct.cost_type;