APPS.CST_ITEMRESOURCECOSTS_GRP SQL Statements

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

Line: 111

      select primary_cost_method
      into l_cost_type_id
      from mtl_parameters
      where organization_id = p_organization_id;

Line: 121

      select item_cost
      into x_item_cost
      from cst_item_costs
      where organization_id = p_organization_id
      and inventory_item_id = p_item_id
      and cost_type_id = l_cost_type_id;

Line: 132

      select list_price_per_unit
      into x_item_cost
      from mtl_system_items_b
      where organization_id = p_organization_id
      and inventory_item_id = p_item_id;

Line: 142

      select avg(transaction_cost)
      into x_item_cost
      from mtl_material_transactions
      where transaction_id in
      ( select transaction_id
        from
        ( select transaction_id
          from mtl_material_transactions
          where transaction_action_id = 27
          and transaction_source_type_id = 1
          and organization_id = p_organization_id
          and inventory_item_id = p_item_id
          and transaction_quantity > 0
          order by transaction_id desc)
        where rownum <= CST_ItemResourceCosts_GRP.LAST_N_PO_RECEIPTS);

Line: 164

   select currency_code
   into x_currency_code
   from cst_organization_definitions
   where organization_id =  p_organization_id;

Line: 331

      select avg_rates_cost_type_id
      into l_cost_type_id
      from mtl_parameters
      where organization_id = p_organization_id;

Line: 339

   select resource_rate
   into x_resource_rate
   from cst_resource_costs
   where organization_id = p_organization_id
   and resource_id = p_resource_id
   and cost_type_id = l_cost_type_id;

Line: 348

   select currency_code
   into x_currency_code
   from cst_organization_definitions
   where organization_id = p_organization_id;