Monday, 4 March 2019

Fusion Query to find Default company values assigned in Legal Entity

1. Link Between Legal Entity & Ledger along with Default Company Assigned in Legal Entity

 SELECT flex_segment_value
                ,gll.*
   FROM gl_legal_entities_bsvs gleb
               ,gl_ledger_le_v gll
WHERE gleb.legal_entity_id = gll.legal_entity_id
     AND ledger_category_code = 'PRIMARY'
     AND gleb.flex_segment_value = :p_company 
 
or

2.  Default Company value assigned in Legal Entity

SELECT * FROM XLE_ENTITY_PROFILES

No comments:

Post a Comment