APPS.GMD_LCF_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

      SELECT unit_cost
      FROM   gmd_lcf_external_cost
      WHERE  inventory_item_id     = p_item_id
      AND    lab_organization_id   = p_organization_id
      AND    cost_organization_id  = p_cost_orgn_id
      AND    NVL(lot_number, '-1') = NVL(p_lot_no, '-1')
      AND    NVL(quantity, -1)     = NVL(p_qty, -1)
      AND    NVL(uom, '-1')        = NVL(p_uom, '-1')
      AND    p_cost_date BETWEEN from_date AND to_date;