View: CSI_INST_TXN_DETAILS_V

Product:	CSI - Install Base
Description:	Details about the transaction performed on an Instance.
Implementation/DBA Data:	APPS.CSI_INST_TXN_DETAILS_V

View Text

SELECT CII.INSTANCE_ID
, CII.INSTANCE_NUMBER
, CII.EXTERNAL_REFERENCE
, CII.INVENTORY_ITEM_ID
, CII.INVENTORY_REVISION
, CII.INV_MASTER_ORGANIZATION_ID
, CII.SERIAL_NUMBER
, CII.MFG_SERIAL_NUMBER_FLAG
, CII.LOT_NUMBER
, CII.QUANTITY
, CII.UNIT_OF_MEASURE
, CII.ACCOUNTING_CLASS_CODE
, CII.INSTANCE_CONDITION_ID
, CII.INSTANCE_STATUS_ID
, CII.CUSTOMER_VIEW_FLAG
, CII.MERCHANT_VIEW_FLAG
, CII.SELLABLE_FLAG
, CII.SYSTEM_ID
, CII.INSTANCE_TYPE_CODE
, CII.ACTIVE_START_DATE
, CII.ACTIVE_END_DATE
, CII.LOCATION_TYPE_CODE
, CII.LOCATION_ID
, CII.INV_ORGANIZATION_ID
, CII.INV_SUBINVENTORY_NAME
, CII.INV_LOCATOR_ID
, CII.PA_PROJECT_ID
, CII.PA_PROJECT_TASK_ID
, CII.IN_TRANSIT_ORDER_LINE_ID
, CII.WIP_JOB_ID
, CII.PO_ORDER_LINE_ID
, CII.LAST_OE_ORDER_LINE_ID
, CII.LAST_OE_RMA_LINE_ID
, CII.LAST_PO_PO_LINE_ID
, CII.LAST_OE_PO_NUMBER
, CII.LAST_WIP_JOB_ID
, CII.LAST_PA_PROJECT_ID
, CII.LAST_PA_TASK_ID
, CII.LAST_OE_AGREEMENT_ID
, CII.INSTALL_DATE
, CII.MANUALLY_CREATED_FLAG
, CII.RETURN_BY_DATE
, CII.ACTUAL_RETURN_DATE
, CII.CREATION_COMPLETE_FLAG
, CII.COMPLETENESS_FLAG
, CII.CONTEXT INST_CONTEXT
, CII.ATTRIBUTE1 INST_ATTRIBUTE1
, CII.ATTRIBUTE2 INST_ATTRIBUTE2
, CII.ATTRIBUTE3 INST_ATTRIBUTE3
, CII.ATTRIBUTE4 INST_ATTRIBUTE4
, CII.ATTRIBUTE5 INST_ATTRIBUTE5
, CII.ATTRIBUTE6 INST_ATTRIBUTE6
, CII.ATTRIBUTE7 INST_ATTRIBUTE7
, CII.ATTRIBUTE8 INST_ATTRIBUTE8
, CII.ATTRIBUTE9 INST_ATTRIBUTE9
, CII.ATTRIBUTE10 INST_ATTRIBUTE10
, CII.ATTRIBUTE11 INST_ATTRIBUTE11
, CII.ATTRIBUTE12 INST_ATTRIBUTE12
, CII.ATTRIBUTE13 INST_ATTRIBUTE13
, CII.ATTRIBUTE14 INST_ATTRIBUTE14
, CII.ATTRIBUTE15 INST_ATTRIBUTE15
, CII.CREATED_BY INST_CREATED_BY
, CII.CREATION_DATE INST_CREATION_DATE
, CII.LAST_UPDATED_BY INST_LAST_UPDATED_BY
, CII.LAST_UPDATE_DATE INST_LAST_UPDATE_DATE
, CII.LAST_UPDATE_LOGIN INST_LAST_UPDATE_LOGIN
, CII.OBJECT_VERSION_NUMBER INST_OBJECT_VERSION_NUMBER
, CII.LAST_TXN_LINE_DETAIL_ID
, CII.INSTALL_LOCATION_TYPE_CODE
, CII.INSTALL_LOCATION_ID
, CII.INSTANCE_USAGE_CODE
, CT.TRANSACTION_ID
, CT.TRANSACTION_DATE
, CT.SOURCE_TRANSACTION_DATE
, CT.TRANSACTION_TYPE_ID
, CT.TXN_SUB_TYPE_ID
, CT.SOURCE_GROUP_REF_ID
, CT.SOURCE_GROUP_REF
, CT.SOURCE_HEADER_REF_ID
, CT.SOURCE_HEADER_REF
, CT.SOURCE_LINE_REF_ID
, CT.SOURCE_LINE_REF
, CT.SOURCE_DIST_REF_ID1
, CT.SOURCE_DIST_REF_ID2
, CT.INV_MATERIAL_TRANSACTION_ID
, CT.TRANSACTION_QUANTITY
, CT.TRANSACTION_UOM_CODE
, CT.TRANSACTED_BY
, CT.TRANSACTION_STATUS_CODE
, CT.TRANSACTION_ACTION_CODE
, CT.MESSAGE_ID
, CT.CONTEXT
, CT.ATTRIBUTE1
, CT.ATTRIBUTE2
, CT.ATTRIBUTE3
, CT.ATTRIBUTE4
, CT.ATTRIBUTE5
, CT.ATTRIBUTE6
, CT.ATTRIBUTE7
, CT.ATTRIBUTE8
, CT.ATTRIBUTE9
, CT.ATTRIBUTE10
, CT.ATTRIBUTE11
, CT.ATTRIBUTE12
, CT.ATTRIBUTE13
, CT.ATTRIBUTE14
, CT.ATTRIBUTE15
, CT.CREATED_BY
, CT.CREATION_DATE
, CT.LAST_UPDATED_BY
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATE_LOGIN
, CT.OBJECT_VERSION_NUMBER
, CTT.SOURCE_APPLICATION_ID
, CTT.SOURCE_TRANSACTION_TYPE
, CTT.SOURCE_TXN_TYPE_NAME
, CTT.DESCRIPTION
, CTT.SOURCE_OBJECT_CODE
FROM CSI_TRANSACTIONS CT
, CSI_TXN_TYPES CTT
, CSI_ITEM_INSTANCES_H CIIH
, CSI_ITEM_INSTANCES CII
WHERE CT.TRANSACTION_ID = CIIH.TRANSACTION_ID
AND CIIH.INSTANCE_ID = CII.INSTANCE_ID
AND CTT.TRANSACTION_TYPE_ID = CT.TRANSACTION_TYPE_ID

Columns