MarkView All Components - Web Inquiry configuration to display and short Organizations

Question / Problem:

• Configure Web Inquiry to Display an LOV to allow filtering by Organization.
• Work around defect  97561 – Organizations not ordered in Web Inquiry LOV.

Answer / Solution: 

• To configure Web Inquiry to display the Organizations LOV:

On Module Admin -> Display Type -> Show Query (on the APINVOICE for INQUIRY row)  
Search on ‘Org Name’ and set the ‘Include in Display Default’ field to Y. 

• To Work around defect  97561 – Organizations not ordered in Web Inquiry LOV 

Set the ENABLE_MVT_WEB_DISPLAY_CUSTOM to TRUE
Alter the GenerateLOVList procedure in the MVT_Web_Display_Custom package as per attachment.

Attachments:
MVT_Web_Display_Custom.GenerateLOVList.txt
MVT_Web_Display_Custom_pb.sql

Applies to: