DBA Data[Home] [Help] [Dependency Information]

TABLE: CSI.CSI_ITEM_INSTANCES

Object Details
Object Name: CSI_ITEM_INSTANCES
Object Type: TABLE
Owner: CSI
FND Design Data: TableCSI.CSI_ITEM_INSTANCES
Subobject Name:
Status: VALID


Item Instaces details.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_ITEM_INSTANCES_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_ID
CSI_ITEM_INSTANCES_U02 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_NUMBER
CSI_ITEM_INSTANCES_F01 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPPER("SERIAL_NUMBER")
CSI_ITEM_INSTANCES_N01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnINV_MASTER_ORGANIZATION_ID
CSI_ITEM_INSTANCES_N03 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_TYPE_CODE
ColumnINV_ORGANIZATION_ID
ColumnINV_SUBINVENTORY_NAME
ColumnINV_LOCATOR_ID
CSI_ITEM_INSTANCES_N04 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVE_END_DATE
CSI_ITEM_INSTANCES_N05 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERIAL_NUMBER
CSI_ITEM_INSTANCES_N06 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_TYPE_CODE
ColumnLOCATION_ID
CSI_ITEM_INSTANCES_N07 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYSTEM_ID
CSI_ITEM_INSTANCES_N08 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_TYPE_CODE
ColumnPA_PROJECT_ID
CSI_ITEM_INSTANCES_N09 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_TYPE_CODE
ColumnWIP_JOB_ID
CSI_ITEM_INSTANCES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_TYPE_CODE
ColumnIN_TRANSIT_ORDER_LINE_ID
CSI_ITEM_INSTANCES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_OE_ORDER_LINE_ID
CSI_ITEM_INSTANCES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNER_PARTY_ACCOUNT_ID
ColumnINVENTORY_ITEM_ID
CSI_ITEM_INSTANCES_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNER_PARTY_ID
ColumnOWNER_PARTY_SOURCE_TABLE
ColumnINSTANCE_NUMBER
CSI_ITEM_INSTANCES_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_OE_AGREEMENT_ID
CSI_ITEM_INSTANCES_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTALL_LOCATION_TYPE_CODE
ColumnINSTALL_LOCATION_ID
CSI_ITEM_INSTANCES_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONFIG_INST_HDR_ID
ColumnCONFIG_INST_ITEM_ID
CSI_ITEM_INSTANCES_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXTERNAL_REFERENCE
CSI_ITEM_INSTANCES_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_DESCRIPTION
CSI_ITEM_INSTANCES_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOT_NUMBER
CSI_ITEM_INSTANCES_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_PO_PO_LINE_ID
ColumnLOCATION_TYPE_CODE
CSI_ITEM_INSTANCES_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnSERIAL_NUMBER
ColumnLAST_VLD_ORGANIZATION_ID
ColumnINSTANCE_ID
ColumnINSTANCE_NUMBER
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER
Yes Unique ID that identifies an item unit instance ( Internally generated sequence number )
INSTANCE_NUMBER VARCHAR2 (30) Yes Functional, user key to the item instance
EXTERNAL_REFERENCE VARCHAR2 (30)
External reference, like customer asset tag.
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier from MTL_SYSTEM_ITEMS_B
INVENTORY_REVISION VARCHAR2 (3)
Inventory Revision Code
INV_MASTER_ORGANIZATION_ID NUMBER
Yes Inventory Master Organization Identifier from MTL_ORGANIZATIONS
SERIAL_NUMBER VARCHAR2 (30)
Serial Number of the Instance.
MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
Flag indicating if the Serial Number is a manufacturer's Serial number.
LOT_NUMBER VARCHAR2 (80)
Lot Number.
QUANTITY NUMBER
Yes Quantity
UNIT_OF_MEASURE VARCHAR2 (3) Yes Unit of Measure Code.
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Accounting Classification Code.
INSTANCE_CONDITION_ID NUMBER

Instance Condition Identifier.
INSTANCE_STATUS_ID NUMBER
Yes Instance Status Identifier.
CUSTOMER_VIEW_FLAG VARCHAR2 (1) Yes Flag indicating if the Instance is as per the Customer Definition.
MERCHANT_VIEW_FLAG VARCHAR2 (1) Yes Flag indicating if the instance is as per the Merchant View.
SELLABLE_FLAG VARCHAR2 (1)
Flag indicating if the Instance is sellable.
SYSTEM_ID NUMBER

System Identifier to which the Instance is a part of.
INSTANCE_TYPE_CODE VARCHAR2 (30)
Instance Type Code.
ACTIVE_START_DATE DATE

Activation Start Date.
ACTIVE_END_DATE DATE

Activation End Date.
LOCATION_TYPE_CODE VARCHAR2 (30)
Location Type Code.
LOCATION_ID NUMBER

Location Identifier.
INV_ORGANIZATION_ID NUMBER

Inventory Organization Identifier.
INV_SUBINVENTORY_NAME VARCHAR2 (10)
Inventory Sub-Inventory Name.
INV_LOCATOR_ID NUMBER

Inventory Locator Identifier.
PA_PROJECT_ID NUMBER

Project Identifier from Project Accounting.
PA_PROJECT_TASK_ID NUMBER

Project Task Identifier from Project Accounting.
IN_TRANSIT_ORDER_LINE_ID NUMBER

Order Line Identifier for an In-Transit Order (Internal Order).
WIP_JOB_ID NUMBER

WIP Job Identifier.
PO_ORDER_LINE_ID NUMBER

Purchase Order Line Identifier.
LAST_OE_ORDER_LINE_ID NUMBER

Last Order Line Idetifier that touched the Instance.
LAST_OE_RMA_LINE_ID NUMBER

Last RMA Line Identifier that touched the Instance.
LAST_PO_PO_LINE_ID NUMBER

Last Purchase Order Line Identifier from Purchasing.
LAST_OE_PO_NUMBER VARCHAR2 (50)
Last Order Entry Purchase Order Number
LAST_WIP_JOB_ID NUMBER

Last WIP job Identifier.
LAST_PA_PROJECT_ID NUMBER

Last Project Identifier from Project Accounting.
LAST_PA_TASK_ID NUMBER

Last Task Identifier from Project Accounting.
LAST_OE_AGREEMENT_ID NUMBER

Last Agreement Identifier from Order Entry.
INSTALL_DATE DATE

Installation Date for an Instance.
MANUALLY_CREATED_FLAG VARCHAR2 (1)
Flag indicating if the instance is created manually.
RETURN_BY_DATE DATE

Date the Instance to be returned.
ACTUAL_RETURN_DATE DATE

Date of the Actual Return.
CREATION_COMPLETE_FLAG VARCHAR2 (1)
Flag indicating if the Instance Creation is complete.
COMPLETENESS_FLAG VARCHAR2 (1)
Flag indicating if the Instance Configuration is Complete.
CONTEXT VARCHAR2 (30)
Standard DFF Columns
ATTRIBUTE1 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE2 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE3 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE4 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE5 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE6 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE7 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE8 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE9 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE10 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE11 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE12 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE13 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE14 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE15 VARCHAR2 (240)
Standard DFF Columns
CREATED_BY NUMBER (15) Yes Standard WHO Columns
CREATION_DATE DATE
Yes Standard WHO Columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Columns
LAST_UPDATE_DATE DATE
Yes Standard WHO Columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Columns
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
SECURITY_GROUP_ID NUMBER

Security Group Identifier.
LAST_TXN_LINE_DETAIL_ID NUMBER

Transaction Line Detail Identifier.
INSTALL_LOCATION_TYPE_CODE VARCHAR2 (30)
Install Location Type Code.
INSTALL_LOCATION_ID NUMBER

Install Location Identifier.
INSTANCE_USAGE_CODE VARCHAR2 (30)
Instance Usage Code.
OWNER_PARTY_SOURCE_TABLE VARCHAR2 (30)
De-normalized Column for Instance Owner Party Source Table.
OWNER_PARTY_ID NUMBER

De-normalized Column for Instance Owner Party Identifier
OWNER_PARTY_ACCOUNT_ID NUMBER

De-normalized Column for Instance Owner Party Account Identifier.
LAST_VLD_ORGANIZATION_ID NUMBER

The Organization Identifier by which the Instance was validated Last.
MIGRATED_FLAG VARCHAR2 (1)
Flag indicating if the record is migrated.
REQUEST_ID NUMBER

Party / Account Merge
PROGRAM_APPLICATION_ID NUMBER

Party / Account Merge
PROGRAM_ID NUMBER

Party / Account Merge
PROGRAM_UPDATE_DATE DATE

Party / Account Merge
CONFIG_INST_HDR_ID NUMBER

Configuration Instance Header Identified from Configurator
CONFIG_INST_REV_NUM NUMBER

Configuration Instance Header Revision Number Configurator
CONFIG_INST_ITEM_ID NUMBER

Configuration Instance Item Identified from Configurator
CONFIG_VALID_STATUS VARCHAR2 (30)
Configurator Validation Status. 1. Valid 2.Invalid
INSTANCE_DESCRIPTION VARCHAR2 (240)
Item Instance Description.
LAST_PURGE_DATE DATE

Last history purge date for this item instance
ATTRIBUTE16 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE17 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE18 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE19 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE20 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE21 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE22 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE23 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE24 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE25 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE26 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE27 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE28 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE29 VARCHAR2 (240)
Standard DFF Columns
ATTRIBUTE30 VARCHAR2 (240)
Standard DFF Columns
NETWORK_ASSET_FLAG VARCHAR2 (1)
eAM Network Asset Flag
MAINTAINABLE_FLAG VARCHAR2 (1)
eAM Maintainable Flag
PN_LOCATION_ID NUMBER

eAM PN Location Id
ASSET_CRITICALITY_CODE VARCHAR2 (30)
eAM Asset Criticality Code
CATEGORY_ID NUMBER

eAM Category Id
EQUIPMENT_GEN_OBJECT_ID NUMBER

eAM Equipment Object Id
INSTANTIATION_FLAG VARCHAR2 (1)
eAM Instantiation Flag
LINEAR_LOCATION_ID NUMBER

eAM Linear Location Id
OPERATIONAL_LOG_FLAG VARCHAR2 (1)
eAM Operational Log Flag
CHECKIN_STATUS NUMBER

eAM Checkin Status Indicator
SUPPLIER_WARRANTY_EXP_DATE DATE

eAM Supplier Warranty Expiration Date
PURCHASE_UNIT_PRICE NUMBER

Purchase Unit Price
PURCHASE_CURRENCY_CODE VARCHAR2 (15)
Purchase Currency Code
PAYABLES_UNIT_PRICE NUMBER

Payables Unit Price
PAYABLES_CURRENCY_CODE VARCHAR2 (15)
Payables Currency Code
SALES_UNIT_PRICE NUMBER

Sales Unit Price
SALES_CURRENCY_CODE VARCHAR2 (15)
Sales Currency Code
OPERATIONAL_STATUS_CODE VARCHAR2 (30)
Operational Status Code
SOURCE_CODE VARCHAR2 (10)
Source Code
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
,      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
,      SECURITY_GROUP_ID
,      LAST_TXN_LINE_DETAIL_ID
,      INSTALL_LOCATION_TYPE_CODE
,      INSTALL_LOCATION_ID
,      INSTANCE_USAGE_CODE
,      OWNER_PARTY_SOURCE_TABLE
,      OWNER_PARTY_ID
,      OWNER_PARTY_ACCOUNT_ID
,      LAST_VLD_ORGANIZATION_ID
,      MIGRATED_FLAG
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONFIG_INST_HDR_ID
,      CONFIG_INST_REV_NUM
,      CONFIG_INST_ITEM_ID
,      CONFIG_VALID_STATUS
,      INSTANCE_DESCRIPTION
,      LAST_PURGE_DATE
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      NETWORK_ASSET_FLAG
,      MAINTAINABLE_FLAG
,      PN_LOCATION_ID
,      ASSET_CRITICALITY_CODE
,      CATEGORY_ID
,      EQUIPMENT_GEN_OBJECT_ID
,      INSTANTIATION_FLAG
,      LINEAR_LOCATION_ID
,      OPERATIONAL_LOG_FLAG
,      CHECKIN_STATUS
,      SUPPLIER_WARRANTY_EXP_DATE
,      PURCHASE_UNIT_PRICE
,      PURCHASE_CURRENCY_CODE
,      PAYABLES_UNIT_PRICE
,      PAYABLES_CURRENCY_CODE
,      SALES_UNIT_PRICE
,      SALES_CURRENCY_CODE
,      OPERATIONAL_STATUS_CODE
,      SOURCE_CODE
FROM CSI.CSI_ITEM_INSTANCES;

Dependencies

[top of page]

CSI.CSI_ITEM_INSTANCES does not reference any database object

CSI.CSI_ITEM_INSTANCES is referenced by following:

SchemaCSI
ViewCSI_ITEM_INSTANCES#