ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F19F3869E053B46B63588994 SELECT DP.PERIOD_NAME PERIOD_NAME, DP.PERIOD_COUNTER PERIOD_COUNTER, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE, CB.ASSET_COST_ACCT GL_ACCOUNT, AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ASSET_NUMBER, BOOKS.DATE_PLACED_IN_SERVICE START_DATE, BOOKS.DEPRN_METHOD_CODE METHOD, BOOKS.LIFE_IN_MONTHS LIFE, BOOKS.ADJUSTED_RATE ADJ_RATE, DS.BONUS_RATE BONUS_RATE, BOOKS.PRODUCTION_CAPACITY PROD, sum(DD.COST) COST, sum(DD.DEPRN_AMOUNT) DEPRN_AMOUNT, sum(DD.YTD_DEPRN) YTD_DEPRN, sum(DD.DEPRN_RESERVE) DEPRN_RESERVE, --fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMP_CODE_DSP1, FA_FAS402_XMLP_PKG.d_lifeformula(BOOKS.LIFE_IN_MONTHS, BOOKS.ADJUSTED_RATE, DS.BONUS_RATE, BOOKS.PRODUCTION_CAPACITY) D_LIFE FROM &lp_fa_deprn_periods DP, &lp_fa_deprn_detail DD, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS DHCC, &lp_fa_books BOOKS, &lp_fa_book_controls BC, FA_ADDITIONS_NON_SEC_VL AD, &lp_fa_deprn_summary DS, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB WHERE DP.BOOK_TYPE_CODE = :P_BOOK AND DP.PERIOD_COUNTER >= :PERIOD1_PC AND DP.PERIOD_COUNTER <= :PERIOD2_PC AND BOOKS.PERIOD_COUNTER_FULLY_RESERVED = (SELECT MAX(PERIOD_COUNTER_FULLY_RESERVED) FROM &LP_FA_BOOKS BKS_PC WHERE BKS_PC.BOOK_TYPE_CODE = BOOKS.BOOK_TYPE_CODE AND BKS_PC.ASSET_ID = BOOKS.ASSET_ID AND BKS_PC.PERIOD_COUNTER_FULLY_RESERVED BETWEEN :PERIOD1_PC AND :PERIOD2_PC) AND BOOKS.PERIOD_COUNTER_FULLY_RESERVED = DP.PERIOD_COUNTER AND BOOKS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND BOOKS.DATE_EFFECTIVE <= Nvl(DP.PERIOD_CLOSE_DATE, BOOKS.DATE_EFFECTIVE) AND NVL(BOOKS.DATE_INEFFECTIVE, SYSDATE+1) > Nvl(DP.PERIOD_CLOSE_DATE, SYSDATE) AND DS.ASSET_ID = BOOKS.ASSET_ID AND DS.PERIOD_COUNTER = DP.PERIOD_COUNTER AND DS.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND DD.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND DD.ASSET_ID = BOOKS.ASSET_ID AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER AND AD.ASSET_ID = BOOKS.ASSET_ID AND CB.CATEGORY_ID = AH.CATEGORY_ID AND CB.BOOK_TYPE_CODE = BOOKS.BOOK_TYPE_CODE AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE <= Nvl(DP.PERIOD_CLOSE_DATE, AH.DATE_EFFECTIVE) AND nvl(AH.DATE_INEFFECTIVE,SYSDATE + 1) > Nvl(DP.PERIOD_CLOSE_DATE, SYSDATE) AND BC.BOOK_TYPE_CODE = BOOKS.BOOK_TYPE_CODE AND DH.ASSET_ID = BOOKS.ASSET_ID AND DH.BOOK_TYPE_CODE = BC.DISTRIBUTION_SOURCE_BOOK AND DH.DATE_EFFECTIVE <= Nvl(DP.PERIOD_CLOSE_DATE, DH.DATE_EFFECTIVE) and NVL(DH.DATE_INEFFECTIVE,SYSDATE + 1) > Nvl(DP.PERIOD_CLOSE_DATE, SYSDATE) AND DHCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID GROUP BY DP.PERIOD_NAME, DP.PERIOD_COUNTER, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), CB.ASSET_COST_ACCT, AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION, BOOKS.DATE_PLACED_IN_SERVICE, BOOKS.DEPRN_METHOD_CODE, BOOKS.LIFE_IN_MONTHS, BOOKS.ADJUSTED_RATE, DS.BONUS_RATE, BOOKS.PRODUCTION_CAPACITY, fnd_flex_xml_publisher_apis.process_kff_combination_1('comp_code_dsp', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') ORDER BY --Commented during DT Fix /* DP.PERIOD_COUNTER, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), CB.ASSET_COST_ACCT, AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION*/ --Added during DT Fix 2,1,3,4,5,6,7,8,10,11,9,12,13,14,15 --End of DT Fix Y OFA FAS402_XML AR FA تقرير الأصول الاحتياطية بالكامل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الأصول الاحتياطية بالكامل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS402_XML DB package: FA_FAS402_XMLP_PKG D FA Vollständig abgeschriebene Anlagen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Vollständig abgeschriebene Anlagen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS402_XML DB package: FA_FAS402_XMLP_PKG F FA Etat des immobilisations entièrement amorties- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des immobilisations entièrement amorties (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS402_XML DB package: FA_FAS402_XMLP_PKG US FA Fully Reserved Assets - draft Application: Assets Source: Fully Reserved Assets Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS402_XML DB package: FA_FAS402_XMLP_PKG ZHS FA 提完折旧资产报表- 不支持：已保留供将来使用 Application: 资产 Source: 提完折旧资产报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS402_XML DB package: FA_FAS402_XMLP_PKG BI Publisher &lp_fa_book_controls &lp_fa_books &lp_fa_deprn_detail &lp_fa_deprn_periods &lp_fa_deprn_summary :accounting_flex_structure :currency_code :lp_currency_code :lp_fa_book_controls :lp_fa_books :lp_fa_deprn_detail :lp_fa_deprn_periods :lp_fa_deprn_summary :p_book :p_ca_set_of_books_id :p_conc_request_id :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :period1_pc :period2_pc :rp_bal_lprompt :rp_company_name :rp_report_name 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_sets_of_books where set_of_books_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 Von Periode F De la période US From Period ZHS 自期间 4 40 :p_period2 LOV Oracle FA_PERIOD_TO_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 period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_book_type and period_name= :$flex$.fa_period_name_closed) order by period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间 :$FLEX$.Book Book Set of Books Currency :$flex$.fa_book_type Book From Period :$flex$.fa_book_type Book Set of Books Currency :$flex$.fa_book_type Book To Period :$flex$.fa_period_name_closed From Period To Period