Now take the content code and also you need to know the column name of one colum,n used in your integrator
SELECT bcb.content_code from apps.bne_integrators_tl bit, apps.bne_contents_b bcb where bcb.integrator_code = bit.integrator_code and bit.user_name = <integrator_user_name>
I guess with the above two query you will get closer if not definitely find the answer
select ATC.TABLE_NAME from all_tab_columns atc, bne_content_cols_b bcb where atc.column_id = bcb.sequence_num and atc.column_name = bcb.col_name and atc.owner = 'APPS' and bcb.content_code = <content_code> and bcb.col_name = <any_col_of_integrator> order by bcb.creation_date desc
I am glad you got the answer..
select user_name from bne_contents_tl where content_code = (select content_code from bne_integrators_tl where user_name = <integrator_user_name>)
select object_type,object_name,procedure_name from all_procedures where procedure_name = (select interface_name from bne_interfaces_b where interface_code = <interface_code>)
where XXX will be number ou get from bne_integrators_b.integrator_code
select attribute2 from bne.bne_attributes where attribute_code like 'GENERAL_XXX%' and attribute1 = 'PROCEDURE'
select ba.attribute2 from apps.bne_attributes ba, apps.bne_param_lists_b bplb, apps.bne_interfaces_b bib, apps.bne_integrators_tl bit where bib.upload_param_list_code = bplb.param_list_code and bib.integrator_code = bit.integrator_code and ba.attribute_code = bplb.param_list_code || '_ATT' and bit.user_name = <integrator_user_name>