Wednesday 28 June 2023

Oracle EBS - SQL query for GL Authorization Limit for Employee

Subject: SQL query for GL Authorization Limit for Employee

SQL Query:

SELECT

    ledger_name,
    ledger_currency,
    employee_name,
    employee_id,
    authorization_limit,
    ledger_id,
    last_update_date,
    last_updated_by,
    created_by,
    creation_date
FROM
    apps.gl_authorization_limits_v
WHERE
    employee_name LIKE '%Ryan%' ---Need to enter user name whoes Authorization Limit need to check
ORDER BY
    ledger_name,
    employee_name