APPS.POS_VENDOR_UTIL_PKG SQL Statements

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

Line: 36

   select vendor_name
     into l_new_vendor_name
     from ap_suppliers
     where vendor_id = p_vendor_id;

Line: 45

   update fnd_registration_details
      set field_value_string = l_new_vendor_name
        , last_updated_by = 1, last_update_date = sysdate
    where application_id = 177
      and field_name = 'Supplier Name'
      and registration_id in
          (select fr.registration_id from fnd_registrations fr,
           fnd_registration_details frd
           where registration_status IN ('INVITED', 'REGISTERED')
           and frd.registration_id = fr.registration_id
           and frd.field_name = 'Supplier Number'
           and frd.field_value_number = p_dup_vendor_id
           and frd.application_id = 177
          );

Line: 60

   update fnd_registration_details
      set field_value_number = p_vendor_id
        , last_update_date = sysdate, last_updated_by = 1
    where field_value_number = p_dup_vendor_id
      and application_id = 177
      and field_name = 'Supplier Number'
      and registration_id in
          (select registration_id from fnd_registrations
           where registration_status IN ('INVITED', 'REGISTERED')
           );

Line: 81

        SELECT party_id
          FROM ap_suppliers
         WHERE vendor_id = p_vendor_id;

Line: 107

        SELECT vendor_id
          FROM pos_supplier_users_v
         WHERE user_name = p_username;

Line: 122

        SELECT vendor_party_id
          FROM pos_supplier_users_v
         WHERE user_name = p_username;

Line: 144

      SELECT akw.number_value
        FROM ak_web_user_sec_attr_values akw, ap_suppliers pv
       WHERE akw.web_user_id = p_user_id
         AND akw.attribute_code = 'ICX_SUPPLIER_ORG_ID'
         AND akw.attribute_application_id = 177
         AND akw.number_value = pv.vendor_id
         AND ((pv.parent_vendor_id is null) OR
              (pv.parent_vendor_id not in
               (SELECT number_value
                  FROM ak_web_user_sec_attr_values
                 WHERE web_user_id = p_user_id
                   AND attribute_code = 'ICX_SUPPLIER_ORG_ID'
                   AND attribute_application_id = 177
                )
               )
              )
	 AND ROWNUM < 3;

Line: 163

      SELECT akw.number_value
        FROM ak_web_user_sec_attr_values akw, ap_supplier_sites_all pvs
       WHERE akw.web_user_id = p_user_id
         AND akw.attribute_code = 'ICX_SUPPLIER_SITE_ID'
         AND akw.attribute_application_id = 177
         AND akw.number_value = pvs.vendor_site_id
         AND pvs.vendor_id NOT IN
             (select vendor_id from ap_suppliers
              start with vendor_id = l_root_vendor_id
              connect by prior vendor_id = parent_vendor_id
              )
         AND ROWNUM < 2;

Line: 177

      SELECT akw.number_value
        FROM ak_web_user_sec_attr_values akw, po_vendor_contacts pvc
       WHERE akw.web_user_id = p_user_id
         AND akw.attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
         AND akw.attribute_application_id = 177
         AND akw.number_value = pvc.vendor_contact_id
         AND pvc.vendor_site_id not in
             (SELECT vendor_site_id
                FROM ap_supplier_sites_all
               WHERE vendor_id in
                     (select vendor_id
                        from ap_suppliers
                        start with vendor_id = l_root_vendor_id
                      connect by prior vendor_id = parent_vendor_id
                      )
              )
         AND ROWNUM < 2;

Line: 242

	SELECT 1
	  FROM ap_suppliers
         WHERE Upper(vendor_name) = Upper(p_vendor_name);