ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1CA3869E053B46B63588994 SELECT &ACCT_FLEX_BAL_SEG COMP_CODE, UPS.MEANING ASSET_TYPE, DECODE(AH.ASSET_TYPE, 'CIP', CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT) ASSET_ACCOUNT, &ACCT_FLEX_COST_SEG COST_CENTER, ad.asset_number ASSET, TH.TRANSACTION_HEADER_ID THID, &CAT_FLEX_ALL_SEG CATEGORY, ad.description DESCR, round(sum(books_old.cost * nvl(dh.units_assigned,ah.units)/ ah.units), :PRECISION) OLD_COST, round(sum(books_new.cost * nvl(dh.units_assigned,ah.units)/ ah.units), :PRECISION) NEW_COST, round(sum((books_new.cost - books_old.cost) * nvl(dh.units_assigned,ah.units)/ah.units), :PRECISION) CHANGE, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CTR, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY FROM FA_ASSET_HISTORY AH, FA_ADDITIONS AD, FA_CATEGORIES CAT, FA_CATEGORY_BOOKS CB, &LP_FA_BOOKS BOOKS_OLD, &LP_FA_BOOKS BOOKS_NEW, FA_LOOKUPS UPS, &LP_FA_DEPRN_PERIODS DP, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS DHCC, FA_TRANSACTION_HEADERS TH WHERE DP.BOOK_TYPE_CODE = :P_BOOK AND DP.PERIOD_COUNTER >= :PERIOD1_PC AND DP.PERIOD_COUNTER <= NVL(:PERIOD2_PC, DP.PERIOD_COUNTER) AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE AND NVL(DP.PERIOD_CLOSE_DATE, SYSDATE) AND TH.TRANSACTION_TYPE_CODE IN ('ADJUSTMENT','CIP ADJUSTMENT') AND BOOKS_OLD.TRANSACTION_HEADER_ID_OUT = TH.TRANSACTION_HEADER_ID AND BOOKS_OLD.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE AND BOOKS_NEW.TRANSACTION_HEADER_ID_IN = TH.TRANSACTION_HEADER_ID AND BOOKS_NEW.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE AND AD.ASSET_ID = TH.ASSET_ID AND UPS.LOOKUP_TYPE = 'ASSET TYPE' AND CB.CATEGORY_ID = AH.CATEGORY_ID AND CB.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE AND CAT.CATEGORY_ID = CB.CATEGORY_ID AND AH.ASSET_ID = AD.ASSET_ID AND AH.ASSET_TYPE = UPS.LOOKUP_CODE AND TH.TRANSACTION_HEADER_ID >= AH.TRANSACTION_HEADER_ID_IN AND TH.TRANSACTION_HEADER_ID < NVL(AH.TRANSACTION_HEADER_ID_OUT, TH.TRANSACTION_HEADER_ID + 1) AND th.asset_id = dh.asset_id and :DISTRIBUTION_SOURCE_BOOK = dh.book_type_code and TH.TRANSACTION_HEADER_ID >= DH.TRANSACTION_HEADER_ID_IN AND TH.TRANSACTION_HEADER_ID < NVL(DH.TRANSACTION_HEADER_ID_OUT, TH.TRANSACTION_HEADER_ID + 1) and dh.code_combination_id = dhcc.code_combination_id HAVING round(sum(books_old.cost * nvl(dh.units_assigned,ah.units)/ah.units), :PRECISION) != round(sum(books_new.cost * nvl(dh.units_assigned,ah.units)/ah.units), :PRECISION) GROUP BY UPS.MEANING, &ACCT_FLEX_BAL_SEG, &ACCT_FLEX_COST_SEG, DECODE(AH.ASSET_TYPE, 'CIP', CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT), ad.asset_number, TH.TRANSACTION_HEADER_ID, &CAT_FLEX_ALL_SEG, ad.description, --added fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') --ORDER BY 1,2,3,4,5,6 ORDER BY D_COMP_CODE,ASSET_TYPE,ASSET_ACCOUNT,D_COST_CTR,ASSET,THID,D_CATEGORY, DESCR,OLD_COST,NEW_COST,CHANGE Y OFA FAS840_XML AR FA تقرير تعديلات التكاليف (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير تعديلات التكاليف (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG D FA AHK-Berichtigungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: AHK-Berichtigungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG F FA Etat des ajustements de coûts- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des ajustements de coûts (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG US FA Cost Adjustments - draft Application: Assets Source: Cost Adjustments Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG ZHS FA 成本调整报表- 不支持：已保留供将来使用 Application: 资产 Source: 成本调整报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS840_XML DB package: FA_FAS840_XMLP_PKG BI Publisher &acct_flex_bal_seg &acct_flex_cost_seg &cat_flex_all_seg &lp_fa_books &lp_fa_deprn_periods :accounting_flex_structure :currency_code :distribution_source_book :lp_currency_code :lp_fa_books :lp_fa_deprn_periods :p_book :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :period1_pc :period2_pc :precision :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 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 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 至期间