Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.
Summary: Greetings, i need some help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.
Content (please ensure you mask any confidential information): i need some way to join the table FND_FLEX_VALUES_VL to either HR_LOCATIONS_ALL, or HR_LOCATIONS, or any HR table.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
XEP.LEGAL_ENTITY_IDENTIFIER AS "cnpj",
HOV.ATTRIBUTE1 AS "codigo",
FFVL.ENABLED_FLAG AS "status",
TO_CHAR(FFVL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS') AS "dataInicio",