APPS.MSC_PMF_PKG SQL Statements

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

Line: 100

         select value
         into l_thresh_value
         from msc_exception_threshold_values
         where exception_type = p_exception_type
         and   company_id = p_company_id
         and   company_site_id = p_company_site_id
         and   inventory_item_id = p_inventory_item_id
         and   supplier_id = p_supplier_id
         and   supplier_site_id = p_supplier_site_id;

Line: 126

         select value
         into l_thresh_value
         from msc_exception_threshold_values
         where exception_type = p_exception_type
         and   company_id = p_company_id
         and   company_site_id = p_company_site_id
         and   inventory_item_id = p_inventory_item_id
         and   customer_id = p_customer_id
         and   customer_site_id = p_customer_site_id;

Line: 164

            select value
            into l_thresh_value
            from msc_exception_threshold_values
            where exception_type = p_exception_type
            and   company_id = p_company_id
            and   company_site_id = p_company_site_id
            and   inventory_item_id = p_inventory_item_id
            and   supplier_id = p_supplier_id;

Line: 188

            select value
            into l_thresh_value
            from msc_exception_threshold_values
            where exception_type = p_exception_type
            and   company_id = p_company_id
            and   company_site_id = p_company_site_id
            and   inventory_item_id = p_inventory_item_id
            and   customer_id = p_customer_id;

Line: 225

            select value
            into l_thresh_value
            from msc_exception_threshold_values
            where exception_type = p_exception_type
            and   company_id = p_company_id
            and   inventory_item_id = p_inventory_item_id
            and   supplier_id = p_supplier_id;

Line: 247

            select value
            into l_thresh_value
            from msc_exception_threshold_values
            where exception_type = p_exception_type
            and   company_id = p_company_id
            and   inventory_item_id = p_inventory_item_id
            and   customer_id = p_customer_id;

Line: 282

            select value
            into l_thresh_value
            from msc_exception_threshold_values
            where exception_type = p_exception_type
            and   company_id = p_company_id
            and   supplier_id = p_supplier_id;

Line: 302

            select value
            into l_thresh_value
            from msc_exception_threshold_values
            where exception_type = p_exception_type
            and   company_id = p_company_id
            and   customer_id = p_customer_id;

Line: 334

         select value
         into l_thresh_value
         from msc_exception_threshold_values
         where exception_type = p_exception_type
         and   company_id = p_company_id
         and   company_site_id is NULL
         and   inventory_item_id is NULL
         and   supplier_id is NULL
         and   supplier_site_id is NULL
         and   customer_id is NULL
         and   customer_site_id is NULL; ---Added for FP-bug#6472941;;