This content has been marked as final. Show 13 replies
whenever you create an integrator there is also an object_code which is created.
If the integrator_code is GENERAL_12_INTG the object_code is GENERAL_12 and it has some link with object_id column of user_objects
Hope this helps. I am looking for an answer . you may check bne_integrator_utils package though
Please run the below queries
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
Thanks for looking for the answer, but it is still incorrect. I need to know how Web ADI looks for table name, which obviously had to be saved when I was creating integrator. Your way is more how to check it for own purposes and it is not right. Altough I thought it is not correct way I checked it anyway - I got 4 tables returned in best case (when I selected invoice_id field). Anyway this would be very freak way of getting that information from database. I went through bne package you provided few days ago and I could not find anything.
I am on 11i and it does gives me the code.
the query shoule be
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>)
I too learned a new thing Thanks
Edited by: 936671 on Jul 11, 2012 3:39 AM
I also found something whereby you can get to know the package/procedure associated with your integrator :
Method 1 :
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'
The best possible way of getting the same :
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>