Need a SQL query to fetch CIP asset and Capitalized assets separately

Hi All,

We need a sql query to fetch details of

CIP assets columns are Asset number, asset type, period name, asset id, cost

Capitalized asset columns Asset number, asset type, period name, asset id, cost, depreciation amount, depreciation period, invoice number, supplier name.

Kindly help us with the query

Thanks,

Dilip