[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_INSTANCE_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | CSI |
| FND Design Data: |  CSI.CSI_INSTANCE_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
This is the Open Interface table for Install Base Open Interface that contains the records for Instance and its Pricing Attributes and Organization Assignments.
Scope: public
Product: CSI
Lifecycle: active
Display Name: CSI Instance Interface
Category: BUSINESS_ENTITY CSI_ITEM_INSTANCE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CSI_INSTANCE_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 INST_INTERFACE_ID
|
| CSI_INSTANCE_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SOURCE_TRANSACTION_DATE
|
| CSI_INSTANCE_INTERFACE_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PROCESS_STATUS
|
| CSI_INSTANCE_INTERFACE_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
SOURCE_SYSTEM_NAME
|
| CSI_INSTANCE_INTERFACE_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PARALLEL_WORKER_ID
|
| CSI_INSTANCE_INTERFACE_U2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
TRANSACTION_IDENTIFIER
SOURCE_SYSTEM_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INST_INTERFACE_ID | NUMBER | Yes | Instance Interface ID | |
| SOURCE_SYSTEM_NAME | VARCHAR2 | (30) | Yes | Source System Name from CSI_INTERFACE_SOURCES |
| PARALLEL_WORKER_ID | NUMBER | Parallel Worker ID that is assigned to this Instance used when creating instances with the Parallel Worker Process Only. | ||
| REPLACE_FLAG | VARCHAR2 | (1) | Flag which indicates if the item instance is replaced | |
| TRANSACTION_IDENTIFIER | VARCHAR2 | (30) | CSI Transaction identifier | |
| SOURCE_TRANSACTION_DATE | DATE | Yes | Transaction Date that this Instance will be processed with the Open Interface. | |
| SOURCE_TRANSACTION_TYPE | VARCHAR2 | (30) | CSI Source transaction type | |
| INSTANCE_ID | NUMBER | Unique ID that identifies an item unit instance | ||
| INSTANCE_NUMBER | VARCHAR2 | (30) | Functional User Key for Item Instance | |
| INSTANCE_DESCRIPTION | VARCHAR2 | (240) | Description of the item instance | |
| EXTERNAL_REFERENCE | VARCHAR2 | (30) | External reference given to item instance | |
| PROCESS_STATUS | VARCHAR2 | (1) | Yes | Process Status for Instance. Value Values are 'R' - Ready, 'E' - Error, 'P' - Processed |
| BATCH_NAME | VARCHAR2 | (30) | Open interface batch name | |
| ERROR_TEXT | VARCHAR2 | (2000) | Error text for any errors that are encountered while processing each row of data. | |
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Id for the instance you are interfacing | ||
| INV_CONCATENATED_SEGMENTS | VARCHAR2 | (250) | Concatenated Segment for the instance you are interfacing | |
| INVENTORY_REVISION | VARCHAR2 | (30) | Inventory Revision for items that are revision controlled in Inventory | |
| INV_VLD_ORGANIZATION_ID | NUMBER | Validation Organization ID that is used for Validating the Inventory Attributes | ||
| INV_VLD_ORGANIZATION_NAME | VARCHAR2 | (250) | Validation Organization Name that is used for Validating the Inventory Attributes | |
| SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number for this Item Instance | |
| MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Manufacturer Serial Number Flag for this Instance. Valid values are Yes - 'Y' or No - 'N'. If this is set to Yes Install Base will validate the serial number against inventory otherwise it will not. | |
| LOT_NUMBER | VARCHAR2 | (30) | The Lot Number for the lot where this item will exist | |
| QUANTITY | NUMBER | Instance Quantity | ||
| UNIT_OF_MEASURE_CODE | VARCHAR2 | (3) | Unit of Measure Code that will be used for this Instance (i.e. 'EA') | |
| UNIT_OF_MEASURE | VARCHAR2 | (30) | Unit of Measure that will be used for this Instance (i.e. 'Each') | |
| ACCOUNTING_CLASS_CODE | VARCHAR2 | (30) | Accounting Class Code | |
| INSTANCE_CONDITION_ID | NUMBER | Instance Condition ID | ||
| INSTANCE_CONDITION | VARCHAR2 | (30) | Instance Condition Name | |
| INSTANCE_STATUS_ID | NUMBER | Instance Status ID | ||
| INSTANCE_STATUS | VARCHAR2 | (30) | Instance Status Name | |
| CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | Flag that indicates if this is as per a customer definition | |
| MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | Flag that indicates if this is as per a merchant definition | |
| SELLABLE_FLAG | VARCHAR2 | (1) | Flag that indicates if this instance is sellable | |
| SYSTEM_ID | NUMBER | System ID | ||
| SYSTEM_NUMBER | VARCHAR2 | (30) | System Number | |
| INSTANCE_START_DATE | DATE | Active Start Date for this Instance | ||
| INSTANCE_END_DATE | DATE | Active End Date for this Instance | ||
| INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Instance Type Code | |
| LOCATION_TYPE_CODE | VARCHAR2 | (30) | Location Type Code | |
| LOCATION_ID | NUMBER | Location ID | ||
| INV_ORGANIZATION_ID | NUMBER | Inventory Organization ID | ||
| INV_ORGANIZATION_CODE | VARCHAR2 | (30) | Inventory Organization Code | |
| INV_ORGANIZATION_NAME | VARCHAR2 | (250) | Inventory Organization Name | |
| INV_SUBINVENTORY_NAME | VARCHAR2 | (250) | Inventory Subinventory Name | |
| INV_LOCATOR_NUMBER | VARCHAR2 | (30) | Inventory Locator Number | |
| INV_LOCATOR_ID | NUMBER | Inventory Locator ID | ||
| PROJECT_ID | NUMBER | Project ID | ||
| PROJECT_NUMBER | VARCHAR2 | (30) | Project Number | |
| TASK_ID | NUMBER | Task ID | ||
| TASK_NUMBER | VARCHAR2 | (30) | Task Number | |
| IN_TRANSIT_ORDER_LINE_ID | NUMBER | In Transit Order Line ID | ||
| IN_TRANSIT_ORDER_LINE_NUMBER | VARCHAR2 | (30) | In Transit Order Line Number | |
| WIP_JOB_ID | NUMBER | WIP Job ID | ||
| WIP_JOB_NAME | VARCHAR2 | (250) | WIP Job Name | |
| PO_ORDER_LINE_ID | NUMBER | Purchase Order Line ID | ||
| PO_ORDER_LINE_NUMBER | VARCHAR2 | (30) | Purchase Order Line Number | |
| OE_ORDER_LINE_ID | NUMBER | Order Line ID | ||
| OE_ORDER_LINE_NUMBER | VARCHAR2 | (30) | Order Line Number | |
| OE_RMA_LINE_ID | NUMBER | RMA Line Id | ||
| OE_RMA_LINE_NUMBER | VARCHAR2 | (30) | RMA Line Number | |
| PO_PO_LINE_ID | NUMBER | Purchase Order Line ID | ||
| PO_PO_LINE_NUMBER | VARCHAR2 | (30) | Purchase Order Line Number | |
| OE_PO_NUMBER | VARCHAR2 | (50) | Order Entry PO Number | |
| OE_AGREEMENT_ID | NUMBER | Order Entry Agreement ID | ||
| INSTALL_LOCATION_TYPE_CODE | VARCHAR2 | (30) | Install Location Type Code | |
| INSTALL_LOCATION_ID | NUMBER | Install Location ID | ||
| INSTALL_DATE | DATE | Install Date | ||
| RETURN_BY_DATE | DATE | Return By Date | ||
| ACTUAL_RETURN_DATE | DATE | Actual Return Date | ||
| CONFIG_INST_HDR_ID | NUMBER | Configured item instance header id | ||
| CONFIG_INST_REV_NUM | NUMBER | Configured item instance revision number | ||
| CONFIG_INST_ITEM_ID | NUMBER | Configured item instance component item id | ||
| CONFIG_VALID_STATUS | VARCHAR2 | (30) | Configured item instance status | |
| INSTANCE_OU_ID | NUMBER | Instance Organization Unit ID | ||
| OPERATING_UNIT_NAME | VARCHAR2 | (250) | Operating Unit Name | |
| OPERATING_UNIT | NUMBER | Operating Unit Code | ||
| OU_RELATION_TYPE | VARCHAR2 | (30) | Operating Unit Relationship Type | |
| OU_START_DATE | DATE | Operating Unit Active Start Date | ||
| OU_END_DATE | DATE | Operating Unit Active End Date | ||
| INSTANCE_CONTEXT | VARCHAR2 | (30) | Instance Flexfield Context | |
| INSTANCE_ATTRIBUTE1 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE2 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE3 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE4 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE5 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE6 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE7 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE8 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE9 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE10 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE11 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE12 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE13 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE14 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE15 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| PRICING_ATTRIBUTE_ID | NUMBER | Pricing Attribute ID | ||
| PRICING_ATT_START_DATE | DATE | Pricing Attribute Active Start Date | ||
| PRICING_ATT_END_DATE | DATE | Pricing Attribute Active End Date | ||
| PRICING_CONTEXT | VARCHAR2 | (30) | Pricing Attribute Flexfield Context | |
| PRICING_ATTRIBUTE1 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE2 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE3 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE4 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE5 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE6 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE7 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE8 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE9 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE10 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE11 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE12 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE13 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE14 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE15 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE16 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE17 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE18 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE19 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE20 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE21 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE22 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE23 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE24 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE25 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE26 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE27 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE28 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE29 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE30 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE31 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE32 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE33 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE34 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE35 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE36 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE37 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE38 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE39 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE40 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE41 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE42 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE43 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE44 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE45 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE46 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE47 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE48 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE49 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE50 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE51 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE52 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE53 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE54 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE55 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE56 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE57 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE58 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE59 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE60 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE61 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE62 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE63 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE64 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE65 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE66 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE67 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE68 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE69 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE70 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE71 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE72 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE73 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE74 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE75 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE76 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE77 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE78 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE79 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE80 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE81 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE82 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE83 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE84 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE85 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE86 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE87 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE88 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE89 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE90 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE91 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE92 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE93 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE94 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE95 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE96 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE97 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE98 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE99 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_ATTRIBUTE100 | VARCHAR2 | (150) | Pricing Attribute Flexfield Column | |
| PRICING_FLEX_CONTEXT | VARCHAR2 | (30) | Pricing Flexfield Context | |
| PRICING_FLEX_ATTRIBUTE1 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE2 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE3 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE4 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE5 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE6 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE7 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE8 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE9 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE10 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE11 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE12 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE13 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE14 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| PRICING_FLEX_ATTRIBUTE15 | VARCHAR2 | (150) | Standard Oracle DFF Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Oracle Who Column |
| CREATION_DATE | DATE | Yes | Standard Oracle Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Oracle Who Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard Oracle Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Oracle Who Column | |
| NETWORK_ASSET_FLAG | VARCHAR2 | (1) | Network Asset Flag | |
| MAINTAINABLE_FLAG | VARCHAR2 | (1) | Maintainable Flag | |
| ASSET_CRITICALITY_CODE | VARCHAR2 | (30) | Asset Criticality Code | |
| CATEGORY_ID | NUMBER | Category Id | ||
| EQUIPMENT_GEN_OBJECT_ID | NUMBER | Equipment object id | ||
| INSTANTIATION_FLAG | VARCHAR2 | (1) | Instantiation Flag | |
| OPERATIONAL_LOG_FLAG | VARCHAR2 | (1) | Operational Log Flag | |
| SUPPLIER_WARRANTY_EXP_DATE | DATE | Supplier Warranty Expiration Date | ||
| INSTANCE_ATTRIBUTE21 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE16 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE17 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE18 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE19 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE20 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE22 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE23 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE24 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE25 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE26 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE27 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE28 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE29 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| INSTANCE_ATTRIBUTE30 | VARCHAR2 | (240) | Standard Oracle DFF Column | |
| SYNCUP_FAMILY | NUMBER | (22) | To identify item instance-assets belonging to the same network of an assets and item instance | |
| OPERATIONAL_STATUS_CODE | VARCHAR2 | (30) | Operational Status Code |
Cut, paste (and edit) the following text to query this object:
SELECT INST_INTERFACE_ID
, SOURCE_SYSTEM_NAME
, PARALLEL_WORKER_ID
, REPLACE_FLAG
, TRANSACTION_IDENTIFIER
, SOURCE_TRANSACTION_DATE
, SOURCE_TRANSACTION_TYPE
, INSTANCE_ID
, INSTANCE_NUMBER
, INSTANCE_DESCRIPTION
, EXTERNAL_REFERENCE
, PROCESS_STATUS
, BATCH_NAME
, ERROR_TEXT
, INVENTORY_ITEM_ID
, INV_CONCATENATED_SEGMENTS
, INVENTORY_REVISION
, INV_VLD_ORGANIZATION_ID
, INV_VLD_ORGANIZATION_NAME
, SERIAL_NUMBER
, MFG_SERIAL_NUMBER_FLAG
, LOT_NUMBER
, QUANTITY
, UNIT_OF_MEASURE_CODE
, UNIT_OF_MEASURE
, ACCOUNTING_CLASS_CODE
, INSTANCE_CONDITION_ID
, INSTANCE_CONDITION
, INSTANCE_STATUS_ID
, INSTANCE_STATUS
, CUSTOMER_VIEW_FLAG
, MERCHANT_VIEW_FLAG
, SELLABLE_FLAG
, SYSTEM_ID
, SYSTEM_NUMBER
, INSTANCE_START_DATE
, INSTANCE_END_DATE
, INSTANCE_TYPE_CODE
, LOCATION_TYPE_CODE
, LOCATION_ID
, INV_ORGANIZATION_ID
, INV_ORGANIZATION_CODE
, INV_ORGANIZATION_NAME
, INV_SUBINVENTORY_NAME
, INV_LOCATOR_NUMBER
, INV_LOCATOR_ID
, PROJECT_ID
, PROJECT_NUMBER
, TASK_ID
, TASK_NUMBER
, IN_TRANSIT_ORDER_LINE_ID
, IN_TRANSIT_ORDER_LINE_NUMBER
, WIP_JOB_ID
, WIP_JOB_NAME
, PO_ORDER_LINE_ID
, PO_ORDER_LINE_NUMBER
, OE_ORDER_LINE_ID
, OE_ORDER_LINE_NUMBER
, OE_RMA_LINE_ID
, OE_RMA_LINE_NUMBER
, PO_PO_LINE_ID
, PO_PO_LINE_NUMBER
, OE_PO_NUMBER
, OE_AGREEMENT_ID
, INSTALL_LOCATION_TYPE_CODE
, INSTALL_LOCATION_ID
, INSTALL_DATE
, RETURN_BY_DATE
, ACTUAL_RETURN_DATE
, CONFIG_INST_HDR_ID
, CONFIG_INST_REV_NUM
, CONFIG_INST_ITEM_ID
, CONFIG_VALID_STATUS
, INSTANCE_OU_ID
, OPERATING_UNIT_NAME
, OPERATING_UNIT
, OU_RELATION_TYPE
, OU_START_DATE
, OU_END_DATE
, INSTANCE_CONTEXT
, INSTANCE_ATTRIBUTE1
, INSTANCE_ATTRIBUTE2
, INSTANCE_ATTRIBUTE3
, INSTANCE_ATTRIBUTE4
, INSTANCE_ATTRIBUTE5
, INSTANCE_ATTRIBUTE6
, INSTANCE_ATTRIBUTE7
, INSTANCE_ATTRIBUTE8
, INSTANCE_ATTRIBUTE9
, INSTANCE_ATTRIBUTE10
, INSTANCE_ATTRIBUTE11
, INSTANCE_ATTRIBUTE12
, INSTANCE_ATTRIBUTE13
, INSTANCE_ATTRIBUTE14
, INSTANCE_ATTRIBUTE15
, PRICING_ATTRIBUTE_ID
, PRICING_ATT_START_DATE
, PRICING_ATT_END_DATE
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15
, PRICING_ATTRIBUTE16
, PRICING_ATTRIBUTE17
, PRICING_ATTRIBUTE18
, PRICING_ATTRIBUTE19
, PRICING_ATTRIBUTE20
, PRICING_ATTRIBUTE21
, PRICING_ATTRIBUTE22
, PRICING_ATTRIBUTE23
, PRICING_ATTRIBUTE24
, PRICING_ATTRIBUTE25
, PRICING_ATTRIBUTE26
, PRICING_ATTRIBUTE27
, PRICING_ATTRIBUTE28
, PRICING_ATTRIBUTE29
, PRICING_ATTRIBUTE30
, PRICING_ATTRIBUTE31
, PRICING_ATTRIBUTE32
, PRICING_ATTRIBUTE33
, PRICING_ATTRIBUTE34
, PRICING_ATTRIBUTE35
, PRICING_ATTRIBUTE36
, PRICING_ATTRIBUTE37
, PRICING_ATTRIBUTE38
, PRICING_ATTRIBUTE39
, PRICING_ATTRIBUTE40
, PRICING_ATTRIBUTE41
, PRICING_ATTRIBUTE42
, PRICING_ATTRIBUTE43
, PRICING_ATTRIBUTE44
, PRICING_ATTRIBUTE45
, PRICING_ATTRIBUTE46
, PRICING_ATTRIBUTE47
, PRICING_ATTRIBUTE48
, PRICING_ATTRIBUTE49
, PRICING_ATTRIBUTE50
, PRICING_ATTRIBUTE51
, PRICING_ATTRIBUTE52
, PRICING_ATTRIBUTE53
, PRICING_ATTRIBUTE54
, PRICING_ATTRIBUTE55
, PRICING_ATTRIBUTE56
, PRICING_ATTRIBUTE57
, PRICING_ATTRIBUTE58
, PRICING_ATTRIBUTE59
, PRICING_ATTRIBUTE60
, PRICING_ATTRIBUTE61
, PRICING_ATTRIBUTE62
, PRICING_ATTRIBUTE63
, PRICING_ATTRIBUTE64
, PRICING_ATTRIBUTE65
, PRICING_ATTRIBUTE66
, PRICING_ATTRIBUTE67
, PRICING_ATTRIBUTE68
, PRICING_ATTRIBUTE69
, PRICING_ATTRIBUTE70
, PRICING_ATTRIBUTE71
, PRICING_ATTRIBUTE72
, PRICING_ATTRIBUTE73
, PRICING_ATTRIBUTE74
, PRICING_ATTRIBUTE75
, PRICING_ATTRIBUTE76
, PRICING_ATTRIBUTE77
, PRICING_ATTRIBUTE78
, PRICING_ATTRIBUTE79
, PRICING_ATTRIBUTE80
, PRICING_ATTRIBUTE81
, PRICING_ATTRIBUTE82
, PRICING_ATTRIBUTE83
, PRICING_ATTRIBUTE84
, PRICING_ATTRIBUTE85
, PRICING_ATTRIBUTE86
, PRICING_ATTRIBUTE87
, PRICING_ATTRIBUTE88
, PRICING_ATTRIBUTE89
, PRICING_ATTRIBUTE90
, PRICING_ATTRIBUTE91
, PRICING_ATTRIBUTE92
, PRICING_ATTRIBUTE93
, PRICING_ATTRIBUTE94
, PRICING_ATTRIBUTE95
, PRICING_ATTRIBUTE96
, PRICING_ATTRIBUTE97
, PRICING_ATTRIBUTE98
, PRICING_ATTRIBUTE99
, PRICING_ATTRIBUTE100
, PRICING_FLEX_CONTEXT
, PRICING_FLEX_ATTRIBUTE1
, PRICING_FLEX_ATTRIBUTE2
, PRICING_FLEX_ATTRIBUTE3
, PRICING_FLEX_ATTRIBUTE4
, PRICING_FLEX_ATTRIBUTE5
, PRICING_FLEX_ATTRIBUTE6
, PRICING_FLEX_ATTRIBUTE7
, PRICING_FLEX_ATTRIBUTE8
, PRICING_FLEX_ATTRIBUTE9
, PRICING_FLEX_ATTRIBUTE10
, PRICING_FLEX_ATTRIBUTE11
, PRICING_FLEX_ATTRIBUTE12
, PRICING_FLEX_ATTRIBUTE13
, PRICING_FLEX_ATTRIBUTE14
, PRICING_FLEX_ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NETWORK_ASSET_FLAG
, MAINTAINABLE_FLAG
, ASSET_CRITICALITY_CODE
, CATEGORY_ID
, EQUIPMENT_GEN_OBJECT_ID
, INSTANTIATION_FLAG
, OPERATIONAL_LOG_FLAG
, SUPPLIER_WARRANTY_EXP_DATE
, INSTANCE_ATTRIBUTE21
, INSTANCE_ATTRIBUTE16
, INSTANCE_ATTRIBUTE17
, INSTANCE_ATTRIBUTE18
, INSTANCE_ATTRIBUTE19
, INSTANCE_ATTRIBUTE20
, INSTANCE_ATTRIBUTE22
, INSTANCE_ATTRIBUTE23
, INSTANCE_ATTRIBUTE24
, INSTANCE_ATTRIBUTE25
, INSTANCE_ATTRIBUTE26
, INSTANCE_ATTRIBUTE27
, INSTANCE_ATTRIBUTE28
, INSTANCE_ATTRIBUTE29
, INSTANCE_ATTRIBUTE30
, SYNCUP_FAMILY
, OPERATIONAL_STATUS_CODE
FROM CSI.CSI_INSTANCE_INTERFACE;
CSI.CSI_INSTANCE_INTERFACE does not reference any database object
CSI.CSI_INSTANCE_INTERFACE is referenced by following:
APPS
CSI_INSTANCE_INTERFACE
|
|
|
|