Product: | INV - Inventory |
---|---|
Description: | Required by electronic records to snapshot serial numbers. |
Implementation/DBA Data: | APPS.MTL_SERIAL_NUMBERS_TEMP_ERV |
SELECT MSNT.TRANSACTION_TEMP_ID
, NULL LOT_NUMBER
, MSN.VENDOR_SERIAL_NUMBER
, MSN.VENDOR_LOT_NUMBER
, MSNT.FM_SERIAL_NUMBER
, MSNT.TO_SERIAL_NUMBER
, MSNT.SERIAL_PREFIX
, MSN.PARENT_SERIAL_NUMBER
, MSN.END_ITEM_UNIT_NUMBER
, MSN.SERIAL_ATTRIBUTE_CATEGORY
, MSN.ORIGINATION_DATE
, MSN.C_ATTRIBUTE1
, MSN.C_ATTRIBUTE2
, MSN.C_ATTRIBUTE3
, MSN.C_ATTRIBUTE4
, MSN.C_ATTRIBUTE5
, MSN.C_ATTRIBUTE6
, MSN.C_ATTRIBUTE7
, MSN.C_ATTRIBUTE8
, MSN.C_ATTRIBUTE9
, MSN.C_ATTRIBUTE10
, MSN.C_ATTRIBUTE11
, MSN.C_ATTRIBUTE12
, MSN.C_ATTRIBUTE13
, MSN.C_ATTRIBUTE14
, MSN.C_ATTRIBUTE15
, MSN.C_ATTRIBUTE16
, MSN.C_ATTRIBUTE17
, MSN.C_ATTRIBUTE18
, MSN.C_ATTRIBUTE19
, MSN.C_ATTRIBUTE20
, MSN.D_ATTRIBUTE1
, MSN.D_ATTRIBUTE2
, MSN.D_ATTRIBUTE3
, MSN.D_ATTRIBUTE4
, MSN.D_ATTRIBUTE5
, MSN.D_ATTRIBUTE6
, MSN.D_ATTRIBUTE7
, MSN.D_ATTRIBUTE8
, MSN.D_ATTRIBUTE9
, MSN.D_ATTRIBUTE10
, MSN.N_ATTRIBUTE1
, MSN.N_ATTRIBUTE2
, MSN.N_ATTRIBUTE3
, MSN.N_ATTRIBUTE4
, MSN.N_ATTRIBUTE5
, MSN.N_ATTRIBUTE6
, MSN.N_ATTRIBUTE7
, MSN.N_ATTRIBUTE8
, MSN.N_ATTRIBUTE9
, MSN.N_ATTRIBUTE10
, MSN.TERRITORY_CODE
, MSN.TIME_SINCE_NEW
, MSN.CYCLES_SINCE_NEW
, MSN.TIME_SINCE_OVERHAUL
, MSN.CYCLES_SINCE_OVERHAUL
, MSN.TIME_SINCE_REPAIR
, MSN.CYCLES_SINCE_REPAIR
, MSN.TIME_SINCE_VISIT
, MSN.CYCLES_SINCE_VISIT
, MSN.TIME_SINCE_MARK
, MSN.CYCLES_SINCE_MARK
, MSN.NUMBER_OF_REPAIRS
FROM MTL_SERIAL_NUMBERS_TEMP MSNT
, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_SERIAL_NUMBERS MSN
WHERE MMTT.TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID
AND MMTT.TRANSACTION_ACTION_ID = 1
AND MSNT.FM_SERIAL_NUMBER = MSN.SERIAL_NUMBER
AND MSN.CURRENT_ORGANIZATION_ID = MMTT.ORGANIZATION_ID
AND MSN.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID UNION SELECT MSNT.TRANSACTION_TEMP_ID
, NULL LOT_NUMBER
, MSNT.VENDOR_SERIAL_NUMBER
, MSNT.VENDOR_LOT_NUMBER
, MSNT.FM_SERIAL_NUMBER
, MSNT.TO_SERIAL_NUMBER
, MSNT.SERIAL_PREFIX
, MSNT.PARENT_SERIAL_NUMBER
, MSNT.END_ITEM_UNIT_NUMBER
, MSNT.SERIAL_ATTRIBUTE_CATEGORY
, MSNT.ORIGINATION_DATE
, MSNT.C_ATTRIBUTE1
, MSNT.C_ATTRIBUTE2
, MSNT.C_ATTRIBUTE3
, MSNT.C_ATTRIBUTE4
, MSNT.C_ATTRIBUTE5
, MSNT.C_ATTRIBUTE6
, MSNT.C_ATTRIBUTE7
, MSNT.C_ATTRIBUTE8
, MSNT.C_ATTRIBUTE9
, MSNT.C_ATTRIBUTE10
, MSNT.C_ATTRIBUTE11
, MSNT.C_ATTRIBUTE12
, MSNT.C_ATTRIBUTE13
, MSNT.C_ATTRIBUTE14
, MSNT.C_ATTRIBUTE15
, MSNT.C_ATTRIBUTE16
, MSNT.C_ATTRIBUTE17
, MSNT.C_ATTRIBUTE18
, MSNT.C_ATTRIBUTE19
, MSNT.C_ATTRIBUTE20
, MSNT.D_ATTRIBUTE1
, MSNT.D_ATTRIBUTE2
, MSNT.D_ATTRIBUTE3
, MSNT.D_ATTRIBUTE4
, MSNT.D_ATTRIBUTE5
, MSNT.D_ATTRIBUTE6
, MSNT.D_ATTRIBUTE7
, MSNT.D_ATTRIBUTE8
, MSNT.D_ATTRIBUTE9
, MSNT.D_ATTRIBUTE10
, MSNT.N_ATTRIBUTE1
, MSNT.N_ATTRIBUTE2
, MSNT.N_ATTRIBUTE3
, MSNT.N_ATTRIBUTE4
, MSNT.N_ATTRIBUTE5
, MSNT.N_ATTRIBUTE6
, MSNT.N_ATTRIBUTE7
, MSNT.N_ATTRIBUTE8
, MSNT.N_ATTRIBUTE9
, MSNT.N_ATTRIBUTE10
, MSNT.TERRITORY_CODE
, MSNT.TIME_SINCE_NEW
, MSNT.CYCLES_SINCE_NEW
, MSNT.TIME_SINCE_OVERHAUL
, MSNT.CYCLES_SINCE_OVERHAUL
, MSNT.TIME_SINCE_REPAIR
, MSNT.CYCLES_SINCE_REPAIR
, MSNT.TIME_SINCE_VISIT
, MSNT.CYCLES_SINCE_VISIT
, MSNT.TIME_SINCE_MARK
, MSNT.CYCLES_SINCE_MARK
, MSNT.NUMBER_OF_REPAIRS
FROM MTL_SERIAL_NUMBERS_TEMP MSNT
, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
WHERE MMTT.TRANSACTION_TEMP_ID = MSNT.TRANSACTION_TEMP_ID
AND MMTT.TRANSACTION_ACTION_ID != 1 UNION SELECT L.TRANSACTION_TEMP_ID
, L.LOT_NUMBER
, S.VENDOR_SERIAL_NUMBER
, S.VENDOR_LOT_NUMBER
, S.FM_SERIAL_NUMBER
, S.TO_SERIAL_NUMBER
, S.SERIAL_PREFIX
, S.PARENT_SERIAL_NUMBER
, S.END_ITEM_UNIT_NUMBER
, S.SERIAL_ATTRIBUTE_CATEGORY
, S.ORIGINATION_DATE
, S.C_ATTRIBUTE1
, S.C_ATTRIBUTE2
, S.C_ATTRIBUTE3
, S.C_ATTRIBUTE4
, S.C_ATTRIBUTE5
, S.C_ATTRIBUTE6
, S.C_ATTRIBUTE7
, S.C_ATTRIBUTE8
, S.C_ATTRIBUTE9
, S.C_ATTRIBUTE10
, S.C_ATTRIBUTE11
, S.C_ATTRIBUTE12
, S.C_ATTRIBUTE13
, S.C_ATTRIBUTE14
, S.C_ATTRIBUTE15
, S.C_ATTRIBUTE16
, S.C_ATTRIBUTE17
, S.C_ATTRIBUTE18
, S.C_ATTRIBUTE19
, S.C_ATTRIBUTE20
, S.D_ATTRIBUTE1
, S.D_ATTRIBUTE2
, S.D_ATTRIBUTE3
, S.D_ATTRIBUTE4
, S.D_ATTRIBUTE5
, S.D_ATTRIBUTE6
, S.D_ATTRIBUTE7
, S.D_ATTRIBUTE8
, S.D_ATTRIBUTE9
, S.D_ATTRIBUTE10
, S.N_ATTRIBUTE1
, S.N_ATTRIBUTE2
, S.N_ATTRIBUTE3
, S.N_ATTRIBUTE4
, S.N_ATTRIBUTE5
, S.N_ATTRIBUTE6
, S.N_ATTRIBUTE7
, S.N_ATTRIBUTE8
, S.N_ATTRIBUTE9
, S.N_ATTRIBUTE10
, S.TERRITORY_CODE
, S.TIME_SINCE_NEW
, S.CYCLES_SINCE_NEW
, S.TIME_SINCE_OVERHAUL
, S.CYCLES_SINCE_OVERHAUL
, S.TIME_SINCE_REPAIR
, S.CYCLES_SINCE_REPAIR
, S.TIME_SINCE_VISIT
, S.CYCLES_SINCE_VISIT
, S.TIME_SINCE_MARK
, S.CYCLES_SINCE_MARK
, S.NUMBER_OF_REPAIRS
FROM MTL_SERIAL_NUMBERS_TEMP S
, MTL_TRANSACTION_LOTS_TEMP L
WHERE S.TRANSACTION_TEMP_ID = L.SERIAL_TRANSACTION_TEMP_ID