Tuesday, 7 July 2015

How to find Legal Entity name in Oracle apps

SELECT   XEP.NAME
  INTO   LEGAL_ENTITY_NAME
  FROM   XLE_ENTITY_PROFILES XEP
 WHERE   LEGAL_ENTITY_ID  =  (SELECT   DISTINCT DEFAULT_LEGAL_CONTEXT_ID
                               FROM   HR_OPERATING_UNITS
                              WHERE   NAME = 'XX_OPERATING_UNIT')

No comments:

Post a Comment