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

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.


 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值