APPS.EDW_SUPPLIER_ITEM_PKG SQL Statements

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

Line: 22

        select  supplier_item_pk
          from  EDW_POA_SPIM_SPLRITEM_FKV
         where  vendor_name = p_supplier_name
           and  vendor_site_id = p_supplier_site_id
           and  vendor_product_num = p_supplier_product_num;

Line: 55

        select  supplier_item_pk
          from  EDW_POA_SPIM_SPLRITEM_FKV
         where  vendor_name = p_supplier_name
           and  vendor_site_code = p_supplier_site_code
           and  vendor_product_num = p_supplier_product_num;