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

TABLE: ASG.ASG_AUDIT

Object Details
Object Name: ASG_AUDIT
Object Type: TABLE
Owner: ASG
Subobject Name:
Status: VALID


Stores the log information for InstallationMgr.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes PK Column.
COMMAND VARCHAR2 (2000)
Stores the command syntax of the run.
START_RUN_DATE DATE

Stores the start date of running the command.
END_RUN_DATE DATE

Stores the end date of the running command.
SUCCESS VARCHAR2 (1)
Stores the flag to indicate if the run is succeeded.
MESSAGE VARCHAR2 (4000)
Stores the last messages from the run.
LOG_FILE VARCHAR2 (2000)
Stores the full path of the log file.
CHANGED_PUB_LIST VARCHAR2 (2000)
Stores the list of the changed Publication.
NEED_RESTART VARCHAR2 (1)
Stores the flag to indicate if the webtogo server needs to be restarted.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT ID
,      COMMAND
,      START_RUN_DATE
,      END_RUN_DATE
,      SUCCESS
,      MESSAGE
,      LOG_FILE
,      CHANGED_PUB_LIST
,      NEED_RESTART
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM ASG.ASG_AUDIT;

Dependencies

[top of page]

ASG.ASG_AUDIT does not reference any database object

ASG.ASG_AUDIT is referenced by following:

SchemaASG
ViewASG_AUDIT#