ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470EA51A9E05362FB09050512Y --This Query selects the list of Assets,which satisfies the input selection parameters-- SELECT FADD.asset_id asset_id ,FADD.asset_number asset_number ,FADD.description asset_name ,FB.date_placed_in_service date_placed_in_service ,FADD.&lc_state_reg_date state_registration_filing_date ,FB.prorate_date prorate_date ,NVL(decode(FM.rate_source_rule, 'FLAT', (12*FFR.&lc_years + FFR.&lc_months) ,FB.life_in_months),0) useful_life_months ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_flex_select', 'OFA', 'CAT#', 101, NULL, fc.CATEGORY_ID, 'ALL', 'N', 'DESCRIPTION') asset_category ,FB.deprn_method_code depreciation_method ,NVL(FB.adjusted_recoverable_cost,0) recoverable_cost ,NVL(FDS.deprn_amount,0) monthly_amount_of_depreciation ,FDP.period_name last_depreciation_period ,FDS.deprn_reserve accumulated_depreciation FROM fa_additions FADD ,fa_books FB ,fa_methods FM ,fa_deprn_summary FDS ,fa_deprn_periods FDP ,fa_categories FC ,fa_flat_rates FFR WHERE FADD.asset_number = NVL(:P_ASSET_NUMBER,FADD.asset_number) AND FB.asset_id = FADD.asset_id AND FB.deprn_method_code = FM.method_code AND NVL(FB.life_in_months,-1) = NVL(FM.life_in_months,-1) AND FDS.asset_id = FADD.asset_id AND FDS.book_type_code = FDP.book_type_code AND FDS.period_counter = FDP.period_counter AND FDP.book_type_code = FB.book_type_code AND FDP.period_counter =(SELECT MAX(FDS1.period_counter) FROM fa_deprn_summary FDS1 WHERE FDS1.asset_id = FADD.asset_id AND FDS1.book_type_code = FB.book_type_code) AND ((FM.rate_source_rule = 'FLAT' AND FFR.basic_rate = FB.basic_rate AND FFR.adjusted_rate = FB.adjusted_rate) OR (NVL(FM.life_in_months,-1) = NVL(FB.life_in_months,-1) AND FM.rate_source_rule <> 'FLAT')) and FM.method_id=FFR.method_id(+) AND FB.date_ineffective is null AND FB.book_type_code = :P_BOOK_NAME AND FADD.asset_category_id = FC.category_id AND FC.category_id = NVL(:P_ASSET_CATEGORY,FC.category_id) OFA FASTAC AR FA البطاقة المحاسبية لضرائب الأصول (روسيا) Imported from BI Publisher Application: الأصول Source: البطاقة المحاسبية لضرائب الأصول (روسيا) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG D FA Anlagensteuerbuchungen (Russland) Imported from BI Publisher Application: Anlagen Source: Anlagensteuerbuchungen (Russland) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG E FA Rusia - Tarjeta de Contabilización de Impuesto sobre Activos Imported from BI Publisher Description: Rusia - Tarjeta de contabilización de impuesto sobre activos Application: Assets Source: Rusia - Tarjeta de Contabilización de Impuesto sobre Activos Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG F FA Fiche de comptabilisation de la taxe sur les immobilisations (Russie) Imported from BI Publisher Application: Assets Source: Fiche de comptabilisation de la taxe sur les immobilisations (Russie) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG I FA Russia - scheda contabilità imposta cespite Imported from BI Publisher Application: Assets Source: Russia - scheda contabilità imposta cespite Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG JA FA 資産税金会計カード(ロシア) Imported from BI Publisher Application: Assets Source: 資産税金会計カード(ロシア) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG KO FA Asset Tax Accounting Card (Russia) Imported from BI Publisher Application: Assets Source: Asset Tax Accounting Card (Russia) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG PTB FA Cartão de Contabilidade do Imposto do Ativo (Rússia) Imported from BI Publisher Application: Assets Source: Cartão de Contabilidade do Imposto do Ativo (Rússia) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG RU FA Карта налогового учета для актива (Россия) Imported from BI Publisher Application: Активы Source: Карта налогового учета для актива (Россия) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG S FA Momsredovisningskort för anläggningar (Ryssland) Imported from BI Publisher Application: Assets Source: Momsredovisningskort för anläggningar (Ryssland) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG TR FA Varlık Vergi Hesaplama Kartı (Rusya) Imported from BI Publisher Application: Duran Varlıklar Source: Varlık Vergi Hesaplama Kartı (Rusya) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG US FA Asset Tax Accounting Card (Russia) Imported from BI Publisher Application: Assets Source: Asset Tax Accounting Card (Russia) Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG ZHS FA 资产税会计卡（俄罗斯） Imported from BI Publisher Application: 资产 Source: 资产税会计卡（俄罗斯） Short Name: FASTAC DB package: FA_TAX_ACCT_CARD_PKG BI Publisher &lc_months &lc_state_reg_date &lc_years :lc_adj_rate_reason :lc_adjusting_coefficient :lc_asset_category_where :lc_asset_number_where :lc_base_rate :lc_company_name :lc_currency_code :lc_event_date :lc_last_deprn_period :lc_months :lc_reference :lc_state_reg_date :lc_suspense_reason :lc_tax_book_cost :lc_years :p_asset_category :p_asset_number :p_book_name :p_category_flex_structure 1 -10 :p_category_flex_structure Number SELECT CATEGORY_FLEX_STRUCTURE FROM FA_SYSTEM_CONTROLS AR هيكل فئة مرن هيكل فئة مرن D Anlagenkategorien-FlexFeld-Struktur Anlagenkategorien-FlexFeld-Struktur E Tipo de Estructura de Categoría Tipo de Estructura de Categoría F Structure de la clé flexible Catégorie Structure de la clé flexible Catégorie I Struttura del flexfield categoria Struttura del flexfield categoria JA カテゴリ・フレックスフィールド体系 カテゴリ・フレックスフィールド体系 KO 분류 가변 구조 분류 가변 구조 PTB Estrutura do Flexfield de Categoria Estrutura do Flexfield de Categoria RU Структура ГП категории Структура ГП категории S Flexfältstruktur för kategori Flexfältstruktur för kategori TR Kategori Esnek Yapısı Kategori Esnek Yapısı US Category Flex Structure Category Flex Structure ZHS 类别弹性结构 类别弹性结构 2 10 :p_book_name 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 AfA-Buchbezeichnung E Nombre del Libro Nombre de libro de activos F Nom du livre d'amortissement Nom du livre d'amortissement I Nome del registro Nome registro cespiti JA 台帳名 資産台帳名 KO 장부명 자산 장부명 PTB Nome do Livro Nome do Livro de Ativo RU Имя книги Имя книги актива S Boknamn Namn på anläggningsbok TR Defter Adı Varlık Defteri Adı US Book Name Asset Book Name ZHS 帐簿名称 资产帐薄名 3 20 :p_asset_category Char AR فئة الأصل فئة الأصل D Anlagenkategorie Anlagenkategorie E Categoría de Activo Categoría de Activo F Catégorie d'immobilisations Catégorie d'immobilisations I Categoria cespite Categoria cespite JA 資産カテゴリ 資産カテゴリ KO 자산 분류 자산 분류 PTB Categoria do Ativo Categoria do Ativo RU Катег.актива Катег.актива S Anläggningskategori Anläggningskategori TR Varlık Kategorisi Varlık Kategorisi US Asset Category Asset Category ZHS 资产类别 资产类别 4 30 :p_asset_number LOV Oracle FA_ASSET_NUMBER 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_book_type and fab.asset_id=fad.asset_id) order by value,description AR رقم الأصل رقم الأصل D Anlagennummer Anlagennummer E Número de Activo Número de Activo F Numéro d'immobilisation Numéro d'immobilisation I Numero cespite Numero cespite JA 資産番号 資産番号 KO 자산 번호 자산 번호 PTB Nr. do Ativo Nr. do Ativo RU Номер актива Номер актива S Anläggningsnummer Anläggningsnummer TR Varlık Numarası Varlık Numarası US Asset Number Asset Number ZHS 资产编号 资产编号