You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get the results from the DBI SQL

edited Jul 5, 2019 2:24PM in Human Capital Management 3 comments

Summary

How to get the results from the DBI SQL

Content

I was trying to find the Value that the DBI 'PER_ASG_JOB_CODE' is returning.For that i had to find the SQL and then the context Names .

SQL:      per_all_assignments_m       paf_asg,
       per_jobs_f                  pjf,
       per_jobs_f_tl               pjftl,
       hr_all_positions_f          hapf,
       hr_all_positions_f_tl       hapftl,
       hr_all_organization_units_f haouf,
       hr_organization_units_f_tl  houftl,
       per_grades_f                pgf,
       per_grades_f_tl             pgftl,
       hr_locations_all_f_vl       hrloc,
       per_contracts_f             percon,
       per_periods_of_service      perpos

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!