Tuesday 13 January 2015

Find legal entities associated with a SOB

SELECT   organization_id legal_entity_id,
         business_group_id,
         name,
         date_from,
         date_to,
         set_of_books_id,
         vat_registration_number
  FROM   hr_legal_entities
 WHERE   set_of_books_id = 1
and business_group_id=202

No comments:

Post a Comment