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

TABLE: CS.CS_CTR_AUDIT_LINES

Object Details
Object Name: CS_CTR_AUDIT_LINES
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_CTR_AUDIT_LINES
Subobject Name:
Status: VALID


Audit line information for Counters


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
AUDIT_LINE_ID NUMBER
Yes The identifier of the Audit Line .
AUDIT_ID NUMBER
Yes The identifier of the Audit .This is a foreign key to audit_id in cs_ctr_audit table.
SOURCE_TYPE VARCHAR2 (100)
Source Type signifies the type of process .Examples include derive_counters,reading etc.
SOURCE_NAME VARCHAR2 (255)
Source Name is the source name from which this value is derived.Example cs_counter_values.
SOURCE_ID NUMBER

Source Identifier is the source identifier from which this value is derived .Example is the counter_value_id from cs_counter_values.
CURRENT_VALUE VARCHAR2 (2000)
Current value of the source .
OLD_VALUE VARCHAR2 (2000)
Old value of the source.
OTHER_TEXT1 VARCHAR2 (240)
Other Text is for defining other sources.
OTHER_TEXT2 VARCHAR2 (240)
Other Text is for defining other sources.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER
Yes Standard WHO column.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER
Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER

Standard WHO column.
Query Text

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


SELECT AUDIT_LINE_ID
,      AUDIT_ID
,      SOURCE_TYPE
,      SOURCE_NAME
,      SOURCE_ID
,      CURRENT_VALUE
,      OLD_VALUE
,      OTHER_TEXT1
,      OTHER_TEXT2
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM CS.CS_CTR_AUDIT_LINES;

Dependencies

[top of page]

CS.CS_CTR_AUDIT_LINES does not reference any database object

CS.CS_CTR_AUDIT_LINES is referenced by following:

SchemaCS
ViewCS_CTR_AUDIT_LINES#