ASL (Approved Supplier List) Query

SELECT hou.NAME operating_unit,
       asl.vendor_business_type,
       pov.segment1 vendor_code,
       pov.vendor_name,
       sites.vendor_site_code,
       msi.segment1 item_code,
       msi.description item_desc,
       using_organization_id,
       owning_organization_id,
       plc.displayed_field,
       past.status Supplier_Status
  FROM po_approved_supplier_list asl,
       po_vendors pov,
       po_vendor_sites_all sites,
       mtl_system_items_b msi,
       hr_operating_units hou,
       po_lookup_codes plc,
       po_asl_statuses past
 WHERE     asl.vendor_id = pov.vendor_id
       AND asl.vendor_site_id = sites.vendor_site_id
       AND msi.inventory_item_id = asl.item_id
       AND msi.organization_id = asl.using_organization_id
       AND sites.org_id = hou.organization_id
       AND asl.vendor_business_type = plc.lookup_code
       AND asl.asl_status_id = past.status_id
       AND plc.lookup_type = 'ASL_VENDOR_BUSINESS_TYPE'
       AND past.status = 'Approved'
       AND msi.inventory_item_id  = 222315;