Fixed Assets - EBS (MOSC)

MOSC Banner

Query to find out from Mass Addition which is not yet converted into Fixed assets from any Source

Fixed Assets - EBS 12.2.8

select b.FEEDER_SYSTEM_NAME,a.mass_addition_id, a.creation_date,a.asset_number,a.invoice_number,a.invoice_date, a.vendor_number,

       a.PO_number,a.description "DESCRIPTION",a.fixed_assets_cost,a.payables_cost,a.queue_name,a.POSTING_STATUS

from fa_mass_additions A,      FA_ASSET_INVOICES B

where A.invoice_Date is not null

      and A.book_type_code=<Asset Book Name of Company>

     and a.queue_name in ('SPLIT','ON HOLD','NEW')

     --and a.invoice_number = 00580--

     --and b.FEEDER_SYSTEM_NAME ='11i Oracle Assets'

     and b.FEEDER_SYSTEM_NAME in ('11i Oracle Assets','DDA CORPORATE','DDA STORES','ORACLE PAYABLES','Spreadsheet')

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