Modify WHERE Clauses

You can edit the properties of a WHERE clause in a query of the view that is being modified. A WHERE clause can be edited or suppressed but not deleted. However, you can delete a WHERE clause after you have added it and before you save the customizations to the view. You can perform the following tasks:

• Editing WHERE Clauses

• Suppressing, Restoring WHERE Clauses

Editing WHERE clauses

You can add a column entry, delete a column entry, or change the position of a column entry in an existing WHERE clause.

1. On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.

2. Select a view, and then click Modify. For information, see Select a View. The Modify View » <view label> page appears.

3. Under Where Clauses, click Add, modify & suppress, and then click Next. The Modify View » <view label> » Add, modify & suppresswhere clauses page appears.

4. If you have more than one query in the selected view, a tab will appear for each query. Select the appropriate tab for the query in which you want to modify the WHERE clauses. The list of WHERE clauses will be displayed. The following columns are available in the list:

   • WHERE clause: Indicates the WHERE clause added to the view.

   • Status: Indicates the status of the WHERE clause. If the WHERE clause is not modified, the status will be displayed as UNCHANGED. If a WHERE clause is added, the status will be displayed as ADDED. If a WHERE clause is modified, the status will be displayed as CHANGED. If a WHERE clause is suppressed, the status will be displayed as SUPPRESSED.

   • Start: Indicates the starting product version of the Oracle E-Business Suite application that is applicable to the WHERE clause.

   • End: Indicates the ending product version of the Oracle E-Business Suite application that is applicable to the WHERE clause.

   • Profile Option: Indicates the profile condition for the WHERE clause.

5. In the query area, select the WHERE clause that you want to modify, and click Edit. The Edit Where Clause dialog box appears.

6. In the Edit Where Clause dialog box, perform the following:

1. In the Tables for reference list, select a table that you want to include in the WHERE clause. If the selected table is used in a subquery, go to step b. Otherwise, go to step c.

2. The Table entry box appears displaying the selected table in the &<application label>.<table name> <table alias> format in the read-only mode. Click Append Table. The selected table will be appended to the existing list of entries in the Where Clause box in the format in which it appears in the Table entry box.

3. In the Columns for reference list showing the columns corresponding to the selected table, select the column that you want to use in the WHERE clause.

4. The selected column will be displayed in the Column entry box in the <table alias.column name> format in the read-only mode. Click Append Column. The selected column will be appended to the existing list of entries in the Where Clause box in the format in which it appears in the Column entry box.

5. In the Where Clause box, you can also edit the list to add entries manually and change the position of entries.
   
   IMPORTANT: If the WHERE clause includes a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.The WHERE clause can contain a maximum of 1,000 characters.

6. Click Save to return to the Modify View » <view label> » Add, modify & suppresswhere clauses page.

7. Repeat steps 5 and 6 if you want to edit another WHERE clause. The status of the modified WHERE clause will be displayed as CHANGED in the query area.

8. If you want to change the position of the WHERE clause that you have edited, select the WHERE clause, and then, click Move up or Move down.

9. In the Customization comments box, provide a summary of the customizations that you performed. The customization comments can contain a maximum of 200 characters.

10. Click Save.The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

Suppressing, Restoring WHERE Clauses

You can suppress or restore an existing WHERE clause.

To suppress, restore a WHERE clause

1. On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.

2. Select a view, and then click Modify. The Modify View » <view label> page appears. For information, see Select a View.

3. Under Where Clauses, click Add, modify & suppress, and then click Next. The Modify View » <view label> » Add, modify & suppresswhere clauses page appears.

4. If you have more than one query in the selected view, a tab will appear for each query. Select the appropriate tab for the query in which you want to modify the WHERE clauses. The list of WHERE clauses will be displayed.

5. In the query area, select the WHERE clause that you want to suppress or restore, and perform the following:

• To suppress the WHERE clause, click Suppress. The status of the WHERE clause will be changed to SUPPRESSED.

• To restore the WHERE clause, click Restore. The status of the WHERE clause will be reset to UNCHANGED.

6. In the Customization comments box, provide a summary of the customizations that you performed. The customization comments can contain a maximum of 200 characters.

7. Click Save. The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.