Oracle Application r12: Query to fetch Legal entity for Operating Unit

In R12 use below query to fetch Legal entity details for Operating Unit
 
Select a.organization_id, 
          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
From apps. ORG_ORGANIZATION_DEFINITIONS a,
         apps. HR_OPERATING_UNITS b,
         apps. xle_entity_profiles c,
         apps. gl_ledgers d
Where a.operating_unit=b.organization_id
and    C.LEGAL_ENTITY_ID=a.LEGAL_ENTITY
AND    d.ledger_id=a.set_of_books_id;

Oracle Apps: Query to check Value Set Values

Below is Query to check Valueset Values in Oracle Apps

SELECT ffvs.flex_value_set_id ,
ffvs.flex_value_set_name ,
ffvs.description set_description ,
ffvs.validation_type,
ffv.flex_value,
ffvt.description value_description,
ffv.enabled_flag,
ffv.last_update_date,
ffv.last_updated_by,
ffv.attribute1,
ffv.attribute2,
ffv.attribute3–Include attribute values based on DFF segments
FROM fnd_flex_value_sets ffvs ,
fnd_flex_values ffv ,
fnd_flex_values_tl ffvt
WHERE
ffvs.flex_value_set_id = ffv.flex_value_set_id
and ffv.flex_value_id = ffvt.flex_value_id
AND ffvt.language = USERENV(‘LANG’)
and flex_value_set_name like <Valueset>
ORDER BY flex_value asc