[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:
|
|
|