前提: 采购订单信息中的默认费用账户必须设置
[@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/