ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470D451A9E05362FB09050512 SELECT --&ACCT_FLEX_BAL_SEG comp_code, 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_CODE1, --&ACCT_FLEX_COST_SEG cost_ctr, 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_CTR1, nvl(emp.full_name, ' ') name, --&LOC_FLEX_ALL_SEG Location, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, loc.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION1, decode(ah.asset_type,'CIP',cb.cip_cost_acct, cb.asset_cost_acct) account, ad.asset_number || ' - ' || ad.description asset_num, ret.date_retired date_retired, ROUND(decode(ret.units, NULL, (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.cost_retired, ret.cost_retired) * (dh.units_assigned /ah.units)), (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.cost_retired, ret.cost_retired) * -dh.transaction_units / ret.units)) ,:PRECISION) cost, ROUND(decode(ret.units, NULL, (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.nbv_retired, ret.nbv_retired) * (dh.units_assigned /ah.units)), (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.nbv_retired, ret.nbv_retired) * -dh.transaction_units / ret.units)),:PRECISION) nbv, ROUND(decode(ret.units, NULL, (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.proceeds_of_sale, ret.proceeds_of_sale) * (dh.units_assigned /ah.units)), (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.proceeds_of_sale, ret.proceeds_of_sale) * -dh.transaction_units / ret.units)),:PRECISION) proceeds, ROUND(decode(ret.units, NULL, (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.gain_loss_amount, ret.gain_loss_amount) * (dh.units_assigned /ah.units)), (decode(th.transaction_type_code, 'REINSTATEMENT', -ret.gain_loss_amount, ret.gain_loss_amount) * -dh.transaction_units / ret.units)),:PRECISION) gain_loss, decode(th.transaction_type_code, 'REINSTATEMENT', '*', NULL) code /* ,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_location', 'OFA', 'LOC#', 101, NULL, loc.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION*/ FROM fa_additions ad, gl_code_combinations dhcc, fa_asset_history ah, fa_category_books cb, per_all_people_f emp, fa_locations loc, fa_distribution_history dh, fa_retirements ret, fa_transaction_headers th WHERE /* &ACCT_FLEX_COST_SEG between nvl(:P_START_CC,&ACCT_FLEX_COST_SEG) AND nvl(:P_END_CC,&ACCT_FLEX_COST_SEG)*/ 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') between nvl(:P_START_CC,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')) AND nvl(:P_END_CC,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')) AND th.date_effective >= :Period1_POD AND th.date_effective <= :Period1_PCD AND th.book_type_code = :p_Book AND th.transaction_key = 'R' AND th.transaction_header_id = decode(th.transaction_type_code, 'REINSTATEMENT', ret.transaction_header_id_out, ret.transaction_header_id_in) AND ad.asset_id = th.asset_id AND cb.category_id = ah.category_id AND cb.book_type_code = :P_Book AND ah.asset_id = ad.asset_id AND ah.date_effective <= th.date_effective AND nvl(ah.date_ineffective, th.date_effective+1) > th.date_effective AND dh.asset_id = th.asset_id AND dh.book_type_code = :distribution_source_book AND ( dh.retirement_id = ret.retirement_id or (ret.date_effective >= dh.date_effective and ret.date_effective <= nvl(dh.date_ineffective,sysdate) and ret.units is null)) AND ret.book_type_code = :P_Book AND dh.asset_id = ret.asset_id AND dhcc.code_combination_id = dh.code_combination_id AND dh.location_id = loc.location_id AND dh.assigned_to = emp.person_id(+) AND trunc(sysdate) between emp.effective_start_date(+) and emp.effective_end_date(+) ORDER BY /* &ACCT_FLEX_BAL_SEG, &ACCT_FLEX_COST_SEG, emp.full_name, &LOC_FLEX_ALL_SEG, decode(ah.asset_type,'CIP',cb.cip_cost_acct, cb.asset_cost_acct), ad.asset_number*/ 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 OFA FAS441_XML AR FA تقرير استبعادات الأصول حسب مركز التكلفة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير استبعادات الأصول بواسطة مركز التكلفة Application: الأصول Source: تقرير استبعادات الأصول حسب مركز التكلفة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG D FA Anlagenabgänge nach Kostenstelle- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Anlagenabgänge nach Kostenstelle Application: Anlagen Source: Anlagenabgänge nach Kostenstelle (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG E FA Informe Bajas de Activos por Centro de Coste: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de bajas de activos por centro de coste Application: Assets Source: Informe Bajas de Activos por Centro de Coste (XML): No Admitido, Reservado para Uso Futuro Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG F FA Etat des cessions d'immobilisations par centre de coûts- Non pris en charge : réservé pour une utilisation ultérieure Imported from BI Publisher Description: Etat des cessions d'immobilisations par centre de coûts Application: Assets Source: Etat des cessions d'immobilisations par centre de coûts (XML) - Non pris en charge : réservé pour une utilisation ultérieure Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG I FA Rapporto Smobilizzi cespiti per centro di costo- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Smobilizzi cespiti per centro di costo Application: Assets Source: Rapporto Smobilizzi cespiti per centro di costo (XML) - non supportato: riservato per usi futuri Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG JA FA コスト・センター別資産除・売却レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: コスト・センター別資産除・売却レポート Application: Assets Source: コスト・センター別資産除・売却レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG KO FA 비용 부서별 자산 처분 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 비용 부서별 자산 처분 보고서 Application: Assets Source: 비용 부서별 자산 처분 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG PTB FA Relatório de Retiradas do Ativo por Centro de Custos- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório de Baixas de Ativo por Centro de Custo Application: Assets Source: Relatório de Retiradas do Ativo por Centro de Custos (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG RU FA Отчет о списаниях активов по МВЗ- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Отчет о списаниях активов по МВЗ Application: Активы Source: Отчет о списаниях активов по МВЗ (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG S FA Utrangeringar per kostnadsställe - rapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Utrangeringar per kostnadsställe - rapport Application: Assets Source: Utrangeringar per kostnadsställe - rapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG TR FA Maliyet Merkezine Göre Varlık Aktiften Çıkarmaları Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Maliyet Merkezi Bazında Varlık Aktiften Çıkarma Raporu Application: Duran Varlıklar Source: Maliyet Merkezine Göre Varlık Aktiften Çıkarmaları Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG US FA Asset Retirements By Cost Center Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Asset Retirements By Cost Center Report Application: Assets Source: Asset Retirements By Cost Center Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG ZHS FA 按成本中心列出的资产报废报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 按成本中心列出的资产报废报表 Application: 资产 Source: 按成本中心列出的资产报废报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS441_XML DB package: FA_FAS441_XMLP_PKG BI Publisher &acct_flex_bal_seg &acct_flex_cost_seg &loc_flex_all_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :distribution_source_book :p_book :p_conc_request_id :p_end_cc :p_min_precision :p_period1 :p_start_cc :period1_fy :period1_pcd :period1_pod :precision :rp_company_name :rp_report_name 1 -20 :p_not_used_in_report Number select Accounting_Flex_Structure from FA_BOOK_CONTROLS where Book_Type_Code = :$flex$.book AR هيكل محاسبي مرن هيكل محاسبي مرن D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Estructura Contable Tipo de Estructura Contable F Structure clé comptable flexible Structure de clé comptable flexible I Struttura flexfield contabile Struttura del flexfield contabile JA 会計フレックスフィールド体系 会計フレックスフィールド体系 KO 회계 가변 구조 회계 가변 구조 PTB Estrutura de Flexfield Contábil Estrutura de Flexfield Contábil RU Структура ГП плана счетов Структура ГП плана счетов S Kodsträngsstruktur Kodsträngsstruktur TR Hesap Esnek Yapısı Hesap Esnekalanı Yapısı US Acct Flex Structure Accounting Flex Structure ZHS 会计科目弹性域结构 会计弹性结构 2 10 :p_book LOV Oracle FA_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' order by book_type_code Y AR الدفتر رمز نوع الدفتر D AfA-Buch Art AfA-Buch E Libro Código de Tipo de Libro F Livre Code type de livre I Registro Codice del tipo di registro JA 台帳 台帳タイプ・コード KO 장부 장부 유형 코드 PTB Livro Código do Tipo de Livro RU Книга Код типа книги S Bok Boktypskod TR Defter Defter Tipi Kodu US Book Book Type Code ZHS 帐簿 账簿类型代码 3 20 :p_period1 LOV Oracle FA_PERIOD_NAME_CORP Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book) order by period_counter Y AR الفترة اسم الفترة D Periode Periodenbezeichnung E Período Nombre del Período F Période Nom de la période I Periodo Nome del periodo JA 期間 期間名 KO 기간 기간명 PTB Período Nome do Período RU Период Имя периода S Period Periodnamn TR Dönem Dönem Adı US Period Period Name ZHS 期间 期间名称 4 30 :p_start_cc Char AR من مركز التكلفة مركز تكلفة البداية D Von Kostenstelle Von Kostenstelle E De Centro de Coste Centro de Coste Inicial F Du centre de coûts Centre de coûts de départ I Centro di costo - Da Centro di costo iniziale JA コスト・センター:自 コスト・センター:自 KO 비용 부서: 부터 시작 비용 부서 PTB Do Centro de Custo Centro de Custo Inicial RU Начальное МВЗ Начальное место возникновения затрат S Från kostnadsställe Första kostnadsställe TR İlk Maliyet Merkezi Başlangıç Maliyeti Merkezi US From Cost Center Start Cost Center ZHS 自成本中心 起始成本中心 5 40 :p_end_cc Char AR إلى مركز تكلفة مركز تكلفة النهاية D Bis Kostenstelle Bis Kostenstelle E A Centro de Coste Centro de Coste Final F Au centre de coûts Centre de coûts de fin I Centro di costo - A Centro di costo finale JA コスト・センター:至 コスト・センター:至 KO 비용 부서: 까지 종료 비용 부서 PTB Centro de Custo - Até Centro de Custo Final RU Конечное МВЗ Конечное место возникновения затрат S Till kostnadsställe Sista kostnadsställe TR Son Maliyet Merkezi Bitiş Maliyet Merkezi US To Cost Center End Cost Center ZHS 至成本中心 终止成本中心 :$flex$.book Book Acct Flex Structure :$flex$.fa_corp_book Book Period