SELECT
cict.item_number,
cict.description,
msi.item_type,
cict.PLANNING_MAKE_BUY_CODE,
mis.inventory_item_status_code_tl AS item_status,
sum(cdcv.item_cost)item_cost
FROM apps.cst_item_cost_type_v cict,
apps.cst_cost_types cct,
apps.cst_detail_cost_view cdcv,
apps.mtl_system_items_b msi,
apps.mtl_item_status mis
WHERE cict.inventory_item_id = cdcv.inventory_item_id
AND cict.organization_id = cdcv.organization_id
AND cict.cost_type_id = cdcv.cost_type_id
and cict.cost_type_id=cct.cost_type_id
AND cict.inventory_item_id = msi.inventory_item_id
and msi.segment1=:P_ITEM
AND cict.organization_id = msi.organization_id
AND msi.inventory_item_status_code = mis.inventory_item_status_code
AND cict.organization_id = :P_ORG
AND cict.cost_type_id = :P_COST_TYPE
AND cict.PLANNING_MAKE_BUY_CODE =’Buy’
GROUP BY cict.item_number,
cict.description,
msi.item_type,
mis.inventory_item_status_code_tl,
cict.PLANNING_MAKE_BUY_CODE
Recent Posts