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
No comments:
Post a Comment
Note: only a member of this blog may post a comment.