APPS.GML_PO_HEADER_ARCHIVE SQL Statements

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

Line: 93

    SELECT agent_id,
     bill_to_location_id,
     terms_id,
     freight_terms_lookup_code,
     fob_lookup_code,
     ship_via_lookup_code

    FROM   po_headers_archive_all
    WHERE  segment1     = p_segment1
    AND    revision_num = p_revision_num;

Line: 107

  SELECT po_line_id,ship_to_location_id,line_location_id
  FROM   po_line_locations_archive_all
  WHERE  po_header_id = v_po_header_id  ;

Line: 116

/* and the resub routine. Just call GML_PO_INTERFACE.insert_rec  */

/*
      OPEN  po_headers_archive_cur(v_segment1, v_revision_num-1);

Line: 143

      GML_PO_INTERFACE.insert_rec (v_po_header_id,
                               v_po_line_id,
                               v_line_location_id,
                               null,
                               null,
                               null,
                               null,
                               null,
                               null,
                               null,
                               null,
                               'N',
                               null,
                               v_ship_to_location_id, null);