Page 1 of 1

Oracle r12 HRMS Tables and fields

Posted: Sun May 03, 2009 3:17 pm
by harhara
I am in the process to develop a report, kindly help me how to find out the name of the Oracle R12 HRMS tables, I have logged in the application and tried to do the following to find out the name of the table but it gives me the name of the view

Help >>> Record History >>> Table Name: PER_PEOPLE_V

Please help

Mohsen

Posted: Sun May 17, 2009 1:42 am
by sforsuccess
Hai

if u got the view ..per_all_people_v then just go to toad and see the script .
By this u can get all the tables involved with this screen and also u can find all the joins which is very important for reporting.