Tuesday, July 12, 2022

ORACLE OAF Customizations Query

 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'

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL Query to Convert number into Words for Money

SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...

  • Oracle User Hook Registration and XXPkg
    now we are going to handle User hook case and it use when we want to validate EIT Or SIT in both case Self Service or Professional View (Fo...
  • Delete Person Absence API
    Note this when its Submit but if still in AME Cycle Use Wrok Flow to approve then delete it or Reject  -- The API  --- DECLARE    CUR...