1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Zero Value Asset

Discussion in 'Oracle Apps Technical' started by brand_ni, Jun 23, 2010.

  1. brand_ni

    brand_ni Guest

    I need a script that will identify all zero value assets, can someone please help me with that.
     
  2. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Below query will show assets with zero values.

    Code (SQL):

    SELECT DISTINCT asset_id
    FROM    FA_BOOKS
    WHERE   original_cost = 0;

     
    Regards,
    Yowan Cristo