===========================================================
===========================================================
获得某个ID 默认的成本中心
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.02.05 19:06
分类: 分销 , 财务 , EBS
出处: http://moonsoft.itpub.net/post/15182/260746
---------------------------------------------------------------
前提: 采购订单信息中的默认费用账户必须设置
/* 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'
