Query to get the all the items and instrumental serial numbers.

Summary:

Content (required): need a query to get the all the items and instrumental serial numbers. Is there any thing like product_type='INST'?

Version (include the version you are using, if applicable): 23C

Code Snippet (add any code snippets that support your topic, if applicable):

select egp.ITEM_NUMBER,SERIAL_NUMBER,imt.PRODUCT_FISC_CLASSIFICATION 

from 

egp_system_items_b egp,INV_SERIAL_NUMBERS isn,inv_material_txns imt

where 

egp.inventory_item_id=isn.inventory_item_id

and egp.organization_id=isn.CURRENT_ORGANIZATION_ID

and egp.inventory_item_id=imt.inventory_item_id

and egp.organization_id=imt.ORGANIZATION_ID