DBA Data[Home] [Help]

APPS.BIX_ALERT SQL Statements

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

Line: 102

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 123

Select round(sum(abandoned_count)/sum(number_of_interactions)*100, 2) abandoned_level,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 129

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 136

  SELECT  tv.target_level_short_name
        , tv.target_level_name
	   , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 178

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 184

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 384

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 405

Select round(sum(interactions_answered_live)/sum(number_of_interactions)*100, 2) service_level,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 412

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 417

  SELECT  tv.target_level_short_name
        , tv.target_level_name
        , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 459

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 465

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 642

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 663

Select round(sum(speed_to_answer)/sum(number_of_interactions), 2) avg_speed_to_answer,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 669

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 674

  SELECT  tv.target_level_short_name
        , tv.target_level_name
        , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 714

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 720

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 946

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 967

Select round(sum(talk_time)/sum(talk_time + idle_time)*100, 2) occupancy_rate,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 973

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 980

  SELECT  tv.target_level_short_name
        , tv.target_level_name
        , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 1022

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 1027

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 1254

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 1275

Select round(sum(talk_time)/sum(interactions_answered_live)/60,2) avg_talk_time,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 1281

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 1286

  SELECT  tv.target_level_short_name
        , tv.target_level_name
        , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 1327

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 1333

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 1511

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 1532

Select round(sum(wait_time_to_abandon)/sum(number_of_interactions), 2) avg_wait_time_to_abandon,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 1538

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 1545

  SELECT  tv.target_level_short_name
        , tv.target_level_name
        , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 1586

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 1592

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 1774

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 1795

Select round(sum(talk_time)/sum(talk_time + idle_time) * 100, 2) utilization_rate,
       to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
from   bix_sum_grp_cls
group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 1801

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 1808

  SELECT  tv.target_level_short_name
        , tv.target_level_name
        , tv.target_level_id
        , tv.plan_name
        , tv.org_level_value_id
        , tv.time_level_value_id
        , tv.target
--        , tv.computed_target_short_name
        , tv.range1_low
        , tv.range1_high
        , tv.range2_low
        , tv.range2_high
        , tv.range3_low
        , tv.range3_high
        , tv.notify_resp1_id
        , tv.notify_resp1_short_name
        , tv.notify_resp2_id
        , tv.notify_resp2_short_name
        , tv.notify_resp3_id
        , tv.notify_resp3_short_name
        , tv.dim1_level_value_id
  FROM BISFV_TARGETS tv
  WHERE tv.target_level_short_name = p_target_level_short_name
  AND tv.time_level_value_id like '%' || p_time || '%'
  AND tv.org_level_value_id = p_organization_id
  AND tv.dim1_level_value_name = p_center_id;
Line: 1850

  SELECT workflow_item_type, workflow_process_short_name
  INTO l_workflow_item_type, l_workflow_process
  FROM bisbv_target_levels
  WHERE target_level_short_name = p_target_level_short_name;
Line: 1856

  BIS_ACTUAL_PUB.Retrieve_User_Selections
  ( p_api_version                  => 1.0
   ,p_Target_Level_Rec             => l_Target_Level_Rec
   ,x_Indicator_Region_Tbl         => l_user_selection_Tbl
   ,x_return_status                => l_return_status
   ,x_msg_count                    => l_msg_count
   ,x_msg_data                     => l_msg_data
   ,x_error_Tbl                    => l_error_tbl
  );
Line: 2038

l_user_selection_tbl       BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
Line: 2059

Select sum(interactions_answered_live) calls_ansd,
	  to_char(hour,'MON-YYYY') month,
       interaction_center_id center_id
	  from   bix_sum_grp_cls
	  group by to_char(hour,'MON-YYYY'), interaction_center_id;
Line: 2065

SELECT call_center_name center_name
FROM   bix_call_center_v
WHERE  call_center_id = p_center_id;
Line: 2071

SELECT  tv.target_level_short_name
	   , tv.target_level_name
	   , tv.target_level_id
	   , tv.plan_name
	   , tv.org_level_value_id
	   , tv.time_level_value_id
	   , tv.target
--      , tv.computed_target_short_name
	   , tv.range1_low
	   , tv.range1_high
	   , tv.range2_low
	   , tv.range2_high
	   , tv.range3_low
	   , tv.range3_high
	   , tv.notify_resp1_id
	   , tv.notify_resp1_short_name
	   , tv.notify_resp2_id
	   , tv.notify_resp2_short_name
	   , tv.notify_resp3_id
	   , tv.notify_resp3_short_name
	   , tv.dim1_level_value_id
FROM BISFV_TARGETS tv
WHERE tv.target_level_short_name = p_target_level_short_name
AND tv.time_level_value_id like '%' || p_time || '%'
AND tv.org_level_value_id = p_organization_id
AND tv.dim1_level_value_name = p_center_id;
Line: 2112

      SELECT workflow_item_type, workflow_process_short_name
      INTO l_workflow_item_type, l_workflow_process
	 FROM bisbv_target_levels
	 WHERE target_level_short_name = p_target_level_short_name;
Line: 2118

      BIS_ACTUAL_PUB.Retrieve_User_Selections
        ( p_api_version                  => 1.0
	     ,p_Target_Level_Rec             => l_Target_Level_Rec
		,x_Indicator_Region_Tbl         => l_user_selection_Tbl
	     ,x_return_status                => l_return_status
		,x_msg_count                    => l_msg_count
		,x_msg_data                     => l_msg_data
		,x_error_Tbl                    => l_error_tbl
	    );