eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MRP.MRP_AUDIT_SQL_STATEMENTS

Object Details

Object Name:	MRP_AUDIT_SQL_STATEMENTS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_AUDIT_SQL_STATEMENTS
Subobject Name:
Status:	VALID

MRP_AUDIT_SQL_STATEMENTS stores dynamically-defined SQL statements
that are used by Oracle Master Scheduling/MRP's audit information
program. Each row represents an audit check (a SQL statement that
checks for questionable or erroneous data).
.
The columns returned by the SQL statement are defined in the NUMBER1,
NUMBER2, NUMBER3, CHARACTER1, CHARACTER2 and CHARACTER3 columns. Each
statement can return 3 numbers and 3 character values. If the numeric
values represent unique identifiers for a flexfield value, the
flexfield code should be loaded in FLEXCODE1, FLEXCODE2 or FLEXCODE3.
The from and where clauses are defined by the FROM and WHERE columns.
The string &ORGID in the WHERE clauses will be replaced by the
organization identifier. ERROR specifies whether the statement checks
for questionable data, in which case a warning is issued, or erroneous
data, in which case an error is issued. SUMMARY_WARNING will be
printed by the audit information program if the program is run summary
mode. It does not reference individual rows, but rather a count of
the rows returned. The string &COUNT will be replaced by the count of
rows returned. DETAIL_WARNING will be printed if the program is
running for a specific program statement, or the statement is defined
to be an error. The strings &NUM1 through &NUM3 and &CHAR1 through
&CHAR3 will be replaced by the values specified in the NUMBER and
CHARACTER columns above. If you have specified that a number column
represents a flexfield, the corresponding &NUM string will be replaced
by the flexfield value. Note that the row with STATEMENT_ID = 0 is
used when launching the audit report to indicate that all audit checks
should be performed.
.
This table is loaded as part of seed data that is shipped with the
product. It is also maintained by the Define Audit SQL Statement
form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_AUDIT_SQL_STATEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	STATEMENT_ID USER_DEFINED

Columns

Name	Datatype	Length	Mandatory	Comments
STATEMENT_ID	NUMBER		Yes	Unique identifier for statement
USER_DEFINED	NUMBER		Yes	Code to indicate if the audit was defined by the user or provided as seed data
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
MODULE	VARCHAR2	(3)	Yes	Module which owns the data being verified
NUMBER1	VARCHAR2	(240)	Yes	First columns in predicate clause which retrieves a number
NUMBER2	VARCHAR2	(240)	Yes	Second column in predicate clause which retrieves a number
NUMBER3	VARCHAR2	(240)	Yes	Third column in predicate clause which retrieves a number
CHARACTER1	VARCHAR2	(240)	Yes	First column in predicate clause which retrieves a string
CHARACTER2	VARCHAR2	(240)	Yes	Second column in predicate clause which retrieves a string
CHARACTER3	VARCHAR2	(240)	Yes	Third column in predicate clause which retrieves a string
FLEXCODE1	VARCHAR2	(4)		Flexfield code which the column number1 identifies
FLEXCODE2	VARCHAR2	(4)		Flexfield code which the column number2 identifies
FLEXCODE3	VARCHAR2	(4)		Flexfield code which the column number3 identifies
FROM_CLAUSE	VARCHAR2	(240)	Yes	From clause of dynamically built sql statement
WHERE_CLAUSE1	VARCHAR2	(240)		First part of predicate clause of dynamically built sql statement
WHERE_CLAUSE2	VARCHAR2	(240)		Second part of predicate clause of dynamically built sql statement
WHERE_CLAUSE3	VARCHAR2	(240)		Third part of predicate clause of dynamically built sql statement
WHERE_CLAUSE4	VARCHAR2	(240)		Fourth part of predicate clause of dynamically built sql statement
WHERE_CLAUSE5	VARCHAR2	(240)		Fifth part of predicate clause of dynamically built sql statement
SUMMARY_WARNING	VARCHAR2	(300)	Yes	Warning message if executed in summary mode
DETAIL_WARNING	VARCHAR2	(400)	Yes	Warning message if executed in detail mode
ACTIVE	NUMBER		Yes	Flag to indicate if the audit is currently used
DESCRIPTION	VARCHAR2	(150)	Yes	Description of this audit check
ERROR	NUMBER		Yes	Flag to indicate whether this audit checks for a data integrity error
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT STATEMENT_ID
,      USER_DEFINED
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MODULE
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      CHARACTER1
,      CHARACTER2
,      CHARACTER3
,      FLEXCODE1
,      FLEXCODE2
,      FLEXCODE3
,      FROM_CLAUSE
,      WHERE_CLAUSE1
,      WHERE_CLAUSE2
,      WHERE_CLAUSE3
,      WHERE_CLAUSE4
,      WHERE_CLAUSE5
,      SUMMARY_WARNING
,      DETAIL_WARNING
,      ACTIVE
,      DESCRIPTION
,      ERROR
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MRP.MRP_AUDIT_SQL_STATEMENTS;

Dependencies

[top of page]

MRP.MRP_AUDIT_SQL_STATEMENTS does not reference any database object

MRP.MRP_AUDIT_SQL_STATEMENTS is referenced by following:

APPS: MRP_AUDIT_SQL_STATEMENTS