VIEW: APPS.MTL_SERIAL_NUMBERS_TEMP_ERV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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