APPS.GMD_SPREADSHEET_COMMON SQL Statements

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

Line: 11

       SELECT  c.result_value_char, c.result_value_num
       FROM    gmd_samples a,
               gmd_qc_tests_b b,
               gmd_results c
       WHERE    a.item_id = v_item_id
         AND   (a.lot_id IS NULL OR a.lot_id = 0)
         AND   a.whse_code IS NULL
         AND   (a.location IS NULL OR a.location = X_loct)
         AND   a.delete_mark = 0
         AND   a.source = 'I'
         AND   a.sample_id = c.sample_id
         AND   c.test_id = b.test_id
         AND   b.test_code = v_assay_code
         AND   c.qc_lab_orgn_code = v_orgn_code
         AND   c.delete_mark = 0
         AND   rownum = 1
         ORDER BY c.result_date desc;