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

TABLE: CSI.CSI_SYSTEMS_H

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


This table stores System Details History data.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSI_SYSTEMS_H_U01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYSTEM_HISTORY_ID
CSI_SYSTEMS_H_N01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSYSTEM_ID
CSI_SYSTEMS_H_N02 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
SYSTEM_HISTORY_ID NUMBER
Yes System History identifier
SYSTEM_ID NUMBER
Yes System identifier
TRANSACTION_ID NUMBER
Yes Transaction Identifier.
OLD_CUSTOMER_ID NUMBER

Customer identifier
NEW_CUSTOMER_ID NUMBER

Customer identifier
OLD_SYSTEM_TYPE_CODE VARCHAR2 (30)
System type lookup code
NEW_SYSTEM_TYPE_CODE VARCHAR2 (30)
System type lookup code
OLD_SYSTEM_NUMBER VARCHAR2 (30)
System number
NEW_SYSTEM_NUMBER VARCHAR2 (30)
System number
OLD_PARENT_SYSTEM_ID NUMBER

Parent system identifier
NEW_PARENT_SYSTEM_ID NUMBER

Parent system identifier
OLD_SHIP_TO_CONTACT_ID NUMBER

Ship-to contact identifier
NEW_SHIP_TO_CONTACT_ID NUMBER

Ship-to contact identifier
OLD_BILL_TO_CONTACT_ID NUMBER

Bill-to contact identifier
NEW_BILL_TO_CONTACT_ID NUMBER

Bill-to contact identifier
OLD_TECHNICAL_CONTACT_ID NUMBER

Technical contact identifier
NEW_TECHNICAL_CONTACT_ID NUMBER

Technical contact identifier
OLD_SERVICE_ADMIN_CONTACT_ID NUMBER

Administration contact identifier
NEW_SERVICE_ADMIN_CONTACT_ID NUMBER

Administration contact identifier
OLD_SHIP_TO_SITE_USE_ID NUMBER

Identifier for ship-to site use
NEW_SHIP_TO_SITE_USE_ID NUMBER

Identifier for ship-to site use
OLD_INSTALL_SITE_USE_ID NUMBER

Installed site identifier
NEW_INSTALL_SITE_USE_ID NUMBER

Installed site identifier
OLD_BILL_TO_SITE_USE_ID NUMBER

Identifier for bill-to site use
NEW_BILL_TO_SITE_USE_ID NUMBER

Identifier for bill-to site use
OLD_COTERMINATE_DAY_MONTH VARCHAR2 (6)
The day and month when every service and product under the system expires
NEW_COTERMINATE_DAY_MONTH VARCHAR2 (6)
The day and month when every service and product under the system expires
OLD_START_DATE_ACTIVE DATE

Start date for the system
NEW_START_DATE_ACTIVE DATE

Start date for the system
OLD_END_DATE_ACTIVE DATE

End date for the system
NEW_END_DATE_ACTIVE DATE

End date for the system
OLD_AUTOCREATED_FROM_SYSTEM NUMBER

System identifier for the copied from system
NEW_AUTOCREATED_FROM_SYSTEM NUMBER

System identifier for the copied from system
OLD_CONFIG_SYSTEM_TYPE VARCHAR2 (30)
Describes the type of system used by Oracle Product Configurator to validate configurations owned by the customer
NEW_CONFIG_SYSTEM_TYPE VARCHAR2 (30)
Describes the type of system used by Oracle Product Configurator to validate configurations owned by the customer
OLD_NAME VARCHAR2 (50)
Name
NEW_NAME VARCHAR2 (50)
Name
OLD_DESCRIPTION VARCHAR2 (240)
Description
NEW_DESCRIPTION VARCHAR2 (240)
Description
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)
History Full dump frequency.
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.
MIGRATED_FLAG VARCHAR2 (1)
Flag indicating if the row is created as a part of migration.
OLD_OPERATING_UNIT_ID NUMBER

Operating Unit Identifier
NEW_OPERATING_UNIT_ID NUMBER

Operating Unit Identifier
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SYSTEM_HISTORY_ID
,      SYSTEM_ID
,      TRANSACTION_ID
,      OLD_CUSTOMER_ID
,      NEW_CUSTOMER_ID
,      OLD_SYSTEM_TYPE_CODE
,      NEW_SYSTEM_TYPE_CODE
,      OLD_SYSTEM_NUMBER
,      NEW_SYSTEM_NUMBER
,      OLD_PARENT_SYSTEM_ID
,      NEW_PARENT_SYSTEM_ID
,      OLD_SHIP_TO_CONTACT_ID
,      NEW_SHIP_TO_CONTACT_ID
,      OLD_BILL_TO_CONTACT_ID
,      NEW_BILL_TO_CONTACT_ID
,      OLD_TECHNICAL_CONTACT_ID
,      NEW_TECHNICAL_CONTACT_ID
,      OLD_SERVICE_ADMIN_CONTACT_ID
,      NEW_SERVICE_ADMIN_CONTACT_ID
,      OLD_SHIP_TO_SITE_USE_ID
,      NEW_SHIP_TO_SITE_USE_ID
,      OLD_INSTALL_SITE_USE_ID
,      NEW_INSTALL_SITE_USE_ID
,      OLD_BILL_TO_SITE_USE_ID
,      NEW_BILL_TO_SITE_USE_ID
,      OLD_COTERMINATE_DAY_MONTH
,      NEW_COTERMINATE_DAY_MONTH
,      OLD_START_DATE_ACTIVE
,      NEW_START_DATE_ACTIVE
,      OLD_END_DATE_ACTIVE
,      NEW_END_DATE_ACTIVE
,      OLD_AUTOCREATED_FROM_SYSTEM
,      NEW_AUTOCREATED_FROM_SYSTEM
,      OLD_CONFIG_SYSTEM_TYPE
,      NEW_CONFIG_SYSTEM_TYPE
,      OLD_NAME
,      NEW_NAME
,      OLD_DESCRIPTION
,      NEW_DESCRIPTION
,      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
,      MIGRATED_FLAG
,      OLD_OPERATING_UNIT_ID
,      NEW_OPERATING_UNIT_ID
FROM CSI.CSI_SYSTEMS_H;

Dependencies

[top of page]

CSI.CSI_SYSTEMS_H does not reference any database object

CSI.CSI_SYSTEMS_H is referenced by following:

SchemaAPPS
SynonymCSI_SYSTEMS_H