[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_ITEM_INSTANCES_H |
|---|---|
| Object Type: | TABLE |
| Owner: | CSI |
| FND Design Data: |  CSI.CSI_ITEM_INSTANCES_H
|
| Subobject Name: | |
| Status: | VALID |
Item Instance history.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CSI_ITEM_INSTANCES_H_U01 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INSTANCE_HISTORY_ID
|
| CSI_ITEM_INSTANCES_H_U02 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
TRANSACTION_ID
INSTANCE_ID
|
| CSI_ITEM_INSTANCES_H_N01 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INSTANCE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTANCE_HISTORY_ID | NUMBER | Yes | Instance History Identifier | |
| INSTANCE_ID | NUMBER | Yes | Instance Identifier | |
| TRANSACTION_ID | NUMBER | Yes | Transaction Identifier | |
| OLD_INSTANCE_NUMBER | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INSTANCE_NUMBER | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_EXTERNAL_REFERENCE | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_EXTERNAL_REFERENCE | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INVENTORY_ITEM_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INVENTORY_ITEM_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_INVENTORY_REVISION | VARCHAR2 | (3) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INVENTORY_REVISION | VARCHAR2 | (3) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INV_MASTER_ORGANIZATION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INV_MASTER_ORGANIZATION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_SERIAL_NUMBER | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_SERIAL_NUMBER | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_MFG_SERIAL_NUMBER_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_LOT_NUMBER | VARCHAR2 | (80) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_LOT_NUMBER | VARCHAR2 | (80) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_QUANTITY | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_QUANTITY | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_UNIT_OF_MEASURE | VARCHAR2 | (3) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_UNIT_OF_MEASURE | VARCHAR2 | (3) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INSTANCE_CONDITION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INSTANCE_CONDITION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_INSTANCE_STATUS_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INSTANCE_STATUS_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_CUSTOMER_VIEW_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_MERCHANT_VIEW_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_SELLABLE_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_SELLABLE_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_SYSTEM_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_SYSTEM_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INSTANCE_TYPE_CODE | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_ACTIVE_START_DATE | DATE | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_ACTIVE_START_DATE | DATE | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_ACTIVE_END_DATE | DATE | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_ACTIVE_END_DATE | DATE | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_LOCATION_TYPE_CODE | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_LOCATION_TYPE_CODE | VARCHAR2 | (30) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_LOCATION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_LOCATION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_INV_ORGANIZATION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INV_ORGANIZATION_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INV_SUBINVENTORY_NAME | VARCHAR2 | (10) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INV_LOCATOR_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INV_LOCATOR_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_PA_PROJECT_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_PA_PROJECT_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_PA_PROJECT_TASK_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_PA_PROJECT_TASK_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_IN_TRANSIT_ORDER_LINE_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_IN_TRANSIT_ORDER_LINE_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_WIP_JOB_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_WIP_JOB_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_PO_ORDER_LINE_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_PO_ORDER_LINE_ID | NUMBER | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_COMPLETENESS_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_COMPLETENESS_FLAG | VARCHAR2 | (1) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| OLD_CONTEXT | VARCHAR2 | (30) | Standard DFF Columns History. | |
| NEW_CONTEXT | VARCHAR2 | (30) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE1 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE1 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE2 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE2 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE3 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE3 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE4 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE4 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE5 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE5 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE6 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE6 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE7 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE7 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE8 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE8 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE9 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE9 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE10 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE10 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE11 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE11 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE12 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE12 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE13 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE13 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE14 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE14 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE15 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE15 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| FULL_DUMP_FLAG | VARCHAR2 | (1) | Flag indicating if the history record is a full dump. | |
| 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 | ||
| OLD_INST_LOC_TYPE_CODE | VARCHAR2 | (30) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INST_LOC_TYPE_CODE | VARCHAR2 | (30) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INST_LOC_ID | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INST_LOC_ID | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_INST_USAGE_CODE | VARCHAR2 | (30) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INST_USAGE_CODE | VARCHAR2 | (30) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| OLD_LAST_VLD_ORGANIZATION_ID | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_LAST_VLD_ORGANIZATION_ID | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| MIGRATED_FLAG | VARCHAR2 | (1) | Flag Indicating if the record is created as a part of Migration. | |
| OLD_OE_AGREEMENT_ID | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_OE_AGREEMENT_ID | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_CONFIG_INST_REV_NUM | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_CONFIG_INST_REV_NUM | NUMBER | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_CONFIG_VALID_STATUS | VARCHAR2 | (30) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| NEW_CONFIG_VALID_STATUS | VARCHAR2 | (30) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INSTANCE_DESCRIPTION | VARCHAR2 | (240) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| NEW_INSTANCE_DESCRIPTION | VARCHAR2 | (240) | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | |
| OLD_INSTALL_DATE | DATE | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_INSTALL_DATE | DATE | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_RETURN_BY_DATE | DATE | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_RETURN_BY_DATE | DATE | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_ACTUAL_RETURN_DATE | DATE | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| NEW_ACTUAL_RETURN_DATE | DATE | Refer to the Base Table CSI_ITEM_INSTANCES for descriptions | ||
| OLD_LAST_OE_ORDER_LINE_ID | NUMBER | Old last sales order line id | ||
| NEW_LAST_OE_ORDER_LINE_ID | NUMBER | New last sales order line id | ||
| OLD_LAST_OE_RMA_LINE_ID | NUMBER | Old last RMA order line id | ||
| NEW_LAST_OE_RMA_LINE_ID | NUMBER | New last RMA order line id | ||
| OLD_LAST_WIP_JOB_ID | NUMBER | Old last WIP Job id | ||
| NEW_LAST_WIP_JOB_ID | NUMBER | New last WIP Job id | ||
| OLD_LAST_PO_PO_LINE_ID | NUMBER | Old last purchase order line id | ||
| NEW_LAST_PO_PO_LINE_ID | NUMBER | New last purchase order line id | ||
| OLD_LAST_PA_PROJECT_ID | NUMBER | Old last project id | ||
| NEW_LAST_PA_PROJECT_ID | NUMBER | New last project id | ||
| OLD_LAST_PA_TASK_ID | NUMBER | Old last project task id | ||
| NEW_LAST_PA_TASK_ID | NUMBER | New last project task id | ||
| OLD_LAST_TXN_LINE_DETAIL_ID | NUMBER | Old last transaction details line id | ||
| NEW_LAST_TXN_LINE_DETAIL_ID | NUMBER | New last transaction details line id | ||
| OLD_LAST_OE_PO_NUMBER | VARCHAR2 | (50) | Old last customer PO number | |
| NEW_LAST_OE_PO_NUMBER | VARCHAR2 | (50) | New last customer PO number | |
| OLD_PAYABLES_CURRENCY_CODE | VARCHAR2 | (15) | Payables Currency Code | |
| NEW_PAYABLES_CURRENCY_CODE | VARCHAR2 | (15) | Payables Currency Code | |
| OLD_NETWORK_ASSET_FLAG | VARCHAR2 | (1) | Old value for Network Asset Flag | |
| NEW_NETWORK_ASSET_FLAG | VARCHAR2 | (1) | New value for Network Asset Flag | |
| OLD_MAINTAINABLE_FLAG | VARCHAR2 | (1) | Old value for Maintainable Flag | |
| NEW_MAINTAINABLE_FLAG | VARCHAR2 | (1) | New value for Maintainable Flag | |
| OLD_PN_LOCATION_ID | NUMBER | Old value for PN Location Id | ||
| NEW_PN_LOCATION_ID | NUMBER | New value for PN Location Id | ||
| OLD_ASSET_CRITICALITY_CODE | VARCHAR2 | (30) | Old value for Asset Criticality Code | |
| NEW_ASSET_CRITICALITY_CODE | VARCHAR2 | (30) | New value for Asset Criticality Code | |
| OLD_CATEGORY_ID | NUMBER | Old value for Category Id | ||
| NEW_CATEGORY_ID | NUMBER | New value for Category Id | ||
| OLD_EQUIPMENT_GEN_OBJECT_ID | NUMBER | Old value for Equipment Id | ||
| NEW_EQUIPMENT_GEN_OBJECT_ID | NUMBER | New value for Equipment Id | ||
| OLD_INSTANTIATION_FLAG | VARCHAR2 | (1) | Old value for Instantiation Flag | |
| NEW_INSTANTIATION_FLAG | VARCHAR2 | (1) | New value for Instantiation Flag | |
| OLD_LINEAR_LOCATION_ID | NUMBER | Old value for Linear Location Id | ||
| NEW_LINEAR_LOCATION_ID | NUMBER | New value for Linear Location Id | ||
| OLD_OPERATIONAL_LOG_FLAG | VARCHAR2 | (1) | Old value for Operational Log Flag | |
| NEW_OPERATIONAL_LOG_FLAG | VARCHAR2 | (1) | New value for Operational Log Flag | |
| OLD_CHECKIN_STATUS | NUMBER | Old value for checkin status | ||
| NEW_CHECKIN_STATUS | NUMBER | New value for checkin status | ||
| OLD_SUPPLIER_WARRANTY_EXP_DATE | DATE | Old value for supplier warranty expiration date | ||
| NEW_SUPPLIER_WARRANTY_EXP_DATE | DATE | New value for supplier warranty expiration date | ||
| OLD_ATTRIBUTE16 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE16 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE17 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE17 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE18 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE18 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE19 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE19 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE20 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE20 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE21 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE21 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE22 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE22 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE23 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE23 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE24 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE24 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE25 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE25 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE26 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE26 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE27 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE27 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE28 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE28 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE29 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE29 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_ATTRIBUTE30 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| NEW_ATTRIBUTE30 | VARCHAR2 | (240) | Standard DFF Columns History. | |
| OLD_PURCHASE_UNIT_PRICE | NUMBER | Purchase Unit Price | ||
| NEW_PURCHASE_UNIT_PRICE | NUMBER | Purchase Unit Price | ||
| OLD_PURCHASE_CURRENCY_CODE | VARCHAR2 | (15) | Purchase Currency Code | |
| NEW_PURCHASE_CURRENCY_CODE | VARCHAR2 | (15) | Purchase Currency Code | |
| OLD_PAYABLES_UNIT_PRICE | NUMBER | Payables Unit Price | ||
| NEW_PAYABLES_UNIT_PRICE | NUMBER | Payables Unit Price | ||
| OLD_SALES_UNIT_PRICE | NUMBER | Sales Unit Price | ||
| NEW_SALES_UNIT_PRICE | NUMBER | Sales Unit Price | ||
| OLD_SALES_CURRENCY_CODE | VARCHAR2 | (15) | Sales Currency Code | |
| NEW_SALES_CURRENCY_CODE | VARCHAR2 | (15) | Sales Currency Code | |
| OLD_OPERATIONAL_STATUS_CODE | VARCHAR2 | (30) | Old Operational Status Code | |
| NEW_OPERATIONAL_STATUS_CODE | VARCHAR2 | (30) | New Operational Status Code | |
| OLD_SOURCE_CODE | VARCHAR2 | (10) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions | |
| NEW_SOURCE_CODE | VARCHAR2 | (10) | Refer to the Base table CSI_ITEM_INSTANCES for descriptions |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_HISTORY_ID
, INSTANCE_ID
, TRANSACTION_ID
, OLD_INSTANCE_NUMBER
, NEW_INSTANCE_NUMBER
, OLD_EXTERNAL_REFERENCE
, NEW_EXTERNAL_REFERENCE
, OLD_INVENTORY_ITEM_ID
, NEW_INVENTORY_ITEM_ID
, OLD_INVENTORY_REVISION
, NEW_INVENTORY_REVISION
, OLD_INV_MASTER_ORGANIZATION_ID
, NEW_INV_MASTER_ORGANIZATION_ID
, OLD_SERIAL_NUMBER
, NEW_SERIAL_NUMBER
, OLD_MFG_SERIAL_NUMBER_FLAG
, NEW_MFG_SERIAL_NUMBER_FLAG
, OLD_LOT_NUMBER
, NEW_LOT_NUMBER
, OLD_QUANTITY
, NEW_QUANTITY
, OLD_UNIT_OF_MEASURE
, NEW_UNIT_OF_MEASURE
, OLD_ACCOUNTING_CLASS_CODE
, NEW_ACCOUNTING_CLASS_CODE
, OLD_INSTANCE_CONDITION_ID
, NEW_INSTANCE_CONDITION_ID
, OLD_INSTANCE_STATUS_ID
, NEW_INSTANCE_STATUS_ID
, OLD_CUSTOMER_VIEW_FLAG
, NEW_CUSTOMER_VIEW_FLAG
, OLD_MERCHANT_VIEW_FLAG
, NEW_MERCHANT_VIEW_FLAG
, OLD_SELLABLE_FLAG
, NEW_SELLABLE_FLAG
, OLD_SYSTEM_ID
, NEW_SYSTEM_ID
, OLD_INSTANCE_TYPE_CODE
, NEW_INSTANCE_TYPE_CODE
, OLD_ACTIVE_START_DATE
, NEW_ACTIVE_START_DATE
, OLD_ACTIVE_END_DATE
, NEW_ACTIVE_END_DATE
, OLD_LOCATION_TYPE_CODE
, NEW_LOCATION_TYPE_CODE
, OLD_LOCATION_ID
, NEW_LOCATION_ID
, OLD_INV_ORGANIZATION_ID
, NEW_INV_ORGANIZATION_ID
, OLD_INV_SUBINVENTORY_NAME
, NEW_INV_SUBINVENTORY_NAME
, OLD_INV_LOCATOR_ID
, NEW_INV_LOCATOR_ID
, OLD_PA_PROJECT_ID
, NEW_PA_PROJECT_ID
, OLD_PA_PROJECT_TASK_ID
, NEW_PA_PROJECT_TASK_ID
, OLD_IN_TRANSIT_ORDER_LINE_ID
, NEW_IN_TRANSIT_ORDER_LINE_ID
, OLD_WIP_JOB_ID
, NEW_WIP_JOB_ID
, OLD_PO_ORDER_LINE_ID
, NEW_PO_ORDER_LINE_ID
, OLD_COMPLETENESS_FLAG
, NEW_COMPLETENESS_FLAG
, OLD_CONTEXT
, NEW_CONTEXT
, OLD_ATTRIBUTE1
, NEW_ATTRIBUTE1
, OLD_ATTRIBUTE2
, NEW_ATTRIBUTE2
, OLD_ATTRIBUTE3
, NEW_ATTRIBUTE3
, OLD_ATTRIBUTE4
, NEW_ATTRIBUTE4
, OLD_ATTRIBUTE5
, NEW_ATTRIBUTE5
, OLD_ATTRIBUTE6
, NEW_ATTRIBUTE6
, OLD_ATTRIBUTE7
, NEW_ATTRIBUTE7
, OLD_ATTRIBUTE8
, NEW_ATTRIBUTE8
, OLD_ATTRIBUTE9
, NEW_ATTRIBUTE9
, OLD_ATTRIBUTE10
, NEW_ATTRIBUTE10
, OLD_ATTRIBUTE11
, NEW_ATTRIBUTE11
, OLD_ATTRIBUTE12
, NEW_ATTRIBUTE12
, OLD_ATTRIBUTE13
, NEW_ATTRIBUTE13
, OLD_ATTRIBUTE14
, NEW_ATTRIBUTE14
, OLD_ATTRIBUTE15
, NEW_ATTRIBUTE15
, FULL_DUMP_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, OLD_INST_LOC_TYPE_CODE
, NEW_INST_LOC_TYPE_CODE
, OLD_INST_LOC_ID
, NEW_INST_LOC_ID
, OLD_INST_USAGE_CODE
, NEW_INST_USAGE_CODE
, OLD_LAST_VLD_ORGANIZATION_ID
, NEW_LAST_VLD_ORGANIZATION_ID
, MIGRATED_FLAG
, OLD_OE_AGREEMENT_ID
, NEW_OE_AGREEMENT_ID
, OLD_CONFIG_INST_REV_NUM
, NEW_CONFIG_INST_REV_NUM
, OLD_CONFIG_VALID_STATUS
, NEW_CONFIG_VALID_STATUS
, OLD_INSTANCE_DESCRIPTION
, NEW_INSTANCE_DESCRIPTION
, OLD_INSTALL_DATE
, NEW_INSTALL_DATE
, OLD_RETURN_BY_DATE
, NEW_RETURN_BY_DATE
, OLD_ACTUAL_RETURN_DATE
, NEW_ACTUAL_RETURN_DATE
, OLD_LAST_OE_ORDER_LINE_ID
, NEW_LAST_OE_ORDER_LINE_ID
, OLD_LAST_OE_RMA_LINE_ID
, NEW_LAST_OE_RMA_LINE_ID
, OLD_LAST_WIP_JOB_ID
, NEW_LAST_WIP_JOB_ID
, OLD_LAST_PO_PO_LINE_ID
, NEW_LAST_PO_PO_LINE_ID
, OLD_LAST_PA_PROJECT_ID
, NEW_LAST_PA_PROJECT_ID
, OLD_LAST_PA_TASK_ID
, NEW_LAST_PA_TASK_ID
, OLD_LAST_TXN_LINE_DETAIL_ID
, NEW_LAST_TXN_LINE_DETAIL_ID
, OLD_LAST_OE_PO_NUMBER
, NEW_LAST_OE_PO_NUMBER
, OLD_PAYABLES_CURRENCY_CODE
, NEW_PAYABLES_CURRENCY_CODE
, OLD_NETWORK_ASSET_FLAG
, NEW_NETWORK_ASSET_FLAG
, OLD_MAINTAINABLE_FLAG
, NEW_MAINTAINABLE_FLAG
, OLD_PN_LOCATION_ID
, NEW_PN_LOCATION_ID
, OLD_ASSET_CRITICALITY_CODE
, NEW_ASSET_CRITICALITY_CODE
, OLD_CATEGORY_ID
, NEW_CATEGORY_ID
, OLD_EQUIPMENT_GEN_OBJECT_ID
, NEW_EQUIPMENT_GEN_OBJECT_ID
, OLD_INSTANTIATION_FLAG
, NEW_INSTANTIATION_FLAG
, OLD_LINEAR_LOCATION_ID
, NEW_LINEAR_LOCATION_ID
, OLD_OPERATIONAL_LOG_FLAG
, NEW_OPERATIONAL_LOG_FLAG
, OLD_CHECKIN_STATUS
, NEW_CHECKIN_STATUS
, OLD_SUPPLIER_WARRANTY_EXP_DATE
, NEW_SUPPLIER_WARRANTY_EXP_DATE
, OLD_ATTRIBUTE16
, NEW_ATTRIBUTE16
, OLD_ATTRIBUTE17
, NEW_ATTRIBUTE17
, OLD_ATTRIBUTE18
, NEW_ATTRIBUTE18
, OLD_ATTRIBUTE19
, NEW_ATTRIBUTE19
, OLD_ATTRIBUTE20
, NEW_ATTRIBUTE20
, OLD_ATTRIBUTE21
, NEW_ATTRIBUTE21
, OLD_ATTRIBUTE22
, NEW_ATTRIBUTE22
, OLD_ATTRIBUTE23
, NEW_ATTRIBUTE23
, OLD_ATTRIBUTE24
, NEW_ATTRIBUTE24
, OLD_ATTRIBUTE25
, NEW_ATTRIBUTE25
, OLD_ATTRIBUTE26
, NEW_ATTRIBUTE26
, OLD_ATTRIBUTE27
, NEW_ATTRIBUTE27
, OLD_ATTRIBUTE28
, NEW_ATTRIBUTE28
, OLD_ATTRIBUTE29
, NEW_ATTRIBUTE29
, OLD_ATTRIBUTE30
, NEW_ATTRIBUTE30
, OLD_PURCHASE_UNIT_PRICE
, NEW_PURCHASE_UNIT_PRICE
, OLD_PURCHASE_CURRENCY_CODE
, NEW_PURCHASE_CURRENCY_CODE
, OLD_PAYABLES_UNIT_PRICE
, NEW_PAYABLES_UNIT_PRICE
, OLD_SALES_UNIT_PRICE
, NEW_SALES_UNIT_PRICE
, OLD_SALES_CURRENCY_CODE
, NEW_SALES_CURRENCY_CODE
, OLD_OPERATIONAL_STATUS_CODE
, NEW_OPERATIONAL_STATUS_CODE
, OLD_SOURCE_CODE
, NEW_SOURCE_CODE
FROM CSI.CSI_ITEM_INSTANCES_H;
CSI.CSI_ITEM_INSTANCES_H does not reference any database object
CSI.CSI_ITEM_INSTANCES_H is referenced by following:
CSI
CSI_ITEM_INSTANCES_H#
|
|
|
|