ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C2E95E107C034779E0530100007F5F55 GL Cost Center Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value US B00C369464645DE0E0530100007F9EB4 select x.company_name ,x.book ,x.cur_period current_period ,x.d_comp_code1 "&balancing_segment_p" ,x.d_cost_ctr1 "&cost_center_p" ,x.owner ,x.d_location1 location ,x.asset "Asset - Description" ,x.units ,x.serial serial_number ,x.tag tag_number ,fa_fas410_xmlp_pkg.as_nbvformula(x.cost, x.reserve) net_book_value ,x.cost current_cost ,case when x.new > 0 then 'New' else null end new ,x.asset_type from ( select fsc.company_name, fsc.book, fsc.cur_period, emp.full_name owner, ad.asset_number || ' - ' || ad.description asset, sum(dh.units_assigned) units, ad.serial_number serial, ad.tag_number tag, sum(decode(dd.deprn_source_code,'B', dd.addition_cost_to_clear, dd.cost)) cost, sum(dd.deprn_reserve) reserve, decode(greatest(books.date_placed_in_service,nvl(:p_from_date, books.date_placed_in_service)) ,least(books.date_placed_in_service, nvl(:p_to_date, books.date_placed_in_service)) ,1,0) new, decode(ad.asset_type,'CIP', 'C', 'EXPENSED','E','') asset_type, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') d_comp_code1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') d_cost_ctr1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, null, loc.location_id, 'ALL', 'Y', 'VALUE') d_location1 from ( select company_name, category_flex_structure, location_flex_structure, asset_key_flex_structure, fa_fas410_xmlp_pkg.bookformula() book, fa_fas410_xmlp_pkg.cur_periodformula(fa_fas410_xmlp_pkg.bookformula()) cur_period, fa_fas410_xmlp_pkg.report_nameformula() report_name, fa_fas410_xmlp_pkg.accounting_flex_structure_p accounting_flex_structure, fa_fas410_xmlp_pkg.currency_code_p currency_code, fa_fas410_xmlp_pkg.book_class_p book_class, fa_fas410_xmlp_pkg.distribution_source_book_p distribution_source_book, fa_fas410_xmlp_pkg.cur_period_pc_p cur_period_pc from fa_system_controls ) fsc, fa_deprn_detail dd, per_people_f emp, fa_additions ad, fa_locations loc, gl_code_combinations cc, fa_books books, fa_distribution_history dh where dh.book_type_code = :p_book and dh.assigned_to = emp.person_id(+) and dh.date_effective between nvl(emp.effective_start_date,dh.date_effective) and nvl(emp.effective_end_date,dh.date_effective) and fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.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#', cc.chart_of_accounts_id, null, cc.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#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE')) and dh.asset_id = ad.asset_id and dh.location_id = loc.location_id and dh.code_combination_id = cc.code_combination_id and dh.date_ineffective is null and dd.asset_id = dh.asset_id and dd.book_type_code = dh.book_type_code and dd.distribution_id = dh.distribution_id and dd.period_counter = (select max (dd2.period_counter) from fa_deprn_detail dd2 where dd2.book_type_code = books.book_type_code and dd2.asset_id = books.asset_id and dd2.distribution_id = dd.distribution_id ) and books.book_type_code = :p_book and books.asset_id = dh.asset_id and books.date_placed_in_service between nvl(:p_from_date, books.date_placed_in_service) and nvl(:p_to_date, books.date_placed_in_service) and books.period_counter_fully_retired is null and books.date_ineffective is null group by fsc.company_name, fsc.book, fsc.cur_period, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), emp.full_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, null, loc.location_id, 'ALL', 'Y', 'VALUE'), ad.asset_number || ' - ' || ad.description, dh.units_assigned, ad.serial_number, ad.tag_number, decode(ad.asset_type,'CIP', 'C', 'EXPENSED','E',''), decode(greatest(books.date_placed_in_service,nvl(:p_from_date, books.date_placed_in_service)) ,least(books.date_placed_in_service,nvl(:p_to_date, books.date_placed_in_service)) ,1, 0), decode(dd.deprn_source_code,'B', dd.addition_cost_to_clear, dd.cost), dd.deprn_reserve union all select fsc.company_name, fsc.book, fsc.cur_period, emp.full_name owner, ad.asset_number || ' - ' || ad.description asset, sum(decode(lu.lookup_code ,'ADDITION COST',decode(adj.source_type_code ,'TRANSFER',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,'RETIREMENT',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,'CIP RETIREMENT',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,'RECLASS',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned,0 ) ,0 ) ) units, ad.serial_number serial, ad.tag_number tag, sum(decode(lu.lookup_code, 'ADDITION COST', decode(adj.debit_credit_flag, 'DR', 1, -1) * adj.adjustment_amount,0)) cost, sum(decode(lu.lookup_code ,'DEPRECIATION RESERVE', decode(adj.debit_credit_flag, 'DR', -1, 1) * adj.adjustment_amount , 0) ) reserve, decode(greatest(books.date_placed_in_service,nvl(:p_from_date, books.date_placed_in_service)) ,least(books.date_placed_in_service,nvl(:p_to_date, books.date_placed_in_service)) ,1, 0) new, decode(ad.asset_type,'CIP', 'C', 'EXPENSED','E','') asset_type, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE') d_comp_code1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE') d_cost_ctr1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, null, loc.location_id, 'ALL', 'Y', 'VALUE') d_location1 from ( select company_name, category_flex_structure, location_flex_structure, asset_key_flex_structure, fa_fas410_xmlp_pkg.bookformula() book, fa_fas410_xmlp_pkg.cur_periodformula(fa_fas410_xmlp_pkg.bookformula()) cur_period, fa_fas410_xmlp_pkg.report_nameformula() report_name, fa_fas410_xmlp_pkg.accounting_flex_structure_p accounting_flex_structure, fa_fas410_xmlp_pkg.currency_code_p currency_code, fa_fas410_xmlp_pkg.book_class_p book_class, fa_fas410_xmlp_pkg.distribution_source_book_p distribution_source_book, fa_fas410_xmlp_pkg.cur_period_pc_p cur_period_pc from fa_system_controls ) fsc, per_people_f emp, fa_additions ad, fa_locations loc, gl_code_combinations cc, fa_books books, fa_adjustments adj, fa_distribution_history dh, fa_lookups lu where dh.book_type_code = :p_book and dh.assigned_to = emp.person_id(+) and dh.date_effective between nvl(emp.effective_start_date,dh.date_effective) and nvl(emp.effective_end_date,dh.date_effective) and fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.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#', cc.chart_of_accounts_id, null, cc.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#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE')) and dh.asset_id = ad.asset_id and dh.location_id = loc.location_id and dh.code_combination_id = cc.code_combination_id and dh.date_ineffective is null and lu.lookup_type = 'JOURNAL ENTRIES' and ( (adj.adjustment_type in ('COST','CIP COST') and lu.lookup_code = 'ADDITION COST') or (adj.adjustment_type = 'RESERVE' and lu.lookup_code = 'DEPRECIATION RESERVE') ) and adj.source_type_code not in ('DEPRECIATION','ADDITION', 'CIP ADDITION') and adj.book_type_code = :p_book and adj.asset_id = dh.asset_id and adj.distribution_id = dh.distribution_id and adj.period_counter_created = fsc.cur_period_pc and books.book_type_code = :p_book and books.asset_id = dh.asset_id and books.date_placed_in_service between nvl(:p_from_date, books.date_placed_in_service) and nvl(:p_to_date, books.date_placed_in_service) and books.period_counter_fully_retired is null and books.date_ineffective is null group by fsc.company_name, fsc.book, fsc.cur_period, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', cc.chart_of_accounts_id, null, cc.code_combination_id, 'FA_COST_CTR', 'Y', 'VALUE'), emp.full_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, null, loc.location_id, 'ALL', 'Y', 'VALUE'), ad.asset_number || ' - ' || ad.description, decode(lu.lookup_code,'ADDITION COST',decode(adj.source_type_code ,'TRANSFER',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,'RETIREMENT',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,'CIP RETIREMENT',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,'RECLASS',decode(adj.debit_credit_flag,'DR',1,-1)*dh.units_assigned ,0) ,0), ad.serial_number, ad.tag_number, decode(ad.asset_type,'CIP', 'C', 'EXPENSED','E',''), decode(greatest(books.date_placed_in_service,nvl(:p_from_date, books.date_placed_in_service)) , least(books.date_placed_in_service,nvl(:p_to_date, books.date_placed_in_service)) , 1, 0), decode(lu.lookup_code,'ADDITION COST', decode(adj.debit_credit_flag, 'DR', 1, -1) * adj.adjustment_amount,0), decode(lu.lookup_code,'DEPRECIATION RESERVE',decode(adj.debit_credit_flag, 'DR', -1, 1) * adj.adjustment_amount,0) order by 13, 14, 4, 15, 5 ) x Y OFA FAS410_XML AR FA Asset Inventory Application: الأصول Source: تقرير مخزون الأصل (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG D FA Asset Inventory Application: Anlagen Source: Anlagen-Inventurliste (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG E FA Asset Inventory Informe de inventario de activos estándar de Oracle importado Fuente: Informe de inventario de activos (XML) Nombre corto: FAS410_XML Paquete DB: FA_FAS410_XMLP_PKG F FA Asset Inventory Application: Assets Source: Etat d'inventaire des immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG I FA Asset Inventory Application: Assets Source: Rapporto Cespiti in inventario (XML) - non supportato: riservato per usi futuri Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG JA FA Asset Inventory Oracle標準の資産インベントリレポートをインポート 出典資産インベントリーレポート（XML 短縮名。FAS410_XML DBパッケージ。FA_FAS410_XMLP_PKG KO FA Asset Inventory 가져온 Oracle 표준 자산 재고 보고서 출처 : 자산 재고 보고서 (XML) 짧은 이름 : FAS410_XML DB 패키지 : FA_FAS410_XMLP_PKG PTB FA Asset Inventory Relatório de inventário de ativos padrão importado da Oracle Fonte: Relatório de inventário de ativos (XML) Nome curto: FAS410_XML Pacote DB: FA_FAS410_XMLP_PKG RU FA Asset Inventory Импортированный стандартный отчет об инвентаризации активов Oracle Источник: Отчет об инвентаризации активов (XML) Короткое имя: FAS410_XML БД-пакет: FA_FAS410_XMLP_PKG S FA Asset Inventory Importerad Oracle standardtillgångsrapport Källa: XML (Asset Inventory Report) Kort namn: FAS410_XML DB-paket: FA_FAS410_XMLP_PKG TR FA Asset Inventory Oracle standart varlık envanteri raporu içe aktarıldı Kaynak: Varlık Envanteri Raporu (XML) Kısa isim: FAS410_XML DB paketi: FA_FAS410_XMLP_PKG US FA Asset Inventory Imported Oracle standard asset inventory report Source: Asset Inventory Report (XML) Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG ZHS FA Asset Inventory Application: 资产 Source: 资产库存报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS410_XML DB package: FA_FAS410_XMLP_PKG Enginatics R12 only &balancing_segment_p &cost_center_p :accounting_flex_structure :book_class :cur_period_pc :currency_code :distribution_source_book :p_book :p_conc_request_id :p_end_cc :p_from_date :p_min_precision :p_start_cc :p_to_date 1 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 F Livre I Registro US Book ZHS 帐簿 2 &balancing_segment_p select fifsv.form_left_prompt from fa_book_controls fbc, fnd_segment_attribute_values fsav, fnd_id_flex_segments_vl fifsv where fbc.book_type_code=:p_book and fbc.accounting_flex_structure=fsav.id_flex_num and fsav.application_id=101 and fsav.id_flex_code='GL#' and fsav.segment_attribute_type='GL_BALANCING' and fsav.attribute_value='Y' and fsav.application_id=fifsv.application_id and fsav.id_flex_code=fifsv.id_flex_code and fsav.id_flex_num=fifsv.id_flex_num and fsav.application_column_name=fifsv.application_column_name F Livre US Book 3 &cost_center_p select fifsv.form_left_prompt from fa_book_controls fbc, fnd_segment_attribute_values fsav, fnd_id_flex_segments_vl fifsv where fbc.book_type_code=:p_book and fbc.accounting_flex_structure=fsav.id_flex_num and fsav.application_id=101 and fsav.id_flex_code='GL#' and fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y' and fsav.application_id=fifsv.application_id and fsav.id_flex_code=fifsv.id_flex_code and fsav.id_flex_num=fifsv.id_flex_num and fsav.application_column_name=fifsv.application_column_name F Livre US Book 4 20 :p_start_cc LOV GL Cost Center C2E95E107C034779E0530100007F5F55 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value AR من مركز التكلفة D Von Kostenstelle F Du centre de coût I Centro di costo - Da US From Cost Center ZHS 自成本中心 5 30 :p_end_cc LOV GL Cost Center C2E95E107C034779E0530100007F5F55 Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where gl_security_pkg.validate_segval(fifsgv.segment_num,null,ffvv.flex_value)='TRUE' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='FA_COST_CTR' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and (:$flex$.chart_of_accounts_id is not null or :$flex$.chart_of_accounts is not null or :$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null or :$flex$.book is not null) and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and ( fifsv.id_flex_num=:$flex$.chart_of_accounts_id or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y' or (:$flex$.operating_unit is not null or :$flex$.ledger is not null or :$flex$.ledger_category is not null) and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from gl_ledgers gl where (:$flex$.operating_unit is null or gl.ledger_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) and (:$flex$.ledger is null or xxen_util.contains(:$flex$.ledger,gl.name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) ) ) or fifsgv.id_flex_num in (select fbc.accounting_flex_structure from fa_book_controls fbc where xxen_util.contains(:$flex$.book,fbc.book_type_code)='Y') ) ) order by ffvv.flex_value AR إلى مركز تكلفة D Bis Kostenstelle F Vers le centre de coût I Centro di costo - A US To Cost Center ZHS 至成本中心 6 40 :p_from_date Date AR من تاريخ بدء الخدمة D Von Datum Inbetriebnahme F De la date de mise en service I Data inizio utilizzo - Da US From Date Placed in Service ZHS 启用起始日期 7 50 :p_to_date Date AR إلى تاريخ بدء الخدمة D Bis Datum Inbetriebnahme F Date de mise en service I Data inizio utilizzo - A US To Date Placed in Service ZHS 启用截止日期 :$flex$.book Book From Cost Center :$flex$.book Book To Cost Center