APPS.GML_AUDIT_REPORTS SQL Statements

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

Line: 10

    SELECT count(*)
    FROM   po_line_locations_all
    WHERE  po_header_id = p_hid;

Line: 35

    SELECT count(*)
    FROM   po_line_locations_all
    WHERE  po_header_id = p_hid
    AND    nvl(po_release_id, 0) > 0;

Line: 62

    SELECT SUM(quantity*unit_price)
    FROM   po_lines_all
    WHERE  po_header_id=p_hid;

Line: 84

      SELECT SUM(quantity*price_override)
	FROM po_line_locations_all
       WHERE po_header_id=p_hid
       AND   nvl(po_release_id,0) > 0;

Line: 107

      SELECT count(*)
	FROM po_ordr_dtl
       WHERE po_id=p_id;

Line: 129

      SELECT count(*)
	FROM po_ordr_dtl
       WHERE po_id IN (SELECT po_id
		       FROM   cpg_oragems_mapping f
		       WHERE  f.po_header_id = p_hid
		       AND    nvl(po_release_id,0)>0);

Line: 154

      SELECT SUM(order_qty1*net_price)
	FROM po_ordr_dtl
       WHERE po_id=p_id
         AND cancellation_code is NULL;

Line: 177

      SELECT SUM(order_qty1*net_price)
	FROM po_ordr_dtl
       WHERE po_id IN (SELECT po_id
		       FROM   cpg_oragems_mapping f
		       WHERE  f.po_header_id = p_hid
		       AND    nvl(po_release_id,0)>0);

Line: 205

    SELECT 'Y'
      FROM cpg_oragems_mapping a
     WHERE a.po_header_id=p_ohid
       AND a.po_line_id = p_olid
       AND a.po_line_location_id=p_ollid
       AND a.po_id=p_gid
       AND a.line_id=p_glid;

Line: 234

      SELECT a.item_no
	FROM ic_item_mst a,
	     po_ordr_dtl b
       WHERE a.item_id=b.item_id
	 AND b.line_id=p_glid;

Line: 241

      SELECT segment1
	FROM po_lines_all a,
	     mtl_system_items b
       WHERE a.item_id=b.inventory_item_id
	 AND a.po_line_id=p_olid;

Line: 276

      SELECT DECODE(po_status,0,'OPEN',1,'CANCEL',20,'CLOSE','X')
	FROM po_ordr_dtl
       WHERE line_id=p_glid;

Line: 281

      SELECT DECODE(closed_code,'OPEN','OPEN','CLOSED','CLOSE',
	     'FINALLY CLOSED','CLOSE','CLOSED FOR RECEIVING','CLOSE','OPEN')
	FROM po_line_locations_all
       WHERE line_location_id=p_ollid;

Line: 319

  SELECT instr(p_ponum, '-', -1)
  INTO   position
  FROM   dual;

Line: 338

 select instr(p_ponum, '-', -1) into position
   from dual;