Blog Archives
Query to get jdr path in oracle apps
Sometimes in form function for a OAF page there will be only Region code there will not be Region path.
In order to get the region path use the below Query. We can search using the PATH_NAME in the below query
SELECT PATH_NAME, jdr_mds_internal.getDocumentName(path_docid) as component
, path_type , path_seq , creation_date , last_update_date
FROM jdr_paths;

