get lot number query

Content

i created this query

select RSL.ITEM_ID,
       RSL.ITEM_DESCRIPTION,
       rct.ORGANIZATION_ID,
       RHI.SHIPMENT_NUM,
       rsh.receipt_num,
       rct.transaction_date receipt_date
  from RCV_HEADERS_INTERFACE RHI,
       PO_HEADERS_ALL        PHA,
       hr_organization_units hou,
       RCV_SHIPMENT_HEADERS  RSH,
       RCV_SHIPMENT_LINES    RSL,
       rcv_transactions      rct,
       INV_ORG_PARAMETERS    iop
 where rct.ORGANIZATION_ID = hou.ORGANIZATION_ID
   and RSL.PO_HEADER_ID = PHA.PO_HEADER_ID
   AND RSH.ASN_TYPE = 'ASBN'
   AND RHI.HEADER_INTERFACE_ID = RSH.HEADER_INTERFACE_ID
   AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
   and rct.shipment_line_id = rsl.shipment_line_id