获得某个ID 默认的成本中心

前提: 采购订单信息中的默认费用账户必须设置

[@more@]/* Formatted on 2007/02/05 18:59 (Formatter Plus v4.8.7) */
SELECT pa.person_id, gc.*
FROM per_all_assignments_f pa,
pay_cost_allocations_f pc,
--pay_cost_allocation_keyflex pk,
gl_code_combinations gc,
per_all_people_f pp,
fnd_user fu
WHERE pa.assignment_id = pc.assignment_id
-- AND pk.cost_allocation_keyflex_id= pc.cost_allocation_keyflex_id --(+)
AND gc.code_combination_id = pa.default_code_comb_id
AND pa.person_id = pp.person_id
AND fu.employee_id = pp.person_id
AND fu.user_name = 'AARON'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/226700/viewspace-897620/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/226700/viewspace-897620/