Modify Table Properties
In the NoetixViews Workbench, you can modify the properties of a table or view. You can suppress or restore these tables and change their order, among other actions. You cannot delete an existing table; however, you can delete a new table or view after adding it but before saving the customizations to the view.
To modify properties of a table or view
On the NoetixViews Workbench home page, clickModify a View. TheModify Viewpage appears.
Select a view, and then click Modify. For information, see Select a View. The Modify View » <view label> page appears.
Under Tables, click Add, modify & suppress tables, and then click Next. The Modify View » <view label> » Add, modify & suppress tables page appears.
-
Select the tab for the query in which you want to modify a table or view. The tables available in the query are displayed in a list. The list contains the following columns:
Name: Indicates the name of the table or view.
Alias: Indicates the table alias.
State: Indicates the status of the table or view. If the table or view is modified, the status is displayed as CHANGED. If the table or view is original, the status is displayed as UNCHANGED. If the table or view is added, the status is displayed as ADDED. If the table or view is suppressed, the status is displayed as SUPPRESSED.
Click the table or view that you want to modify. Depending on the requirement, do the following:
If you want to suppress a table or view, click Suppress. A warning message will be displayed indicating that Stage 4 will fail if you do not remove all references to the suppressed table or view from the WHERE clauses of the view and suppress the columns of the table or view that are used in the view. Click OK to confirm the action.
If you want to restore a table or view that has been suppressed, click Restore.
If you want to change the position of the table or view in the list, click Move up or Move down.
To modify the query in which the table is used, click This table is used in the main query or This table is used in a subquery. If you have selected the This table is used in a subquery option oryou are modifying a table or view in a list of values (LoV) view, go to step 8.
If the table or view is used in the main query, you can modify the properties as follows:
NOTE: You cannot modify the table alias for an existing table or view.
If you want to define the table or view as a base table, select the This is a base table check box. A base table is the core table for a view. This table could be a Noetix base view or an Oracle table.
If you want to automatically generate search-by (A$) columns that are based on the indexed columns in the table or view, select the Add Search-By column based on table to this view check box.
NOTE: You cannot modify the starting and ending versions of the Oracle E-Business Suite application that is applicable to an existing table.
In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.
Click Next. The Modify View » <view label>» Add, modify & suppress where clauses page appears.
Add or modify the WHERE clause settings. For information about managing WHERE clauses, see Manage WHERE Clauses.
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.