11.5.10 Fix Assets SQL
Hello Oracle Gurus
I want to inquiry a Tax Book through SQL and I have noticed the following table does not have any information.
select * from apps.fa_distribution_history
Where book_type_code = 'My Tax Book'
Therefore my SQL does not work. Will you please let me know any glues how to get the Tax Book Information.
The following SQL does not work for a Tax Book.
alter session set NLS_DATE_FORMAT = 'DD/MM/YYYY';
alter session set nls_language=american;
SELECT
a.asset_number "Asset Number",
a.asset_id,
a.asset_category_id,
d.deprn_method_code,