Tagged: “#sql”

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
26 Mar 2024 | 4 min read

#sql #oracle #fusion #gl #ap #project #bip #report

Orecle Fusion - Query for GL to Project Cost

AP # SELECT gjh.JE_HEADER_ID hdr_id, gjl.JE_LINE_NUM line_num, --xte.source_id_int_1, sql1.project, sql1.project_name, sql1.task, sql1.task_name, aia.INVOICE_ID...
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