ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2013869E053B46B63588994 SELECT fadd.asset_number asset_no ,fadd.description asset_desc ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_maj_seg', 'OFA', 'CAT#', 101, NULL, fc.CATEGORY_ID, 'BASED_CATEGORY', 'N', 'VALUE') major_category ,fnd_flex_xml_publisher_apis.process_kff_combination_1('cat_min_seg', 'OFA', 'CAT#', 101, NULL, fc.CATEGORY_ID, 'MINOR_CATEGORY', 'N', 'VALUE') minor_category ,to_char(fa_tofes_yud_alef_pkg.purchase_date(fadd.asset_id),'DD-MON-YYYY') purchase_date ,to_char(fb.date_placed_in_service,'DD-MON-YYYY') date_placed_in_service ,fb.original_cost org_asset_cost ,NVL(fa_tofes_yud_alef_pkg.ytd_trans_amt(fadd.asset_id),0) ytd_trans_amounts ,ROUND(NVL((12/fb.life_in_months)*100,fb.basic_rate*100),2) depr_off_rate ,((ROUND(NVL((12/fb.life_in_months)*100,fb.basic_rate*100),2)/12)) * fa_tofes_yud_alef_pkg.deprn_claim_number(fadd.asset_id) depr_claim_rate ,nvl(fa_tofes_yud_alef_pkg.ytd_deprn_amt(fadd.asset_id),0) ytd_depr_amount ,NVL(fa_tofes_yud_alef_pkg.accm_deprn_pr_amt(fadd.asset_id),0) accum_depr_prior_yr FROM FA_ADDITIONS fadd ,&LP_FA_BOOKS fb ,FA_CATEGORIES fc ,(SELECT MAX(fth1.transaction_header_id) transaction_header_id ,fth1.asset_id FROM fa_transaction_headers fth1 ,&LP_FA_BOOKS fb1 ,&LP_FA_DEPRN_PERIODS fdp1 WHERE fb1.transaction_header_id_in = fth1.transaction_header_id AND fth1.asset_id = fb1.asset_id AND fth1.book_type_code = fdp1.book_type_code AND fth1.book_type_code = :P_BOOK_NAME AND fdp1.period_counter = &p_lex_end_period_counter AND fth1.date_effective <= fdp1.period_close_date GROUP BY fth1.asset_id) subfth -- Bug#12351785:Continuation of bug9237853. -- Bug#9237853:Changes done to avoid duplicate rows. WHERE fadd.asset_id = fb.asset_id -- AND fadd.asset_id = fah.asset_id -- AND fah.category_id = fc.category_id -- AND fadd.asset_id = fai.asset_id(+) -- AND fai.po_vendor_id = pov.vendor_id(+) --AND fdp.book_type_code = fds.book_type_code --AND fb.asset_id = fds.asset_id --AND fdp.period_counter = fds.period_counter AND fadd.asset_category_id = fc.category_id AND fb.transaction_header_id_in = subfth.transaction_header_id AND fb.asset_id = subfth.asset_id --AND fb.book_type_code = fdp.book_type_code AND fadd.asset_type = 'CAPITALIZED' AND fb.depreciate_flag = 'YES' AND fb.book_type_code = :P_BOOK_NAME --AND fdp.period_counter >= &p_lex_begin_period_counter --AND fdp.period_counter <= &p_lex_end_period_counter AND NVL(fb.period_counter_fully_retired, &p_lex_end_period_counter) >= &p_lex_begin_period_counter --Bug#11932660 --AND fb.date_effective BETWEEN fdp.period_open_date AND NVL(fdp.period_close_date, fb.date_effective) --Bug#9237853 --AND fah.transaction_header_id_in = -- (SELECT MAX(fah1.transaction_header_id_in) -- FROM fa_asset_history fah1 -- WHERE fah1.asset_id = fadd.asset_id) ORDER BY major_category, asset_no Y OFA FASTYA AR FA تقرير Tofes Yud Alef رقم 1342 (إسرائيل) Application: الأصول Source: تقرير Tofes Yud Alef رقم 1342 (إسرائيل) Short Name: FASTYA DB package: FA_TOFES_YUD_ALEF_PKG D FA Tofes Yud Alef 1342 (Israel) Application: Anlagen Source: Tofes Yud Alef 1342 (Israel) Short Name: FASTYA DB package: FA_TOFES_YUD_ALEF_PKG F FA Etat Tofes Yud Alef 1342 (Israël) Application: Assets Source: Etat Tofes Yud Alef 1342 (Israël) Short Name: FASTYA DB package: FA_TOFES_YUD_ALEF_PKG US FA Tofes Yud Alef Report 1342 (Israel) Application: Assets Source: Tofes Yud Alef Report 1342 (Israel) Short Name: FASTYA DB package: FA_TOFES_YUD_ALEF_PKG ZHS FA Tofes Yud Alef 报表 1342（以色列） Application: 资产 Source: Tofes Yud Alef 报表 1342（以色列） Short Name: FASTYA DB package: FA_TOFES_YUD_ALEF_PKG BI Publisher &lp_fa_books &lp_fa_deprn_periods &p_lex_begin_period_counter &p_lex_end_period_counter :lc_acct_flex_struc :lp_currency_code :lp_fa_adjustments :lp_fa_asset_invoices :lp_fa_book_controls :lp_fa_books :lp_fa_deprn_periods :lp_fa_retirements :p_begin_period :p_book_name :p_ca_set_of_books_id :p_end_period :p_ledger_id :p_legal_entity :p_lex_begin_period_counter :p_lex_end_period_counter :p_mrcsobtype 1 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 F Nom du livre d'amortissement US Book Name 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_Name) Y AR عملة دفتر الأستاذ D Buchwährung F Devise comptable US Ledger Currency ZHS 分类帐币种 3 30 :p_ledger_id LOV Oracle FA_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_ledgers l,fa_book_controls fbc where l.ledger_id=fbc.set_of_books_id and fbc.book_type_code=:$flex$.fa_book_type order by value,description Y AR اسم دفتر الأستاذ D Buchbezeichnung F Nom du livre comptable US Ledger Name ZHS 分类帐名称 4 40 :p_legal_entity LOV Oracle FA_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where ledger_id=:$flex$.fa_ledger_name order by value,description Y AR اسم الكيان القانوني D Mandantenname F Nom de l'entité juridique US Legal Entity Name ZHS 法人主体名称 5 50 :p_begin_period LOV Oracle FA_FROM_PERIOD_CLOSED 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) and period_close_date is not null order by period_counter Y AR من الفترة D Von Periode F De la période US From Period ZHS 自期间 6 60 :p_end_period LOV Oracle FA_TO_PERIOD_CLOSED_FISCAL Y select fdp1.period_name id, fdp1.period_name value, null description from fa_deprn_periods fdp1,fa_deprn_periods fdp2 where fdp1.book_type_code=fdp2.book_type_code and fdp1.book_type_code=:$flex$.fa_book_type and fdp2.book_type_code=:$flex$.fa_book_type and fdp1.period_counter>=fdp2.period_counter and fdp2.period_name=:$flex$.fa_from_period_closed and fdp1.fiscal_year=fdp2.fiscal_year and fdp1.period_close_date is not null order by fdp1.period_counter Y AR إلى الفترة D Bis Periode F A la période US To Period ZHS 至期间 :$FLEX$.Book_Name Book Name Ledger Currency :$flex$.fa_book_type Book Name From Period :$flex$.fa_book_type Book Name Ledger Currency :$flex$.fa_book_type Book Name Ledger Name :$flex$.fa_book_type Book Name To Period :$flex$.fa_from_period_closed From Period To Period :$flex$.fa_ledger_name Ledger Name Legal Entity Name