APPS.CSP_FORECAST_PVT SQL Statements

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

Line: 17

  select schedule_close_date end_date
  from   org_acct_periods
  where  period_start_date = trunc(p_period_start_date)
  and    organization_id = p_organization_id
  order by period_start_date asc;

Line: 45

  /*select start_date
  from   org_acct_periods_v
  where  start_date >= c_start_date
  and    organization_id = p_organization_id
  order by start_date asc;*/

Line: 50

  select PERIOD_START_DATE
  from   ORG_ACCT_PERIODS
  where PERIOD_START_DATE >= c_start_date
  and    organization_id = p_organization_id
  order by PERIOD_START_DATE asc;

Line: 57

  /*select start_date
  from   org_acct_periods_v
  where  start_date < c_start_date
  and    organization_id = p_organization_id
  order by start_date desc;*/

Line: 62

  select PERIOD_START_DATE
  from   ORG_ACCT_PERIODS
  where PERIOD_START_DATE < c_start_date
  and    organization_id = p_organization_id
  order by PERIOD_START_DATE desc;

Line: 236

  select sum(quantity) usage_quantity
  from   csp_usage_histories
  where  parts_loop_id      = nvl(p_parts_loop_id,parts_loop_id)
  and    organization_id    = p_organization_id
  and    subinventory_code  = nvl(p_subinventory_code,subinventory_code)
  and    inventory_item_id  = p_inventory_item_id
  and    history_data_type = 0
  Group by Period_Start_date
  Order by period_start_date desc;

Line: 247

  select cfrb.period_size,
	 cfrb.forecast_rule_id,
         cfrb.period_type,
         cfrb.forecast_method,
         cfrb.forecast_periods,
         cfrb.history_periods,
         cfrb.alpha,
         cfrb.beta,
         cfrb.weighted_avg_period1,
         cfrb.weighted_avg_period2,
         cfrb.weighted_avg_period3,
         cfrb.weighted_avg_period4,
         cfrb.weighted_avg_period5,
         cfrb.weighted_avg_period6,
         cfrb.weighted_avg_period7,
         cfrb.weighted_avg_period8,
         cfrb.weighted_avg_period9,
         cfrb.weighted_avg_period10,
         cfrb.weighted_avg_period11,
         cfrb.weighted_avg_period12
   from  csp_forecast_rules_b cfrb,
         csp_parts_loops_b cplb
   where cfrb.forecast_rule_id = cplb.forecast_rule_id
   and   cplb.parts_loop_id = p_parts_loop_id;

Line: 351

    csp_usage_histories_pkg.insert_row(
        px_usage_id           => l_usage_id,
        p_created_by          => fnd_global.user_id,
        p_creation_date       => sysdate,
        p_last_updated_by     => fnd_global.user_id,
        p_last_update_date    => sysdate,
        p_last_update_login   => null,
        p_inventory_item_id   => p_inventory_item_id,
        p_organization_id     => p_organization_id,
        p_period_type         => l_rec.period_type,
        p_period_start_date   => sysdate + ((l_count - 1) * l_rec.period_size),
        p_quantity            => l_forecast_qty,
        p_request_id          => null,
        p_program_application_id => null,
        p_program_id          => null,
        p_program_update_date => null,
        p_subinventory_code   => nvl(p_subinventory_code,'-'),
        p_transaction_type_id => -1,
        p_hierarchy_node_id   => null,
        p_parts_loop_id       => p_parts_loop_id,
	p_history_data_type   => 0,
        p_attribute_category  => null,
        p_attribute1          => null,
        p_attribute2          => null,
        p_attribute3          => null,
        p_attribute4          => null,
        p_attribute5          => null,
        p_attribute6          => null,
        p_attribute7          => null,
        p_attribute8          => null,
        p_attribute9          => null,
        p_attribute10         => null,
        p_attribute11         => null,
        p_attribute12         => null,
        p_attribute13         => null,
        p_attribute14         => null,
        p_attribute15         => null);