Query to find All VO Substitutions
SELECT PATH.path_docid PERZ_DOC_ID,
jdr_mds_internal.Getdocumentname(PATH.path_docid) PERZ_DOC_PATH
FROM jdr_paths PATH
WHERE PATH.path_docid IN (SELECT DISTINCT comp_docid
FROM jdr_components
WHERE comp_seq = 0
AND comp_element = 'customization'
AND comp_id IS NULL)
AND ( jdr_mds_internal.Getdocumentname(PATH.path_docid) ) LIKE '%VO%'
ORDER BY perz_doc_path;
In order to delete the customization definition, use the below call -
BEGIN
jdr_utils.Deletedocument('/oracle/apps/icx/por/reqmgmt/server/customizations/site/0/AllReqsVO');
END;
BEGIN
jdr_utils.Deletedocument('/oracle/apps/fnd/server/customizations/site/0/FndAttachedDocumentsDomExtensionVO');
END;
Comments
Post a Comment