R12 GL to Subledger View

The requirement is to show the detail transactions and account subtotals (for balancing).  Parameters: Period Name + list of Accounts.  I have seen a number of discussions circling on drilling down from the GL records to the subledgers, however, I have not come across the following alternative :

1)     Create 4 views that start from xla_distributions_all table for the following source_distribution_type : AP_INV_DIST / RCV_RECEIVING_SUB_LEDGER / AP_PMT_DIST / MTL_TRANSACTION_ACCOUNTS

2)     Create a view that links to the above 4 views by way of the xla_ae_lines table, something like this:

INNER  JOIN apps.xla_ae_lines xal ON gir.gl_sl_link_id = xal.gl_sl_link_id AND gir.gl_sl_link_table = xal.gl_sl_link_table