FA :- SQL to Get Department Wise Asset number and their Price

The below SQL query is used to get the Department Wise Asset Number, Cost of the Asset and their Date placed in service details.

......................................................................................................................................................
SELECT ATTRIBUTE27 DEPARTMENT,
       ASSET_NUMBER ASSET_NUMBER,
       A.ASSET_ID,
       ATTRIBUTE26 RESOURCE_NO,
       ATTRIBUTE25 MACHINE_NO,
       DESCRIPTION,
       COST,
       ORIGINAL_COST ORIGINAL_ASSET_COST,
       DATE_PLACED_IN_SERVICE
  FROM APPS.FA_ADDITIONS A, APPS.FA_BOOKS B
 WHERE     1 = 1                                 --ATTRIBUTE27 = :P_DEPARTMENT
       AND A.ASSET_ID = B.ASSET_ID
       AND ATTRIBUTE26 IS NOT NULL
       AND B.DATE_INEFFECTIVE IS NULL;
-----------------------------------------------------------------------------------------------------------------

In this Query Contains Resource Number and Machine Number values in the Attribute Columns.