[Home] [Help] [Dependency Information]
Object Name: | CS_CTR_AUDIT_LINES |
---|---|
Object Type: | TABLE |
Owner: | CS |
FND Design Data: | CS.CS_CTR_AUDIT_LINES |
Subobject Name: | |
Status: | VALID |
Audit line information for Counters
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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. |
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;
CS.CS_CTR_AUDIT_LINES does not reference any database object
CS.CS_CTR_AUDIT_LINES is referenced by following:
|
|
|