APPS.CSI_SYSTEMS_TRANSACTIONS_V
[Home] [Help]
| Product: | CSI - Install Base |
|---|---|
| Description: | Systems transactions View |
| Implementation/DBA Data: |
APPS.CSI_SYSTEMS_TRANSACTIONS_V
|
SELECT T.TRANSACTION_ID TRANSACTION_ID
, TL.SYSTEM_ID SYSTEM_ID
, T.TRANSACTION_DATE TRASACTION_DATE
, T.SOURCE_TRANSACTION_DATE SOURCE_TRANSACTION_DATE
, T.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, T.TXN_SUB_TYPE_ID TXN_SUB_TYPE_ID
, T.SOURCE_GROUP_REF_ID SOURCE_GROUP_REF_ID
, T.SOURCE_GROUP_REF SOURCE_GROUP_REF
, T.SOURCE_HEADER_REF_ID SOURCE_HEADER_REF_ID
, T.SOURCE_HEADER_REF SOURCE_HEADER_REF
, T.SOURCE_LINE_REF_ID SOURCE_LINE_REF_ID
, T.SOURCE_LINE_REF SOURCE_LINE_REF
, T.SOURCE_DIST_REF_ID1 SOURCE_DIST_REF_ID1
, T.SOURCE_DIST_REF_ID2 SOURCE_DIST_REF_ID2
, T.INV_MATERIAL_TRANSACTION_ID INV_MATERIAL_TRANSACTION_ID
, T.TRANSACTION_QUANTITY TRANSACTION_QUANTITY
, T.TRANSACTION_UOM_CODE TRANSACTION_UOM_CODE
, T.TRANSACTED_BY TRANSACTED_BY
, T.TRANSACTION_STATUS_CODE TRANSACTION_STATUS_CODE
, T.TRANSACTION_ACTION_CODE TRANSACTION_ACTION_CODE
, T.MESSAGE_ID MESSAGE_ID
, T.CONTEXT CONTEXT
, T.ATTRIBUTE1 ATTRIBUTE1
, T.ATTRIBUTE2 ATTRIBUTE2
, T.ATTRIBUTE3 ATTRIBUTE3
, T.ATTRIBUTE4 ATTRIBUTE4
, T.ATTRIBUTE5 ATTRIBUTE5
, T.ATTRIBUTE6 ATTRIBUTE6
, T.ATTRIBUTE7 ATTRIBUTE7
, T.ATTRIBUTE8 ATTRIBUTE8
, T.ATTRIBUTE9 ATTRIBUTE9
, T.ATTRIBUTE10 ATTRIBUTE10
, T.ATTRIBUTE11 ATTRIBUTE11
, T.ATTRIBUTE12 ATTRIBUTE12
, T.ATTRIBUTE13 ATTRIBUTE13
, T.ATTRIBUTE14 ATTRIBUTE14
, T.ATTRIBUTE15 ATTRIBUTE15
, T.CREATED_BY CREATED_BY
, T.CREATION_DATE CREATION_DATE
, T.LAST_UPDATED_BY LAST_UPDATED_BY
, T.LAST_UPDATE_DATE LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, T.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TL.NAME NAME
, B.SYSTEM_NUMBER SYSTEM_NUMBER
, TL.DESCRIPTION SYSTEM_DESCRIPTION
, FND.USER_NAME TXN_USER_NAME
FROM CSI_TRANSACTIONS T
, CSI_SYSTEMS_H H
, CSI_SYSTEMS_B B
, CSI_SYSTEMS_TL TL
, FND_USER FND
WHERE T.TRANSACTION_ID = H.TRANSACTION_ID
AND FND.USER_ID = T.LAST_UPDATED_BY
AND H.SYSTEM_ID = TL.SYSTEM_ID
AND TL.SYSTEM_ID = B.SYSTEM_ID
AND TL.LANGUAGE = USERENV('LANG')