FA Unassigned Assets by FA Book (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Fixed Assets (FA-Fusion-SQL's)
1

This FA unassigned assets by FA book query displays asset details for unassigned fixed assets as of today, supporting asset tracking and reconciliation.

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --This query lists unassigned fixed assets with key details and category information
  FAB.ASSET_NUMBER,
  FAB.ASSET_TYPE,
  FAB.TAG_NUMBER,                                            					
  FAB.SERIAL_NUMBER,                                         					
  FAB.MANUFACTURER_NAME,
  FAB.MODEL_NUMBER,                                          					
  FAB.PROPERTY_TYPE_CODE                     PROPERTY_TYPE,
  FAB.IN_USE_FLAG,
  FAB.OWNED_LEASED,
  FAB.NEW_USED                               ASSET_CONDITION, 
  FAB.CREATION_DATE,
  FAB.CREATED_BY,
  FAB.INVENTORIAL,                
  FCB.SEGMENT1 || '_' || FCB.SEGMENT2        CATEGORY
FROM
  FA_ADDITIONS_B          FAB,
  FA_CATEGORIES_B         FCB,
  FA_BOOKS                FB
WHERE
  1 = 1
  AND FAB.ASSET_CATEGORY_ID = FCB.CATEGORY_ID
  AND FAB.ASSET_ID          = FB.ASSET_ID(+)
  AND FB.ASSET_ID IS NULL
ORDER BY
  FAB.ASSET_NUMBER;