Modify Lookup Columns
The NoetixViews Workbench allows you to modify the lookup type columns of a view.
NOTE: If a lookup column has a profile condition associated with it, the profile condition of the column is displayed on the query tab. The query tab also displays information about the status of the query. The status information indicates that the query is available for the current version of your Oracle E-Business Suite instance and is used in at least one form of the view.
To modify a lookup column
On the NoetixViews Workbench home page, click Modify a View. The Modify View page appears.
Select a view, and then click Modify. For information, see Select a View. The Modify View » <view label> page appears.
Under Columns, click Add, modify & suppress columns, and then click Next. The Modify View » <view label> » Add, modify & suppress columns page appears showing the list of columns available in the view.
Select a column, and click Modify. The Modify Lookup Column page appears.
Modify the column properties depending on your requirements. For information about the column properties, see Add Lookup Columns in "Add Columns."
Click OK.The Modify View » <view label> » Add, modify & suppress columns page appears showing the modified column with the state "CHANGED".
Repeat steps 4 to 6 to modify more lookup columns. You can also perform other customizations on view columns, such as addition or modification of columns of any type. For information about these tasks, see the respective topics under Manage View Columns.
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 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.