This page allows you to view the SQL statement associated with the view. This offers a read-only editor.
Select the “View SQL” link in the “Define View” page.
The system displays the following fields:
View Display Name |
The name of the view, as it appears in the “Inquiries” activity. |
View Type |
The type of the view, which could be” Private” or “Public”. |
View Access |
The access type of the view, which could be “Public” or “Private”. |
The system displays the SQL statements for the selected view, in the text box. The SQL statement associated with the view appears in “Read-only” mode. You cannot make any changes to the statement in this screen.
Click the “Copy SQL Statements” pushbutton to copy the SQL statements to clipboard.