This content has been marked as final. Show 4 replies
Hi,1 person found this helpful
Join MTL_SYSTEM_ITEMS_B and MTL_ONHAND_QUANTITIES using INVENTORY_ITEM_ID and ORGANIZATION_XID column, you will get most of the columns.
use the following query you will get max columns1 person found this helpful
select segment1 as "ITEM",description,inventory_item_status_code,a.organization_id,list_price_per_unit,lot_control_code,primary_unit_of_measure,transaction_quantity,subinventory_code,revision,revision_qty_control_code from mtl_system_items_b a,
But am looking for pricelist as well of the item.