APPS.WIP_WEIGHTED_AVG SQL Statements

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

Line: 12

    select nvl(wp.auto_compute_final_completion, WIP_CONSTANTS.NO)
    from   wip_parameters wp
    where  wp.organization_id = c_org_id;

Line: 17

    select mp.primary_cost_method
    from   mtl_parameters mp
    where  mp.organization_id = c_org_id;

Line: 91

    select start_quantity - quantity_scrapped
    from   wip_discrete_jobs
    where  wip_entity_id = c_wip_id
    and    organization_id = c_org_id;

Line: 99

    select nvl(sum(primary_quantity),0)
    from   mtl_material_transactions
    where  transaction_source_type_id = 5
    and    transaction_source_id = c_wip_id
    and    organization_id = c_org_id
    and    transaction_action_id in (WIP_CONSTANTS.CPLASSY_ACTION,
                                     WIP_CONSTANTS.RETASSY_ACTION);

Line: 160

      select sum(quantity_in_queue)
      + sum(quantity_running)
      + sum(quantity_waiting_to_move)
      + sum(quantity_rejected)
      into l_remain_job_qty
      from wip_operations
      where wip_entity_id = p_wip_id
      and organization_id = p_org_id;

Line: 202

    select mmtt.rowid,
           mmtt.primary_quantity
    from   mtl_material_transactions_temp mmtt
    where  mmtt.transaction_header_id = c_mtl_hdr_id
    and    mmtt.transaction_action_id = WIP_CONSTANTS.CPLASSY_ACTION
    order by mmtt.source_line_id;

Line: 251

      select sum(quantity_in_queue)
      + sum(quantity_running)
      + sum(quantity_waiting_to_move)
      + sum(quantity_rejected)
      into l_remain_job_qty
      from wip_operations
      where wip_entity_id = p_wip_id
      and organization_id = p_org_id;

Line: 278

        update mtl_material_transactions_temp
        set    final_completion_flag = 'Y'
        where  rowid = x_rowid;