Oracle Cloud Fusion R13 Multi Organization tables

                      Oracle Cloud Fusion R13 Multi Organization tables

                       =====================================

Multi Org Tables

==============

Locations Tables

==============

select * from hr_locations_all where location_code like 'TCS%'

Business Group Tables

=================

select * from hr_all_organization_units where name like 'TCS%'

Currency Tables

=================

select * from fnd_currencies_tl where currency_code ='INR'

Periods Type Tables

=================

select * from gl_period_types where user_period_type like 'TCS%'

Calendar  Tables

=================

select * from gl_period_sets where period_set_name like 'TCS%'

select * from gl_periods  where period_set_name like 'TCS%'

Chart of Account  Tables

====================

select * from fnd_id_flex_structures_tl where id_flex_structure_name like 'TCS%'

select * from fnd_id_flex_segments where id_flex_num = 54202

Ledger Tables

====================

select * from gl_ledgers where name like 'TCS%'

Legal Entity  Tables

====================

select * from hz_parties where party_name like 'TCS%'

Operating Units Tables

=====================

select * from hr_all_organization_units where name like 'TCS%'

select * from hr_operating_units where name like 'TCS%'