select
org.name,
si.segment1 item_code,
si.description item_name,
c.item_cost
from
mtl_system_items si,
cst_item_costs c,
hr_all_organization_units org
where
si.inventory_item_id=c.inventory_item_id
and si.organization_id=c.organization_id
and c.organization_id=org.organization_id
and si.organization_id<>85 --master organization
org.name,
si.segment1 item_code,
si.description item_name,
c.item_cost
from
mtl_system_items si,
cst_item_costs c,
hr_all_organization_units org
where
si.inventory_item_id=c.inventory_item_id
and si.organization_id=c.organization_id
and c.organization_id=org.organization_id
and si.organization_id<>85 --master organization
No comments:
Post a Comment