Query to Find out Shelf life days and Hazardous Class of a Product

Select org.organization_code, org.organization_name ,
mtl.segment1||'-'||mtl.segment2 item_code,
mtl.description,
mtl.shelf_life_days ,
mtl.retest_interval,
mtl.expiration_action_interval,
ptl.hazard_class,
ptl.description
from mtl_system_items mtl,
org_organization_definitions org,
po_hazard_classes_tl ptl---------------------------Hazardous Class Table
where mtl.organization_id=org.organization_id
and mtl.hazard_class_id  = ptl.hazard_class_id (+)
and segment1 like '3%'-----------------Your product Segment
and ptl.SOURCE_LANG (+) ='US'
and org.operating_unit=:p_org_id
ORDER BY 1,3