ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE7F79D2E0530100007F1FF2 AR Account Number Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8679D2E0530100007F1FF2 AR Customer Name Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name US 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 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）限制的操作单元。 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDEF479D2E0530100007F1FF2 ONT Line Type Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and otta.transaction_type_code='LINE' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name US 8E2FF36EDEE779D2E0530100007F1FF2 ONT Order Number Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.org_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) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc Fixed bug in operating unit access restriction when the default operating unit is set to something else US 8E2FF36EDF0979D2E0530100007F1FF2 ONT Order Status Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='FLOW_STATUS' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDEE879D2E0530100007F1FF2 ONT Order Type Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and otta.transaction_type_code='ORDER' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name US 8E2FF36EDF3979D2E0530100007F1FF2 ONT Quote Number Y Y select nvl(ooha.quote_number,regexp_substr(ooha.orig_sys_document_ref,'^(\d+).',1,1,null,1)) value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where (ooha.quote_number is not null or ooha.orig_sys_document_ref is not null and ooha.source_document_type_id=16) and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.org_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) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc Fixed bug in operating unit access restriction when the default operating unit is set to something else US B93EA5B904891111E0530100007F2F7E select x.operating_unit, x.customer, x.account_number, x.order_number, x.quote_number, x.source_type, x.source_document, x.type, x.order_type, x.customer_po, hp1.party_name ship_to_customer, hca1.account_number ship_to_account, hcsua1.location ship_to_location, (select hz_format_pub.format_address(hps1.location_id,null,null,' , ') from dual) ship_to_address, ftv1.territory_short_name ship_to_country, hp2.party_name bill_to_customer, hca2.account_number bill_to_account, hcsua2.location bill_to_location, (select hz_format_pub.format_address(hps2.location_id,null,null,' , ') from dual) bill_to_address, ftv2.territory_short_name bill_to_country, x.ordered_date, x.price_list, x.salesperson, x.invoice_salesperson, x.order_source, x.order_source_reference, x.header_status, x.currency, x.subtotal, x.tax, nvl(x.line_charges_total,0)+nvl(x.header_charges,0) charges, nvl(x.subtotal,0)+nvl(x.tax,0)+nvl(x.line_charges_total,0)+nvl(x.header_charges,0) total, x.payment_terms, x.invoice_number, x.invoice_date, x.invoice_gl_date, x.invoice_status, x.invoiced_amount, x.warehouse, x.ship_method, x.line_set, x.freight_terms, x.fob, x.shipment_priority, x.shipping_instructions, x.packing_instructions, x.quantity, x.uom, x.extended_price, x.line_charges, x.tax_code, x.tax_amount, x.request_date, x.promise_date, x.schedule_ship_date, x.actual_shipment_date, x.shipped_quantity, x.shippable_flag, x.order_category, x.created_by, x.creation_date, x.last_updated_by, x.last_update_date, x.header_id from ( select -- order ooh.*, -- invoice jrrev2.resource_name invoice_salesperson, rcta.trx_number invoice_number, rcta.trx_date invoice_date, rctlgda.gl_date invoice_gl_date, xxen_util.meaning(max(rcta.status_trx) keep (dense_rank first order by rcta.customer_trx_id desc nulls last) over (partition by ooh.header_id),'PAYMENT_SCHEDULE_STATUS',222) invoice_status from ( select distinct haouv.name operating_unit, hp.party_name customer, hca.account_number, ooha.order_number, nvl(ooha.quote_number,regexp_substr(ooha.orig_sys_document_ref,'^(\d+).',1,1,null,1)) quote_number, decode(ooha.source_document_type_id,10,'Requisitions',2,'Orders',16,'Quotes',7,'Incidents',(select oos0.name from oe_order_sources oos0 where ooha.source_document_type_id=oos0.order_source_id)) source_type, case ooha.source_document_type_id when 10 then (select prha.segment1 from po_requisition_headers_all prha where ooha.source_document_id=prha.requisition_header_id) when 2 then (select to_char(ooha0.order_number) from oe_order_headers_all ooha0 where ooha.source_document_id=ooha0.header_id) when 16 then (select aqha.quote_number||':'||aqha.quote_version from aso_quote_headers_all aqha where ooha.source_document_id=aqha.quote_header_id) when 7 then (select ciab.incident_number from cs_incidents_all_b ciab where ooha.source_document_id=ciab.incident_id) end source_document, decode(ooha.transaction_phase_code,'N','Quote','Order') type, ottt.name order_type, nvl(oola.cust_po_number,ooha.cust_po_number) customer_po, xxen_util.client_time(ooha.ordered_date) ordered_date, (select qlhv.name from qp_list_headers_vl qlhv where ooha.price_list_id=qlhv.list_header_id) price_list, jrrev.resource_name salesperson, oos.name order_source, ooha.orig_sys_document_ref order_source_reference, xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660) header_status, ooha.transactional_curr_code currency, sum(decode(oola.cancelled_flag,'N',oola.extended_price)) over (partition by oola.header_id) subtotal, sum(decode(oola.cancelled_flag,'N',oola.tax_amount)) over (partition by oola.header_id) tax, sum(decode(oola.cancelled_flag,'N',oola.line_charges)) over (partition by oola.header_id) line_charges_total, (select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*opa.operand) from oe_price_adjustments opa where ooha.header_id=opa.header_id and opa.line_id is null and opa.list_line_type_code='FREIGHT_CHARGE' and opa.applied_flag='Y') header_charges, (select rtv.name from ra_terms_vl rtv where ooha.payment_term_id=rtv.term_id) payment_terms, mp.organization_code warehouse, xxen_util.meaning(ooha.shipping_method_code,'SHIP_METHOD',3) ship_method, xxen_util.meaning(ooha.customer_preference_set_code,'REQUEST_DATE_TYPE',660) line_set, xxen_util.meaning(ooha.freight_terms_code,'FREIGHT_TERMS',660) freight_terms, xxen_util.meaning(ooha.fob_point_code,'FOB',222) fob, xxen_util.meaning(ooha.shipment_priority_code,'SHIPMENT_PRIORITY',660) shipment_priority, ooha.shipping_instructions, ooha.packing_instructions, sum(oola.ordered_quantity) over (partition by oola.header_id) quantity, max(oola.order_quantity_uom) over (partition by oola.header_id) uom, sum(oola.extended_price) over (partition by oola.header_id) extended_price, sum(oola.line_charges) over (partition by oola.header_id) line_charges, max(oola.tax_code) over (partition by oola.header_id) tax_code, sum(oola.tax_amount) over (partition by oola.header_id) tax_amount, sum(oola.invoiced_amount) over (partition by oola.header_id) invoiced_amount, xxen_util.client_time(min(oola.request_date) over (partition by oola.header_id)) request_date, xxen_util.client_time(min(oola.promise_date) over (partition by oola.header_id)) promise_date, xxen_util.client_time(min(oola.schedule_ship_date) over (partition by oola.header_id)) schedule_ship_date, xxen_util.client_time(min(oola.actual_shipment_date) over (partition by oola.header_id)) actual_shipment_date, sum(oola.shipped_quantity) over (partition by oola.header_id) shipped_quantity, xxen_util.yes(max(oola.shippable_flag) over (partition by oola.header_id)) shippable_flag, xxen_util.meaning(ooha.order_category_code,'ORDER_CATEGORY',660) order_category, xxen_util.user_name(ooha.created_by) created_by, xxen_util.client_time(ooha.creation_date) creation_date, xxen_util.user_name(ooha.last_updated_by) last_updated_by, xxen_util.client_time(ooha.last_update_date) last_update_date, ooha.header_id, ooha.ship_to_org_id, ooha.invoice_to_org_id, max(oola.last_trx_id) over (partition by oola.header_id) last_trx_id from hr_all_organization_units_vl haouv, oe_order_headers_all ooha, ( select decode(oola.line_category_code,'RETURN',-1,1)*oola.unit_selling_price*oola.ordered_quantity extended_price, decode(oola.line_category_code,'RETURN',-1,1)*oola.tax_value tax_amount, ( select sum(decode(opa.credit_or_charge_flag,'C',-1,1)*decode(opa.arithmetic_operator,'LUMPSUM',case when oola.ordered_quantity>0 then opa.operand end,oola.ordered_quantity*opa.adjusted_amount)) line_charges from oe_price_adjustments opa where oola.line_id=opa.line_id and opa.list_line_type_code='FREIGHT_CHARGE' and opa.applied_flag='Y' ) line_charges, max(oola.open_flag) over (partition by oola.header_id) max_open_flag, ( select sum(rctla.extended_amount) from ra_customer_trx_lines_all rctla where rctla.interface_line_context in ('INTERCOMPANY','ORDER ENTRY') and rctla.interface_line_attribute6 = to_char(oola.line_id) and exists (select null from ra_cust_trx_line_gl_dist_all rctlgda where 2=2 and rctlgda.customer_trx_id=rctla.customer_trx_id and rctlgda.account_class='REC' and rctlgda.latest_rec_flag='Y') ) invoiced_amount, ( select max(rctla.customer_trx_id) from ra_customer_trx_lines_all rctla where rctla.interface_line_context in ('INTERCOMPANY','ORDER ENTRY') and rctla.interface_line_attribute6 = to_char(oola.line_id) and exists (select null from ra_cust_trx_line_gl_dist_all rctlgda where 2=2 and rctlgda.customer_trx_id=rctla.customer_trx_id and rctlgda.account_class='REC' and rctlgda.latest_rec_flag='Y') ) last_trx_id, oola.* from oe_order_lines_all oola ) oola, oe_transaction_types_tl ottt, hz_cust_accounts hca, hz_parties hp, oe_order_sources oos, jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev, mtl_parameters mp where 1=1 and haouv.organization_id=ooha.org_id and ooha.sold_to_org_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and ooha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and ooha.order_source_id=oos.order_source_id(+) and ooha.header_id=oola.header_id(+) and ooha.salesrep_id=jrs.salesrep_id(+) and ooha.org_id=jrs.org_id(+) and jrs.resource_id=jrrev.resource_id(+) and ooha.ship_from_org_id=mp.organization_id(+) ) ooh, ra_customer_trx_all rcta, (select rctlgda.* from ra_cust_trx_line_gl_dist_all rctlgda where rctlgda.account_class='REC' and rctlgda.latest_rec_flag='Y') rctlgda, jtf_rs_salesreps jrs2, jtf_rs_resource_extns_vl jrrev2 where 2=2 and ooh.last_trx_id=rcta.customer_trx_id(+) and rcta.customer_trx_id=rctlgda.customer_trx_id(+) and rcta.primary_salesrep_id=jrs2.salesrep_id(+) and rcta.org_id=jrs2.org_id(+) and jrs2.resource_id=jrrev2.resource_id(+) ) x, hz_cust_site_uses_all hcsua1, hz_cust_site_uses_all hcsua2, hz_cust_acct_sites_all hcasa1, hz_cust_acct_sites_all hcasa2, hz_cust_accounts hca1, hz_cust_accounts hca2, hz_parties hp1, hz_parties hp2, hz_party_sites hps1, hz_party_sites hps2, hz_locations hl1, hz_locations hl2, fnd_territories_vl ftv1, fnd_territories_vl ftv2 where x.ship_to_org_id=hcsua1.site_use_id(+) and x.invoice_to_org_id=hcsua2.site_use_id(+) and hcsua1.cust_acct_site_id=hcasa1.cust_acct_site_id(+) and hcsua2.cust_acct_site_id=hcasa2.cust_acct_site_id(+) and hcasa1.cust_account_id=hca1.cust_account_id(+) and hcasa2.cust_account_id=hca2.cust_account_id(+) and hca1.party_id=hp1.party_id(+) and hca2.party_id=hp2.party_id(+) and hcasa1.party_site_id=hps1.party_site_id(+) and hcasa2.party_site_id=hps2.party_site_id(+) and hps1.location_id=hl1.location_id(+) and hps2.location_id=hl2.location_id(+) and hl1.country=ftv1.territory_code(+) and hl2.country=ftv2.territory_code(+) order by x.operating_unit, x.account_number, x.order_number Y #,##0.00;[Red]-#,##0.00 AR ONT Order Headers تفاصيل أمر المبيعات أو تقرير رأس عرض الأسعار ، بما في ذلك معلومات الحالة والمبلغ وحالة الفاتورة. D ONT Order Headers Detaillierter Kundenauftrags- oder Angebotskopfbericht, einschließlich Status, Betrag und Rechnungsstatusinformationen. E ONT Order Headers Informe detallado de la cabecera de la orden de venta o de la cotización, incluyendo información sobre el estado, el importe y el estado de la factura. F ONT Order Headers Rapport détaillé de l'en-tête de la commande ou du devis, y compris les informations sur le statut, le montant et le statut de la facture. I ONT Order Headers Rapporto dettagliato dell'intestazione dell'ordine di vendita o del preventivo, compresi lo stato, l'importo e le informazioni sullo stato della fattura. JA ONT Order Headers ステータス、金額、請求書のステータス情報を含む、詳細な販売注文または見積書のヘッダーレポート。 KO ONT Order Headers 상태, 금액 및 송장 상태 정보를 포함한 상세 판매 주문 또는 견적 헤더 보고서. PTB ONT Order Headers Relatório detalhado da ordem de venda ou do cabeçalho da cotação, incluindo informações de status, valor e status da fatura. RU ONT Order Headers Подробный отчет по заказу на продажу или заголовку заказа, включая информацию о состоянии, сумме и счете-фактуре. S ONT Order Headers Detalj försäljningsorder eller offertrapport, inklusive status, belopp och fakturastatusinformation. TR ONT Order Headers Durum, tutar ve fatura durumu bilgilerini içeren Ayrıntılı Satış Siparişi veya Teklif başlığı raporu. US ONT Orders Detail Sales Order or Quote header report, including status, amount and invoice status information. ZHS ONT Order Headers 详细的销售订单或报价头报告，包括状态、金额和发票状态信息。 Enginatics 1=1 2=2 1 10 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) Y F Unité d'exploitation US Operating Unit 2 20 1=1 ooha.order_number=:order_number LOV ONT Order Number 8E2FF36EDEE779D2E0530100007F1FF2 Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.org_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) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc F Numéro de commande US Order Number 3 30 1=1 ( ooha.quote_number=:quote_number or ooha.orig_sys_document_ref like :quote_number||'%' and ooha.source_document_type_id=16 ) LOV ONT Quote Number 8E2FF36EDF3979D2E0530100007F1FF2 Y Y select nvl(ooha.quote_number,regexp_substr(ooha.orig_sys_document_ref,'^(\d+).',1,1,null,1)) value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where (ooha.quote_number is not null or ooha.orig_sys_document_ref is not null and ooha.source_document_type_id=16) and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.org_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) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc F Numéro de devis US Quote Number 4 40 1=1 upper(hp.party_name) like upper(:customer_name) LOV AR Customer Name 8E2FF36EDE8679D2E0530100007F1FF2 Y select hp.party_name value, hca.account_number||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Nom du client US Customer Name 5 50 1=1 hca.account_number=:account_number LOV AR Account Number 8E2FF36EDE7F79D2E0530100007F1FF2 Y Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and ( :$flex$.operating_unit is null or hca.cust_account_id in ( select hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_acct_sites_all hcasa where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' and haouv.organization_id=hcasa.org_id ) ) order by hp.party_name F Numéro de compte US Account Number 6 60 1=1 nvl(ooha.transaction_phase_code,'F')='F' LOV custom Y select 'Order' value, '' description from dual union all select 'Quote' value, '' description from dual Order US Type 7 1=1 ooha.transaction_phase_code='N' Quote US Type 8 70 1=1 ooha.order_category_code=xxen_util.lookup_code(:order_category,'ORDER_CATEGORY',660) LOV custom Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='ORDER_CATEGORY' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning F Catégorie de commande US Order Category 9 80 1=1 ottt.name=:order_type LOV ONT Order Type 8E2FF36EDEE879D2E0530100007F1FF2 Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and otta.transaction_type_code='ORDER' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name F Type de commande US Order Type 10 90 1=1 oola.line_type_id in (select ottt2.transaction_type_id from oe_transaction_types_tl ottt2 where ottt2.name=:line_type and ottt2.language=userenv('lang')) LOV ONT Line Type 8E2FF36EDEF479D2E0530100007F1FF2 Y select ottt.name value, xxen_util.meaning(otta.order_category_code,'ORDER_CATEGORY',660) description from oe_transaction_types_all otta, oe_transaction_types_tl ottt where (:$flex$.operating_unit is null or otta.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and otta.transaction_type_code='LINE' and otta.transaction_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by decode(otta.order_category_code,'ORDER',1,'MIXED',2,3), ottt.name F Type de ligne US Line Type 11 100 1=1 ooha.open_flag='Y' and oola.max_open_flag='Y' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y select 'Y' from dual where :$flex$.order_number is null F Ouvert uniquement US Open only 12 110 1=1 ooha.cancelled_flag='N' and oola.cancelled_flag='N' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y select 'Y' from dual where :$flex$.order_number is null F Exclure Annulé US Exclude Cancelled 13 120 1=1 ooha.flow_status_code=xxen_util.lookup_code(:header_status,'FLOW_STATUS',660) LOV ONT Order Status 8E2FF36EDF0979D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.lookup_type='FLOW_STATUS' and flvv.view_application_id=660 and flvv.security_group_id=0 order by flvv.meaning F Statut de la commande US Order Status 14 130 1=1 oola.schedule_ship_date>=:schedule_ship_date_from Date F Date d'expédition prévue du US Schedule Ship Date From 15 140 1=1 oola.schedule_ship_date<:schedule_ship_date_to+1 Date last_day(:$flex$.schedule_ship_date_from) F Date d'expédition prévue pour US Schedule Ship Date To 16 150 1=1 ooha.ship_to_org_id in ( select hcsua.site_use_id from fnd_territories_vl ftv, hz_locations hl, hz_party_sites hps, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where ftv.territory_short_name=:country and ftv.territory_code=hl.country and hl.location_id=hps.location_id and hps.party_site_id=hcasa.party_site_id and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id ) LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Ship To Country 17 160 1=1 ooha.invoice_to_org_id in ( select hcsua.site_use_id from fnd_territories_vl ftv, hz_locations hl, hz_party_sites hps, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where ftv.territory_short_name=:bill_to_country and ftv.territory_code=hl.country and hl.location_id=hps.location_id and hps.party_site_id=hcasa.party_site_id and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id ) LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Bill To Country 18 170 1=1 mp.organization_code=:ship_from_warehouse 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 US Ship From Warehouse 19 180 1=1 oola.request_date>=:request_date_from Date F Date de la demande US Request Date From 20 190 1=1 oola.request_date<:request_date_to+1 Date last_day(:$flex$.request_date_from) F Date de la demande au US Request Date To 21 200 1=1 ooha.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 22 210 1=1 ooha.creation_date<:creation_date_to+1 Date last_day(:$flex$.creation_date_from) F Date de création au US Creation Date To 23 220 2=2 rctlgda.gl_date>=:invoice_gl_date_from Date US Invoice GL Date From 24 230 2=2 rctlgda.gl_date<:invoice_gl_date_to+1 Date last_day(:$flex$.invoice_gl_date_from) US Invoice GL Date To :$flex$.creation_date_from Creation Date From Y Creation Date To :$flex$.invoice_gl_date_from Invoice GL Date From Y Invoice GL Date To :$flex$.operating_unit Operating Unit Account Number :$flex$.operating_unit Operating Unit Customer Name :$flex$.operating_unit Operating Unit Line Type :$flex$.operating_unit Operating Unit Order Number :$flex$.operating_unit Operating Unit Order Type :$flex$.operating_unit Operating Unit Quote Number :$flex$.operating_unit Operating Unit Ship From Warehouse :$flex$.order_number Order Number Exclude Cancelled :$flex$.order_number Order Number Open only :$flex$.request_date_from Request Date From Y Request Date To :$flex$.schedule_ship_date_from Schedule Ship Date From Y Schedule Ship Date To