Need a query to get the Fixed Assets category combination along with all its account combinations

Summary:

Need to get the following accounting combinations of the category combinations in accounting rules;

Cost, clearing, depreciation reserve, depreciation expense,cip, cip clearing, impairment reserve.impairment expense,revaluation reserve, revaluation loss and revaluation amortization

Content (required):

Hi All,

Need a query to get the category combination along with all its account combinations namely cost, clearing, depreciation reserve, depreciation expense,cip, cip clearing, impairment reserve.impairment expense,revaluation reserve, revaluation loss and revaluation amortization

Thanks in advance.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):