FND Design Data [Home] [Help]

View: MTL_UNIT_TRANSACTIONS_ALL_V

Product: INV - Inventory
Description: 10SC ONLY
Implementation/DBA Data: ViewAPPS.MTL_UNIT_TRANSACTIONS_ALL_V
View Text

SELECT TRANSACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SERIAL_NUMBER
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, TRANSACTION_DATE
, TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_NAME
, RECEIPT_ISSUE_TYPE
, CUSTOMER_ID
, SHIP_ID
, SERIAL_ATTRIBUTE_CATEGORY
, TERRITORY_CODE
, ORIGINATION_DATE
, C_ATTRIBUTE1
, C_ATTRIBUTE2
, C_ATTRIBUTE3
, C_ATTRIBUTE4
, C_ATTRIBUTE5
, C_ATTRIBUTE6
, C_ATTRIBUTE7
, C_ATTRIBUTE8
, C_ATTRIBUTE9
, C_ATTRIBUTE10
, C_ATTRIBUTE11
, C_ATTRIBUTE12
, C_ATTRIBUTE13
, C_ATTRIBUTE14
, C_ATTRIBUTE15
, C_ATTRIBUTE16
, C_ATTRIBUTE17
, C_ATTRIBUTE18
, C_ATTRIBUTE19
, C_ATTRIBUTE20
, D_ATTRIBUTE1
, D_ATTRIBUTE2
, D_ATTRIBUTE3
, D_ATTRIBUTE4
, D_ATTRIBUTE5
, D_ATTRIBUTE6
, D_ATTRIBUTE7
, D_ATTRIBUTE8
, D_ATTRIBUTE9
, D_ATTRIBUTE10
, N_ATTRIBUTE1
, N_ATTRIBUTE2
, N_ATTRIBUTE3
, N_ATTRIBUTE4
, N_ATTRIBUTE5
, N_ATTRIBUTE6
, N_ATTRIBUTE7
, N_ATTRIBUTE8
, N_ATTRIBUTE9
, N_ATTRIBUTE10
, STATUS_ID
, TIME_SINCE_NEW
, CYCLES_SINCE_NEW
, TIME_SINCE_OVERHAUL
, CYCLES_SINCE_OVERHAUL
, TIME_SINCE_REPAIR
, CYCLES_SINCE_REPAIR
, TIME_SINCE_VISIT
, CYCLES_SINCE_VISIT
, TIME_SINCE_MARK
, CYCLES_SINCE_MARK
, NUMBER_OF_REPAIRS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM MTL_UNIT_TRANSACTIONS

Columns

Name
TRANSACTION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
SERIAL_NUMBER
INVENTORY_ITEM_ID
ORGANIZATION_ID
SUBINVENTORY_CODE
LOCATOR_ID
TRANSACTION_DATE
TRANSACTION_SOURCE_ID
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_SOURCE_NAME
RECEIPT_ISSUE_TYPE
CUSTOMER_ID
SHIP_ID
SERIAL_ATTRIBUTE_CATEGORY
TERRITORY_CODE
ORIGINATION_DATE
C_ATTRIBUTE1
C_ATTRIBUTE2
C_ATTRIBUTE3
C_ATTRIBUTE4
C_ATTRIBUTE5
C_ATTRIBUTE6
C_ATTRIBUTE7
C_ATTRIBUTE8
C_ATTRIBUTE9
C_ATTRIBUTE10
C_ATTRIBUTE11
C_ATTRIBUTE12
C_ATTRIBUTE13
C_ATTRIBUTE14
C_ATTRIBUTE15
C_ATTRIBUTE16
C_ATTRIBUTE17
C_ATTRIBUTE18
C_ATTRIBUTE19
C_ATTRIBUTE20
D_ATTRIBUTE1
D_ATTRIBUTE2
D_ATTRIBUTE3
D_ATTRIBUTE4
D_ATTRIBUTE5
D_ATTRIBUTE6
D_ATTRIBUTE7
D_ATTRIBUTE8
D_ATTRIBUTE9
D_ATTRIBUTE10
N_ATTRIBUTE1
N_ATTRIBUTE2
N_ATTRIBUTE3
N_ATTRIBUTE4
N_ATTRIBUTE5
N_ATTRIBUTE6
N_ATTRIBUTE7
N_ATTRIBUTE8
N_ATTRIBUTE9
N_ATTRIBUTE10
STATUS_ID
TIME_SINCE_NEW
CYCLES_SINCE_NEW
TIME_SINCE_OVERHAUL
CYCLES_SINCE_OVERHAUL
TIME_SINCE_REPAIR
CYCLES_SINCE_REPAIR
TIME_SINCE_VISIT
CYCLES_SINCE_VISIT
TIME_SINCE_MARK
CYCLES_SINCE_MARK
NUMBER_OF_REPAIRS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15