APPS.WMS_PARAMETER_EXT SQL Statements

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

Line: 93

   select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
   from   mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
   where  mtrl.line_id = mmtt.move_order_line_id
   and    mmtt.transaction_temp_id = p_transaction_id;

Line: 239

   select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
   from   mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
   where  mtrl.line_id = mmtt.move_order_line_id
   and    mmtt.transaction_temp_id = p_transaction_id;

Line: 385

   select primary_uom_code
   from   mtl_system_items msi
   where  msi.inventory_item_id = p_inventory_item_id
   and    msi.organization_id = p_organization_id;

Line: 486

   select mmtt.organization_id, mmtt.inventory_item_id,
          nvl(mmtt.transfer_subinventory, mmtt.subinventory_code),
          nvl(mmtt.transfer_to_location, mmtt.locator_id),
          mtlt.lot_number
   from   mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt
   where  mmtt.transaction_temp_id = mtlt.transaction_temp_id
   and    mmtt.transaction_temp_id = p_transaction_id;

Line: 568

     select primary_uom_code
     from mtl_system_items mtl
     where mtl.inventory_item_id = p_inventory_item_id
     and mtl.organization_id = p_organization_id;

Line: 575

     select sum(wlc.quantity) summed_quantity, uom_code
     from wms_lpn_contents wlc
     where wlc.parent_lpn_id = p_lpn_id
     and wlc.inventory_item_id = p_inventory_item_id
     and wlc.organization_id = p_organization_id
     and nvl(wlc.revision, '@@@') = nvl(p_revision, nvl(wlc.revision, '@@@'))
     and nvl(wlc.lot_number, '@@@@') = nvl(p_lot_number, nvl(wlc.lot_number, '@@@@'))
     group by uom_code;

Line: 693

     select primary_uom_code
     from mtl_system_items mtl
     where mtl.inventory_item_id = p_inventory_item_id
     and mtl.organization_id = p_organization_id;

Line: 700

     select sum(wlc.quantity) summed_quantity, uom_code
     from wms_lpn_contents wlc
     where wlc.parent_lpn_id = p_lpn_id
     and wlc.inventory_item_id = p_inventory_item_id
     and wlc.organization_id = p_organization_id
     group by uom_code;

Line: 801

  select count(distinct(wlc.inventory_item_id))
  into  l_return_value
  from  wms_lpn_contents wlc
  where wlc.parent_lpn_id = p_lpn_id
  and   wlc.organization_id = p_organization_id;

Line: 829

  select count(distinct(wlc.revision))
  into  l_return_value
  from  wms_lpn_contents wlc
  where wlc.parent_lpn_id = p_lpn_id
  and   wlc.inventory_item_id = p_inventory_item_id
  and   wlc.organization_id = p_organization_id;

Line: 859

  select count(distinct(wlc.lot_number))
  into  l_return_value
  from  wms_lpn_contents wlc
  where wlc.parent_lpn_id = p_lpn_id
  and   wlc.inventory_item_id = p_inventory_item_id
  and   wlc.organization_id = p_organization_id;