add

About Me

My photo
Oracle Apps - Techno Functional consultant

Wednesday, June 13

Discoverer Query to find BA, BA_DESC, FOLDER_NAME, FOLDER_NAME_DESC

Please find below query to find Business area, folder name , Business area description and folder description for a given discoverer report.

select distinct
      DOC_NAME
    , OBJ.OBJ_NAME FOLDER_NAME
    , BAS.BA_NAME
    , BAS.BA_DESCRIPTION
    , OBJ.OBJ_DESCRIPTION FOLDER_DESCRIPTION

from
      EUL6_US.EUL5_DOCUMENTS DOC
    , EUL6_US.EUL5_ELEM_XREFS XREF
    , eul6_us.eul5_expressions exp
    , EUL6_US.EUL5_OBJS OBJ
    , EUL6_US.EUL5_BA_OBJ_LINKS BOL
    , eul6_us.eul5_bas bas
where XREF.EX_FROM_ID = DOC.DOC_ID
--    and doc.doc_name = 'PR_Over Scale and Special Agreements'
    and xref.ex_to_id = exp.exp_id
    and obj.obj_id = exp.it_obj_id
    and BOL.BOL_OBJ_ID = OBJ.OBJ_ID
    and bas.ba_id = bol.bol_ba_id

No comments: