Thursday 26 December 2013

EAM Assets

SELECT inventory_item_id
     , serial_number
     , parent_item_id
     , parent_serial_number
     , parent_object_id
     , descriptive_text
     , concatenated_segments
     , asset_group_description
     , eam_location
     , wip_accounting_class_code
     , owning_department_id
     , owning_department
     , maintained_unit
  FROM apps.mtl_eam_asset_numbers_all_v;

No comments:

Post a Comment