VIEW: MRP.MRP_AUDIT_SQL_STATEMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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