[Home] [Help]
View: CSP_USAGE_HISTORIES_V
Product: | CSP - Spares Management |
Description: | Usage history generated by a batchprogram |
Implementation/DBA Data: |
APPS.CSP_USAGE_HISTORIES_V
|
View Text
SELECT CUH.CREATED_BY
, CUH.CREATION_DATE
, CUH.LAST_UPDATED_BY
, CUH.LAST_UPDATE_DATE
, CUH.LAST_UPDATE_LOGIN
, CUH.USAGE_ID
, CUH.INVENTORY_ITEM_ID
, CUH.ORGANIZATION_ID
, CUH.HIERARCHY_NODE_ID
, CUH.PARTS_LOOP_ID
, CUH.PERIOD_TYPE
, CUH.PERIOD_START_DATE
, CUH.QUANTITY
, CUH.SUBINVENTORY_CODE
, CUH.TRANSACTION_TYPE_ID
, CUH.ATTRIBUTE_CATEGORY
, CUH.ATTRIBUTE1
, CUH.ATTRIBUTE2
, CUH.ATTRIBUTE3
, CUH.ATTRIBUTE4
, CUH.ATTRIBUTE5
, CUH.ATTRIBUTE6
, CUH.ATTRIBUTE7
, CUH.ATTRIBUTE8
, CUH.ATTRIBUTE9
, CUH.ATTRIBUTE10
, CUH.ATTRIBUTE11
, CUH.ATTRIBUTE12
, CUH.ATTRIBUTE13
, CUH.ATTRIBUTE14
, CUH.ATTRIBUTE15
FROM CSP_USAGE_HISTORIES CUH
Columns
Name |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
USAGE_ID |
INVENTORY_ITEM_ID |
ORGANIZAITON_ID |
HIERARCHY_NODE_ID |
PARTS_LOOP_ID |
PERIOD_TYPE |
PERIOD_START_DATE |
QUANTITY |
SUBINVENTORY_CODE |
TRANSACTION_TYPE_ID |
ATTRIBUTE_CATEGORY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |