1 Reply Latest reply: Jun 5, 2008 8:32 AM by 628428 RSS

    Oracle Install Base relationship to Serial Numbers

    Jason ORCL
      OK, so the table CSI_TRANSACTIONS is a listing of transactions within Install Base, right?

      I need to associate a serial number with each. How is this table connected to MTL_SERIAL_NUMBERS?

      If I have an install base transaction_id...how do I get the serial number?

      Any help would be appreciated!
        • 1. Re: Oracle Install Base relationship to Serial Numbers
          628428
          select a.serial_number from mtl_unit_transactions a,mtl_material_transactions b, csi_transactions c
          where a.transaction_id=b.transaction_id
          and b.transaction_id=c.inv_material_transaction_id
          UNION
          select a.serial_number from mtl_unit_transactions a,mtl_material_transactions b, csi_transactions c,mtl_transaction_lot_numbers d
          where a.transaction_id=d.serial_transaction_id
          and b.transaction_id=d.transaction_id
          and b.transaction_id=c.inv_material_transaction_id;

          Thanks
          Nagamohan