Fixed Assets

SELECT SUBSTR (a.OWNER, 1, 20),
         SUBSTR (a.NAME, 1, 30),
         SUBSTR (a.TYPE, 1, 20),
         SUBSTR (u.status, 1, 10) Stat,
         u.last_ddl_time,
         SUBSTR (text, 1, 80)   Desc...

-- Period status for Inventory
  SELECT DISTINCT opu.name            AS operating_unit,
                  per.organization_id AS inv_org_id,
                  par.organization_code AS inv_org_code,
  ...

SELECT DISTINCT
         fab.asset_id,
         fab.asset_number,
         FAT.DESCRIPTION,
         fab.current_units,
         SUM (fdh.units_assigned)                         units_assigned_count,
...