Запрос для поиска страниц или регионов OEBS OAF с отключенной персонализацией:
select *
from (select att.att_value base_path
,jdr_mds_internal.getDocumentName(pat.path_docid) custom_path
,regexp_replace(jdr_mds_internal.getDocumentName(pat.path_docid),
'.*/customizations/([[:alpha:]]*)/.*',
'\1') custom_level
,decode(regexp_replace(jdr_mds_internal.getDocumentName(pat.path_docid),
'.*/customizations/([[:alpha:]]*)/.*',
'\1'),
'site',
'SITE',
(regexp_replace(jdr_mds_internal.getDocumentName(pat.path_docid),
'.*/customizations/([[:alpha:]]*)/([0-9A-Za-z_]*)/.*',
'\2'))) custom_level_value
,nvl((select 'N'
from jdr_attributes cat
where cat.att_comp_docid = pat.path_docid
and cat.att_name = 'MDSActiveDoc'
and cat.att_value = 'false'),
'Y') is_active
,pat.created_by
,pat.creation_date
,pat.last_updated_by
,pat.last_update_login
,pat.LAST_UPDATE_DATE
from jdr_paths pat
join jdr_attributes att on (pat.path_docid = att.att_comp_docid)
where att_comp_seq = 0
and att_name = 'customizes'
--and regexp_like( jdr_mds_internal.getDocumentName(path_docid), 'apps/(iby|fnd)' )
)
where is_active = 'N'
Finding out and getting details of existing OA Framework personalizations and extensions
Последние комментарии