Fixed Assets - EBS (MOSC)

MOSC Banner

11.5.10 Fix Assets SQL

edited Mar 9, 2014 12:00PM in Fixed Assets - EBS (MOSC) 2 commentsAnswered


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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center