WHERE CLAUSE CREATOR DIALOG#
The Where Clause Creator Dialog MMWCC screen allows you to create a Where Clause. The data in the dialog is stored on the P2K_AM_WHERE_CLAUSES and P2K_AM_CONDITIONS tables.
Where Clause Data Source Name Where Clause Usage Description Type Predefined Column Operator Value Test Where Clause
- Table Note is Attached
- User Notes For
- Note Type
- The type of note is defined in this field.
- Start Date/End Date
- The start and end dates of the note are defined in these fields.
- Note Text
- The actual note text is provided in this field.
- Created By
- The individual who created the note is identified in this field.
- Create Date
- The date the note was created is indicated in this field.
- Last Change User
- The last user to change the note is identified in this field.
- Last Change Date
- The date the note was last changed is indicated in this field.