APPS.CSP_FAILURE_RATES_PVT SQL Statements

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

Line: 27

select cfrb.history_periods * cfrb.period_size history_size,
       cplp.level_id,
       cpp.planning_parameters_id,
       cpp.product_id,
	   cpp.current_population
from   csp_product_populations cpp,
       csp_planning_parameters cplp,
       csp_forecast_rules_b cfrb
where  cplp.planning_parameters_id = cpp.planning_parameters_id
and    cplp.product_norm = 'Y'
and    cplp.forecast_rule_id = cfrb.forecast_rule_id
and    cplp.level_id like p_level_id||'%';

Line: 41

select cdl.inventory_item_id,
       sum(inv_convert.inv_um_convert(
       cdl.inventory_item_id,
       null,
       cdl.quantity,
       cdl.uom_code,
       msib.primary_uom_code,
       null,
       null)) quantity
from   csf_debrief_lines cdl,
       csf_debrief_headers cdh,
       jtf_task_assignments jta,
       jtf_tasks_b jtb,
       mtl_system_items_b msib,
       cs_incidents_all cia,
       csp_planning_parameters cplp
where  cdl.issuing_sub_inventory_code is not null
and    cdl.spare_update_status = 'SUCCEEDED'
and    cdl.inventory_item_id = msib.inventory_item_id
and    cdl.issuing_inventory_org_id = msib.organization_id
and    cdh.debrief_header_id = cdl.debrief_header_id
and    jta.task_assignment_id = cdh.task_assignment_id
and    jtb.task_id = jta.task_id
and    jtb.source_object_type_code = 'SR'
and    cia.incident_id = jtb.source_object_id
and    cia.inventory_item_id = l_product_id
and    cdl.issuing_inventory_org_id = cplp.organization_id
and    cdl.issuing_sub_inventory_code = nvl(cplp.secondary_inventory,cdl.issuing_sub_inventory_code)
and    cplp.level_id like l_level_id||'%'
and    cdl.service_date > sysdate - l_history_size
group by  cdl.inventory_item_id;

Line: 121

		delete from csp_failure_rates
		where  product_id = cp.product_id
		and    planning_parameters_id = cp.planning_parameters_id
		and	   manual_failure_rate is null;

Line: 129

		  update csp_failure_rates cfr
		  set    cfr.calculated_failure_rate = l_failure_rate,
		         cfr.last_updated_by         = g_user_id,
				 cfr.last_update_date		 = sysdate,
				 cfr.last_update_login		 = g_user_id
		  where  cfr.planning_parameters_id = cp.planning_parameters_id
		  and    cfr.product_id = cp.product_id
 		  and    cfr.inventory_item_id = cdl.inventory_item_id;

Line: 138

    	    insert into csp_failure_rates(
		      failure_rate_id,
			  planning_parameters_id,
              product_id,
              inventory_item_id,
              calculated_failure_rate,
              manual_failure_rate,
              last_update_date,
              last_updated_by,
              creation_date,
              created_by,
              last_update_login)
	        values(
		      csp_failure_rates_s1.nextval,
			  cp.planning_parameters_id,
			  cp.product_id,
			  cdl.inventory_item_id,
			  l_failure_rate,
			  null,
			  sysdate,
			  g_user_id,
			  sysdate,
			  g_user_id,
			  g_login_id);