已有系统中采购的审批设置

0,PO/Setup/Purchasing/Document Types,查看不同订单的权限及审批流程设置

1,PO/Setup/Approvals/Approval Groups, 找出合适的审批组

2,带入以下query,找出organization和position

SELECT hou.NAME ou,
       hao.NAME org,
       pap.NAME postion,
       pcf.control_function_name document_type,
       pcg.control_group_name approve_group,
       ppc.start_date,
       ppc.end_date
  FROM po_position_controls_all  ppc,
       po_control_groups_all     pcg,
       po_control_functions      pcf,
       per_all_positions         pap,
       hr_operating_units        hou,
       hr_all_organization_units hao
 WHERE ppc.control_group_id = pcg.control_group_id
   AND ppc.control_function_id = pcf.control_function_id
   AND pap.position_id = ppc.position_id
   AND ppc.org_id = hou.organization_id
   AND pap.organization_id = hao.organization_id
   AND pcg.control_group_name = 'Approval Groups Name'

3,PO/Setup/Approvals/Approval Assignments,找出Job

4.HRMS/People/Enter and Maintain,把position assign给employee

5,把这个employee设置成buyer

6,把这employee设置成当前用户对应的person
Job Flexfield, Position Flexfield, People Group Flexfield all are Key Flexfield.


 

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值