ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 53CBABC9B7B32FBCE0630100007F5445 FA Asset Key Y select distinct fakk.concatenated_segments value, null description from fa_asset_keywords_kfv fakk, fa_additions fa where fa.asset_key_ccid=fakk.code_combination_id order by fakk.concatenated_segments US 53CBABC9B7B42FBCE0630100007F5445 FA Asset Number Y Y select fa.asset_number value, fa.description description from fa_additions fa, fa_books fb where fa.asset_id=fb.asset_id and fb.date_ineffective is null and fb.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and (:$flex$.ledger is null or fb.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fb.book_type_code)='Y') order by fa.asset_number US B12587B17F666485E0530100007FA7F4 FA Book Y select x.value, x.description from ( select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs where :$flex$.ledger is null or fbcs.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') != 'R' union select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs, fa_mc_book_controls fmbc where fbcs.book_type_code = fmbc.book_type_code and fbcs.set_of_books_id = fmbc.primary_set_of_books_id and :$flex$.ledger is null or fmbc.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.value US ED83C3588D118586E0530100007FB788 FA Category Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments US B12835F5EC2F6F85E0530100007F7410 FA Period Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar US 8E2FF36EDEC879D2E0530100007F1FF2 GL Chart of Accounts (inv org related) Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name AR دليل الحسابات المتعلقة بمنظمات المخزون D Kontenplan für Bestandsorganisationen E Plan de cuentas relacionado con las organizaciones de inventario F Plan comptable relatif aux organismes d'inventaire I Piano dei conti relativo alle organizzazioni dell'inventario JA 棚卸し組織に関する勘定科目一覧表 KO 재고 조직과 관련된 계정과 목표 PTB Plano de contas relacionado às organizações de inventário RU План счетов организаций, занимающихся инвентаризацией S Kontoplan relaterade till lagerorganisationer TR Envanter organizasyonları ile ilgili hesap planı US Chart of accounts related to inventory organizations ZHS 与库存组织有关的会计科目表 05FCF30F9B56017AE0630100007F6C53 GL Ledger (Asset Book Secured) Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select set_of_books_id from fa_book_controls_sec) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name US CA8C58FD1B2C4684E0530100007FE8F1Y select x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, &segment_cols x.location location_name, x.asset_type, x.asset_account, x.cost_center, x.reserve_account, x.asset_number, x.asset_key, x.asset_description, x.asset_category, x.tag_number, x.manufacturer_name, x.serial_number, x.model_number, x.date_placed_in_service, x.method depreciation_method, x.d_life "Life Yr.Mo", x.cost initial_cost, x.ytd_depreciation, x.initial_depreciation_reserve, x.period_effective, x.period_entered, x.thid transaction_number, x.company_name || ': ' || x.book || ' (' || x.currency || ')' comp_book_curr_label from ( select fsc.company_name, gsob.name ledger, fbc.book_type_code book, gsob.currency_code currency, gcc.code_combination_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') balancing_segment, flk.concatenated_segments location, fl.meaning asset_type, decode(fah.asset_type, 'CIP', fcb.cip_cost_acct,fcb.asset_cost_acct) asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, decode(fah.asset_type, 'CIP', null,fcb.deprn_reserve_acct) reserve_account, fa.asset_number, fakk.concatenated_segments asset_key, fa.description asset_description, fcbk.concatenated_segments asset_category, fa.tag_number, fa.manufacturer_name, fa.serial_number, fa.model_number, fb.date_placed_in_service, fb.deprn_method_code method, fb.life_in_months life, fb.adjusted_rate adj_rate, decode (fah.asset_type, 'CIP', 0,nvl(fds.bonus_rate,0)) bonus_rate, fb.production_capacity prod, fa_fas420_xmlp_pkg.d_lifeformula(fb.life_in_months, fb.adjusted_rate, decode (fah.asset_type, 'CIP', 0,nvl(fds.bonus_rate,0)), fb.production_capacity) d_life, sum(nvl(decode(fadj.debit_credit_flag,'DR',1,-1) * fadj.adjustment_amount, fdd.addition_cost_to_clear) ) cost, sum(nvl(fdd.ytd_deprn,0)) ytd_depreciation, sum(fdd.deprn_reserve) initial_depreciation_reserve, (select fcp.period_name from fa_calendar_periods fcp where fcp.calendar_type=fbc.deprn_calendar and fth.transaction_date_entered between fcp.start_date and fcp.end_date) period_effective, (select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=fbc.book_type_code and fth.date_effective between fdp.period_open_date and nvl(fdp.period_close_date,fth.date_effective)) period_entered, fth.transaction_header_id thid from fa_system_controls fsc, fa_lookups fl, fa_additions fa, fa_asset_keywords_kfv fakk, fa_asset_history fah, fa_transaction_headers fth, fa_category_books fcb, fa_categories_b_kfv fcbk, fa_distribution_history fdh, fa_locations_kfv flk, gl_code_combinations gcc, &lp_fa_adjustments fadj, &lp_fa_books fb, &lp_fa_deprn_summary fds, &lp_fa_deprn_detail fdd, fnd_currencies fc, &lp_fa_book_controls fbc, gl_sets_of_books gsob where 2=2 and fbc.set_of_books_id = :p_ca_set_of_books_id and fth.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and fadj.book_type_code = fth.book_type_code and fadj.transaction_header_id = fth.transaction_header_id and ((fadj.source_type_code = 'CIP ADDITION' and fadj.adjustment_type = 'CIP COST') or (fadj.source_type_code = 'ADDITION' and fadj.adjustment_type = 'COST') ) and fdh.distribution_id = fadj.distribution_id and gcc.code_combination_id = fdh.code_combination_id and fdh.location_id = flk.location_id(+) and fl.lookup_type = 'ASSET TYPE' and fah.asset_type = fl.lookup_code and fa.asset_id = fth.asset_id and fa.asset_key_ccid = fakk.code_combination_id (+) and fah.asset_id = fth.asset_id and fth.date_effective >= fah.date_effective and fth.date_effective < nvl(fah.date_ineffective, sysdate) and fb.transaction_header_id_in = fth.transaction_header_id and fcb.book_type_code = fth.book_type_code and fcb.category_id = fah.category_id and fbc.book_type_code = fth.book_type_code and fah.category_id = fcbk.category_id and gsob.set_of_books_id = fbc.set_of_books_id and gsob.currency_code = fc.currency_code and fdd.book_type_code (+) = fadj.book_type_code and fdd.distribution_id (+) = fadj.distribution_id and fdd.deprn_source_code (+) = 'B' and fds.book_type_code (+) = fadj.book_type_code and fds.asset_id (+) = fadj.asset_id and fds.period_counter (+) = fadj.period_counter_created group by fsc.company_name, gsob.name, fbc.book_type_code, fbc.deprn_calendar, gcc.code_combination_id, gsob.currency_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), flk.concatenated_segments, fl.meaning, decode(fah.asset_type, 'CIP', fcb.cip_cost_acct,fcb.asset_cost_acct), fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), decode(fah.asset_type, 'CIP', null,fcb.deprn_reserve_acct), fa.asset_number, fakk.concatenated_segments, fa.description, fcbk.concatenated_segments, fa.tag_number, fa.manufacturer_name, fa.serial_number, fa.model_number, fb.date_placed_in_service, fb.deprn_method_code, fb.life_in_months, fb.production_capacity, fb.adjusted_rate, decode (fah.asset_type, 'CIP', 0,nvl(fds.bonus_rate,0)), fth.transaction_header_id, fth.date_effective, fth.transaction_date_entered, fc.precision union select distinct --0 cost assets fsc.company_name, gsob.name ledger, fbc.book_type_code book, gsob.currency_code currency, gcc.code_combination_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') balancing_segment, flk.concatenated_segments location, fl.meaning asset_type, decode(fah.asset_type, 'CIP', fcb.cip_cost_acct, fcb.asset_cost_acct) asset_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_cost_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, null, gcc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') cost_center, decode(fah.asset_type, 'CIP', null, fcb.deprn_reserve_acct) reserve_account, fa.asset_number, fakk.concatenated_segments asset_key, fa.description asset_description, fcbk.concatenated_segments asset_category, fa.tag_number, fa.manufacturer_name, fa.serial_number, fa.model_number, fb.date_placed_in_service, fb.deprn_method_code method, fb.life_in_months life, fb.adjusted_rate adj_rate, decode (fah.asset_type, 'CIP', 0, nvl(fds.bonus_rate,0)) bonus_rate, fb.production_capacity prod, fa_fas420_xmlp_pkg.d_lifeformula(fb.life_in_months, fb.adjusted_rate, decode (fah.asset_type, 'CIP', 0,nvl(fds.bonus_rate,0)), fb.production_capacity) d_life, 0 cost, 0 ytd_depreciation, 0 initial_depreciation_reserve, (select fcp.period_name from fa_calendar_periods fcp where fcp.calendar_type=fbc.deprn_calendar and fth.transaction_date_entered between fcp.start_date and fcp.end_date) period_effective, (select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=fbc.book_type_code and fth.date_effective between fdp.period_open_date and nvl(fdp.period_close_date,fth.date_effective)) period_entered, fth.transaction_header_id thid from fa_system_controls fsc, fa_lookups fl, fa_additions fa, fa_asset_keywords_kfv fakk, fa_asset_history fah, fa_category_books fcb, fa_categories_b_kfv fcbk, gl_code_combinations gcc, fa_distribution_history fdh, fa_locations_kfv flk, &lp_fa_books fb, &lp_fa_deprn_summary fds, fnd_currencies fc, &lp_fa_book_controls fbc, gl_sets_of_books gsob, (select fth.book_type_code, fth.transaction_header_id, fth.asset_id, fth.date_effective, fth.transaction_date_entered, dp.period_counter from fa_transaction_headers fth, &lp_fa_book_controls fbc, &lp_fa_deprn_periods dp where 2=2 and fth.book_type_code = fbc.book_type_code and fth.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and fth.transaction_type_code in ('ADDITION', 'CIP ADDITION') and dp.book_type_code = fth.book_type_code and fth.date_effective between dp.period_open_date and nvl (dp.period_close_date, sysdate) ) fth where fbc.set_of_books_id = :p_ca_set_of_books_id and fdh.asset_id = fth.asset_id and fth.date_effective >= fdh.date_effective and fth.date_effective < nvl(fdh.date_ineffective, sysdate) and gcc.code_combination_id = fdh.code_combination_id and fdh.location_id = flk.location_id(+) and fl.lookup_type = 'ASSET TYPE' and fah.asset_type = fl.lookup_code and fa.asset_id = fth.asset_id and fa.asset_key_ccid = fakk.code_combination_id (+) and fah.asset_id = fth.asset_id and fth.date_effective >= fah.date_effective and fth.date_effective < nvl(fah.date_ineffective, sysdate) and fb.transaction_header_id_in = fth.transaction_header_id and fb.cost = 0 and fcb.book_type_code = fth.book_type_code and fcb.category_id = fah.category_id and fbc.book_type_code = fth.book_type_code and fah.category_id = fcbk.category_id and gsob.set_of_books_id = fbc.set_of_books_id and gsob.currency_code = fc.currency_code and fds.book_type_code (+) = fth.book_type_code and fds.asset_id (+) = fth.asset_id and fds.period_counter (+) = fth.period_counter ) x, gl_code_combinations gcc where 1=1 and :p_ledger_name=:p_ledger_name and x.code_combination_id=gcc.code_combination_id order by x.company_name, x.ledger, x.book, x.currency, x.balancing_segment, x.location, x.asset_type, x.asset_account, x.cost_center, x.reserve_account, x.asset_number Added Location Code, Location (FA Location KFF), and Asset Key (FA Asset Key KFF) columns; added Asset Number and Asset Key parameters. OFA FAS420_XML #,##0.00;[Red]-#,##0.00 (:From_Period_Entered is not null and :To_Period_Entered is not null) or (:From_Period_Effective is not null and :To_Period_Effective is not null) AR FA تقرير إضافات الأصول (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل (1) Imported from BI Publisher Description: تقرير إضافات الأصول Application: الأصول Source: تقرير إضافات الأصول (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG D FA Anlagenzugänge- Nicht unterstützt: Reserviert für zukünftige Verwendung (1) Imported from BI Publisher Description: Auswertung "Anlagenzugänge" Application: Anlagen Source: Anlagenzugänge (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG F FA Etat des acquisitions d'immobilisations- Non pris en charge : réservé pour une utilisation future (1) Imported from BI Publisher Description: Etat des acquisitions d'immobilisations Application: Assets Source: Etat des acquisitions d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG I FA Rapporto Incrementi cespiti- non supportato: riservato per usi futuri Imported from BI Publisher Description: Rapporto Incrementi cespiti Application: Assets Source: Rapporto Incrementi cespiti (XML) - non supportato: riservato per usi futuri Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG US FA Asset Additions Imported from BI Publisher Description: Asset Additions Report Application: Assets Source: Asset Additions Report (XML) Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG An Entered Period Range and/or an Effective Period Range must be specified ZHS FA 资产增加报表- 不支持：已保留供将来使用 (1) Imported from BI Publisher Description: 资产增加报表 Application: 资产 Source: 资产增加报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS420_XML DB package: FA_FAS420_XMLP_PKG Enginatics R12 only &lp_fa_adjustments &lp_fa_book_controls &lp_fa_books &lp_fa_deprn_detail &lp_fa_deprn_periods &lp_fa_deprn_summary &segment_cols 1=1 2=2 :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :lp_currency_code :lp_fa_adjustments :lp_fa_book_controls :lp_fa_books :lp_fa_deprn_detail :lp_fa_deprn_periods :lp_fa_deprn_summary :p_book :p_ca_org_id :p_ca_set_of_books_id :p_conc_request_id :p_ledger_name :p_min_precision :p_mrcsobtype :p_period1 :p_period2 :period1_fy :period1_pcd :period1_pod :period2_fy :period2_pcd :period2_pod :period_from :period_to 1 -30 &segment_cols select 'gcc.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",' text from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.enabled_flag='Y' and fifsv.id_flex_num=(select fifsv0.id_flex_num from fnd_id_flex_structures_vl fifsv0 where fifsv0.application_id=101 and fifsv0.id_flex_code='GL#' and fifsv0.id_flex_structure_name=:chart_of_accounts) order by fifsv.segment_num LOV GL Chart of Accounts (inv org related) 8E2FF36EDEC879D2E0530100007F1FF2 Y select fifsv.id_flex_structure_name value, fifsv.id_flex_structure_code description from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num in (select ood.chart_of_accounts_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate + 1) > sysdate) order by fifsv.id_flex_structure_name select fifsv.id_flex_structure_name from fnd_id_flex_structures_vl fifsv where fifsv.id_flex_code='GL#' and fifsv.application_id=101 and fifsv.id_flex_num=(select chart_of_accounts_id from gl_sets_of_books where set_of_books_id=:$flex$.ledger_id) US Chart of Accounts 2 -20 :p_ca_set_of_books_id Number select gsob.set_of_books_id from gl_sets_of_books gsob where gsob.name = :$flex$.Ledger US Ledger ID 3 -10 :p_mrcsobtype Char select nvl( (select decode(gsob.mrc_sob_type_code,'R','R','P') from gl_sets_of_books gsob where gsob.name = :$flex$.Ledger ) ,'P' ) from dual F Drapeau MRC US MRC Flag 4 &lp_fa_adjustments fa_adjustments P F Drapeau MRC US MRC Flag 5 &lp_fa_adjustments fa_adjustments_mrc_v R F Drapeau MRC US MRC Flag 6 &lp_fa_book_controls fa_book_controls P F Drapeau MRC US MRC Flag 7 &lp_fa_book_controls fa_book_controls_mrc_v R F Drapeau MRC US MRC Flag 8 &lp_fa_books fa_books P F Drapeau MRC US MRC Flag 9 &lp_fa_books fa_books_mrc_v R F Drapeau MRC US MRC Flag 10 &lp_fa_deprn_detail fa_deprn_detail P F Drapeau MRC US MRC Flag 11 &lp_fa_deprn_detail fa_deprn_detail_mrc_v R F Drapeau MRC US MRC Flag 12 &lp_fa_deprn_periods fa_deprn_periods P F Drapeau MRC US MRC Flag 13 &lp_fa_deprn_periods fa_deprn_periods_mrc_v R F Drapeau MRC US MRC Flag 14 &lp_fa_deprn_summary fa_deprn_summary P F Drapeau MRC US MRC Flag 15 &lp_fa_deprn_summary fa_deprn_summary_mrc_v R F Drapeau MRC US MRC Flag 16 10 :p_ledger_name LOV GL Ledger (Asset Book Secured) 05FCF30F9B56017AE0630100007F6C53 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select set_of_books_id from fa_book_controls_sec) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name select gl.name from gl_sets_of_books gl where gl.set_of_books_id in (select set_of_books_id from fa_book_controls_sec) and gl.set_of_books_id = nvl(fnd_profile.value('GL_SET_OF_BKS_ID'),gl.set_of_books_id) Y AR عملة دفاتر الحسابات عملة دفاتر الحسابات D Währung Buchungsstruktur Währung Buchungsstruktur F Ensemble de livres Monnaie Devise de l'entité comptable I Divisa set of books Divisa set of books US Ledger Ledger ZHS 帐套币种 帐套币种 17 20 2=2 fth.book_type_code = :p_book LOV FA Book B12587B17F666485E0530100007FA7F4 Y select x.value, x.description from ( select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs where :$flex$.ledger is null or fbcs.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') != 'R' union select fbcs.book_type_code value, fbcs.book_type_name||' ('||fbcs.book_class||')' description from fa_book_controls_sec fbcs, fa_mc_book_controls fmbc where fbcs.book_type_code = fmbc.book_type_code and fbcs.set_of_books_id = fmbc.primary_set_of_books_id and :$flex$.ledger is null or fmbc.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y') and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.value select case when xrpv.parameter_type='LOV Oracle' and xrrpv.value not like '<multiple_values>%' then xxen_report.id_to_value(xrpv.parameter_id,xrrpv.value) else xrrpv.value end value from xxen_report_parameters_v xrpv, (select xrr.report_id,max(xrr.run_id) run_id from xxen_report_runs xrr where xrr.created_by = fnd_global.user_id and xrr.responsibility_id = fnd_global.resp_id group by xrr.report_id) xrr, xxen_report_run_param_values xrrpv where xrpv.report_name = 'FA Asset Additions' and xrpv.parameter_name = 'Book' and xrpv.report_id = xrr.report_id and xrr.run_id = xrrpv.run_id and xrpv.parameter_id = xrrpv.parameter_id AR الدفتر نوع الدفتر D AfA-Buch Art AfA-Buch F Livre Type de livre I Registro Tipo di registro US Book Book Type ZHS 帐簿 账簿类型 18 30 2=2 fth.date_effective >= ( select min(fdp.period_open_date) from fa_deprn_periods fdp where fdp.book_type_code = fbc.book_type_code and fdp.calendar_period_open_date >= (select fcp.start_date from fa_calendar_periods fcp where fcp.calendar_type = fbc.deprn_calendar and fcp.period_name = :p_from_period) and nvl(:p_mrcsobtype,'P') != 'R' having min(fdp.period_open_date) is not null union select min(fdpmv.period_open_date) from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code = fbc.book_type_code and fdpmv.calendar_period_open_date >= (select fcp.start_date from fa_calendar_periods fcp where fcp.calendar_type = fbc.deprn_calendar and fcp.period_name = :p_from_period) and :p_mrcsobtype = 'R' having min(fdpmv.period_open_date) is not null ) LOV FA Period B12835F5EC2F6F85E0530100007F7410 Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar select fdp.period_name from fa_deprn_periods fdp where fdp.book_type_code=:$flex$.book and fdp.period_counter= (select max(fdp2.period_counter) from fa_deprn_periods fdp2 where fdp2.book_type_code=:$flex$.book and fdp2.period_close_date is not null ) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code=:$flex$.book and fdpmv.period_counter= (select max(fdpmv2.period_counter) from fa_deprn_periods_mrc_v fdpmv2 where fdpmv2.book_type_code=:$flex$.book and fdpmv2.period_close_date is not null ) and nvl(:$flex$.mrc_flag,'P') = 'R' AR من الفترة اسم الفترة D Von Periode Periodenbezeichnung F De la période Nom de la période I Periodo - Da Nome del periodo US From Period Entered Entered From Period Name ZHS 自期间 期间名称 19 40 2=2 fth.date_effective <= ( select max(nvl(fdp.period_close_date, sysdate)) from fa_deprn_periods fdp where fdp.book_type_code = fth.book_type_code and fdp.calendar_period_open_date <= (select fcp.start_date from fa_calendar_periods fcp where fcp.calendar_type = fbc.deprn_calendar and fcp.period_name = :p_to_period) and nvl(:p_mrcsobtype,'P') != 'R' having max(nvl(fdp.period_close_date, sysdate)) is not null union select max(nvl(fdpmv.period_close_date, sysdate)) from fa_deprn_periods_mrc_v fdpmv where fdpmv.book_type_code = fth.book_type_code and fdpmv.calendar_period_open_date <= (select fcp.start_date from fa_calendar_periods fcp where fcp.calendar_type = fbc.deprn_calendar and fcp.period_name = :p_to_period) and :p_mrcsobtype = 'R' having max(nvl(fdpmv.period_close_date, sysdate)) is not null ) LOV FA Period B12835F5EC2F6F85E0530100007F7410 Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar :$flex$.From_Period_Entered AR إلى الفترة اسم الفترة D Bis Periode Periodenbezeichnung F À la période Nom de la période I Periodo - A Nome del periodo US To Period Entered Entered To Period Name ZHS 至期间 期间名称 20 50 2=2 fth.transaction_date_entered >= ( select min(fcp.start_date) from fa_calendar_periods fcp where fcp.calendar_type = fbc.deprn_calendar and fcp.start_date >= (select fcp2.start_date from fa_calendar_periods fcp2 where fcp2.calendar_type = fbc.deprn_calendar and fcp2.period_name = :p_from_period_effective) ) LOV FA Period B12835F5EC2F6F85E0530100007F7410 Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar US From Period Effective Effective From Period Name 21 60 2=2 fth.transaction_date_entered <= ( select max(fcp.end_date) from fa_calendar_periods fcp where fcp.calendar_type = fbc.deprn_calendar and fcp.start_date <= (select fcp2.start_date from fa_calendar_periods fcp2 where fcp2.calendar_type = fbc.deprn_calendar and fcp2.period_name = :p_to_period_effective) ) LOV FA Period B12835F5EC2F6F85E0530100007F7410 Y select x.value, x.description, x.fiscal_year, x.period_num from ( select fdp.period_name value, fbcs.deprn_calendar || ': ' || fdp.fiscal_year||' - '||fdp.period_num description, fdp.fiscal_year, fdp.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods fdp where fbcs.book_type_code = fdp.book_type_code and (:$flex$.ledger is null or fdp.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdp.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdp.book_type_code)='Y') and fdp.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') != 'R' union select fdpmv.period_name value, fbcs.deprn_calendar || ': ' || fdpmv.fiscal_year||' - '||fdpmv.period_num description, fdpmv.fiscal_year, fdpmv.period_num, fbcs.deprn_calendar from fa_book_controls_sec fbcs, fa_deprn_periods_mrc_v fdpmv where fbcs.book_type_code = fdpmv.book_type_code and (:$flex$.ledger is null or fdpmv.book_type_code in (select fbcmv.book_type_code from gl_ledgers gl, fa_book_controls_mrc_v fbcmv where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcmv.set_of_books_id)) and (:$flex$.asset_book is null or xxen_util.contains(:$flex$.asset_book,fdpmv.book_type_code)='Y') and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fdpmv.book_type_code)='Y') and fdpmv.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and nvl(:$flex$.mrc_flag,'P') = 'R' ) x order by x.fiscal_year desc, x.period_num desc, x.deprn_calendar :$flex$.from_period_effective US To Period Effective Effective To Period Name 22 70 1=1 x.asset_category >= :p_category_from LOV FA Category ED83C3588D118586E0530100007FB788 Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments US Category From 23 80 1=1 x.asset_category <= :p_category_to LOV FA Category ED83C3588D118586E0530100007FB788 Y select fcbk.concatenated_segments value, null description from fa_categories_b_kfv fcbk where (nvl(:$flex$.book,:$flex$.asset_book) is null and (:$flex$.ledger_id is null or fcbk.category_id in (select fcb.category_id from gl_ledgers gl, fa_book_controls_sec fbcs, fa_category_books fcb where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id and fbcs.book_type_code = fcb.book_type_code) ) ) or fcbk.category_id in (select fcb.category_id from fa_category_books fcb where xxen_util.contains(nvl(:$flex$.book,:$flex$.asset_book),fcb.book_type_code)='Y') order by fcbk.concatenated_segments :$flex$.category_from US Category To 24 90 1=1 x.asset_number=:p_asset_number LOV FA Asset Number 53CBABC9B7B42FBCE0630100007F5445 Y Y select fa.asset_number value, fa.description description from fa_additions fa, fa_books fb where fa.asset_id=fb.asset_id and fb.date_ineffective is null and fb.book_type_code in (select fbcs.book_type_code from fa_book_controls_sec fbcs) and (:$flex$.ledger is null or fb.book_type_code in (select fbcs.book_type_code from gl_ledgers gl, fa_book_controls_sec fbcs where xxen_util.contains(:$flex$.ledger,gl.name)='Y' and gl.ledger_id=fbcs.set_of_books_id)) and (:$flex$.book is null or xxen_util.contains(:$flex$.book,fb.book_type_code)='Y') order by fa.asset_number US Asset Number 25 100 1=1 x.asset_key=:p_asset_key LOV FA Asset Key 53CBABC9B7B32FBCE0630100007F5445 Y select distinct fakk.concatenated_segments value, null description from fa_asset_keywords_kfv fakk, fa_additions fa where fa.asset_key_ccid=fakk.code_combination_id order by fakk.concatenated_segments US Asset Key :$flex$.From_Period_Entered From Period Entered To Period Entered :$flex$.Ledger Ledger Ledger ID :$flex$.Ledger Ledger MRC Flag :$flex$.book Book Asset Number :$flex$.book Book Category From :$flex$.book Book Category To :$flex$.book Book From Period Effective :$flex$.book Book From Period Entered :$flex$.book Book To Period Effective :$flex$.book Book To Period Entered :$flex$.category_from Category From Category To :$flex$.from_period_effective From Period Effective To Period Effective :$flex$.ledger Ledger Asset Number :$flex$.ledger Ledger Book :$flex$.ledger Ledger Category From :$flex$.ledger Ledger Category To :$flex$.ledger Ledger From Period Effective :$flex$.ledger Ledger From Period Entered :$flex$.ledger Ledger To Period Effective :$flex$.ledger Ledger To Period Entered :$flex$.ledger_id Ledger ID Category From :$flex$.ledger_id Ledger ID Category To :$flex$.ledger_id Ledger ID Chart of Accounts :$flex$.mrc_flag MRC Flag Book :$flex$.mrc_flag MRC Flag From Period Effective :$flex$.mrc_flag MRC Flag From Period Entered :$flex$.mrc_flag MRC Flag To Period Effective :$flex$.mrc_flag MRC Flag To Period Entered 4514D97503ABAF9D4DC3DBB78DFA51FB Pivot: Default Template Asset Additions Summary (Pivot) with Asset Addition Details by Asset SYSADMIN 7 ASSET_ACCOUNT 6 12 ASSET_CATEGORY 11 ASSET_DESCRIPTION 10 ASSET_NUMBER 9 6 ASSET_TYPE 5 5 BALANCING_SEGMENT 4 3 BOOK 3 1 COMPANY_NAME 1 26 COMP_BOOK_CURR_LABEL 8 COST_CENTER 7 4 CURRENCY 17 DATE_PLACED_IN_SERVICE 18 DEPRECIATION_METHOD 20 INITIAL_COST 22 INITIAL_DEPRECIATION_RESERVE 2 LEDGER 2 19 Life Yr.Mo 14 MANUFACTURER_NAME 16 MODEL_NUMBER -22.0023 PERIOD 23 PERIOD_EFFECTIVE 24 PERIOD_ENTERED 9 RESERVE_ACCOUNT 8 15 SERIAL_NUMBER 13 TAG_NUMBER 25 TRANSACTION_NUMBER 21 YTD_DEPRECIATION ASSET_ACCOUNT ROW 4 ASSET_TYPE ROW 3 BALANCING_SEGMENT ROW 2 COMP_BOOK_CURR_LABEL ROW 1 COST_CENTER ROW 5 INITIAL_COST VALUE 1 SUM INITIAL_DEPRECIATION_RESERVE VALUE 3 SUM PERIOD FILTER 1 PERIOD_EFFECTIVE FILTER 2 PERIOD_ENTERED FILTER 1 RESERVE_ACCOUNT ROW 6 YTD_DEPRECIATION VALUE 2 SUM S Site 4514D97503ABAF9D4DC3DBB78DFA51FB