ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDF2A79D2E0530100007F1FF2 INV Subinventory Y select msi.secondary_inventory_name value, msi.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msi where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msi.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msi.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or xxen_util.contains(:$flex$.organization_code,mp.organization_id)='Y' ) and mp.organization_id=msi.organization_id order by mp.organization_code, msi.secondary_inventory_name US 357B15AE262606FAE06362FB0905B36DY select y.* from ( select /*+ push_pred(x) push_pred(rctla) */ gl.name ledger, haouv.name operating_unit, mta.organization_code, mta.transaction_date, (select gp.period_name from gl_periods gp where mta.transaction_date>=gp.start_date and mta.transaction_date<gp.end_date+1 and gl.period_set_name=gp.period_set_name and gl.accounted_period_type=gp.period_type and gp.adjustment_period_flag='N') period, to_number(to_char(mta.transaction_date,'yyyy')) year, to_number(to_char(mta.transaction_date,'ww')) week, msiv.description, mtst.transaction_source_type_name source_type, mtt.transaction_type_name transaction_type, case when mta.transaction_source_type_id in (2,8,12,101) then msok.concatenated_segments when mta.transaction_source_type_id=1 then pha.segment1 when mta.transaction_source_type_id=3 then gcck2.concatenated_segments when mta.transaction_source_type_id=4 then (select mtrh.request_number from mtl_txn_request_headers mtrh where mmt.transaction_source_id=mtrh.header_id) when mta.transaction_source_type_id=5 then (select we.wip_entity_name from wip_entities we where mmt.transaction_source_id=we.wip_entity_id) when mta.transaction_source_type_id=6 then mgdk.concatenated_segments when mta.transaction_source_type_id=7 then (select prha.segment1 from po_requisition_headers_all prha where mmt.transaction_source_id=prha.requisition_header_id) when mta.transaction_source_type_id=9 then (select mcch.cycle_count_header_name from mtl_cycle_count_headers mcch where mmt.transaction_source_id=mcch.cycle_count_header_id and mmt.organization_id=mcch.organization_id) when mta.transaction_source_type_id=10 then (select mpi.physical_inventory_name from mtl_physical_inventories mpi where mmt.transaction_source_id=mpi.physical_inventory_id and mmt.organization_id=mpi.organization_id) when mta.transaction_source_type_id=11 then (select ccu.description from cst_cost_updates ccu where mmt.transaction_source_id=ccu.cost_update_id) else nvl(mmt.transaction_source_name, to_char(mmt.transaction_source_id)) end source, nvl(oola.line_number,pla.line_num) source_line, case when mmt.transaction_action_id=3 then decode(mmt.organization_id,mta.organization_id,mmt.subinventory_code,mmt.transfer_subinventory) when mmt.transaction_action_id in (2,28) then decode(sign(mta.primary_quantity),-1,mmt.subinventory_code,1,mmt.transfer_subinventory,mmt.subinventory_code) else mmt.subinventory_code end subinventory, gcck.concatenated_segments account_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('acc desc','SQLGL','GL#',gcck.chart_of_accounts_id,null,gcck.code_combination_id,'ALL','Y','DESCRIPTION') account_segments_description, xxen_util.meaning(mta.accounting_line_type,'CST_ACCOUNTING_LINE_TYPE',700) accounting_type, msiv.concatenated_segments item, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, --mck.concatenated_segments category, &category_columns decode(mta.transaction_source_type_id,11,mmt.quantity_adjusted, mta.primary_quantity) quantity, muomv.unit_of_measure_tl primary_uom, decode(mmt.transaction_action_id,30, abs(nvl(mta.rate_or_amount,mta.base_transaction_value/decode(mta.primary_quantity,0,1,null,1,mta.primary_quantity))), abs(nvl(mta.rate_or_amount,mta.base_transaction_value/decode(mta.primary_quantity,0,1,null,1,mta.primary_quantity)))*sign(mta.base_transaction_value)*sign(mta.primary_quantity) ) base_unit_cost, mta.base_transaction_value, nvl(:p_currency_code,gl.currency_code) currency, nvl(:p_exchange_rate,1) exchange_rate, decode(mmt.transaction_action_id,30, abs(round(nvl(mta.rate_or_amount,mta.base_transaction_value/decode(mta.primary_quantity,0,1,null,1,mta.primary_quantity))*nvl(:p_exchange_rate,1),:p_ext_prec)), abs(round(nvl(mta.rate_or_amount,mta.base_transaction_value/decode(mta.primary_quantity,0,1,null,1,mta.primary_quantity))*nvl(:p_exchange_rate,1),:p_ext_prec))*sign(mta.base_transaction_value)*sign(mta.primary_quantity) ) unit_cost, nvl(mta.base_transaction_value,0)*nvl(:p_exchange_rate,1) transaction_value, (select mtr.reason_name from mtl_transaction_reasons mtr where mmt.reason_id=mtr.reason_id) transaction_reason, &lp_sla_columns case when mmt.transaction_source_type_id in (2,8,12,101) then rcta.trx_number when mmt.transaction_source_type_id=1 and mmt.source_code='RCV' then (select distinct max(aia.invoice_num) keep (dense_rank last order by aia.invoice_id) from ap_invoice_distributions_all aida, ap_invoices_all aia where rt.po_distribution_id=aida.po_distribution_id and aida.invoice_id=aia.invoice_id) end invoice_number, coalesce(aps.segment1,hca.account_number) vendor_or_customer_number, coalesce(aps.vendor_name,hp.party_name) vendor_or_customer_name, xxen_util.user_name(mta.created_by) created_by, xxen_util.client_time(mta.creation_date) creation_date, xxen_util.user_name(mta.last_updated_by) last_updated_by, xxen_util.client_time(mta.last_update_date) last_update_date, mta.transaction_id, mta.inv_sub_ledger_id, mta.gl_batch_id, mta.set_of_books_id, mmt.transaction_type_id, mmt.transaction_action_id, mta.transaction_source_type_id, mta.transaction_source_id from ( select mta.*, ood.organization_code, ood.operating_unit, ood.set_of_books_id from mtl_transaction_accounts mta, org_organization_definitions ood where mta.organization_id=ood.organization_id ) mta, mtl_material_transactions mmt, mtl_system_items_vl msiv, mtl_units_of_measure_vl muomv, --mtl_category_sets_v mcsv, --mtl_item_categories mic, --mtl_categories_kfv mck, mtl_txn_source_types mtst, mtl_transaction_types mtt, gl_code_combinations_kfv gcck, hr_all_organization_units_vl haouv, gl_ledgers gl, po_headers_all pha, mtl_sales_orders_kfv msok, gl_code_combinations_kfv gcck2, mtl_generic_dispositions_kfv mgdk, oe_order_lines_all oola, oe_order_headers_all ooha, hz_cust_accounts hca, hz_parties hp, ( select distinct rctla.org_id, rctla.interface_line_attribute6, max(rctla.customer_trx_id) over (partition by rctla.org_id, rctla.interface_line_attribute6) customer_trx_id from ra_customer_trx_lines_all rctla where rctla.interface_line_context in ('INTERCOMPANY','ORDER ENTRY') and nvl(rctla.interface_line_attribute11,0)=0 and rctla.line_type='LINE' ) rctla, ra_customer_trx_all rcta, rcv_transactions rt, po_lines_all pla, ap_suppliers aps, ( select xdl.source_distribution_id_num_1, xal.ledger_id, gcck.concatenated_segments, xal.code_combination_id, gcck.chart_of_accounts_id, xah.gl_transfer_status_code, nvl(xal.entered_dr,0)-nvl(xal.entered_cr,0) entered_amount, nvl(xal.accounted_dr,0)-nvl(xal.accounted_cr,0) accounted_amount, xal.party_type_code, xal.party_id, xal.party_site_id from ( select distinct --subquery required as there are a few cases with more than one xdl records per source_distribution_id_num_1 and ledger xdl.source_distribution_id_num_1, xdl.ae_header_id, xdl.application_id, min(xdl.ae_line_num) keep (dense_rank first order by decode(xdl.accounting_line_code,'INTERCOMPANY_COGS',1,2)) over (partition by xdl.application_id,xdl.source_distribution_id_num_1,xdl.accounting_line_code,xdl.ae_header_id) ae_line_num from xla_distribution_links xdl where '&show_sla'='Y' and xdl.source_distribution_type='MTL_TRANSACTION_ACCOUNTS' ) xdl, xla_ae_lines xal, xla_ae_headers xah, xla_events xe, gl_code_combinations_kfv gcck where xdl.ae_header_id=xal.ae_header_id and xdl.ae_line_num=xal.ae_line_num and xdl.application_id=xal.application_id and xdl.ae_header_id=xah.ae_header_id and xdl.application_id=xah.application_id and xah.event_id=xe.event_id and xah.application_id=xe.application_id and nvl(xe.budgetary_control_flag,'N')='N' and xal.code_combination_id=gcck.code_combination_id ) x where 1=1 and nvl(:p_coa_id,-1)=nvl(:p_coa_id,-1) and mta.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mta.transaction_id=mmt.transaction_id and mta.inventory_item_id=msiv.inventory_item_id and mta.organization_id=msiv.organization_id and msiv.primary_uom_code=muomv.uom_code(+) and --mcsv.category_set_name=:category_set_name and --mcsv.category_set_id=mic.category_set_id and --mta.inventory_item_id=mic.inventory_item_id and --mta.organization_id=mic.organization_id and --mic.category_id=mck.category_id and mta.transaction_source_type_id=mtst.transaction_source_type_id and mmt.transaction_type_id=mtt.transaction_type_id and mta.reference_account=gcck.code_combination_id and mta.operating_unit=haouv.organization_id(+) and mta.set_of_books_id=gl.ledger_id and mta.accounting_line_type<>15 and case when mmt.transaction_source_type_id=1 then mmt.transaction_source_id end=pha.po_header_id(+) and case when mta.transaction_source_type_id in (2,8,12,101) then mta.transaction_source_id end=msok.sales_order_id(+) and case when mta.transaction_source_type_id=3 then mta.transaction_source_id end=gcck2.code_combination_id(+) and case when mta.transaction_source_type_id=6 then mta.transaction_source_id end=mgdk.disposition_id(+) and case when mmt.transaction_source_type_id in (2,8,12,101) then mmt.trx_source_line_id end=oola.line_id(+) and oola.header_id=ooha.header_id(+) and ooha.sold_to_org_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and oola.org_id=rctla.org_id(+) and to_char(oola.line_id)=rctla.interface_line_attribute6(+) and rctla.customer_trx_id=rcta.customer_trx_id(+) and case when mmt.transaction_source_type_id=1 and mmt.source_code='RCV' then mmt.source_line_id end=rt.transaction_id(+) and rt.po_line_id=pla.po_line_id(+) and pha.vendor_id=aps.vendor_id(+) and mta.inv_sub_ledger_id=x.source_distribution_id_num_1(+) and mta.set_of_books_id=x.ledger_id(+) ) y where 2=2 order by y.ledger, y.account_segments, y.transaction_date, y.source_type, y.transaction_type, y.source, y.subinventory, y.quantity, y.unit_cost, y.transaction_value INV C6E085D4702C51A9E05362FB09050512 US LSE: INV Material Account Distribution Detail Description: Material account distribution detail Application: Inventory Source: Material account distribution detail (XML) Short Name: INVTRDST_XML &category_columns &lp_sla_columns &show_sla 1=1 2=2 :p_coa_id :p_currency_code :p_exchange_rate :p_ext_prec 1 -30 :p_ext_prec Number select nvl(fc.extended_precision,1) from fnd_currencies fc where fc.currency_code=:$flex$.currency F Précision étendue US Extended Precision 2 -20 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE عرض السعر العكسي D CST_SRS_INVERSE_RATE Gegenkurs anzeigen E CST_SRS_INVERSE_RATE Visualizar Tipo de Cambio Inverso F CST_SRS_INVERSE_RATE Afficher taux inverse I CST_SRS_INVERSE_RATE Visualizza tasso inverso JA CST_SRS_INVERSE_RATE 逆数レートの表示 KO CST_SRS_INVERSE_RATE 역산율 표시 PTB CST_SRS_INVERSE_RATE Exibir Taxa de Inversão RU CST_SRS_INVERSE_RATE Вывод обратного курса S CST_SRS_INVERSE_RATE Visa inverterad kurs TR CST_SRS_INVERSE_RATE Ters Kuru Görüntüle US CST_SRS_INVERSE_RATE Display Inverse Rate ZHS CST_SRS_INVERSE_RATE 显示逆汇率 3 -10 :p_rate_type Number fnd_profile.value('CST_EXCHANGE_RATE_TYPE') Y AR CST_SRS_RATE_TYPE نوع سعر الصرف D CST_SRS_RATE_TYPE Wechselkursart E CST_SRS_RATE_TYPE Clase de Tipo de Cambio F CST_SRS_RATE_TYPE Type de taux de change I CST_SRS_RATE_TYPE Tipo di tasso di cambio JA CST_SRS_RATE_TYPE 換算レート・タイプ KO CST_SRS_RATE_TYPE 환율 유형 PTB CST_SRS_RATE_TYPE Tipo de Taxa de Câmbio RU CST_SRS_RATE_TYPE Тип обменного курса S CST_SRS_RATE_TYPE Växelkurstyp TR CST_SRS_RATE_TYPE Döviz Kuru Tipi US CST_SRS_RATE_TYPE Exchange Rate Type ZHS CST_SRS_RATE_TYPE 汇率类型 4 -5 :p_coa_id Number select coalesce( (select ood.chart_of_accounts_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y' and rownum=1), (select gsob.chart_of_accounts_id from hr_operating_units hou, gl_sets_of_books gsob where hou.set_of_books_id = gsob.set_of_books_id and xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y' and rownum=1), (select gsob.chart_of_accounts_id from gl_sets_of_books gsob where xxen_util.contains(:$flex$.ledger,gsob.name) = 'Y' and rownum <= 1), (select ood.chart_of_accounts_id from org_organization_definitions ood where ood.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')), (select oav.chart_of_accounts_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id and rownum=1) ) from dual US Chart of Accounts ID 5 10 1=1 gl.name=:ledger LOV custom Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_sets_of_books gl, fnd_id_flex_structures_vl fifsv where gl.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and gl.set_of_books_id in (select oav.set_of_books_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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, gl.name F Grand livre US Ledger 6 20 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name F Unité d'exploitation US Operating Unit 7 30 1=1 mta.organization_code=:organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select organization_code from mtl_parameters where organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Code de l'organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Code Organization ZHS 组织 组织 8 40 1=1 mta.transaction_date>=:transaction_date_from Date AR تواريخ الحركات من تاريخ حركة من D Von Transaktionsdatum Von Transaktionsdatum E De Fecha de Transacción De Fecha de Transacción F Date de la transaction Du Date du mouvement - Du : I Date transazione - Da Data transazione minima JA 取引日:自 取引日:自 KO 트랜잭션 일자: 부터 트랜잭션 일자 하한 PTB Datas Transação - De Data de Transação - Inferior RU Даты транзакций с Дата транзакции с S Från transaktionsdatum Från transaktionsdatum TR İşlem Tarihleri: İlk İşlem Tarihi Alt Değeri US Transaction Date From Transaction Date Low ZHS 事务处理起始日期 事务处理日期下限 9 50 1=1 mta.transaction_date<:transaction_date_to+1 Date last_day(:$flex$.transaction_date_from) AR إلى تاريخ حركة إلى D Bis Bis Transaktionsdatum E A A Fecha de Transacción F Date de la transaction au Date du mouvement - Au : I A Data transazione massima JA 至 取引日:至 KO 까지 트랜잭션 일자 상한 PTB Até Data de Transação - Superior RU По Дата транзакции по S Till Till transaktionsdatum TR Son İşlem Tarihi Üst Değeri US Transaction Date To Transaction Date High ZHS 至 事务处理日期上限 10 60 1=1 gcck.concatenated_segments=:account LOV custom Y Y select gcck.concatenated_segments value, fifsv.id_flex_structure_name||': '||xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck, fnd_id_flex_structures_vl fifsv where gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and gcck.chart_of_accounts_id = :$flex$.chart_of_accounts_id and gcck.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by gcck.concatenated_segments US Account 11 70 1=1 select 'gcck.'||lower(seg.application_column_name)||'>='''|| seg_val.segment_value||''''||decode(seg.segment_num,seg.max_segment_num,null,' and') text from ( select row_number() over (order by fifs.segment_num) seq, fifs.application_column_name, fifs.segment_num, max(fifs.segment_num) over () max_segment_num from fnd_id_flex_segments fifs where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=:p_coa_id and fifs.enabled_flag='Y' order by fifs.segment_num ) seg, ( select level seq, regexp_substr(x.concatenated_segments,x.regexp_s,1,level) segment_value from ( select :p_account_from concatenated_segments, '[^' || fifs.concatenated_segment_delimiter || ']+' regexp_s from fnd_id_flex_structures fifs where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=:p_coa_id ) x connect by level<=regexp_count(x.concatenated_segments,x.regexp_s) ) seg_val where seg.seq = seg_val.seq order by seg.seq LOV custom Y select gcck.concatenated_segments value, fifsv.id_flex_structure_name||': '||xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck, fnd_id_flex_structures_vl fifsv where gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and gcck.chart_of_accounts_id = :$flex$.chart_of_accounts_id and gcck.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by gcck.concatenated_segments AR حسابات من من حساب D Von Konto Von Konto E De Cuenta De Cuenta F Compte de Compte - De I Conti - Da Conto - minimo JA 勘定科目:自 勘定科目:自 KO 계정: From 계정 하한 PTB Contas - De Conta Inferior RU Счета с Счет с S Från konton Från konto TR Hesaplar, İlk Hesap Alt Değeri US Account From Account Low ZHS 帐户自 帐户下限 12 80 1=1 select 'gcck.'||lower(seg.application_column_name)||'<='''|| seg_val.segment_value||''''||decode(seg.segment_num,seg.max_segment_num,null,' and') text from ( select row_number() over (order by fifs.segment_num) seq, fifs.application_column_name, fifs.segment_num, max(fifs.segment_num) over () max_segment_num from fnd_id_flex_segments fifs where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=:p_coa_id and fifs.enabled_flag='Y' order by fifs.segment_num ) seg, ( select level seq, regexp_substr(x.concatenated_segments,x.regexp_s,1,level) segment_value from ( select :p_account_to concatenated_segments, '[^' || fifs.concatenated_segment_delimiter || ']+' regexp_s from fnd_id_flex_structures fifs where fifs.application_id=101 and fifs.id_flex_code='GL#' and fifs.id_flex_num=:p_coa_id ) x connect by level<=regexp_count(x.concatenated_segments,x.regexp_s) ) seg_val where seg.seq = seg_val.seq order by seg.seq LOV custom Y select gcck.concatenated_segments value, fifsv.id_flex_structure_name||': '||xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck, fnd_id_flex_structures_vl fifsv where gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' and gcck.chart_of_accounts_id = :$flex$.chart_of_accounts_id and gcck.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by gcck.concatenated_segments :$flex$.Account_From AR إلى 2 إلى حساب D Bis 2 Bis Konto E A 2 A Cuenta F Compte à Compte - A I A 2 Conto - massimo JA 至 2 勘定科目:至 KO 까지 2 계정 상한 PTB Até 2 Conta Superior RU По 2 Счет по S Till 2 Till konto TR Son 2 Hesap Üst Değeri US Account To Account High ZHS 至 2 帐户上限 13 90 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'msiv') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) F Ensemble de la catégorie Category Set Name US Category Set 1 Category Set Name 14 100 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'msiv') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) AR الفئات من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégorie de Catégorie - De I Categorie - Da Categoria (min) JA カテゴリ:自 カテゴリ:下位 KO 범주: 부터 범주 하한 PTB Categorias - De Categoria - Inferior RU Категории с Категория с S Från kategorier Från kategori TR Kategoriler - İlk Kategori Alt Değeri US Category Set 2 Category Low ZHS 类别自 类别下限 15 105 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'msiv') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 16 110 1=1 msiv.concatenated_segments=:item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments AR الأصناف من صنف من D Von Artikel Von Artikel E De Artículo De Artículo F Article de Article - De I Articoli - Da Articolo - Minimo JA 品目:自 品目:下位 KO 품목: 부터 품목 하한 PTB Itens - De Item Inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem Alt Değeri US Item ZHS 物料自 物料下限 17 120 2=2 x.subinventory=:subinventory LOV INV Subinventory 8E2FF36EDF2A79D2E0530100007F1FF2 Y select msi.secondary_inventory_name value, msi.description||' ('||mp.organization_code||')' description from mtl_parameters mp, mtl_secondary_inventories msi where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msi.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msi.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or xxen_util.contains(:$flex$.organization_code,mp.organization_id)='Y' ) and mp.organization_id=msi.organization_id order by mp.organization_code, msi.secondary_inventory_name AR المخازن من مخزن من D Von Lager Von Lager E De Subalmacén De Subalmacén F Sous-inventaire De Magasin - De I Sottomagazzini - Da Sottomagazzino - Da JA 保管場所:自 保管場所:下位 KO 창고: 부터 창고 하한 PTB Subinventários - De Subinventário - Inferior RU Складские подразделения с Складское подразделение с S Från lagerställen Från lagerställe TR Stok Yerleri, İlk Stok Yeri İlk: US Subinventory ZHS 子库存自 子库存下限 18 140 1=1 mta.base_transaction_value>=:transaction_value_from Number AR قيم الحركة من قيمة حركة من D Von Transaktionswert Von Transaktionswert E De Valor Transacción De Valor de Transacción F Valeur de la transaction De Valeur mouvement - De I Valori transazione - Da Valore transazione - Da JA 取引値:自 取引価額:下位 KO 트랜잭션 값: 부터 트랜잭션 값 하한 PTB ValoresTransação - De Valor da Transação - Inferior RU Стоимости транзакций с Стоимость транзакции с S Från transaktionsvärden Transaktionsvärde från TR İşlem Değerleri, İlk İşlem Değeri İlk: US Transaction Value From ZHS 事务处理值自 事务处理值下限 19 150 1=1 mta.base_transaction_value <=:transaction_value_to Number AR إلى 6 قيمة حركة إلى D Bis 6 Bis Transaktionswert E A 6 A Valor de Transacción F Valeur de la transaction à Valeur mouvement - A I A 6 Valore transazione - A JA 至 6 取引価額:上位 KO 까지 6 트랜잭션 값 상한 PTB Até 6 Valor da Transação - Superior RU По 6 Стоимость транзакции по S Till 6 Transaktionsvärde till TR Son 6 İşlem Değeri Son: US Transaction Value To ZHS 至 6 事务处理值上限 20 160 1=1 mta.gl_batch_id=:gl_batch_id LOV custom Y select ogb.gl_batch_id value, oap.period_name||' '||to_char(ogb.gl_batch_date,'DD-MON-YYYY')||' '||ogb.description description from org_gl_batches ogb, org_acct_periods oap where oap.organization_id=ogb.organization_id and oap.acct_period_id=ogb.acct_period_id and ogb.organization_id in (select ood.organization_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' or (:$flex$.organization_code is null and ood.operating_unit in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) or (:$flex$.organization_code is null and :$flex$.operating_unit is null and ood.set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where xxen_util.contains(:$flex$.ledger,gsob.name)='Y')) or (:$flex$.organization_code is null and :$flex$.operating_unit is null and :$flex$.ledger is null and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.responsibility_id = fnd_global.resp_id and oav.resp_application_id = fnd_global.resp_appl_id) ) and rownum <=1 ) order by ogb.creation_date desc AR مجموعة أ/ع مجموعة أ/ع D Stapel Stapel E Lote Contable Lote Contable F Lot GL Lot GL I Batch GL Batch GL JA GLバッチ GLバッチ KO GL 뱃치 GL 뱃치 PTB Lote GL Lote GL RU Пакет ГК Пакет ГК S Huvudboksbunt Huvudboksbunt TR GL İşlem Grubu GL İşlem Grubu US GL Batch ZHS GL 批 GL 批 21 170 1=1 select case when :p_source_type_id=7 and :transaction_type_id=54 then 'mta.transaction_source_type_id=8 and mmt.transaction_action_id=3' else 'mta.transaction_source_type_id=:p_source_type_id' end text from dual LOV custom Y select mtst.transaction_source_type_id id, mtst.transaction_source_type_name value, mtst.transaction_source_type_id description from mtl_txn_source_types mtst order by mtst.transaction_source_type_name AR نوع مصدر الحركة نوع المصدر D Transaktionsherkunftsart Bezugsart E Tipo de Origen de la Transacción Tipo de Origen F Type de source de transaction Type d'origine I Tipo origine transazione Tipo di origine JA 取引ソース・タイプ ソース・タイプ KO 트랜잭션 출처 유형 출처 유형 PTB Tipo Origem Transação Tipo de Origem RU Тип источника транзакции Тип источника S Typ av transaktionskälla Källtyp TR İşlem Kaynak Tipi Kaynak Tipi US Transaction Source Type ZHS 事务处理来源类型 来源类型 22 180 2=2 x.source>=:source_from Char AR مصادر من مصدر من D Von Herkunft Von Herkunft E De Origen De Origen F Source de Origine - De I Origini - Da Origine - Da JA ソース:自 ソース:下位 KO 출처: 부터 출처 하한 PTB Origens - De Origem - Inferior RU Источники с Источник с S Från källor Källor från TR Kaynaklar, İlk İlk Kaynak US Source From ZHS 来源自 来源下限 23 190 2=2 x.source<=:source_to Char :$flex$.source_from AR إلى 7 مصدر إلى D Bis 7 Bis Herkunft E A 7 A Origen F Source à Origine - A I A 7 Origine - A JA 至 7 ソース:上位 KO 까지 7 출처 상한 PTB Até 7 Origem - Superior RU По 7 Источник по S Till 7 Källor till TR Son 7 Son Kaynak US Source To ZHS 至 7 来源上限 24 200 1=1 mmt.transaction_type_id=:transaction_type_id LOV custom Y select mtt.transaction_type_id id, mtt.transaction_type_name value, mtt.description||' ('||mtt.transaction_type_id||')' description from mtl_transaction_types mtt where :$flex$.transaction_source_type is null or mtt.transaction_source_type_id=:$flex$.transaction_source_type or mtt.transaction_source_type_id=8 and :$flex$.transaction_source_type=7 and mtt.transaction_type_id=54 order by mtt.transaction_type_name AR نوع الحركة نوع الحركة D Transaktionsart Transaktionsart E Tipo de Transacción Tipo de Transacción F Type de transaction Type de mouvement I Tipo di transazione Tipo di transazione JA 取引タイプ 取引タイプ KO 트랜잭션 유형 트랜잭션 유형 PTB Tipo de Transação Tipo de Transação RU Тип транзакции Тип транзакции S Transaktionstyp Transaktionstyp TR İşlem Tipi İşlem Tipi US Transaction Type ZHS 事务处理类型 事务处理类型 25 210 1=1 mmt.reason_id=:reason_id LOV Oracle INV_SRS_TXN_REASON_SGL Y select reason_id id, reason_name value, description description from mtl_transaction_reasons order by value,description AR سبب الحركة سبب الحركة D Transaktionsgrund Transaktionsgrund E Motivo de Transacción Motivo de Transacción F Motif de la transaction Motif du mouvement I Motivo transazione Motivo transazione JA 取引事由 取引事由 KO 트랜잭션 사유 트랜잭션 사유 PTB Motivo Transação Motivo Transação RU Основание транзакции Основание транзакции S Transaktionsorsak Transaktionsorsak TR İşlem Nedeni İşlem Nedeni US Transaction Reason ZHS 事务处理原因 事务处理原因 26 220 :p_currency_code LOV custom Y select fcv.currency_code value, fcv.description description from fnd_currencies_vl fcv where trunc(nvl(fcv.start_date_active,sysdate-1))<sysdate and trunc(nvl(fcv.end_date_active,sysdate+1))>sysdate and 1 = (select count(distinct gsob.currency_code) from gl_sets_of_books gsob where (xxen_util.contains(:$flex$.ledger,gsob.name) = 'Y' or gsob.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') or gsob.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y') or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and gsob.set_of_books_id in (select oav.set_of_books_id from org_access_view oav where oav.responsibility_id = fnd_global.resp_id and oav.resp_application_id = fnd_global.resp_appl_id) ) ) ) order by value,description select fcv.currency_code from fnd_currencies_vl fcv where trunc(nvl(fcv.start_date_active,sysdate-1))<sysdate and trunc(nvl(fcv.end_date_active,sysdate+1))>sysdate and fcv.currency_code = (select min(gsob.currency_code) from gl_sets_of_books gsob where (xxen_util.contains(:$flex$.ledger,gsob.name) = 'Y' or gsob.set_of_books_id in (select hou.set_of_books_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y') or gsob.set_of_books_id in (select ood.set_of_books_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code) = 'Y') or (:$flex$.ledger is null and :$flex$.operating_unit is null and :$flex$.organization_code is null and gsob.set_of_books_id in (select oav.set_of_books_id from org_access_view oav where oav.responsibility_id = fnd_global.resp_id and oav.resp_application_id = fnd_global.resp_appl_id) ) ) having count(distinct gsob.currency_code) = 1 ) AR العملة العملة D Währung Währung E Divisa Divisa F Monnaie Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency ZHS 币种 币种 27 230 :p_exchange_rate LOV custom Y select distinct x.actual_rate value, x.description description from ( select cgtv.actual_rate, cgtv.period || case cgtv.inverse when 'Y' then ' (' || cgtv.display_rate || ')' end description, cgtv.period, cgtv.period_year, cgtv.period_num from cst_gl_translation_view cgtv where org_id = (select ood.organization_id from org_organization_definitions ood where ( xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' or (:$flex$.organization_code is null and ood.operating_unit in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) or (:$flex$.organization_code is null and :$flex$.operating_unit is null and ood.set_of_books_id in (select gsob.set_of_books_id from gl_sets_of_books gsob where xxen_util.contains(:$flex$.ledger,gsob.name)='Y')) or (:$flex$.organization_code is null and :$flex$.operating_unit is null and :$flex$.ledger is null and ood.organization_id in (select oav.organization_id from org_access_view oav where oav.responsibility_id = fnd_global.resp_id and oav.resp_application_id = fnd_global.resp_appl_id) ) ) and rownum <=1 ) and cgtv.code=:$flex$.currency and cgtv.inverse=:$flex$.CST_SRS_INVERSE_RATE and cgtv.rate_type=:$flex$.CST_SRS_RATE_TYPE union select 1 actual_rate, null description, null period, 0 period_year, 0 period_num from dual where :$flex$.currency is null order by period_year desc, period_num desc ) x select 1 from dual where :$flex$.currency is null Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate ZHS 汇率 汇率 28 240 &lp_sla_columns x.concatenated_segments sla_account_segments, fnd_flex_xml_publisher_apis.process_kff_combination_1('acc desc','SQLGL','GL#',x.chart_of_accounts_id,null,x.code_combination_id,'ALL','Y','DESCRIPTION') sla_account_segments_desc, xxen_util.meaning(x.gl_transfer_status_code,'XLA_ACCT_TRANSFER',602) sla_gl_tfr_status, x.entered_amount sla_entered_amount, x.accounted_dr, x.accounted_cr, x.accounted_amount sla_accounted_amount, x.ae_header_id xla_header_id, x.ae_line_num xla_line_num LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where fnd_release.major_version>=12 select 'Y' from dual where fnd_release.major_version>=12 US Show SLA Accounting 29 &show_sla Y US Show SLA Accounting :$flex$.Account_From Account From Account To :$flex$.CST_SRS_INVERSE_RATE CST_SRS_INVERSE_RATE Exchange Rate :$flex$.CST_SRS_RATE_TYPE CST_SRS_RATE_TYPE Exchange Rate :$flex$.chart_of_accounts_id Chart of Accounts ID Account :$flex$.chart_of_accounts_id Chart of Accounts ID Account From :$flex$.chart_of_accounts_id Chart of Accounts ID Account To :$flex$.currency Currency Exchange Rate :$flex$.currency Currency Extended Precision :$flex$.ledger Ledger Chart of Accounts ID :$flex$.ledger Ledger Currency :$flex$.ledger Ledger Exchange Rate :$flex$.ledger Ledger GL Batch :$flex$.ledger Ledger Operating Unit :$flex$.ledger Ledger Organization Code :$flex$.operating_unit Operating Unit Chart of Accounts ID :$flex$.operating_unit Operating Unit Currency :$flex$.operating_unit Operating Unit Exchange Rate :$flex$.operating_unit Operating Unit GL Batch :$flex$.operating_unit Operating Unit Organization Code :$flex$.organization_code Organization Code Category Set 1 :$flex$.organization_code Organization Code Category Set 2 :$flex$.organization_code Organization Code Category Set 3 :$flex$.organization_code Organization Code Chart of Accounts ID :$flex$.organization_code Organization Code Currency :$flex$.organization_code Organization Code Exchange Rate :$flex$.organization_code Organization Code GL Batch :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Subinventory :$flex$.source_from Source From Source To :$flex$.transaction_date_from Transaction Date From Y Transaction Date To :$flex$.transaction_source_type Transaction Source Type Transaction Type