SELECT JP.path_docid DOC_ID
, JP.path_name NAME
, jdr_mds_internal.getdocumentname(JP.path_docid) DOC_PATH
FROM jdr_paths JP
WHERE JP.path_docid IN ( SELECT DISTINCT comp_docid
FROM jdr_components
WHERE comp_seq = 0
AND comp_element = 'customization'
No comments:
Post a Comment