ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470D551A9E05362FB09050512 SELECT null LOCATION, null COMPANY, cb.asset_cost_acct account, to_char(bk.date_placed_in_service, 'YYYY') year, ad.asset_number asset, ad.description descr, lpad(to_char(sum(di.units_assigned)),6) units, bk.date_placed_in_service date_installed, round(sum(bk.cost * (di.units_assigned/ah.units)),:precision) orig_cost, fnd_flex_xml_publisher_apis.process_kff_combination_1('company_dsp', 'SQLGL', 'GL#', COMCC.CHART_OF_ACCOUNTS_ID, NULL, COMCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') COMPANY_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LO.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION FROM fa_system_controls sc, fa_locations lo, fa_books bk, fa_asset_history ah, fa_additions ad, fa_distribution_history di, gl_Code_combinations comcc, fa_category_books cb, fa_book_controls bc WHERE &LOC_FLEX_WHERE AND :P_END_DATE_ACQ between bk.date_effective and nvl(bk.date_ineffective,sysdate) AND bk.book_type_code = :P_BOOK AND bk.asset_id = ad.asset_id and nvl(bk.period_counter_fully_retired,:P_Per_Ctr+1) >= :P_Per_Ctr and AD.OWNED_LEASED = 'OWNED' AND :P_END_DATE_ACQ between ah.date_effective and nvl(ah.date_ineffective,sysdate) AND ah.asset_id = ad.asset_id AND ah.category_id = cb.category_id AND cb.book_type_code= bk.book_type_code AND bc.book_type_code = bk.book_type_code and di.book_type_code = bc.distribution_source_book AND di.location_id = lo.location_id AND di.asset_id = bk.asset_id AND di.code_combination_id= comcc.code_combination_id AND di.transaction_header_id_in <= (select max(th.transaction_header_id) from fa_transaction_headers th where th.asset_id = di.asset_id AND th.book_type_code = di.book_type_code AND th.date_effective <= :P_END_DATE_ACQ) AND (di.transaction_header_id_out >= (select min(th.transaction_header_id) from fa_transaction_headers th where th.asset_id = di.asset_id AND th.book_type_code = di.book_type_code AND th.date_effective > :P_END_DATE_ACQ) OR di.transaction_header_id_out is null) GROUP BY bk.book_type_code, &ACCT_FLEX_BAL_SEG, &LOC_FLEX_ALL_SEG, to_char(bk.date_placed_in_service, 'YYYY'), cb.asset_cost_acct, ad.asset_number, ad.description, bk.date_placed_in_service, --ADDED fnd_flex_xml_publisher_apis.process_kff_combination_1('company_dsp', 'SQLGL', 'GL#', COMCC.CHART_OF_ACCOUNTS_ID, NULL, COMCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LO.LOCATION_ID, 'ALL', 'Y', 'VALUE') ORDER BY --ADDED COMPANY,D_LOCATION,ACCOUNT,YEAR,ASSET,descr,UNITS,DATE_INSTALLED,ORIG_COST /* &ACCT_FLEX_BAL_SEG, &LOC_FLEX_ALL_SEG, cb.asset_cost_acct, to_char(bk.date_placed_in_service, 'YYYY'), asset_number */ Y OFA FAS460_XML AR FA تقرير ضريبة الملكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير ضريبة الملكية Application: الأصول Source: تقرير ضريبة الملكية (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG D FA Vermögensteuer- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Vermögensteuer Application: Anlagen Source: Vermögensteuer (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG E FA Informe Impuesto sobre el Patrimonio: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de impuesto sobre el patrimonio Application: Assets Source: Informe Impuesto sobre el Patrimonio (XML): No Admitido, Reservado para Uso Futuro Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG F FA Property Tax Report (USA)- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Property Tax Report (USA) Application: Assets Source: Property Tax Report (USA) (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG I FA Rapporto Imposta su proprietà- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Imposta sulla proprietà Application: Assets Source: Rapporto Imposta su proprietà (XML) - non supportato: riservato per usi futuri Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG JA FA 資産税レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 資産税レポート Application: Assets Source: 資産税レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG KO FA 재산세 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 재산세 보고서 Application: Assets Source: 재산세 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG PTB FA Relatório de Imposto sobre Propriedade- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Imposto sobre Propriedade Application: Assets Source: Relatório de Imposto sobre Propriedade (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG RU FA Отчет о налоге на имущество- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о налоге на имущество Application: Активы Source: Отчет о налоге на имущество (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG S FA Fastighetsskatt - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Fastighetsskatt - rapport Application: Assets Source: Fastighetsskatt - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG TR FA Mülk Vergisi Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Varlık Vergisi Raporu Application: Duran Varlıklar Source: Mülk Vergisi Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG US FA Property Tax Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Property Tax Report Application: Assets Source: Property Tax Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG ZHS FA 财产税报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 财产税报表 Application: 资产 Source: 财产税报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS460_XML DB package: FA_FAS460_XMLP_PKG BI Publisher &acct_flex_bal_seg &loc_flex_all_seg &loc_flex_where :accounting_flex_structure :currency_code :p_book :p_conc_request_id :p_end_date_acq :p_per_ctr :p_state :precision :rp_bal_lprompt :rp_company_name :rp_report_name 1 -20 :p_not_used_in_report Number SELECT LOCATION_FLEX_STRUCTURE FROM FA_SYSTEM_CONTROLS AR هيكل موقع مرن الحصول علي معرف الهيكل D Standort-FlexFeld-Struktur Ruft die Strukturkennung ab E Tipo de Estructura de Ubicación Obtiene el id estructura F Structure de la clé flexible Site Extrait l'ID structure I Struttura del flexfield ubicazione Visualizza l'ID della struttura JA 事業所フレックスフィールド体系 体系IDの取得 KO 위치 가변 구조 구조 id 가져오기 PTB Estrutura do Flexfield de Local Obtém o id da estrutura RU Структура ГП расположения Получение идентификатора структуры S Platsflexstruktur Hämtar struktur-id TR Yerleşim Esnek Yapısı Yapı no'yu alır US Location Flex Structure Gets the structure id ZHS 地点弹性结构 获得结构标识 2 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 Art AfA-Buch E Libro Tipo de Libro F Livre Type de livre I Registro Tipo di registro JA 台帳 台帳タイプ KO 장부 장부 유형 PTB Livro Tipo de Livro RU Книга Тип книги S Bok Boktyp TR Defter Defter Tipi US Book Book Type ZHS 帐簿 账簿类型 3 20 :p_state Char AR الولاية الموقع D Bundesland Standort E Provincia Ubicación F Département Lieu I Stato Ubicazione JA 市区町村区分 事業所 KO 도 위치 PTB Estado Local RU Республика Расположение S Delstat Adress TR Eyalet Yerleşim US State Location ZHS 省（州） 地点 4 30 :p_end_date_acq Date Y AR تاريخ النهاية المكتسب تاريخ النهاية المكتسب D Bis Erwerbsdatum Bis Erwerbsdatum E Fecha de Finalización de Adquisición Fecha de Finalización de Adquisición F Date fin acquisition Date fin acquisition I Data fine acquisita Data fine acquisita JA 取得日:至 取得日:至 KO 취득종료일자 취득종료일자 PTB Aquisição - Data Final Aquisição - Data Final RU Конечная дата приобретения Конечная дата приобретения S Sista förvärvsdatum Sista förvärvsdatum TR Kayda Geçirme Bitiş Tarihi Kayda Geçirme Bitiş Tarihi US End Date Acquired End Date Acquired ZHS 已获得终止日期 已获得终止日期