APPS.GMD_TECH_PARAMS SQL Statements

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

Line: 76

  item_master_tbl.delete;

Line: 77

  tp_master_tbl.delete;

Line: 78

  attrib_master_tbl.delete;

Line: 228

  item_master_tbl.delete;

Line: 229

  tp_master_tbl.delete;

Line: 230

  attrib_master_tbl.delete;

Line: 268

    SELECT i.item_no, i.item_id, i.item_um, d.line_type, d.qty,
           d.item_um line_um, d.line_no, d.formulaline_id, NVL(d.tpformula_id,0) tpformula_id
    FROM   ic_item_mst i, fm_matl_dtl d
    WHERE  formula_id = p_formula_id
           AND i.item_id = d.item_id
    ORDER BY d.line_type, d.line_no;

Line: 276

    SELECT i.orgn_code, i.item_id, i.tech_parm_name, i.num_data,
           i.text_data, i.boolean_data, NVL(f.tpformula_id,0) tpformula_id,
           f.line_type, f.line_no
    FROM   lm_item_dat i, fm_matl_dtl f
    WHERE  orgn_code = p_lab_type
           AND i.item_id = f.item_id
           AND f.formula_id = p_formula_id
           AND NVL(i.formula_id,0) = NVL(f.tpformula_id,0)
           AND i.lot_id = 0
    ORDER BY f.line_type, f.line_no;

Line: 288

    SELECT t.orgn_code lab_type, t.tech_parm_name, p.sort_seq, t.expression_char,
           t.data_type, t.lm_unit_code, q.orgn_code, q.assay_code
    FROM   lm_tech_hdr t, lm_prlt_asc p, gmd_tests q
    WHERE  t.orgn_code = p_lab_type
           AND p.orgn_code = t.orgn_code
           AND t.tech_parm_name = p.tech_parm_name
           AND t.qcassy_typ_id = q.qcassy_typ_id(+)
    ORDER BY p.sort_seq;

Line: 456

       X_sql_stmt := 'select '||X_expr||' from dual';

Line: 520

    SELECT std_um
    FROM   sy_uoms_typ
    WHERE  um_type = V_um_type;

Line: 629

    SELECT a.text_result, a.num_result
    FROM   qc_rslt_mst a, gmd_tests b
    WHERE  a.item_id = V_item_id
           AND a.formula_id IS NULL
           AND a.routing_id IS NULL
           AND a.oprn_id IS NULL
           AND a.cust_id IS NULL
           AND a.vendor_id IS NULL
           AND a.batch_id IS NULL
           AND a.final_mark = 1
           AND a.delete_mark = 0
           AND a.orgn_code = V_orgn_code
           AND a.assay_code = V_assay_code
           AND a.orgn_code = b.orgn_code
           AND a.assay_code = b.assay_code
    ORDER BY result_date DESC;

Line: 945

    SELECT 1
      FROM sy_orgn_mst
      WHERE  orgn_code = plab_type
             AND plant_ind = 2 ;

Line: 951

    SELECT 1
      FROM lm_item_dat
      WHERE  orgn_code = x_lab_type
             AND lot_id = 0
             AND delete_mark = 0
             AND (NVL(formula_id,0) = NVL(pformula_id,0)
              OR formula_id = 0)
             AND item_id = pitem_id ;

Line: 961

    SELECT 1
    FROM   qc_rslt_mst q, lm_prlt_asc s, lm_tech_hdr h
    WHERE  q.item_id = pitem_id
           AND q.formula_id IS NULL
           AND q.routing_id IS NULL
           AND q.oprn_id IS NULL
           AND q.cust_id IS NULL
           AND q.vendor_id IS NULL
           AND q.batch_id IS NULL
           AND q.final_mark = 1
           AND q.delete_mark = 0
           AND q.qcassy_typ_id = h.qcassy_typ_id
           AND s.orgn_code = x_lab_type
           AND h.tech_parm_name = s.tech_parm_name
           AND h.qcassy_typ_id IS NOT NULL
           AND q.orgn_code = NVL(plab_type,x_lab_type)
    ORDER BY result_date DESC;