[Home] [Help] [Dependency Information]
Object Name: | CS_SYSTEM_AUDIT |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_SYSTEM_AUDIT |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CS_SYSTEM_AUDIT_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SYSTEM_ID |
CS_SYSTEM_AUDIT_U1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | CS_SYSTEM_AUDIT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SYSTEM_ID | NUMBER | (15) | Yes | System identifier |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OLD_CUSTOMER_ID | NUMBER | (15) | Old customer identifier | |
CURRENT_CUSTOMER_ID | NUMBER | (15) | Current customer identifier | |
AUDIT_COMMENTS | VARCHAR2 | (240) | Audit comments | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
OLD_SYSTEM_TYPE_CODE | VARCHAR2 | (30) | System type lookup code | |
CURR_SYSTEM_TYPE_CODE | VARCHAR2 | (30) | System type lookup code | |
OLD_SERIAL_NUMBER | VARCHAR2 | (15) | Serial number before change | |
CURR_SERIAL_NUMBER | VARCHAR2 | (15) | Serial number after change | |
OLD_PARENT_SYSTEM_ID | NUMBER | parent system identifier before change | ||
CURR_PARENT_SYSTEM_ID | NUMBER | parent system identifier after change | ||
OLD_TECHNICAL_CONTACT_ID | NUMBER | (15) | Technical contact identifier | |
CURR_TECHNICAL_CONTACT_ID | NUMBER | (15) | Technical contact identifier | |
OLD_SERVICE_ADMIN_CONTACT_ID | NUMBER | (15) | Administration contact identifier | |
CURR_SERVICE_ADMIN_CONTACT_ID | NUMBER | (15) | Administration contact identifier | |
OLD_INSTALL_SITE_USE_ID | NUMBER | (15) | Installed site identifier | |
CURR_INSTALL_SITE_USE_ID | NUMBER | (15) | Installed site identifier | |
OLD_BILL_TO_CONTACT_ID | NUMBER | (15) | Bill-to contact identifier | |
CURR_BILL_TO_CONTACT_ID | NUMBER | (15) | Bill-to contact identifier | |
OLD_BILL_TO_SITE_USE_ID | NUMBER | (15) | Identifier for bill-to site use | |
CURR_BILL_TO_SITE_USE_ID | NUMBER | (15) | Identifier for bill-to site use | |
OLD_SHIP_TO_SITE_USE_ID | NUMBER | (15) | Identifier for ship-to site use | |
CURR_SHIP_TO_SITE_USE_ID | NUMBER | (15) | Identifier for ship-to site use | |
OLD_SHIP_TO_CONTACT_ID | NUMBER | (15) | Ship-to contact identifier before change | |
CURR_SHIP_TO_CONTACT_ID | NUMBER | (15) | Ship-to contact identifier after change | |
OLD_COTERMINATE_DAY_MONTH | VARCHAR2 | (6) | The day and month when every service and product under the system expires | |
CURR_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 before change | ||
CURR_START_DATE_ACTIVE | DATE | Start date for the system after change | ||
OLD_END_DATE_ACTIVE | DATE | End date for the system | ||
CURR_END_DATE_ACTIVE | DATE | End date for the system | ||
OLD_CONFIG_SYSTEM_TYPE | VARCHAR2 | (30) | Describes the type of system used by Oracle Product Configurator to validate configurations owned by the customer | |
CURR_CONFIG_SYSTEM_TYPE | VARCHAR2 | (30) | Describes the type of system used by Oracle Product Configurator to validate configurations owned by the customer | |
OBJECT_VERSION_NUMBER | NUMBER | Sequential number used for database locking control | ||
CS_SYSTEM_AUDIT_ID | NUMBER | Yes | Audit identifier | |
SYS_AUD_SYSTEM_ID | NUMBER | (15) | Yes | system identifier |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
UPGRADED_STATUS_FLAG | VARCHAR2 | (1) | ||
VALID_FOR_CSI_MIGRATION | VARCHAR2 | (1) | ||
MIGRATED_STATUS_FLAG | VARCHAR2 | (1) | ||
OLD_BILL_TO_SITE_USE | NUMBER | |||
OLD_SHIP_TO_SITE_USE | NUMBER | |||
CURRENT_BILL_TO_SITE_USE | NUMBER | |||
CURRENT_SHIP_TO_SITE_USE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SYSTEM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OLD_CUSTOMER_ID
, CURRENT_CUSTOMER_ID
, AUDIT_COMMENTS
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, OLD_SYSTEM_TYPE_CODE
, CURR_SYSTEM_TYPE_CODE
, OLD_SERIAL_NUMBER
, CURR_SERIAL_NUMBER
, OLD_PARENT_SYSTEM_ID
, CURR_PARENT_SYSTEM_ID
, OLD_TECHNICAL_CONTACT_ID
, CURR_TECHNICAL_CONTACT_ID
, OLD_SERVICE_ADMIN_CONTACT_ID
, CURR_SERVICE_ADMIN_CONTACT_ID
, OLD_INSTALL_SITE_USE_ID
, CURR_INSTALL_SITE_USE_ID
, OLD_BILL_TO_CONTACT_ID
, CURR_BILL_TO_CONTACT_ID
, OLD_BILL_TO_SITE_USE_ID
, CURR_BILL_TO_SITE_USE_ID
, OLD_SHIP_TO_SITE_USE_ID
, CURR_SHIP_TO_SITE_USE_ID
, OLD_SHIP_TO_CONTACT_ID
, CURR_SHIP_TO_CONTACT_ID
, OLD_COTERMINATE_DAY_MONTH
, CURR_COTERMINATE_DAY_MONTH
, OLD_START_DATE_ACTIVE
, CURR_START_DATE_ACTIVE
, OLD_END_DATE_ACTIVE
, CURR_END_DATE_ACTIVE
, OLD_CONFIG_SYSTEM_TYPE
, CURR_CONFIG_SYSTEM_TYPE
, OBJECT_VERSION_NUMBER
, CS_SYSTEM_AUDIT_ID
, SYS_AUD_SYSTEM_ID
, SECURITY_GROUP_ID
, UPGRADED_STATUS_FLAG
, VALID_FOR_CSI_MIGRATION
, MIGRATED_STATUS_FLAG
, OLD_BILL_TO_SITE_USE
, OLD_SHIP_TO_SITE_USE
, CURRENT_BILL_TO_SITE_USE
, CURRENT_SHIP_TO_SITE_USE
FROM CS.CS_SYSTEM_AUDIT;
CS.CS_SYSTEM_AUDIT does not reference any database object
CS.CS_SYSTEM_AUDIT is referenced by following:
|
|
|