-----------Integrtor-----------
select integrator_code, application_short_name
from apps.bne_integrators_vl bnv
,apps.fnd_application_vl fav
where bnv.user_name like 'XX Patty Cash AP Invoice%'
and fav.application_id = bnv.application_id;
---------layout------------
select layout_code,user_name
from apps.bne_layouts_vl
where user_name like 'XX Patty Cash AP Invoice%'
; -- XXPATTYCASHAPINVOICELAYOUT
---------Mapping---------
select mapping_code
from apps.bne_mappings_vl
where integrator_code = 'XXAPINV4_XINTG';
-----------Content -------------
select content_code
from apps.bne_contents_vl
where integrator_code = 'XXAPINV4_XINTG';
select integrator_code, application_short_name
from apps.bne_integrators_vl bnv
,apps.fnd_application_vl fav
where bnv.user_name like 'XX Patty Cash AP Invoice%'
and fav.application_id = bnv.application_id;
---------layout------------
select layout_code,user_name
from apps.bne_layouts_vl
where user_name like 'XX Patty Cash AP Invoice%'
; -- XXPATTYCASHAPINVOICELAYOUT
---------Mapping---------
select mapping_code
from apps.bne_mappings_vl
where integrator_code = 'XXAPINV4_XINTG';
-----------Content -------------
select content_code
from apps.bne_contents_vl
where integrator_code = 'XXAPINV4_XINTG';