quote from jhoann:
----------------------------------------------------------------------
i'm doing a report , customized report for oracle financial.. i don't know what table to use to get the right fields...? can u help me.. what table where i can find the account(cost center) and the cost center name...pls help
thank you
----------------------------------------------------------------------
This question really belongs in the ERP Applications Forum, but this is what I've seen used:SELECT asg.assignment_number asg_no
, cak.segment2 cost_center_nbr
, org.name cost_center_name
FROM hr.per_all_assignments_f asg
, hr.hr_all_organization_units org
, hr.pay_cost_allocation_keyflex cak
WHERE TRUNC(SYSDATE) BETWEEN asg.effective_start_date
AND asg.effective_end_date
AND asg.primary_flag = 'Y'
AND asg.assignment_type = 'E'
AND asg.organization_id = org.organization_id
AND TRUNC(SYSDATE) BETWEEN org.date_from
AND NVL(org.date_to
, TO_DATE('31-DEC-4712'
, 'DD-MON-YYYY'))
AND org.cost_allocation_keyflex_id = cak.cost_allocation_keyflex_id
Good luck,
A.