ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1F33869E053B46B63588994 select a.category_flex, b.concatenated_segments reval_amortization_account, c.concatenated_segments impair_expense_account, d.concatenated_segments impair_reserve_account, e.concatenated_segments capital_adj_account, f.concatenated_segments general_fund_account, decode(a.validation_flag,'Y','SUCCESS:Category has qualified for UK Local Authority Accounting Category Implementation', 'R','WARNING:Revaluation Amortization account should be the same as Capital Adjustment account', 'ERROR:Impairment Expense account or Accumulated Impairment account not assigned' ) status, count(a.category_flex) category_count from fa_sorp_upg_cat a, GL_CODE_COMBINATIONS_KFV b, GL_CODE_COMBINATIONS_KFV c, GL_CODE_COMBINATIONS_KFV d, GL_CODE_COMBINATIONS_KFV e, GL_CODE_COMBINATIONS_KFV f where a.reval_amort_account_ccid= b.code_combination_id(+) and a.impair_expense_account_ccid = c.code_combination_id(+) and a.impair_reserve_account_ccid = d.code_combination_id(+) and a.capital_adj_account_ccid = e.code_combination_id(+) and a.general_fund_account_ccid = f.code_combination_id(+) and e.chart_of_accounts_id = :P_ACCT_FLEX_STRUCT and a.book_type_code = :P_FA_BOOK group by a.category_flex, b.concatenated_segments, c.concatenated_segments, d.concatenated_segments, e.concatenated_segments, f.concatenated_segments, a.validation_flag order by a.validation_flag desc Y OFA FASRPCTIL AR FA تنفيذ الفئة لمحاسبة السلطة المحلية بالمملكة المتحدة Application: الأصول Source: تنفيذ الفئة لمحاسبة السلطة المحلية بالمملكة المتحدة Short Name: FASRPCTIL DB package: FA_SORP_UPG_PKG D FA Kategorie-Implementierung für die kommunale Rechnungslegung (GB) Application: Anlagen Source: Kategorie-Implementierung für die kommunale Rechnungslegung (GB) Short Name: FASRPCTIL DB package: FA_SORP_UPG_PKG F FA Implémentation de catégorie pour la comptabilité des administrations locales du Royaume-Uni Application: Assets Source: Implémentation de catégorie pour la comptabilité des administrations locales du Royaume-Uni Short Name: FASRPCTIL DB package: FA_SORP_UPG_PKG US FA Category Implementation for UK Local Authority Accounting Application: Assets Source: Category Implementation for UK Local Authority Accounting Short Name: FASRPCTIL DB package: FA_SORP_UPG_PKG ZHS FA UK 本地税务机关会计的类别实施 Application: 资产 Source: UK 本地税务机关会计的类别实施 Short Name: FASRPCTIL DB package: FA_SORP_UPG_PKG BI Publisher :p_acct_flex_struct :p_fa_book :p_from :p_order_by :p_request_where :p_where 1 10 :p_fa_book LOV Oracle FA_SORP_BOOK Y select book_type_code id, book_type_code value, null description from fa_book_controls where sorp_enabled_flag='Y' order by value,description Y AR دفتر الأصل D AfA-Buch F Livre d'amortissement US Asset Book ZHS 资产帐簿 2 20 :p_acct_flex_struct Number select Accounting_Flex_Structure from FA_BOOK_CONTROLS where Book_Type_Code = :$FLEX$.Asset_Book Y AR هيكل مرن للحساب D Konto-FlexFeld-Struktur F Structure de clé comptable flexible US Account Flex Structure ZHS 帐户弹性结构 3 30 :p_capital_adj_flex Char Y AR حساب تسوية رأس المال D Kapitalberichtigungskonto F Compte d'ajustement de capital US Capital Adjustment Account ZHS 资本调整帐户 4 40 :p_general_fund_flex Char Y AR حساب الصندوق العام D Konto für Steuern und sonstige Einkünfte F Compte de fonds général US General Fund Account ZHS 一般资金帐户 5 50 :p_mode LOV Oracle FA_SORP_UPG_MODE Y select lookup_code id, lookup_code value, meaning description from fa_lookups where lookup_type='FA_SORP_UPG_MODE' order by value,description Y AR طور التقرير D Auswertungsmodus F Mode édition US Report Mode ZHS 报表模式 :$FLEX$.Asset_Book Asset Book Account Flex Structure