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

Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.

Question
23
Views
0
Comments
in Reporting and Analytics for ERP

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):

SELECT

   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",

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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