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
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:
Thanks it works
Post a Comment