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
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:
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
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
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.
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
Yes ,
this is a good blog ever.content is also very informative.
Thanks for sharing this blog.
oracle fusion SCM on line training
Yes ,
this is a good blog ever.content is also very informative.
Thanks for sharing this blog.
oracle fusion HCM on line training
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
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/
thanks for your information visit us at Oracle Fusion Financials Online Training
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