Tagged: “#query”

30 Oct 2024 | 1 min read

#oracle #fusion #query #sql #business #bu

Oracle Fusion - SQL Query for Business Units

Oracle Fusion SQL Query returning the data of Business units
read article
28 Oct 2024 | 2 min read

#query #sql #oracle #fusion #p2p #procurement #requisition

Oracle Fusion - SQL Query for Requisitions

Oracle Fusion SQL Query returning the data from Requisitions - Lines and distributions
read article
22 May 2024 | 1 min read

#costcenter #query #manager #oracle #fusion #sql

Oracle Fusion - Query for Cost Center Manger

Cost Center manager details from an employee # If you have an employee and you need to know his cost center manager: SELECT peo.person_number employee_number, per_name.display_name ...
read article
03 Mar 2024 | 2 min read

#oracle #fusion #query #sql #data #access

Orecle Fusion - Query for Data Access

SELECT gl.name Security_Context_Value, pr.role_name Role_Name, pu.username UserName, role.ACTIVE_FLAG , 'DATA ACCESS SET' Security_Context FROM fusion.FUN_USER_ROLE_DATA_ASGNMNTS...
read article