Tuesday, 13 January 2015

Find operating units for a legal entity :

SELECT   organization_id operating_unit,
         name,
         business_group_id,
         SUBSTR (set_of_books_id, 1, 10),
         SUBSTR (legal_entity_id, 1, 10),
         date_from,
         date_to
  FROM   hr_operating_units
 WHERE   legal_entity_id = 204
/

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete