Wednesday 30 May 2018

Query to get the package called from webadi

select ba.attribute2
, bit.user_name
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.attribute_code
and bit.language='US'
and bit.user_name = '----';