[Home] [Help] [Dependency Information]

VIEW: APPS.CSI_INST_TXN_DETAILS_V

Object Details

Object Name:	CSI_INST_TXN_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSI.CSI_INST_TXN_DETAILS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

APPS

CSI_ITEM_INSTANCES

CSI_ITEM_INSTANCES_H

CSI_TRANSACTIONS

CSI_TXN_TYPES

APPS

CSE_ASSET_CREATION_PKG - show dependent code

CSE_ASSET_MOVE_PKG - show dependent code

CSE_ASSET_UTIL_PKG - show dependent code

CSE_ASSET_WIP_PKG - show dependent code

CSE_GL_INTERFACE_PKG - show dependent code