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


VIEW: CSI.CSI_ITEM_INSTANCES_H#

Object Details
Object Name: CSI_ITEM_INSTANCES_H#
Object Type: VIEW
Owner: CSI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INSTANCE_HISTORY_ID NUMBER
Yes
INSTANCE_ID NUMBER
Yes
TRANSACTION_ID NUMBER
Yes
OLD_INSTANCE_NUMBER VARCHAR2 (30)
NEW_INSTANCE_NUMBER VARCHAR2 (30)
OLD_EXTERNAL_REFERENCE VARCHAR2 (30)
NEW_EXTERNAL_REFERENCE VARCHAR2 (30)
OLD_INVENTORY_ITEM_ID NUMBER

NEW_INVENTORY_ITEM_ID NUMBER

OLD_INVENTORY_REVISION VARCHAR2 (3)
NEW_INVENTORY_REVISION VARCHAR2 (3)
OLD_INV_MASTER_ORGANIZATION_ID NUMBER

NEW_INV_MASTER_ORGANIZATION_ID NUMBER

OLD_SERIAL_NUMBER VARCHAR2 (30)
NEW_SERIAL_NUMBER VARCHAR2 (30)
OLD_MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
NEW_MFG_SERIAL_NUMBER_FLAG VARCHAR2 (1)
OLD_LOT_NUMBER VARCHAR2 (80)
NEW_LOT_NUMBER VARCHAR2 (80)
OLD_QUANTITY NUMBER

NEW_QUANTITY NUMBER

OLD_UNIT_OF_MEASURE VARCHAR2 (3)
NEW_UNIT_OF_MEASURE VARCHAR2 (3)
OLD_ACCOUNTING_CLASS_CODE VARCHAR2 (10)
NEW_ACCOUNTING_CLASS_CODE VARCHAR2 (10)
OLD_INSTANCE_CONDITION_ID NUMBER

NEW_INSTANCE_CONDITION_ID NUMBER

OLD_INSTANCE_STATUS_ID NUMBER

NEW_INSTANCE_STATUS_ID NUMBER

OLD_CUSTOMER_VIEW_FLAG VARCHAR2 (1)
NEW_CUSTOMER_VIEW_FLAG VARCHAR2 (1)
OLD_MERCHANT_VIEW_FLAG VARCHAR2 (1)
NEW_MERCHANT_VIEW_FLAG VARCHAR2 (1)
OLD_SELLABLE_FLAG VARCHAR2 (1)
NEW_SELLABLE_FLAG VARCHAR2 (1)
OLD_SYSTEM_ID NUMBER

NEW_SYSTEM_ID NUMBER

OLD_INSTANCE_TYPE_CODE VARCHAR2 (30)
NEW_INSTANCE_TYPE_CODE VARCHAR2 (30)
OLD_ACTIVE_START_DATE DATE

NEW_ACTIVE_START_DATE DATE

OLD_ACTIVE_END_DATE DATE

NEW_ACTIVE_END_DATE DATE

OLD_LOCATION_TYPE_CODE VARCHAR2 (30)
NEW_LOCATION_TYPE_CODE VARCHAR2 (30)
OLD_LOCATION_ID NUMBER

NEW_LOCATION_ID NUMBER

OLD_INV_ORGANIZATION_ID NUMBER

NEW_INV_ORGANIZATION_ID NUMBER

OLD_INV_SUBINVENTORY_NAME VARCHAR2 (10)
NEW_INV_SUBINVENTORY_NAME VARCHAR2 (10)
OLD_INV_LOCATOR_ID NUMBER

NEW_INV_LOCATOR_ID NUMBER

OLD_PA_PROJECT_ID NUMBER

NEW_PA_PROJECT_ID NUMBER

OLD_PA_PROJECT_TASK_ID NUMBER

NEW_PA_PROJECT_TASK_ID NUMBER

OLD_IN_TRANSIT_ORDER_LINE_ID NUMBER

NEW_IN_TRANSIT_ORDER_LINE_ID NUMBER

OLD_WIP_JOB_ID NUMBER

NEW_WIP_JOB_ID NUMBER

OLD_PO_ORDER_LINE_ID NUMBER

NEW_PO_ORDER_LINE_ID NUMBER

OLD_COMPLETENESS_FLAG VARCHAR2 (1)
NEW_COMPLETENESS_FLAG VARCHAR2 (1)
OLD_CONTEXT VARCHAR2 (30)
NEW_CONTEXT VARCHAR2 (30)
OLD_ATTRIBUTE1 VARCHAR2 (240)
NEW_ATTRIBUTE1 VARCHAR2 (240)
OLD_ATTRIBUTE2 VARCHAR2 (240)
NEW_ATTRIBUTE2 VARCHAR2 (240)
OLD_ATTRIBUTE3 VARCHAR2 (240)
NEW_ATTRIBUTE3 VARCHAR2 (240)
OLD_ATTRIBUTE4 VARCHAR2 (240)
NEW_ATTRIBUTE4 VARCHAR2 (240)
OLD_ATTRIBUTE5 VARCHAR2 (240)
NEW_ATTRIBUTE5 VARCHAR2 (240)
OLD_ATTRIBUTE6 VARCHAR2 (240)
NEW_ATTRIBUTE6 VARCHAR2 (240)
OLD_ATTRIBUTE7 VARCHAR2 (240)
NEW_ATTRIBUTE7 VARCHAR2 (240)
OLD_ATTRIBUTE8 VARCHAR2 (240)
NEW_ATTRIBUTE8 VARCHAR2 (240)
OLD_ATTRIBUTE9 VARCHAR2 (240)
NEW_ATTRIBUTE9 VARCHAR2 (240)
OLD_ATTRIBUTE10 VARCHAR2 (240)
NEW_ATTRIBUTE10 VARCHAR2 (240)
OLD_ATTRIBUTE11 VARCHAR2 (240)
NEW_ATTRIBUTE11 VARCHAR2 (240)
OLD_ATTRIBUTE12 VARCHAR2 (240)
NEW_ATTRIBUTE12 VARCHAR2 (240)
OLD_ATTRIBUTE13 VARCHAR2 (240)
NEW_ATTRIBUTE13 VARCHAR2 (240)
OLD_ATTRIBUTE14 VARCHAR2 (240)
NEW_ATTRIBUTE14 VARCHAR2 (240)
OLD_ATTRIBUTE15 VARCHAR2 (240)
NEW_ATTRIBUTE15 VARCHAR2 (240)
FULL_DUMP_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER
Yes
SECURITY_GROUP_ID NUMBER

OLD_INST_LOC_TYPE_CODE VARCHAR2 (30)
NEW_INST_LOC_TYPE_CODE VARCHAR2 (30)
OLD_INST_LOC_ID NUMBER

NEW_INST_LOC_ID NUMBER

OLD_INST_USAGE_CODE VARCHAR2 (30)
NEW_INST_USAGE_CODE VARCHAR2 (30)
OLD_LAST_VLD_ORGANIZATION_ID NUMBER

NEW_LAST_VLD_ORGANIZATION_ID NUMBER

MIGRATED_FLAG VARCHAR2 (1)
OLD_OE_AGREEMENT_ID NUMBER

NEW_OE_AGREEMENT_ID NUMBER

OLD_CONFIG_INST_REV_NUM NUMBER

NEW_CONFIG_INST_REV_NUM NUMBER

OLD_CONFIG_VALID_STATUS VARCHAR2 (30)
NEW_CONFIG_VALID_STATUS VARCHAR2 (30)
OLD_INSTANCE_DESCRIPTION VARCHAR2 (240)
NEW_INSTANCE_DESCRIPTION VARCHAR2 (240)
OLD_INSTALL_DATE DATE

NEW_INSTALL_DATE DATE

OLD_RETURN_BY_DATE DATE

NEW_RETURN_BY_DATE DATE

OLD_ACTUAL_RETURN_DATE DATE

NEW_ACTUAL_RETURN_DATE DATE

OLD_LAST_OE_ORDER_LINE_ID NUMBER

NEW_LAST_OE_ORDER_LINE_ID NUMBER

OLD_LAST_OE_RMA_LINE_ID NUMBER

NEW_LAST_OE_RMA_LINE_ID NUMBER

OLD_LAST_WIP_JOB_ID NUMBER

NEW_LAST_WIP_JOB_ID NUMBER

OLD_LAST_PO_PO_LINE_ID NUMBER

NEW_LAST_PO_PO_LINE_ID NUMBER

OLD_LAST_PA_PROJECT_ID NUMBER

NEW_LAST_PA_PROJECT_ID NUMBER

OLD_LAST_PA_TASK_ID NUMBER

NEW_LAST_PA_TASK_ID NUMBER

OLD_LAST_TXN_LINE_DETAIL_ID NUMBER

NEW_LAST_TXN_LINE_DETAIL_ID NUMBER

OLD_LAST_OE_PO_NUMBER VARCHAR2 (50)
NEW_LAST_OE_PO_NUMBER VARCHAR2 (50)
OLD_PAYABLES_CURRENCY_CODE VARCHAR2 (15)
NEW_PAYABLES_CURRENCY_CODE VARCHAR2 (15)
OLD_NETWORK_ASSET_FLAG VARCHAR2 (1)
NEW_NETWORK_ASSET_FLAG VARCHAR2 (1)
OLD_MAINTAINABLE_FLAG VARCHAR2 (1)
NEW_MAINTAINABLE_FLAG VARCHAR2 (1)
OLD_PN_LOCATION_ID NUMBER

NEW_PN_LOCATION_ID NUMBER

OLD_ASSET_CRITICALITY_CODE VARCHAR2 (30)
NEW_ASSET_CRITICALITY_CODE VARCHAR2 (30)
OLD_CATEGORY_ID NUMBER

NEW_CATEGORY_ID NUMBER

OLD_EQUIPMENT_GEN_OBJECT_ID NUMBER

NEW_EQUIPMENT_GEN_OBJECT_ID NUMBER

OLD_INSTANTIATION_FLAG VARCHAR2 (1)
NEW_INSTANTIATION_FLAG VARCHAR2 (1)
OLD_LINEAR_LOCATION_ID NUMBER

NEW_LINEAR_LOCATION_ID NUMBER

OLD_OPERATIONAL_LOG_FLAG VARCHAR2 (1)
NEW_OPERATIONAL_LOG_FLAG VARCHAR2 (1)
OLD_CHECKIN_STATUS NUMBER

NEW_CHECKIN_STATUS NUMBER

OLD_SUPPLIER_WARRANTY_EXP_DATE DATE

NEW_SUPPLIER_WARRANTY_EXP_DATE DATE

OLD_ATTRIBUTE16 VARCHAR2 (240)
NEW_ATTRIBUTE16 VARCHAR2 (240)
OLD_ATTRIBUTE17 VARCHAR2 (240)
NEW_ATTRIBUTE17 VARCHAR2 (240)
OLD_ATTRIBUTE18 VARCHAR2 (240)
NEW_ATTRIBUTE18 VARCHAR2 (240)
OLD_ATTRIBUTE19 VARCHAR2 (240)
NEW_ATTRIBUTE19 VARCHAR2 (240)
OLD_ATTRIBUTE20 VARCHAR2 (240)
NEW_ATTRIBUTE20 VARCHAR2 (240)
OLD_ATTRIBUTE21 VARCHAR2 (240)
NEW_ATTRIBUTE21 VARCHAR2 (240)
OLD_ATTRIBUTE22 VARCHAR2 (240)
NEW_ATTRIBUTE22 VARCHAR2 (240)
OLD_ATTRIBUTE23 VARCHAR2 (240)
NEW_ATTRIBUTE23 VARCHAR2 (240)
OLD_ATTRIBUTE24 VARCHAR2 (240)
NEW_ATTRIBUTE24 VARCHAR2 (240)
OLD_ATTRIBUTE25 VARCHAR2 (240)
NEW_ATTRIBUTE25 VARCHAR2 (240)
OLD_ATTRIBUTE26 VARCHAR2 (240)
NEW_ATTRIBUTE26 VARCHAR2 (240)
OLD_ATTRIBUTE27 VARCHAR2 (240)
NEW_ATTRIBUTE27 VARCHAR2 (240)
OLD_ATTRIBUTE28 VARCHAR2 (240)
NEW_ATTRIBUTE28 VARCHAR2 (240)
OLD_ATTRIBUTE29 VARCHAR2 (240)
NEW_ATTRIBUTE29 VARCHAR2 (240)
OLD_ATTRIBUTE30 VARCHAR2 (240)
NEW_ATTRIBUTE30 VARCHAR2 (240)
OLD_PURCHASE_UNIT_PRICE NUMBER

NEW_PURCHASE_UNIT_PRICE NUMBER

OLD_PURCHASE_CURRENCY_CODE VARCHAR2 (15)
NEW_PURCHASE_CURRENCY_CODE VARCHAR2 (15)
OLD_PAYABLES_UNIT_PRICE NUMBER

NEW_PAYABLES_UNIT_PRICE NUMBER

OLD_SALES_UNIT_PRICE NUMBER

NEW_SALES_UNIT_PRICE NUMBER

OLD_SALES_CURRENCY_CODE VARCHAR2 (15)
NEW_SALES_CURRENCY_CODE VARCHAR2 (15)
OLD_OPERATIONAL_STATUS_CODE VARCHAR2 (30)
NEW_OPERATIONAL_STATUS_CODE VARCHAR2 (30)
OLD_SOURCE_CODE VARCHAR2 (10)
NEW_SOURCE_CODE VARCHAR2 (10)
Query Text

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#;

Dependencies

[top of page]

CSI.CSI_ITEM_INSTANCES_H# references the following:

SchemaCSI
TableCSI_ITEM_INSTANCES_H
CSI.CSI_ITEM_INSTANCES_H# is referenced by following:

SchemaAPPS
SynonymCSI_ITEM_INSTANCES_H