APPS.GML_VALIDATE_PO SQL Statements

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

Line: 23

  SELECT 1
  FROM sy_orgn_mst
  WHERE orgn_code = v_orgn_code
  AND delete_mark = 0;

Line: 70

  SELECT 1
  FROM sy_oper_mst
  WHERE op_code = v_op_code
  AND delete_mark = 0;

Line: 116

  SELECT 1
  FROM sy_docs_seq
  WHERE doc_type = 'PORD'
  AND   orgn_code = v_orgn_code
  AND   delete_mark = 0;

Line: 166

  SELECT distinct sob_id
  from   gl_plcy_mst
  where  co_code = (select co_code
                    from   sy_orgn_mst
                    where  orgn_code = (select orgn_code
                                        from   ic_whse_mst
                                        where  whse_code=v_whse_code));

Line: 175

  SELECT distinct sob_id
  from   gl_plcy_mst
  where  co_code = (select co_code
                    from   sy_orgn_mst
                    where  orgn_code = v_orgn_code);

Line: 233

  SELECT 1
  FROM po_vend_mst
  WHERE of_vendor_site_id = v_of_vendor_site_id
  AND ship_ind > 0
  /* B#972240 Begin */
  /*AND co_code = v_co_code; */

Line: 282

  SELECT 1
  FROM   ic_item_mst
  WHERE  item_no = v_item_no;

Line: 326

  SELECT 1
  FROM gl_curr_mst
  WHERE currency_code = v_currency_code;

Line: 371

  SELECT 1
  FROM    po_cost_mst
  WHERE   aqui_cost_code = v_aqui_cost_code;

Line: 416

  SELECT 1
  FROM    sy_uoms_mst
  WHERE   um_code = v_um_code;

Line: 462

  SELECT 1
  FROM    op_ship_mst
  WHERE   shipper_code = v_shipper_code;

Line: 508

  SELECT 1
  FROM    op_frgt_mth
  WHERE   of_frtbill_mthd = v_frtbill_mthd;

Line: 554

  SELECT 1
  FROM    op_term_mst
  WHERE   of_terms_code = v_of_terms_code;

Line: 600

  SELECT 1
  FROM   qc_grad_mst
  WHERE  qc_grade = v_qc_grade_wanted;

Line: 643

  SELECT  trans_source_type
  FROM    gl_srce_mst
  WHERE   trans_source_code = 'PO';

Line: 678

  SELECT  plcy.base_currency_code
  FROM    sy_orgn_mst orgn,
          gl_plcy_mst plcy
  WHERE   orgn.orgn_code = v_orgn_code AND
          orgn.co_code = plcy.co_code;

Line: 722

  SELECT  ex.exchange_rate,
          ex.mul_div_sign,
          ex.exchange_rate_date
  FROM    gl_xchg_rte ex,
          gl_srce_mst src
  WHERE   ex.to_currency_code = v_to_currency  AND
          ex.from_currency_code = v_from_currency  AND
          ex.exchange_rate_date <= SYSDATE  AND
          ex.rate_type_code = src.rate_type_code  AND
          src.trans_source_type = v_trans_source_type AND
          ex.delete_mark =0;