ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470E351A9E05362FB09050512 SELECT bks.book_type_code, null acct_flex, &c_cat_flex_seg cat_flex, &c_loc_flex_seg locn_flex, FMP.calculation_method, PVO.vendor_name insurance_company, FAD.asset_number, FAD.description, FIP.policy_number, BKS.life_in_months asset_life, to_char(BKS.date_placed_in_service,'DD-MON-YYYY') date_placed_in_service, bks.cost, round(nvl(FIP.base_insurance_value,0) * (fdh.units_assigned/fad.current_units),2) base_insurance_value, round(nvl(FIP.current_insurance_value,0) * (fdh.units_assigned/fad.current_units),2) insurance_Value, round(FIP.insured_amount * (fdh.units_assigned/fad.current_units),2) insured_amount, --NULL last_indexation_date, to_char(FIV.indexation_date,'DD-MON-RRRR'), round((nvl(FIP.insured_amount,0) * (fdh.units_assigned/fad.current_units)) - (nvl(FIP.current_insurance_value,0) * (fdh.units_assigned/fad.current_units)),2) insurance_coverage, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_bal_desc', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') CF_BAL_DESC, FA_FASINSVR_XMLP_PKG.cf_no_data_foundformula() CF_NO_DATA_FOUND FROM FA_BOOKS BKS, FA_DISTRIBUTION_HISTORY FDH, FA_ADDITIONS FAD, PO_VENDORS PVO, GL_CODE_COMBINATIONS GCC, FA_CATEGORIES CAT, FA_LOCATIONS LOC, FA_INS_VALUES FIV, FA_INS_VALUES FIV2, FA_INS_MST_POLS FMP, FA_INS_POLICIES FIP WHERE gcc.code_combination_id = fdh.code_combination_id and fdh.asset_id = fad.asset_id and fdh.date_ineffective is null and fad.asset_category_id = cat.category_id and loc.location_id = fdh.location_id and fad.asset_id = bks.asset_id and bks.asset_id = fip.asset_id and bks.period_counter_fully_retired is null and bks.date_effective <= :TO_CLOSE_DATE and nvl(bks.date_ineffective ,:TO_CLOSE_DATE + 1) >= :FROM_OPEN_DATE and bks.transaction_header_id_in = (select max(bks1.transaction_header_id_in ) from fa_books bks1 where bks1.period_counter_fully_retired is null and bks1.asset_id = fip.asset_id and bks1.date_effective<= :TO_CLOSE_DATE and nvl(bks1.date_ineffective ,:TO_CLOSE_DATE + 1) >= :FROM_OPEN_DATE and bks1.book_type_code = :P_ASSET_BOOK) and bks.book_type_code = fip.book_type_code and bks.book_type_code = :P_ASSET_BOOK and fiv.asset_policy_id = fip.asset_policy_id and fiv.asset_id = fip.asset_id and fiv2.asset_policy_id = fip.asset_policy_id and fiv2.asset_id = fip.asset_id and fiv2.indexation_date = (select max(fiv3.indexation_date) from fa_ins_values fiv3 where fiv3.asset_policy_id = fiv2.asset_policy_id and fiv3.asset_id = fiv2.asset_id) and fiv.indexation_date = (select max(fiv3.indexation_date) from fa_ins_values fiv3 where fiv3.asset_policy_id = fiv.asset_policy_id and fiv3.asset_id = fiv.asset_id and fiv3.indexation_year <= :P_YEAR ) and fip.asset_policy_id = fmp.asset_policy_id &c_where_old_ins_data and &c_acct_flex_bal_where and &c_where_cat_flex and &c_where_locn_flex &c_where_asset_number &c_where_ins_company &c_where_cal_method AND pvo.vendor_id = fmp.vendor_id UNION SELECT bks.book_type_code, &c_acct_flex_bal_seg acct_flex, &c_cat_flex_seg cat_flex, &c_loc_flex_seg locn_flex, FMP.calculation_method, PVO.vendor_name insurance_company, FAD.asset_number, FAD.description, FIP.policy_number, BKS.life_in_months asset_life, to_char(BKS.date_placed_in_service,'DD-MON-YYYY') date_placed_in_service, bks.cost, round(nvl(FIP.base_insurance_value,0) * (fdh.units_assigned/fad.current_units),2) base_insurance_value, round(nvl(FIP.current_insurance_value,0) * (fdh.units_assigned/fad.current_units),2) insurance_Value, round(FIP.insured_amount * (fdh.units_assigned/fad.current_units),2) insured_amount, NULL last_indexation_date, round((nvl(FIP.insured_amount,0) * (fdh.units_assigned/fad.current_units)) - (nvl(FIP.current_insurance_value,0) * (fdh.units_assigned/fad.current_units)),2) insurance_coverage, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_bal_desc', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'DESCRIPTION') CF_BAL_DESC, FA_FASINSVR_XMLP_PKG.cf_no_data_foundformula() CF_NO_DATA_FOUND FROM FA_BOOKS BKS, FA_DISTRIBUTION_HISTORY FDH, FA_ADDITIONS FAD, PO_VENDORS PVO, GL_CODE_COMBINATIONS GCC, FA_CATEGORIES CAT, FA_LOCATIONS LOC, FA_INS_MST_POLS FMP, FA_INS_POLICIES FIP WHERE gcc.code_combination_id = fdh.code_combination_id and fdh.asset_id = fad.asset_id and fdh.date_ineffective is null and bks.book_type_code = :P_ASSET_BOOK and fad.asset_category_id = cat.category_id and loc.location_id = fdh.location_id and fad.asset_id = bks.asset_id and bks.asset_id = fip.asset_id and bks.period_counter_fully_retired is null and bks.date_placed_in_service < :CALENDAR_OPEN_DATE and bks.date_effective <= :TO_CLOSE_DATE and nvl(bks.date_ineffective ,:TO_CLOSE_DATE + 1) >= :FROM_OPEN_DATE and bks.transaction_header_id_in = ( select max(bks1.transaction_header_id_in ) from fa_books bks1 where bks1.asset_id = fip.asset_id and bks1.period_counter_fully_retired is null and bks1.date_placed_in_service < :CALENDAR_OPEN_DATE and bks1.date_effective <= :TO_CLOSE_DATE and nvl(bks1.date_ineffective ,:TO_CLOSE_DATE + 1) >= :FROM_OPEN_DATE and bks1.book_type_code = :P_ASSET_BOOK) and bks.book_type_code = fip.book_type_code and fip.asset_policy_id = fmp.asset_policy_id and fip.last_indexation_date is null and &c_acct_flex_bal_where and &c_where_cat_flex and &c_where_locn_flex &c_where_asset_number &c_where_ins_company &c_where_cal_method AND pvo.vendor_id = fmp.vendor_id and bks.book_type_code=:Asset_book Y OFA FASINSVR_XML AR FA تقرير تفاصيل قيم التأمين (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: تقرير تفاصيل قيم التأمين Application: الأصول Source: تقرير تفاصيل قيم التأمين (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG D FA Anlagen - Versicherungswerte- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Anlagen - Versicherungswerte Application: Anlagen Source: Anlagen - Versicherungswerte (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG E FA Informe Detalle de Valores de Seguros: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Informe de detalle de valores del seguro Application: Assets Source: Informe Detalle de Valores de Seguros (XML): No Admitido, Reservado para Uso Futuro Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG F FA Etat détaillé des valeurs d'assurance- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Etat détaillé des valeurs d'assurance des immobilisations Application: Assets Source: Etat détaillé des valeurs d'assurance (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG I FA Rapporto Dettagli valori assicurazione- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Dettagli valori assicurazione Application: Assets Source: Rapporto Dettagli valori assicurazione (XML) - non supportato: riservato per usi futuri Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG JA FA 保険価額詳細レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 保険価額詳細レポート Application: Assets Source: 保険価額詳細レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG KO FA 보험 가액 상세 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 보험 가액 상세내역 보고서 Application: Assets Source: 보험 가액 상세 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG PTB FA Relatório Detalhado dos Valores do Seguro- Não Suportado: Reservado Para Uso Futuro Imported from BI Publisher Description: Relatório Detalhado de Valores do Seguro Application: Assets Source: Relatório Detalhado dos Valores do Seguro (XML) - Não Suportado: Reservado Para Uso Futuro Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG RU FA Подробный отчет о стоимости страхования- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Подробный отчет о стоимости страхования Application: Активы Source: Подробный отчет о стоимости страхования (XML) - не поддерживается: зарезервировано для будущего использования Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG S FA Försäkringsvärden - detaljrapport- Stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Försäkringsvärden - detaljrapport Application: Assets Source: Försäkringsvärden - detaljrapport (XML) - Stöds inte: Reserverad för framtida bruk Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG TR FA Sigorta Değerleri Detay Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: Sigorta Değerleri Detay Raporu Application: Duran Varlıklar Source: Sigorta Değerleri Detay Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG US FA Insurance Values Detail Report- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Insurance Values Detail Report Application: Assets Source: Insurance Values Detail Report (XML) - Not Supported: Reserved For Future Use Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG ZHS FA 保险值明细报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 保险价值详细资料报表 Application: 资产 Source: 保险值明细报表 (XML) - 不支持：已保留供将来使用 Short Name: FASINSVR_XML DB package: FA_FASINSVR_XMLP_PKG BI Publisher &c_acct_flex_bal_seg &c_acct_flex_bal_where &c_cat_flex_seg &c_loc_flex_seg &c_where_asset_number &c_where_cal_method &c_where_cat_flex &c_where_ins_company &c_where_locn_flex &c_where_old_ins_data :asset_book :c_acct_flex_bal_seg :c_acct_flex_bal_where :c_acct_flex_struct :c_book_class :c_book_type_code :c_cat_flex_seg :c_cat_flex_struct :c_currency_code :c_current_fiscal_year :c_distribution_source_book :c_loc_flex_seg :c_locn_flex_struct :c_no_data_found :c_precision :c_set_of_books_id :c_sob_name :c_todays_date :c_where_asset_number :c_where_cal_method :c_where_cat_flex :c_where_ins_company :c_where_locn_flex :c_where_old_ins_data :calendar_open_date :cp_insurance_from :cp_insurance_to :from_open_date :l_count :p_asset_book :p_asset_number_from :p_asset_number_to :p_cal_method_from :p_cal_method_to :p_category_flex_from :p_category_flex_to :p_company_from :p_company_to :p_conc_request_id :p_insurance_company_from :p_insurance_company_to :p_location_flex_from :p_location_flex_to :p_report_type :p_year :to_close_date 1 -20 :p_sob_id Number SELECT ACCOUNTING_FLEX_STRUCTURE FROM FA_BOOK_CONTROLS WHERE BOOK_TYPE_CODE= :$flex$.asset_book Y AR هيكل مرن للحساب هيكل مرن للحساب D Konto-FlexFeld-Struktur Konto-FlexFeld-Struktur E Tipo de Estructura Contable Tipo de Estructura Contable F Structure de clé comptable flexible Structure de clé comptable flexible I Struttura flexfield contabile Struttura flexfield contabile JA 会計フレックス体系 会計フレックス体系 KO 계정 가변 구조 계정 가변 구조 PTB Estrutura Flex de Conta Estrutura Flex de Conta RU Структура ГП плана счетов Структура ГП плана счетов S Kodsträngsstruktur Kodsträngsstruktur TR Hesap Esnek Yapısı Hesap Esnek Yapısı US Account Flex Structure Account Flex Structure ZHS 帐户弹性结构 帐户弹性结构 2 10 :p_asset_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 AfA-Buch E Libro de Activos Libro de Activos F Livre d'amortissement Livre d'amortissement I Registro cespiti Registro cespiti JA 資産台帳 資産台帳 KO 자산 장부 자산 장부 PTB Livro de Ativo Livro de Ativo RU Книга активов Книга активов S Anläggningsbok Anläggningsbok TR Varlık Defteri Varlık Defteri US Asset Book Asset Book ZHS 资产帐簿 资产帐簿 3 20 :p_company_from Char Y AR من شركة بداية مدى الشركة D Von Firma Von Firma E De Compañía De Compañía F Société de départ Début fourchette sociétés I Società - Da Valore iniziale intervallo società JA 会社:自 会社範囲:自 KO 회사: 부터 회사 범위 시작 PTB Empresa - De Início da Faixa de Empresas RU Компания с Начало диапазона компаний S Från företag Start på bolagsintervall TR İlk Şirket Şirket Aralığı Başlangıcı US From Company Start Of Company Range ZHS 起始公司 起始公司范围 4 30 :p_company_to Char AR إلى شركة نهاية مدى الشركة D Bis Firma Bis Firma E A Compañía A Compañía F Société d'arrivée Fin fourchette sociétés I Società - A Valore finale intervallo società JA 会社:至 会社範囲:至 KO 회사: 까지 회사 범위 종료 PTB Empresa - Até Final da Faixa de Empresas RU Компания по Конец диапазона компаний S Till företag Slut på bolagsintervall TR Son Şirket Şirket Aralığı Sonu US To Company End Of Company Range ZHS 终止公司 终止公司范围 5 40 :p_cal_method_from LOV Oracle FA_INS_CAL_MTHDS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FA_CAL_METHODS' order by lookup_code AR من طريقة العملية الحسابية بداية مدى الطريقة D Von Berechnungsverfahren Von Berechnungsverfahren E De Método de Cálculo De Método F De la méthode de calcul Début fourchette méthodes I Metodo di calcolo - Da Inizio dell'intervallo del metodo JA 計算方法:自 方法範囲:自 KO 계산 방법: 부터 방법 범위 시작 PTB Método de Cálculo - De Início da Faixa de Métodos RU Метод расчета с Начало диапазона методов S Från beräkningsmetod Start på metodintervall TR İlk Hesaplama Yöntemi Yöntem Aralığı Başlangıcı US From Calculation Method Start of Method Range ZHS 起始计算方法 方法范围起始值 6 50 :p_cal_method_to LOV Oracle FA_INS_CAL_MTHDS Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='FA_CAL_METHODS' order by lookup_code AR إلى طريقة العملية الحسابية نهاية مدى الطريقة D Bis Berechnungsverfahren Bis Berechnungsverfahren E A Método de Cálculo A Método F A la méthode de calcul Fin fourchette méthodes I Metodo di calcolo - A Valore finale intervallo metodi JA 計算方法:至 方法範囲:至 KO 계산 방법: 까지 방법 범위의 종료 PTB Método de Cálculo - Até Final da Faixa de Métodos RU Метод расчета по Конец диапазона методов S Till beräkningsmetod Slut på metodintervall TR Son Hesaplama Yöntemi Yöntem Aralığı Sonu US To Calculation Method End of Method Range ZHS 终止计算方法 终止方法范围 7 60 :p_insurance_company_from LOV Oracle FA_INS_VENDOR Y select vendor_id id, vendor_name value, null description from po_vendors where upper(vendor_type_lookup_code)='INSURANCE' order by value,description AR من شركة التأمين بداية مدى شركة التأمين D Von Versicherungsgesellschaft Von Versicherungsgesellschaft E De Compañía Aseguradora De Compañía Aseguradoras F De la compagnie d'assurance Début de la fourchette de compagnies d'assurance I Società assicurativa - Da Inizio dell'intervallo della società assicurativa JA 保険会社:自 保険会社範囲:自 KO 보험 회사: 부터 보험 회사 범위 시작 PTB Seguradora - De Início da Faixa de Seguradoras RU Страховая компания с Начало диапазона страховых компаний S Från försäkringsbolag Start på försäkringsbolagsintervall TR İlk Sigorta Şirketi Sigorta Şirketi Aralığı Başlangıcı US From Insurance Company Start of Insurance Company Range ZHS 起始保险公司 保险公司范围起始值 8 70 :p_insurance_company_to LOV Oracle FA_INS_VENDOR Y select vendor_id id, vendor_name value, null description from po_vendors where upper(vendor_type_lookup_code)='INSURANCE' order by value,description AR إلى شركة التأمين نهاية مدى شركة التأمين D Bis Versicherungsgesellschaft Bis Versicherungsgesellschaft E A Compañía Aseguradora A Compañía Aseguradora F A la compagnie d'assurance Fin de la fourchette de compagnies d'assurance I Società assicurativa - A Fine dell'intervallo della società assicurativa JA 保険会社:至 保険会社範囲:至 KO 보험 회사: 까지 보험 회사 범위 종료 PTB Seguradora - Até Final da Faixa de Seguradoras RU Страховая компания по Конец диапазона страховых компаний S Till försäkringsbolag Slut på försäkringsbolagsintervall TR Son Sigorta Şirketi Sigorta Şirketi Aralığı Sonu US To Insurance Company End of Insurance Company Range ZHS 终止保险公司 保险公司范围终止值 9 80 :p_year LOV Oracle FA_INS_INDEXATION_YEARS Y select fiscal_year id, fiscal_year value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter in (select max(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book and period_close_date is not null group by dp2.fiscal_year) and period_close_date is not null order by period_counter Y AR السنة السنة المالية D Jahr Geschäftsjahr E Año Año Fiscal F Année Exercice I Anno Anno fiscale JA 年 会計年度 KO 연도 회계년도 PTB Ano Ano Fiscal RU Год Финансовый год S År Räkenskapsår TR Yıl Mali Yıl US Year Fiscal Year ZHS 年 会计年度 10 90 :p_location_flex_from Char AR من موقع الأصل بداية مدى موقع الأصل D Von Anlagenstandort Von Anlagenstandort E De Ubicación de Activo De Ubicación de Activos F Du lieu immobilisation Début de la fourchette de lieux immobilisations I Ubicazione attività - Da Inizio dell'intervallo dell'ubicazione attività JA 資産事業所:自 資産事業所範囲:自 KO 자산 위치: 부터 자산 위치 범위 시작 PTB Local de Ativo - De Início da Faixa de Locais de Ativo RU Расположение актива с Начало диапазона расположений активов S Från anläggningsplats Början på anläggningsplaceringsintervall TR İlk Varlık Yerleşimi Varlık Yerleşim Aralığı Başlangıcı US From Asset Location Start of Asset Location Range ZHS 起始资产地点 资产地点范围起始值 11 100 :p_location_flex_to Char AR إلى موقع الأصل نهاية مدى موقع الأصل D Bis Anlagenstandort Bis Anlagenstandort E A Ubicación de Activo A Ubicación de Activos F Au lieu immobilisation Fin de la fourchette de lieux immobilisations I Ubicazione attività - A Fine dell'intervallo dell'ubicazione attività JA 資産事業所:至 資産事業所範囲:至 KO 자산 위치: 까지 자산 위치 범위 종료 PTB Local de Ativo - Até Final da Faixa de Locais de Ativo RU Расположение актива по Конец диапазона расположений активов S Till anläggningsplats Slut på anläggningsplaceringsintervall TR Son Varlık Yerleşimi Varlık Yerleşim Aralığı Sonu US To Asset Location End of Asset Location Range ZHS 终止资产地点 资产地点范围终止值 12 110 :p_category_flex_from Char AR من فئة الأصل فئة الأصل من D Von Anlagenkategorie Von Anlagenkategorie E De Categoría de Activos De Categoría de Activo F De la catégorie d'immobilisations Catégorie immobilisations - De I Categoria attività - Da Categoria cespite - Da JA 資産カテゴリ:自 資産カテゴリ:自 KO 자산 분류: 부터 자산 분류: 부터 PTB Categoria de Ativo - De Categoria de Ativo - De RU Категория актива с Категория актива с S Från anläggningskategori Från anläggningskategori TR İlk Varlık Kategorisi İlk Varlık Kategorisi US From Asset Category Asset Category From ZHS 起始资产类别 资产类别自 13 120 :p_category_flex_to Char AR إلى فئة الأصل فئة الأصل إلى D Bis Anlagenkategorie Bis Anlagenkategorie E A Categoría de Activos A Categoría de Activo F A la catégorie d'immobilisations Catégorie immobilisations - A I Categoria attività - A Categoria cespite - A JA 資産カテゴリ:至 資産カテゴリ:至 KO 자산 분류: 까지 자산 분류: 까지 PTB Categoria de Ativo - Até Categoria de Ativo - Até RU Категория актива по Категория актива по S Till anläggningskategori Till anläggningskategori TR Son Varlık Kategorisi Son Varlık Kategorisi US To Asset Category Asset Category To ZHS 终止资产类别 资产类别至 14 130 :p_asset_number_from LOV Oracle FA_ASSET Y select asset_number id, asset_number value, null description from fa_additions fad where exists (select asset_id from fa_books fab where book_type_code=:$flex$.fa_corp_book and fab.asset_id=fad.asset_id and fab.cost>=0 and fab.period_counter_fully_retired is null) order by value,description AR من رقم الأصل بداية مدى رقم الأصل D Von Anlagennummer Von Anlagennummer E De Número de Activo De Número de Activo F Du numéro d'immobilisation Début de la fourchette de numéros d'immobilisations I Numero cespite - Da Intervallo di numeri di cespite iniziale JA 資産番号:自 資産番号範囲:自 KO 자산 번호:부터 자산 번호 범위 시작 PTB Número do Ativo - De Início da Faixa de Números de Ativo RU Номер актива с Начало диапазона номеров активов S Från anläggningsnr Start på anläggningsnummerintervall TR İlk Varlık Numarası Varlık Numarası Aralığı Başlangıcı US From Asset Number Start of Asset Number Range ZHS 起始资产编号 资产编号起始范围 15 140 :p_asset_number_to LOV Oracle FA_ASSET Y select asset_number id, asset_number value, null description from fa_additions fad where exists (select asset_id from fa_books fab where book_type_code=:$flex$.fa_corp_book and fab.asset_id=fad.asset_id and fab.cost>=0 and fab.period_counter_fully_retired is null) order by value,description AR إلى رقم الأصل نهاية مدى رقم الأصل D Bis Anlagennummer Bis Anlagennummer E A Número de Activo A Número de Activo F Au numéro d'immobilisation Fin de la fourchette de numéros d'immobilisations I Numero cespite - A Intervallo di numeri di cespite finale JA 資産番号:至 資産番号範囲:至 KO 자산 번호:까지 자산 번호 범위 종료 PTB Número do Ativo - Até Final da Faixa de Números de Ativo RU Номер актива по Конец диапазона номеров активов S Till anläggningsnr Slut på anläggningsnummerintervall TR Son Varlık Numarası Varlık Numarası Aralığı Sonu US To Asset Number End of Asset Number Range ZHS 终止资产编号 资产编号终止范围