DBA Data[Home] [Help]

APPS.PO_LINES_SV1 SQL Statements

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

Line: 23

   SELECT count(*)
     INTO x_temp
     FROM po_lines
    WHERE po_header_id = x_po_header_id
      AND line_num = x_line_num
      AND (rowid <> x_rowid OR x_rowid is null);
Line: 62

   SELECT COUNT(*)
     INTO x_temp
     FROM po_lines
    WHERE po_header_id = x_po_header_id
      AND po_line_id = x_po_line_id
      AND (rowid <> x_rowid OR x_rowid is null);
Line: 101

 SELECT po_line_id
   INTO X_po_line_id_v
   FROM po_lines
  WHERE po_header_id = X_po_header_id
    AND line_num = X_line_num;