How can we extract requisitions tied other locations data through BIP tables ?
Content
Hi All,
PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUISITION_ID” and able to see the data rows in IRC_REQ_LOCATIONS table and this table ‘REQ_LOCATION_ID’ is available and it’s not mapped to LOCATION_ID From the table ‘HR_LOCATIONS_ALL_F_VL’.
Navigation: Navigator ->Hiring -> Job Requisitions and search Requisition number
Can you please help me on this, how we can extract the requisitions tied other locations data through BIP tables
Thanks,
Janardhana