• Blog
    • Oracle EBS ERP
      • DBA
      • Developer
      • Application
    • Db2 Database
    • MySQL
  • About Me
  • Skills
  • Education
  • Employment
  • Contact

Assets list

  • Home
  • Assets list
List of all Assets

Find all the assets list through given script. SELECT DISTINCT a.asset_number, a.description, a.asset_type, d.segment1 asset_key, c.segment1 major_category, c.segment2 minor_category, c.segment3 sub_minor_category, b.deprn_method_code, b.life_in_months/12 life, b.book_type_code, b.date_placed_in_service, b.depreciate_flag, b.cost, h.units_assigned UNITS,...

/ Posted by Kapil
Categories
  • Application
  • Db2 Database
  • DBA
  • Developer
  • MySQL
  • Oracle EBS ERP
o
  • Extract & restore single mysql table from backup of databaseSaturday - September 04, 2021
© 2019 KS is proudly powered by Kapil Savaliya.