ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1A43869E053B46B63588994 SELECT UPS.MEANING ASSET_TYPE, --&ACCT_FLEX_BAL_SEG COMP_CODE, decode(AH.ASSET_TYPE, 'CIP', CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT) GL_ACCOUNT, decode(AH.ASSET_TYPE, 'CIP', NULL, 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, MD.RATE_SOURCE_RULE RATE_SOURCE_RULE, BOOKS.LIFE_IN_MONTHS LIFE, BOOKS.ADJUSTED_RATE ADJ_RATE, DS.BONUS_RATE BONUS_RATE, BOOKS.PRODUCTION_CAPACITY PROD, BOOKS.cost COST, sum(nvl(DD.YTD_DEPRN,0)) YTD_DEPRN, sum(nvl(DD.DEPRN_RESERVE,0)) DEPRN_RESERVE, THADD.TRANSACTION_HEADER_ID TH_ID, --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_FAS423_XMLP_PKG.d_lifeformula(BOOKS.LIFE_IN_MONTHS, BOOKS.ADJUSTED_RATE, DS.BONUS_RATE, BOOKS.PRODUCTION_CAPACITY) D_LIFE FROM FA_METHODS MD, FA_DEPRN_DETAIL DD, FA_LOOKUPS UPS, FA_DEPRN_PERIODS DP, FA_TRANSACTION_HEADERS THADD, FA_TRANSACTION_HEADERS THDIS, FA_BOOKS BOOKS, FA_ADDITIONS AD, FA_ASSET_HISTORY AH, FA_CATEGORY_BOOKS CB, GL_CODE_COMBINATIONS DHCC, FA_DISTRIBUTION_HISTORY DH, FA_DEPRN_SUMMARY DS 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 = :DISTRIBUTION_SOURCE_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 MD.METHOD_CODE = BOOKS.DEPRN_METHOD_CODE AND nvl(MD.LIFE_IN_MONTHS,-1) = nvl(BOOKS.LIFE_IN_MONTHS,-1) AND DS.BOOK_TYPE_CODE = :P_BOOK AND DS.ASSET_ID = BOOKS.ASSET_ID AND DS.DEPRN_RESERVE != 0 AND DS.DEPRN_SOURCE_CODE = 'BOOKS' AND DD.BOOK_TYPE_CODE = :P_BOOK AND DD.ASSET_ID = THADD.ASSET_ID AND DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND DD.DEPRN_SOURCE_CODE = 'B' AND DH.DATE_EFFECTIVE <= nvl(DP.PERIOD_CLOSE_DATE, sysdate) AND nvl(DH.DATE_INEFFECTIVE, sysdate) >= nvl(DP.PERIOD_CLOSE_DATE, sysdate) AND DH.BOOK_TYPE_CODE = :DISTRIBUTION_SOURCE_BOOK AND DH.ASSET_ID = THDIS.ASSET_ID AND DHCC.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 AH.ASSET_TYPE = UPS.LOOKUP_CODE AND UPS.LOOKUP_TYPE = 'ASSET TYPE' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND CB.BOOK_TYPE_CODE = BOOKS.BOOK_TYPE_CODE GROUP BY UPS.MEANING, -- &ACCT_FLEX_BAL_SEG, decode(AH.ASSET_TYPE, 'CIP', CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT), decode(AH.ASSET_TYPE, 'CIP', NULL, CB.DEPRN_RESERVE_ACCT), AD.ASSET_NUMBER, AD.DESCRIPTION, BOOKS.DATE_PLACED_IN_SERVICE, MD.RATE_SOURCE_RULE, BOOKS.DEPRN_METHOD_CODE, BOOKS.ADJUSTED_RATE, DS.BONUS_RATE, BOOKS.PRODUCTION_CAPACITY, BOOKS.LIFE_IN_MONTHS, THADD.TRANSACTION_HEADER_ID, BOOKS.COST --Added during DT Fix ,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') --End of DT Fix /*ORDER BY 2, 1, 3, AD.ASSET_NUMBER*/ ORDER BY 15, 1, 2, 3, 4, 5, 6, 8, 14, 12, 13, 9, 10, 11, 12, 7 Y OFA FAS423_XML AR FA تقرير أصول التحويلات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير أصول التحويلات (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS423_XML DB package: FA_FAS423_XMLP_PKG D FA Abstimmliste Übernahme- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Abstimmliste Übernahme (XML)- Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS423_XML DB package: FA_FAS423_XMLP_PKG F FA Etat des reprises d'immobilisations- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des reprises d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS423_XML DB package: FA_FAS423_XMLP_PKG US FA Conversion Assets - draft Application: Assets Source: Conversion Assets Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS423_XML DB package: FA_FAS423_XMLP_PKG ZHS FA 转换资产报表- 不支持：已保留供将来使用 Application: 资产 Source: 转换资产报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS423_XML DB package: FA_FAS423_XMLP_PKG BI Publisher &acct_flex_bal_seg :accounting_flex_structure :acct_bal_aprompt :acct_cc_aprompt :book_class :cat_maj_aprompt :currency_code :distribution_source_book :p_book :p_conc_request_id :p_min_precision :p_period1 :p_period2 :period1_fy :period1_pc :period1_pcd :period1_pod :period2_fy :period2_pc :period2_pcd :period2_pod :rp_company_name :rp_period_range :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_period1 LOV Oracle FA_PERIOD_NAME 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 自期间 3 30 :p_period2 LOV Oracle FA_PERIOD_TO 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) order by period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间