HCM Core HR Quires

 

Core HR:

1. Legal Entity and Business Unit

select legEnt.name LE_NAME, hou.name BU_Name,FUBU.SHORT_CODE,FUBU.STATUS

from

xle_entity_profiles legEnt ,

hr_operating_units hou,

FUN_BU_USAGES_V FUBU

where 1=1

and hou.DEFAULT_LEGAL_CONTEXT_ID(+) = legEnt.LEGAL_ENTITY_ID

and FUBU.BUSINESS_UNIT_ID = HOU.ORGANIZATION_ID

AND FUBU.STATUS = 'A'AND FUBU.CONFIGURATION_STATUS = 'Y' 

and legEnt.name = 'LEGAL ENTITY NAME'