Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, June 13, 2012

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

1 comment:

Anonymous said...

Thanks it works

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect