Often at the time of working with Oracle Web ADIs, we want to know what all components are associated with it like Integrator, Layout, Mapping, Underlying PL/SQL procedure etc.
Also while migrating Web ADIs from one instance to another (in case of Installation upgrades, or from Development Instance to Production Instance), using FNDLOAD, we need to know each associated component of a Web ADI to migrate it completely.
bit.INTEGRATOR_CODE = biv.INTEGRATOR_CODE
AND biv.interface_code = blcv.INTERFACE_CODE
AND UPPER(bit.user_name) LIKE UPPER('<integrator USER name>')
The query enables a you to reduce his time spent on analysis of a Web ADI. All that one should know is the name of the Integrator of the Web ADI. Even the end user (Business User) would know the name of the Integrator that they are using.