SQL语句 - EBS 员工审批权限及上下级查询

员工审批权限及上下级(针对总账日记账审批)

select gal.employee_name 员工名,
       gal.employee_id 员工ID,
       gal.LEDGER_NAME 帐套名,
       gal.authorization_limit 审批限额,
       gal.LEDGER_CURRENCY 本位币种
  from GL_AUTHORIZATION_LIMITS_V gal
select ppv7.person_id,
       ppv7.last_name,
       ppv7.effective_start_date,
       ppv7.effective_end_date,
       pav7.assignment_number,
       ppv72.last_name
  from PER_PEOPLE_V7 ppv7, PER_ASSIGNMENTS_V7 pav7, PER_PEOPLE_V7 ppv72
 where 1 = 1
   and ppv7.person_id = pav7.person_id
   and pav7.supervisor_id = ppv72.person_id



我的博客即将搬运同步至腾讯云+社区,邀请大家一同入驻:https://cloud.tencent.com/developer/support-plan?invite_code=2xrfvozycg4ks

本文标题:SQL语句 - EBS 员工审批权限及上下级查询

本文链接:https://catonisland.cn/post/258.html

本文版权归作者所有,欢迎转载,转载请以文字链接的形式注明文章出处。

相关文章