EBS:资产类别

EBS R12.1 资产类别

 

查询语句

-- FA-资产分类.sql
SELECT FC.CATEGORY_ID,
       FC.SEGMENT1 ||'.'|| FC.SEGMENT2 AS "资产类别" -- FA_CATEGORY 
      ,FC.DESCRIPTION AS  "资产说明"  -- FA_DESCRIPTION
      --,FC.CAPITALIZE_FLAG -- 资本化
      ,DECODE(FC.CATEGORY_TYPE, 'NON-LEASE','非租赁','LEASE','租赁'
         ,'LEASEHOLD IMPROVEMENT','租赁资产改良支出') AS "分类类型"
      ,DECODE(FC.OWNED_LEASED,'OWNED','自有','租用')  AS "所有权"
      ,FCB.BOOK_TYPE_CODE AS "帐簿"
      ,FCBD.DEPRN_METHOD  AS "折旧方法"
      ,DECODE(FCBD.DEPRN_METHOD,'CUX_FA_DEP','当月新增，次月折旧','CUX_FA_AMO','当月新增，当月折旧')  AS "折旧方法"
      ,floor(FCBD.LIFE_IN_MONTHS/12) AS "折旧年限(年数)"
      ,MOD(FCBD.LIFE_IN_MONTHS,12) AS "折旧年限(月数)"
      ,FCBD.PRORATE_CONVENTION_CODE AS "折旧惯例" 
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.ASSET_COST_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS "资产成本" --ASSET_COST_ACCOUNT_SEGS,
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.ASSET_CLEARING_ACCOUNT_CCID --in number  -- code_Combination_id    
       )  AS "资产结算" --ASSET_CLEARING_ACCOUNT_SEGS
      , FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.RESERVE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS "累计折旧" --RESERVE_ACCOUNT_SEGS
     --  ,FCB.REVAL_AMORT_ACCOUNT_CCID
     /*  ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.REVAL_AMORT_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS REVAL_AMORT_ACCOUNT_SEGS,
      -- FCB.REVAL_RESERVE_ACCOUNT_CCID,
       FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.REVAL_RESERVE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS REVAL_RESERVE_ACCOUNT_SEGS,
     */ -- FCB.BONUS_RESERVE_ACCT_CCID,
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.BONUS_RESERVE_ACCT_CCID --in number  -- code_Combination_id    
       ) AS "附加准备金" -- BONUS_RESERVE_ACCT_SEGS
     /*  ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.UNPLAN_EXPENSE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS UNPLAN_EXPENSE_ACCOUNT_SEGS
      */ --,FCB.DEPRN_EXPENSE_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.DEPRN_EXPENSE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS "折旧费用" -- DEPRN_EXPENSE_ACCOUNT_SEGS,
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.BONUS_EXPENSE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS "附加费用" -- BONUS_EXPENSE_ACCOUNT_SEGS 
       -- ,FCB.WIP_COST_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.WIP_COST_ACCOUNT_CCID --in number  -- code_Combination_id    
       )  AS "CIP 成本" -- WIP_COST_ACCOUNT_SEGS
      -- FCB.WIP_CLEARING_ACCOUNT_CCID
      , FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.WIP_CLEARING_ACCOUNT_CCID --in number  -- code_Combination_id    
       )  AS "CIP 结算" -- WIP_CLEARING_ACCOUNT_SEGS 
      -- ,FCB.ALT_COST_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.ALT_COST_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS "替代资产成本" --ALT_COST_ACCOUNT_SEGS
      -- ,FCB.WRITE_OFF_ACCOUNT_CCID
     /*  ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.WRITE_OFF_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS  WRITE_OFF_ACCOUNT_SEGS
      -- ,FCB.IMPAIR_EXPENSE_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.IMPAIR_EXPENSE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS IMPAIR_EXPENSE_ACCOUNT_SEGS
      -- ,FCB.IMPAIR_RESERVE_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.IMPAIR_RESERVE_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS IMPAIR_RESERVE_ACCOUNT_SEGS
      -- ,FCB.CAPITAL_ADJ_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.CAPITAL_ADJ_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS CAPITAL_ADJ_ACCOUNT_SEGS
      -- ,FCB.GENERAL_FUND_ACCOUNT_CCID
       ,FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID 
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>FCB.GENERAL_FUND_ACCOUNT_CCID --in number  -- code_Combination_id    
       ) AS GENERAL_FUND_ACCOUNT_SEGS
     */,FC.*
 FROM FA_CATEGORIES_VL FC,
 FA_CATEGORY_BOOKS  FCB ,  
  FA_CATEGORY_BOOK_DEFAULTS  FCBD  -- 默认折旧规则 
 WHERE FC.CATEGORY_ID = FCB.CATEGORY_ID 
 AND FCB.BOOK_TYPE_CODE = 'FA_BOOK_SIMI'
 AND FCB.CATEGORY_ID = FCBD.CATEGORY_ID 
 AND FCB.BOOK_TYPE_CODE = FCBD.BOOK_TYPE_CODE
 AND FC.CATEGORY_ID NOT  IN (2008,2009)  -- (长期待摊.08,长期待摊.09)
-- AND FC.SEGMENT1  LIKE '无形资产%'
 ORDER BY FC.SEGMENT1 , FC.SEGMENT2