Tagged: “#sql”

• 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

See all tags.