Query to findout Assemble to Order?

select segment1 item,description,inventory_item_status_code item_status,item_type user_item_type,ood.organization_code inventory_org,replenish_to_order_flag assemble_to_orderfrom mtl_system_items_b msib,org_organization_definitions oodwhere msib.organization_id = ood.organization_idand ood.operating_unit =100order by segment1,organization_code