ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F19C3869E053B46B63588994Y SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE ,decode(TRANSACTION_TYPE,'B',RSV.RESERVE_ACCT, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE')) GL_ACCOUNT ,RSV.DEPRN_RESERVE_ACCT RSV_ACCOUNT ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') COST_CENTER ,AD.ASSET_NUMBER || '-' || AD.DESCRIPTION ASSET_NUMBER ,RSV.DATE_PLACED_IN_SERVICE START_DATE ,RSV.METHOD_CODE METHOD ,RSV.LIFE LIFE ,RSV.RATE ADJ_RATE ,DS.BONUS_RATE BONUS_RATE ,RSV.CAPACITY PROD ,SUM(decode(RSV.transaction_type,'B',NULL,RSV.COST)) COST ,SUM(RSV.DEPRN_AMOUNT) DEPRN_AMOUNT ,SUM(RSV.YTD_DEPRN) YTD_DEPRN ,SUM(RSV.DEPRN_RESERVE) DEPRN_RESERVE ,sum(decode(RSV.transaction_type,'B',NULL,nvl(RSV.PERCENT,0))) PERCENT ,RSV.TRANSACTION_TYPE T_TYPE ,FA_RES_LDG_PKG.d_lifeformula(RSV.LIFE,RSV.RATE,DS.BONUS_RATE,RSV.CAPACITY) D_LIFE FROM FA_RESERVE_LEDGER_GT RSV ,FA_ADDITIONS AD ,GL_CODE_COMBINATIONS CC ,FA_DEPRN_SUMMARY DS WHERE RSV.ASSET_ID = AD.ASSET_ID AND RSV.DH_CCID = CC.CODE_COMBINATION_ID AND DS.PERIOD_COUNTER (+) = RSV.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE (+) = :P_Book AND DS.ASSET_ID (+) = RSV.ASSET_ID GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') ,decode(RSV.transaction_type,'B', RSV.RESERVE_ACCT,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE')), RSV.DEPRN_RESERVE_ACCT ,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', cc.CHART_OF_ACCOUNTS_ID, NULL, cc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') ,AD.ASSET_NUMBER ,AD.DESCRIPTION ,RSV.DATE_PLACED_IN_SERVICE ,RSV.METHOD_CODE ,RSV.LIFE ,RSV.RATE ,RSV.CAPACITY ,DS.BONUS_RATE ,RSV.TRANSACTION_TYPE ORDER BY 1, 2, 3, 4, 5 OFA FARESLDG AR FA تقرير دفتر الأستاذ الاحتياطي ببلغاريا Application: الأصول Source: تقرير دفتر الأستاذ الاحتياطي ببلغاريا Short Name: FARESLDG DB package: FA_RES_LDG_PKG D FA Bulgarien - Steuerliche Abschreibungen Application: Anlagen Source: Bulgarien - Steuerliche Abschreibungen Short Name: FARESLDG DB package: FA_RES_LDG_PKG F FA Journal d'amortissement (Bulgarie) Application: Assets Source: Journal d'amortissement (Bulgarie) Short Name: FARESLDG DB package: FA_RES_LDG_PKG US FA Bulgarian Reserve Ledger Application: Assets Source: Bulgarian Reserve Ledger Report Short Name: FARESLDG DB package: FA_RES_LDG_PKG ZHS FA 保加利亚准备金分类帐报表 Application: 资产 Source: 保加利亚准备金分类帐报表 Short Name: FARESLDG DB package: FA_RES_LDG_PKG BI Publisher :c_errbuf :c_retcode :gc_book_class :gc_currency_code :gc_distribution_source_book :gc_period_closed :gd_period1_pcd :gd_period1_pod :gn_accounting_flex_structure :gn_period1_fy :gn_period1_pc :p_book :p_ca_set_of_books_id :p_period1 1 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_ca_set_of_books_id LOV Oracle FA_CA_SOB_CURRENCY Y select gsob.set_of_books_id id, gsob.currency_code value, gsob.name description from gl_sets_of_books gsob where gsob.set_of_books_id in ( select set_of_books_id from fa_book_controls where book_type_code=:$flex$.fa_book_type union all select set_of_books_id from fa_mc_book_controls where book_type_code=:$flex$.fa_book_type) order by gsob.currency_code SELECT currency_code FROM gl_ledgers WHERE ledger_id = ( SELECT set_of_books_id FROM fa_book_controls WHERE book_type_code = :$FLEX$.Book ) Y AR عملة دفاتر الحسابات D Währung Buchungsstruktur F Devise de l'entité comptable US Set of Books Currency ZHS 帐套币种 3 30 :p_period1 LOV Oracle FA_PERIOD_NAME_CLOSED Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_book_type and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_book_type) order by period_counter Y AR الفترة D Periode F Période US Period ZHS 期间