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