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;

Design a site like this with WordPress.com
Get started