Testing Zero Cost Items SQL

Categories: Draft
Columns: Org Code, Segment1, Description, Inventory Item Status Code, Creation Date, Planner, Mk Buy, Based On Rollup ...
select mp.organization_code, msi.segment1, msi.description, msi.inventory_item_status_Code, msi.creation_date, msi.planner_code,
       decode(msi.planning_make_buy_code, 1, 'MAKE', 'BUY') Mk_Buy, decode(cic.based_on_rollup_flag, 1, 'Yes', 'No') Based_on_rollup
from cst_item_costs cic, mtl_system_items msi, hr_organization_units hou, mtl_parameters mp
where 1=1
and msi.organization_id = mp.organization_id 
and cic.organization_id = msi.organization_id
and cic.inventory_item_id = msi.inventory_item_id 
and cic.cost_type_id = 1 
and hou.organization_id = mp.organization_id
and msi.costing_enabled_flag = 'Y' 
and hou.date_to is null
and nvl(cic.item_cost,0) = 0
order by msi.segment1, mp.organization_code
Parameter Name SQL text Validation
Organization Code