How to find the External Table referred in the Query?
SELECT doc_name,
ba_name,
folder_name,
user_name,
ext_table,
EUL
FROM
(SELECT d.DOC_name,
b.ba_name ba_name,
o.obj_name folder_name,
o.sobj_ext_table ext_table,
e.EXP_name item_name,
UPPER (USR1.user_name) user_name,
'EUL4_US' EUL
FROM eul4_us.eul5_objs o
LEFT JOIN eul4_us.eul5_expressions e
ON o.obj_id = e.it_obj_id
LEFT JOIN eul4_us.eul5_elem_xrefs x
ON e.exp_id = x.ex_to_id
LEFT JOIN eul4_us.eul5_documents d
ON d.doc_id = x.ex_from_id
LEFT JOIN eul4_us.EUL5_ba_obj_links l
ON l.bol_obj_id = o.obj_id
LEFT JOIN eul4_us.EUL5_bas b
ON b.ba_id = l.bol_ba_id
LEFT JOIN eul4_us.eul5_eul_users EU1
ON d.DOC_EU_ID + 0 = EU1.eu_id
LEFT JOIN applsys.fnd_user USR1
ON SUBSTR (EU1.eu_username, 2) = TO_CHAR (USR1.user_id)
WHERE b.ba_name LIKE '%'
--AND upper(e.exp_name) LIKE upper('%') --folder item
--AND upper(b.ba_name) LIKE upper('%Sample BA Name%') --business area
AND upper(o.obj_name) LIKE upper('%PPER%') --folder
-- AND upper(d.doc_name) LIKE upper('%Payroll%Season%') --report name
/* and (upper(o.SOBJ_ext_table) like upper('%XXBLOG_MV%')
)*/
AND UPPER (USR1.user_name) = 'BIADMIN'
)
GROUP BY doc_name,
ba_name,
folder_name,
user_name,
ext_table,
EUL;
ba_name,
folder_name,
user_name,
ext_table,
EUL
FROM
(SELECT d.DOC_name,
b.ba_name ba_name,
o.obj_name folder_name,
o.sobj_ext_table ext_table,
e.EXP_name item_name,
UPPER (USR1.user_name) user_name,
'EUL4_US' EUL
FROM eul4_us.eul5_objs o
LEFT JOIN eul4_us.eul5_expressions e
ON o.obj_id = e.it_obj_id
LEFT JOIN eul4_us.eul5_elem_xrefs x
ON e.exp_id = x.ex_to_id
LEFT JOIN eul4_us.eul5_documents d
ON d.doc_id = x.ex_from_id
LEFT JOIN eul4_us.EUL5_ba_obj_links l
ON l.bol_obj_id = o.obj_id
LEFT JOIN eul4_us.EUL5_bas b
ON b.ba_id = l.bol_ba_id
LEFT JOIN eul4_us.eul5_eul_users EU1
ON d.DOC_EU_ID + 0 = EU1.eu_id
LEFT JOIN applsys.fnd_user USR1
ON SUBSTR (EU1.eu_username, 2) = TO_CHAR (USR1.user_id)
WHERE b.ba_name LIKE '%'
--AND upper(e.exp_name) LIKE upper('%') --folder item
--AND upper(b.ba_name) LIKE upper('%Sample BA Name%') --business area
AND upper(o.obj_name) LIKE upper('%PPER%') --folder
-- AND upper(d.doc_name) LIKE upper('%Payroll%Season%') --report name
/* and (upper(o.SOBJ_ext_table) like upper('%XXBLOG_MV%')
)*/
AND UPPER (USR1.user_name) = 'BIADMIN'
)
GROUP BY doc_name,
ba_name,
folder_name,
user_name,
ext_table,
EUL;
Comments
Post a Comment