The below given query provides the drill down from the FA Assets mapping to GL with XLA Tables SELECT FTH.ASSET_ID,
Category: FA – Fixed Assets
Query to fetch fixed asset invoices in oracle apps
The below given query provides the data extract related to the invoice,vendor, project related details of assets SELECT DISTINCT’I’
Extract fixed asset and depreciation details in Oracle apps R12
The below given query provides the extract for the Fixed Asset information and related depreciation details SELECT ‘A’ RECORD_IDENTIFIER, FAB.ASSET_TYPE