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;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete