ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1B73869E053B46B63588994 SELECT --null COMP_CODE, &ACCT_FLEX_BAL_SEG COMP_CODE, FY.FISCAL_YEAR FISCAL_YEAR, CB.ASSET_COST_ACCT GL_ACCOUNT, CB.DEPRN_RESERVE_ACCT RES_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.PRODUCTION_CAPACITY PROD, BOOKS.ADJUSTED_RATE ADJ_RATE, DS.BONUS_RATE BONUS_RATE, SUM(NVL(BOOKS.COST,0)) COST, sum(nvl(DD.DEPRN_RESERVE,0)) DEPRN_RESERVE, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', COMCC.CHART_OF_ACCOUNTS_ID, NULL, COMCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE, FA_FAS540_XMLP_PKG.d_lifeformula(BOOKS.LIFE_IN_MONTHS, BOOKS.ADJUSTED_RATE , DS.BONUS_RATE , BOOKS.PRODUCTION_CAPACITY) D_LIFE FROM FA_DEPRN_DETAIL DD, FA_ADDITIONS AD, FA_BOOKS BOOKS, FA_ASSET_HISTORY AH, FA_DISTRIBUTION_HISTORY DH, FA_DEPRN_PERIODS DP, FA_CATEGORY_BOOKS CB, FA_FISCAL_YEAR FY, FA_DEPRN_SUMMARY DS, GL_CODE_COMBINATIONS COMCC, FA_TRANSACTION_HEADERS THDIS, FA_TRANSACTION_HEADERS THADD WHERE DP.BOOK_TYPE_CODE =:P_BOOK AND DP.PERIOD_COUNTER >= :PERIOD1_PC AND DP.PERIOD_COUNTER <= nvl(:PERIOD2_PC, DP.PERIOD_COUNTER)AND THADD.DATE_EFFECTIVE >= DP.PERIOD_OPEN_DATE AND THADD.DATE_EFFECTIVE < nvl(DP.PERIOD_CLOSE_DATE, sysdate) AND THADD.BOOK_TYPE_CODE =:P_BOOK AND THADD.TRANSACTION_TYPE_CODE = 'ADDITION' AND THDIS.BOOK_TYPE_CODE =:DIST_BOOK AND THDIS.TRANSACTION_TYPE_CODE = 'TRANSFER IN' AND THDIS.ASSET_ID = THADD.ASSET_ID AND BOOKS.TRANSACTION_HEADER_ID_IN = THADD.TRANSACTION_HEADER_ID AND BOOKS.BOOK_TYPE_CODE = :P_BOOK AND BOOKS.ASSET_ID = THADD.ASSET_ID AND DS.BOOK_TYPE_CODE = :P_BOOK AND DS.ASSET_ID = BOOKS.ASSET_ID AND DS.DEPRN_SOURCE_CODE = 'BOOKS' AND DD.BOOK_TYPE_CODE = :P_BOOK AND DD.ASSET_ID = THADD.ASSET_ID AND DD.DEPRN_SOURCE_CODE = 'B' AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND COMCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID AND AD.ASSET_ID = THADD.ASSET_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.DATE_EFFECTIVE <= THADD.DATE_EFFECTIVE AND nvl(AH.DATE_INEFFECTIVE,sysdate)> THADD.DATE_EFFECTIVE AND CB.CATEGORY_ID = AH.CATEGORY_ID AND CB.BOOK_TYPE_CODE = :P_BOOK AND FY.FISCAL_YEAR_NAME =:FISCAL_YEAR_NAME AND FY.START_DATE <= BOOKS.DATE_PLACED_IN_SERVICE AND FY.END_DATE >= BOOKS.DATE_PLACED_IN_SERVICE GROUP BY &ACCT_FLEX_BAL_SEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', COMCC.CHART_OF_ACCOUNTS_ID, NULL, COMCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), FY.FISCAL_YEAR, CB.ASSET_COST_ACCT, CB.DEPRN_RESERVE_ACCT, AD.ASSET_NUMBER, AD.DESCRIPTION, BOOKS.DATE_PLACED_IN_SERVICE, BOOKS.DEPRN_METHOD_CODE, BOOKS.LIFE_IN_MONTHS, BOOKS.PRODUCTION_CAPACITY, BOOKS.ADJUSTED_RATE, DS.BONUS_RATE --ORDER BY 1, 2, 3, 4, 5 order by COMP_CODE,FISCAL_YEAR,GL_ACCOUNT,RES_ACCOUNT,ASSET_NUMBER,START_DATE,METHOD,LIFE,COST, DEPRN_RESERVE,ADJ_RATE,PROD,BONUS_RATE OFA FAS540_XML AR FA تقرير إضافات الضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير إضافات الضرائب (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS540_XML DB package: FA_FAS540_XMLP_PKG D FA Steuerliche Zugänge- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Steuerliche Zugänge (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS540_XML DB package: FA_FAS540_XMLP_PKG F FA Etat des acquisitions par livre de gestion- Non pris en charge : réservé pour une utilisation ultérieure Application: Assets Source: Etat des acquisitions par livre de gestion (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: FAS540_XML DB package: FA_FAS540_XMLP_PKG US FA Tax Additions - draft Application: Assets Source: Tax Additions Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS540_XML DB package: FA_FAS540_XMLP_PKG ZHS FA 税务增加报表- 不支持：已保留供将来使用 Application: 资产 Source: 税务增加报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS540_XML DB package: FA_FAS540_XMLP_PKG BI Publisher &acct_flex_bal_seg :accounting_flex_structure :currency_code :dist_book :fiscal_year_name :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :period1_pc :period2_pc :rp_bal_lprompt :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_TAX_BOOKS Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='TAX' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿 2 20 :p_period1 LOV Oracle FA_PERIOD_NAME_TAX Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_tax_books and period_counter> (select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_tax_books) order by period_counter Y AR من الفترة D Von Periode F De la période US From Period ZHS 自期间 3 30 :p_period2 LOV Oracle FA_PERIOD_TAX_TO Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_tax_books and period_counter>=(select period_counter from fa_deprn_periods where book_type_code= :$flex$.fa_tax_books and period_name= :$flex$.fa_period_name_tax) order by period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间 :$flex$.fa_period_name_tax From Period To Period :$flex$.fa_tax_books Book From Period :$flex$.fa_tax_books Book To Period