Business requirement to subset AP data based on ORG_IDs.

From the ERD diagram, is it possible to re-create the inter-related AP tables with ORG_IDs that customer is interested in. Then re-apply the grants, synonyms, triggers etc.

For example:

Rename AP_AE_LINES_ALL to AP_AE_LINES_ALL_OLD. Then, create table AP_AE_LINES_ALL as select * from AP_AE_LINES_ALL_OLD where org_id in (<required org_ids>).

Thereafter, build indexes, synonyms, triggers, grants on the newly created AP_AE_LINES_ALL table.

Repeat these steps for all inter-related AP tables.

If so, what would be the list of tables that need to re-created?

Thanks.