DBA Data[Home] [Help]

APPS.PO_RFQ_VENDORS_PKG_S4 SQL Statements

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

Line: 25

  SELECT  1
  INTO    dummy
  FROM    sys.DUAL
  WHERE  not exists (SELECT 1
		     FROM   po_rfq_vendors
		     WHERE  po_header_id   = X_po_header_id
                     AND    vendor_id      = X_vendor_id
		     AND    vendor_site_id = X_vendor_site_id
		     AND    ((X_rowid is null) or
                             (X_rowid != rowid)));