固定資産

SELECT fa.asset_id 資産id,
       fa.asset_number ebs資産标簽号,
       nvl(fa.tag_number, fa.asset_number) 資産編号,
       fa.serial_number 序列号,
       fa.description 資産名稱,
       (SELECT fcb.concatenated_segments
          FROM fa_categories_b_kfv fcb
         WHERE fcb.category_id = fa.asset_category_id) 資産類别組合說明,
       (SELECT fak.concatenated_segments
          FROM fa_asset_keywords_kfv fak
         WHERE fak.code_combination_id = fa.asset_key_ccid) 資産關鍵字組合說明,
       fa.current_units 資産數量,
       fa.model_number 型号,
       (SELECT ffv.flex_value
          FROM fa_book_controls fbc, fa_books_v fbv, fnd_flex_values ffv
         WHERE ffv.flex_value_set_id IN
               (SELECT flex_value_set_id
                  FROM fnd_flex_value_sets
                 WHERE flex_value_set_name = 'BZ_COMPANY')
           AND ffv.value_category = 'BZ_COMPANY'
           AND ffv.attribute3 = fbv.book_type_code
           AND fbv.book_type_code = fbc.book_type_code
           AND fbv.asset_id = fa.asset_id) 公司代碼,
       fbv.cost 資産成本金額,
       fbv.salvage_value 殘值,
       fbv.depreciate_flag 是否折舊,
       cux_fa_public_pkg.get_ltd_deprn(p_asset_id          => fa.asset_id,
                                       p_book_type_code    => fbv.book_type_code,
                                       p_rate_source_rule  => NULL,
                                       p_dist_id           => 0,
                                       p_period_ctr        => 0,
                                       p_mrc_sob_type_code => 'N',
                                       p_set_of_books_id   => fbc.set_of_books_id) 累計折舊,
       fbv.date_placed_in_service 資産啟用日期,
       to_date(fa.attribute5, 'YYYY-MM-DD') 期初日期
  FROM fa_additions_v fa, fa_books_v fbv, fa_book_controls fbc
 WHERE fa.asset_id = fbv.asset_id
   AND fbv.book_type_code = fbc.book_type_code;
           

轉載于:https://www.cnblogs.com/wanghang/p/6299324.html