Tuesday 6 May 2014

Find Orcale Discoverer Reports in DataBase

SELECT DISTINCT doc_name, obj.obj_name folder_name, bas.ba_name,
                DECODE (doc.doc_created_by,
                        'EUL5_US', 'N/A',
                        (SELECT user_name
                           FROM fnd_user
                          WHERE user_id = SUBSTR (doc.doc_created_by, 2))
                       ) user_name,
                DECODE (doc.doc_created_by,
                        'EUL5_US', 'N/A',
                        (SELECT description
                           FROM fnd_user
                          WHERE user_id = SUBSTR (doc.doc_created_by, 2))
                       ) user_description
           FROM eul_us.eul5_documents doc,
                eul_us.eul5_elem_xrefs xref,
                eul_us.eul5_expressions EXP,
                eul_us.eul5_objs obj,
                eul_us.eul5_ba_obj_links bol,
                eul_us.eul5_bas bas
          WHERE xref.ex_from_id = doc.doc_id
            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
            AND doc.doc_created_by != 'ORACLE_APPS'
            AND UPPER (doc_name) LIKE UPPER ('%CONS%TRACK%')
--and BAS.BA_NAME like '%Business Area%'
ORDER BY        user_name


Thanks
AmarAlam

10 comments:

oraclehcm said...

I just read your comment such a very nice. Thank you for posting this blog,
Oracle Fusion hcm online coaching supplier offers numerous courses on the various technical platform.
Oracle fusion hcm training

oracleSCM said...

it is vety good content to read it.
Oracle Fusion Procurement & Oracle Fusion Payables are components of Oracle Fusion Applications, helps you ... With Oracle Fusion Procurement you can do better negotiation, better buying. ... SAP Training

oracle procurement said...

First-rate weblog to examine it was so beneficial to us we're looking from long time thanks for sharing this blog..............every other related doubts about oracle get exceptional oracle on-line education institute info from this oracle fusion hcm online trainings
First very very thanks for beneficial facts to newbie.
oracle fusion hcm online trainings
First very very thanks for beneficial facts to newbie.

ORACLE FUSION PROCUREMENT said...

it is vety good content to read it.
Oracle Fusion Procurement & Oracle Fusion Payables are components of Oracle Fusion Applications, helps you ... With Oracle Fusion Procurement you can do better negotiation, better buying. ... SAP Training

oracleSCM said...

Yes ,

this is a good blog ever.content is also very informative.
Thanks for sharing this blog.
oracle fusion SCM on line training


ORACLE FUSION PROCUREMENT said...

Yes ,

this is a good blog ever.content is also very informative.
Thanks for sharing this blog.
oracle fusion HCM on line training

Unknown said...

CALFRE handles oracle fusion financials online training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there


Oracle fusion Financials Training in hyderabad

Oracle Fusion Financials online Training in hyderabad

Unknown said...

your site is genuine to view sir
thank you for your valluable information sir
regards
http://www.erptree.com/course/oracle-fusion-procurement-online-training-in-kolkata/

Unknown said...


thanks for your information visit us at Oracle Fusion Financials Online Training

basha said...

I like this article very much, if Anyone Reads Your Blog, Each And Every one will appreciate you.
Oracle Fusion HCM Online Training

Post a Comment