Line Manager information in OTBI report

Summary:

If any employee is Line Manager for other employee record then we need to display 'X' value.

Content (required):

Ex:

Output:

In the above scenario 66789 and 12345 are line managers for 12345 and 223344. But 223344 is not Line Manager for any employee record. While displaying 223344 employee record in the Line Manager or not column as 'N'.

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

Oracle Fusion Cloud Applications 23B (11.13.23.04.0)

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