HR_LOOKUPS vs HCM_LOOKUPS View — Cloud Customer Connect
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

HR_LOOKUPS vs HCM_LOOKUPS View

edited Apr 17, 2019 5:34AM in Reporting and Analytics for HCM 1 comment

Summary

Need to know the difference between HR Lookup and HCM Lookup view

Content

Can anyone let me know the difference between HR Lookup and HCM Lookup view.

From view SQL Statement i could see that HR Lookup has below decode statement which is not present in HCM Lookup.

AND decode(B.TAG, NULL, 'Y', decode(substr(B.TAG,1,1), '+', decode(sign(instr(B.TAG, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(B.TAG, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'

Thanks,

Parthiban

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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