To retrieve activity and asset information along with asset group

 To retrieve activity and asset information along with asset group from Oracle Apps R12,

you would typically query the relevant tables in the Oracle E-Business Suite database.

Below is an example query that you can use:

sql

SELECT

    fa.asset_number,

    fa.asset_id,

    fa.asset_category_id,

    fai.asset_group,

    fa.description AS asset_description,

    fai.tag_number,

    fai.asset_key,

    fai.asset_creation_date,

    faa.transaction_units,

    faa.transaction_date,

    fat.description AS transaction_type,

    fa.location_id,

    fl.location_code,

    fa.installation_date,

    fa.in_service_date

FROM

    fa_additions fa

    JOIN fa_additions_b fai ON fa.asset_id = fai.asset_id

    JOIN fa_transaction_headers fth ON fai.transaction_header_id = fth.transaction_header_id

    JOIN fa_transaction_lines ftl ON fth.transaction_header_id = ftl.transaction_header_id

    JOIN fa_asset_categories_fac fac ON fa.asset_category_id = fac.asset_category_id

    JOIN fa_asset_books fab ON fa.asset_id = fab.asset_id

    JOIN fa_book_controls fbc ON fab.book_type_code = fbc.book_type_code

    JOIN fa_locations fl ON fa.location_id = fl.location_id

    JOIN fa_adjustments faa ON faa.transaction_header_id = fth.transaction_header_id

    JOIN fa_transaction_types fat ON faa.transaction_type_id = fat.transaction_type_id

WHERE

    fat.transaction_type_code = 'ADDITION'

    AND faa.transaction_units > 0;

This query retrieves information about assets, including their number, group, description,

creation date, transaction details (like units, date, and type), and location. Adjust the joins and conditions

based on your specific requirements and the structure of your Oracle Apps R12 instance.