Locating the Module for a Business Object

If you've ever known the name of the business object you were looking for, but could not figure out which module it is located in and didn't feel like searching every module in the GUI builder, below is a script to help you out. The IBS_SPEC_TYPE table provides a list of all business objects and the IBS_MODULE table give a list of all modules, so a simple SQL script can join these two tables and give you your answer. For a list of all objects and modules use this:

select O.NAME, M.MODULE_NAME

from IBS_SPEC_TYPE o, IBS_MODULE m

where O.SPEC_CLASS_TYPE = M.MODULE_ID

order by M.MODULE_NAME, O.NAME

If you just want to get the details for a specific object you can use the script below, substituting the value in red for the name of the BO you are looking for.

select O.NAME, M.MODULE_NAME

from IBS_SPEC_TYPE o, IBS_MODULE m

where O.SPEC_CLASS_TYPE = M.MODULE_ID

and O.NAME = 'triREPaymentAdjustment'

order by M.MODULE_NAME, O.NAME