Simple Query To Fetch Item Information

SELECT

     substr(inv.segment1,1,7) "Item",

     substr(inv.inventory_item_id,1,4) "Id",

     inv.bom_enabled_flag,

     inv.build_in_wip_flag,

     inv.customer_order_enabled_flag,

     inv.internal_order_enabled_flag,

     inv.invoiceable_item_flag,

     inv.mtl_transactions_enabled_flag,

     inv.purchasing_item_flag,

     inv.stock_enabled_flag,

     substr(inv.receiving_routing_id,1,2) "Rte ID",

     substr(inv.list_price_per_unit,1,2) "Lst Pr"

FROM

     mtl_system_items_B inv

WHERE

     inv.segment1 LIKE 'XX%' AND

     inv.organization_id = "Org_Id"