ASCP QUERY TO FIND SAFETY STOCK QUANTITY FOR AN ITEM AND ORGANIZATION

SELECT DISTINCT C.name                                      ORGANIZATION,
                D.organization_code,
                B.segment1                                  ITEM,
                ( safety_stock_quantity / conversion_rate )
                SAFETY_STOCK_QUANTITY,
                A.last_update_date,
                SQ_UOM.from_uom_code                        UOM
FROM   mtl_safety_stocks A,
       mtl_system_items_b B,
       hr_all_organization_units C,
       mtl_parameters D,
       (SELECT Substr (from_uom_code, 0, 3)    FROM_UOM_CODE,
               Substr (to_uom_code, 0, 3)      TO_UOM_CODE,
               inventory_item_id,
               organization_id,
               Substr (primary_uom_code, 0, 3) PRIMARY_UOM_CODE,
               conversion_rate
        FROM   (SELECT mtl_uom_class_conversions.to_uom_code     FROM_UOM_CODE,
                       mtl_uom_class_conversions.from_uom_code   TO_UOM_CODE,
                       mtl_system_items_b.inventory_item_id
                       INVENTORY_ITEM_ID,
                       mtl_system_items_b.organization_id        ORGANIZATION_ID
                       ,
mtl_system_items_b.primary_uom_code       PRIMARY_UOM_CODE,
mtl_uom_class_conversions.conversion_rate CONVERSION_RATE
FROM   apps.mtl_system_items_b MTL_SYSTEM_ITEMS_B,
apps.mtl_uom_class_conversions MTL_UOM_CLASS_CONVERSIONS
WHERE  ( 1 = 1 )
AND ( mtl_system_items_b.inventory_item_id =
          mtl_uom_class_conversions.inventory_item_id )
UNION ALL
SELECT mtl_units_of_measure.uom_code           FROM_UOM_CODE,
mtl_system_items_b.primary_uom_code     TO_UOM_CODE,
mtl_system_items_b.inventory_item_id    INVENTORY_ITEM_ID,
mtl_system_items_b.organization_id      ORGANIZATION_ID,
mtl_system_items_b.primary_uom_code     PRIMARY_UOM_CODE,
1 / mtl_uom_conversions.conversion_rate CONVERSION_RATE
FROM   apps.mtl_system_items_b MTL_SYSTEM_ITEMS_B,
apps.mtl_uom_conversions MTL_UOM_CONVERSIONS,
apps.mtl_units_of_measure MTL_UNITS_OF_MEASURE
WHERE  ( 1 = 1 )
AND ( mtl_uom_conversions.uom_class =
      mtl_units_of_measure.uom_class )
AND ( mtl_system_items_b.primary_uom_code =
    mtl_uom_conversions.uom_code )
AND ( mtl_units_of_measure.base_uom_flag = 'Y' )
AND ( mtl_uom_conversions.inventory_item_id = 0 ))) SQ_UOM
WHERE  A.inventory_item_id = B.inventory_item_id
       AND A.organization_id = B.organization_id
       AND B.organization_id = C.organization_id
       AND A.inventory_item_id = SQ_UOM.inventory_item_id
       AND A.organization_id = SQ_UOM.organization_id
       AND B.primary_uom_code = SQ_UOM.to_uom_code
       AND SQ_UOM.from_uom_code = 'GAL'
       AND C.organization_id = D.organization_id
       AND B.segment1 IN ( 'ENTER THE ITEM NAME  HERE' )
       AND D.organization_code IN ( 'ENTER THE ORG CODE HERE' )
ORDER  BY 1,
          2 DESC;