VIEW: APPS.CSI_INST_TXN_DETAILS_V

Source

View Text - Preformatted

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, CT.GL_INTERFACE_STATUS_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

View Text - HTML Formatted

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
, CT.GL_INTERFACE_STATUS_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