Wednesday, February 4, 2015

Query to get The Organization Details

SELECT a.organization_id INV_ORG,
       a.organization_code,
       a.organization_name,
       a.operating_unit,
       b.name OU,
       a.set_of_books_id,
       d.name LEDGER,
       a.legal_entity,
       c.name LE_NAME,
       d.currency_code,
       e.segment1
  FROM apps.ORG_ORGANIZATION_DEFINITIONS a,
       apps.HR_OPERATING_UNITS b,
       apps.xle_entity_profiles c,
       apps.gl_ledgers d,
       apps.GL_CODE_COMBINATIONS_KFV e
 WHERE     1 = 1
       AND d.RET_EARN_CODE_COMBINATION_ID = e.CODE_COMBINATION_ID
       AND a.operating_unit = b.organization_id
       AND c.legal_entity_id = a.legal_entity
       AND d.ledger_id = a.set_of_books_id


No comments:

Post a Comment

Best Blogger TipsGet Flower Effect