EUL4_BAS
Table gives list of Business Areas
EUL4_OBJS
Table gives all folders in the EUL
EUL4_KEY_CONS
Table gives all Folder Joins details.
- Key_Obj_ID points to parent folder,
- FK_Obj_ID_Remote points to child folder
EUL4_EXPRESSIONS
Table gives all Items that are in the EUL
- IT_Obj_ID is not null AND join to a row in EUL4_Objs you have a Folder Item.
They are listed as Exp_Type of 'CO' or 'CI'.
COs are database object items.
CIs are created items (like date hierarchy items, complex folder items, etc).
EUL4_OBJS
Table gives details about the types of objects
- Obj_Type tells you Standard (SOBJ) from Complex (COBJ) folders.
EUL_USERS
Table gives user details.
EUL4_ACCESS_PRIVS
Table to use to get the list of Discoverer users that was granted access to the User Edition.
Basically, when a user has been granted privileges one row per privilege is inserted into this table.
- The column called AP_EU_ID contains the ID of the user.
- The column GP_APP_ID is the one that tells you what privilege a user has.
Table gives list of Business Areas
EUL4_OBJS
Table gives all folders in the EUL
EUL4_KEY_CONS
Table gives all Folder Joins details.
- Key_Obj_ID points to parent folder,
- FK_Obj_ID_Remote points to child folder
EUL4_EXPRESSIONS
Table gives all Items that are in the EUL
- IT_Obj_ID is not null AND join to a row in EUL4_Objs you have a Folder Item.
They are listed as Exp_Type of 'CO' or 'CI'.
COs are database object items.
CIs are created items (like date hierarchy items, complex folder items, etc).
EUL4_OBJS
Table gives details about the types of objects
- Obj_Type tells you Standard (SOBJ) from Complex (COBJ) folders.
EUL_USERS
Table gives user details.
EUL4_ACCESS_PRIVS
Table to use to get the list of Discoverer users that was granted access to the User Edition.
Basically, when a user has been granted privileges one row per privilege is inserted into this table.
- The column called AP_EU_ID contains the ID of the user.
- The column GP_APP_ID is the one that tells you what privilege a user has.
SELECT DISTINCT disco_docs.doc_name "Discoverer Workbook", trunc(disco_docs.doc_created_date) "Workbook Create Date", CASE WHEN instr(disco_docs.doc_created_by, '#') = 0 THEN disco_docs.doc_created_by WHEN instr(disco_docs.doc_created_by, '#') > 0 AND instr(disco_docs.doc_created_by, '#', 2) = 0 THEN (SELECT fu.user_name FROM apps.fnd_user fu WHERE fu.user_id = substr(disco_docs.doc_created_by, 2, 5)) ELSE NULL END "Workbook Owner/Creator", --disco_users.eu_username, CASE WHEN instr(disco_users.eu_username, '#') = 0 THEN disco_users.eu_username WHEN instr(disco_users.eu_username, '#') > 0 AND instr(disco_users.eu_username, '#', 2) = 0 THEN (SELECT apps.fu.user_name FROM apps.fnd_user fu WHERE fu.user_id = substr(disco_users.eu_username, 2, 5)) ELSE (SELECT resp.responsibility_name FROM apps.fnd_responsibility_tl resp WHERE resp.language = 'US' AND resp.responsibility_id = substr(disco_users.eu_username, 2, 5)) END AS "Shared Name / Responsibility"
FROM xxdis_us.eul5_documents disco_docs, xxdis_us.eul5_access_privs disco_shares, xxdis_us.eul5_eul_users disco_users WHERE disco_docs.doc_id = disco_shares.gd_doc_id AND disco_users.eu_username(+) NOT IN ('EUL5', 'PUBLIC') AND disco_users.eu_id(+) = disco_shares.ap_eu_id AND upper(disco_docs.doc_name) LIKE 'XX%'
FROM xxdis_us.eul5_documents disco_docs, xxdis_us.eul5_access_privs disco_shares, xxdis_us.eul5_eul_users disco_users WHERE disco_docs.doc_id = disco_shares.gd_doc_id AND disco_users.eu_username(+) NOT IN ('EUL5', 'PUBLIC') AND disco_users.eu_id(+) = disco_shares.ap_eu_id AND upper(disco_docs.doc_name) LIKE 'XX%'
http://my.safaribooksonline.com/book/certification/oracle/01320110037si/oracle-discoverer-10g-create-queries-and-reports-windows/table_of_contents#X2ludGVybmFsX0J2ZGVwRmxhc2hSZWFkZXI/eG1saWQ9MDEzMjAxMTAwMzdTSS9peA==
