Skip to main content

All Discoverer how to get list of discoverer report from DB

Discoverer How to get list of discoverer report from DB

---------------------------------------------------------------------------------------------------
SELECT DISTINCT doc_name, obj.obj_name folder_name, bas.ba_name, (SELECT user_name
FROM fnd_user where to_char(USER_ID) = SUBSTR (DOC.DOC_CREATED_BY, 2, 4)) OWNER
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 BAS.BA_NAME like ‘%Business Area%’




To find Business folders
===============================================================

SELECT DISTINCT EB.BA_NAME "CUSTOM BUSINESS AREA" ,
  EO.OBJ_NAME "CUSTOM FOLDER"
FROM EUL_US.EUL5_BAS EB ,
  EUL_US.EUL5_OBJS EO ,
  EUL_US.EUL5_BA_OBJ_LINKS EBOL ,
  EUL_US.EUL5_EXPRESSIONS EE
WHERE EBOL.BOL_BA_ID = EB.BA_ID
AND EBOL.BOL_OBJ_ID  = EO.OBJ_ID
AND EE.IT_OBJ_ID     = EO.OBJ_ID
AND UPPER(EO.OBJ_NAME) LIKE '%STR%'
ORDER BY 1

Comments

Post a Comment

Popular posts from this blog

FND_PROFILE API In Oracle Apps

 FND_PROFILE API In Oracle Apps --------------------------------------------------------------------------------------------------- FND_PROFILE API is used very frequently in oracle apps development. The major purpose of this API is to: ·                      Retrieve user profile values for the current run-time environment ·                      Set user profile values for the current run-time environment FND_PROFILE API has different procedures and functions which are most frequently used. Following are the brief explanation of them: 1. FND_PROFILE.PUT:  This can be used to put a value to the specified user profile option. Example:  FND_Profile.Put(‘PROFILE_NAME’, ‘New_Value’) FND_Profile.Put(’USERNAME’, Usr_Name) FND_Profile.Pu...
Post a Comment
Read more

PO Matching Setting in Purchase Order Shipment Line(2-way,3-way,4-way)

[PO] Matching Setting in Purchase Order Shipment Line Invoice matching can be set in five different areas of Oracle Purchasing: In the list below, a setting at any level will override the settings above it. 1. Oracle Purchasing Options a. Navigate to: Setup > Organizations > Purchasing Options b. Select Default Alternative Region 2. Supplier Information a. Navigate to: Supply Base > Suppliers b. Query on specific supplier c. Click on Open d. Select Receiving Alternative Region 3. Line Types a. Navigate to: Setup > Purchasing > Line Types b. In the Receipt Required field: Yes = 3-way, No = 2-way 4. Items a. Navigate to: Items > Master Items b. Query on specific item c. Select Purchasing Alternative Region d. In the Invoice Matching section: Yes = 3-way, No = 2-way 5. Purchase Order Shipments a. Navigate to: Purchase Orders > Purchase Orders b. Enter (header and) line information c. Click on Shipments button d. Select More Alternative Region Ramification of Invoice ...
Post a Comment
Read more

Query To get the SMTP Server Details for a database server

Query To get the SMTP Server Details for a database server -------------------------------------------------------------------------------------------------------------------------------------- select fscpv.parameter_value "SMTP Host Name"       --SMTP protocol uses default port number 25 for outgoing emails       ,25                    "SMTP Port Number"       ,fscpt.description   from fnd_svc_comp_params_tl fscpt       ,fnd_svc_comp_param_vals fscpv  where fscpt.parameter_id = fscpv.parameter_id    and fscpt.display_name = 'Outbound Server Name' --'Inbound Server Name'    and fscpt.language = 'US'; --------------------------------------------------------------------------------------------------------------------------------------
Post a Comment
Read more