APPS.PO_VENDORS_SV1 SQL Statements

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

Line: 28

    SELECT count(*)
    INTO   x_temp_1
    FROM   po_suppliers_val_v
    WHERE  vendor_id = X_vendor_id;

Line: 43

           SELECT  count(*)
	    INTO   x_temp_2
            FROM    po_supplier_po_sites_val_v
            WHERE   vendor_id  = X_vendor_id
            AND     vendor_site_id = X_vendor_site_id;

Line: 56

           SELECT  count(*)
	    INTO   x_temp_3
            FROM    po_supplier_sites_val_v
            WHERE   vendor_id  = X_vendor_id
            AND     vendor_site_id = X_vendor_site_id;

Line: 74

       SELECT  count(*)
       INTO    x_temp_4
       FROM    po_vendor_contacts
       WHERE   vendor_site_id  = X_vendor_site_id
       AND     vendor_contact_id = X_vendor_contact_id;

Line: 109

/*  We will select the vendor id from the po_suppliers_val_v view
    based on the input vendor name.                             */

   SELECT COUNT(*)
     INTO X_vendor_count
     FROM po_suppliers_val_v
    WHERE (vendor_name = X_vendor_name
           OR
           segment1 = X_vendor_num);

Line: 122

      SELECT  vendor_id
        INTO  X_vendor_name_v
        FROM  po_suppliers_val_v
       WHERE  (vendor_name = X_vendor_name
               OR
               segment1 = X_vendor_num);