once create job requisition we need pass parameter for position in same screen to link it with flex

Summary:

Dear Oracle support,

Kindly note that once create job requisition we need pass parameter for position in same screen to link it with flex filed.

kindly find SQL we used on flex filed to call position in the Code Snippet:

Regards,

Mohammad Merie

Content (required):

Recruiting , DATA BASE Column

Version (include the version you are using, if applicable):

23B (11.13.23.04.0)

Code Snippet (add any code snippets that support your topic, if applicable):

select distinct NAME

from

HR_ALL_ORGANIZATION_UNITS_F a,

HR_ORGANIZATION_UNITS_F_TL b ,

HR_ALL_POSITIONS_F c

where

a.ORGANIZATION_ID=b.ORGANIZATION_ID