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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B65C94D1841FA5BFE0530100007FB7CE with mmt as -- driving inventory transactions for intercompany ( select 'Sales Order' source_document , ooha.ordered_date source_document_date , to_char(ooha.order_number) source_document_num , oe_order_misc_pub.get_concat_line_number(oola.line_id) source_document_line_num , oola.ordered_quantity source_document_qty , oola.order_quantity_uom source_document_uom , 'INTERCOMPANY' source_line_context , oola.line_id source_line_id , to_number(hoi.org_information3) shipping_ou_id , oola.org_id selling_ou_id , mmt.transaction_id , mmt.transaction_type_id , mmt.transaction_action_id , mmt.transaction_date , mmt.organization_id , mmt.transfer_organization_id , mmt.inventory_item_id , mmt.transaction_quantity , mmt.transaction_uom , mmt.primary_quantity , mmt.transaction_cost , mmt.actual_cost , mmt.transfer_price , mmt.currency_code , mmt.currency_conversion_rate , mmt.currency_conversion_type , mmt.currency_conversion_date , mmt.costed_flag , mmt.invoiced_flag from mtl_material_transactions mmt , hr_organization_information hoi , oe_order_lines_all oola , oe_order_headers_all ooha , mtl_intercompany_parameters mip where mmt.transaction_source_type_id in (2,12) -- sales order/rma and mmt.transaction_action_id in (1,27) -- issue from stores/receipt into stores and oola.line_id = mmt.trx_source_line_id and ooha.header_id = oola.header_id and hoi.organization_id = mmt.organization_id and hoi.org_information_context = 'Accounting Information' and mip.ship_organization_id = to_number(hoi.org_information3) and mip.sell_organization_id = oola.org_id union select 'Internal Sales Order' source_document , ooha.ordered_date source_document_date , to_char(ooha.order_number) source_document_num , oe_order_misc_pub.get_concat_line_number(oola.line_id) source_document_line_num , oola.ordered_quantity source_document_qty , oola.order_quantity_uom source_document_uom , 'INTERCOMPANY' source_line_context , oola.line_id source_line_id , to_number(hoi1.org_information3) shipping_ou_id , to_number(hoi2.org_information3) selling_ou_id , mmt.transaction_id , mmt.transaction_type_id , mmt.transaction_action_id , mmt.transaction_date , mmt.organization_id , mmt.transfer_organization_id , mmt.inventory_item_id , mmt.transaction_quantity , mmt.transaction_uom , mmt.primary_quantity , mmt.transaction_cost , mmt.actual_cost , mmt.transfer_price , mmt.currency_code , mmt.currency_conversion_rate , mmt.currency_conversion_type , mmt.currency_conversion_date , mmt.costed_flag , mmt.invoiced_flag from mtl_material_transactions mmt , oe_order_lines_all oola , oe_order_headers_all ooha , hr_organization_information hoi1 , hr_organization_information hoi2 , mtl_intercompany_parameters mip where mmt.transaction_source_type_id in (8) -- internal order and mmt.transaction_action_id in (21) -- intransit shipment and oola.line_id = mmt.trx_source_line_id and ooha.header_id = oola.header_id and hoi1.organization_id = mmt.organization_id and hoi1.org_information_context = 'Accounting Information' and hoi2.organization_id = mmt.transfer_organization_id and hoi2.org_information_context = 'Accounting Information' and mip.ship_organization_id = to_number(hoi1.org_information3) and mip.sell_organization_id = to_number(hoi2.org_information3) and fnd_profile.value('INV_INTERCOMPANY_INVOICE_INTERNAL_ORDER') =1 union select 'Sales Order' source_document , ooha.ordered_date source_document_date , to_char(ooha.order_number) source_document_num , oe_order_misc_pub.get_concat_line_number(oola.line_id) source_document_line_num , oola.ordered_quantity source_document_qty , oola.order_quantity_uom source_document_uom , 'INTERCOMPANY' source_line_context , oola.line_id source_line_id , to_number(hoi1.org_information3) shipping_ou_id , to_number(hoi2.org_information3) selling_ou_id , mmt.transaction_id , mmt.transaction_type_id , mmt.transaction_action_id , mmt.transaction_date , mmt.organization_id , mmt.transfer_organization_id , mmt.inventory_item_id , mmt.transaction_quantity , mmt.transaction_uom , mmt.primary_quantity , mmt.transaction_cost , mmt.actual_cost , mmt.transfer_price , mmt.currency_code , mmt.currency_conversion_rate , mmt.currency_conversion_type , mmt.currency_conversion_date , mmt.costed_flag , mmt.invoiced_flag from mtl_material_transactions mmt , oe_order_lines_all oola , oe_order_headers_all ooha , hr_organization_information hoi1 , hr_organization_information hoi2 , mtl_transaction_flow_headers mtfh , mtl_intercompany_parameters mip where mmt.transaction_source_type_id in (13) -- invenory and mmt.transaction_action_id in (9,14) -- logical sales order issue/logical sales order receipt and mmt.logical_trx_type_code in (2,5) and oola.line_id = mmt.trx_source_line_id and ooha.header_id = oola.header_id and hoi1.organization_id = mmt.organization_id and hoi1.org_information_context = 'Accounting Information' and hoi2.organization_id = mmt.transfer_organization_id and hoi2.org_information_context = 'Accounting Information' and mtfh.header_id = mmt.trx_flow_header_id and mtfh.flow_type = 1 and mip.ship_organization_id = to_number(hoi1.org_information3) and mip.sell_organization_id = to_number(hoi2.org_information3) union select 'Purchase Order' source_document , pha.creation_date source_document_date , pha.segment1 source_document_num , pla.line_num || '.' || plla.shipment_num source_document_line_num , plla.quantity - nvl(plla.quantity_cancelled,0) source_document_qty , nvl( ( select mufm.uom_code from mtl_units_of_measure mufm where mufm.unit_of_measure = plla.unit_meas_lookup_code and rownum=1 ) , plla.unit_meas_lookup_code ) source_document_uom , 'GLOBAL_PROCUREMENT' source_line_context , plla.line_location_id source_line_id , to_number(hoi1.org_information3) shipping_ou_id , to_number(hoi2.org_information3) selling_ou_id , mmt.transaction_id , mmt.transaction_type_id , mmt.transaction_action_id , mmt.transaction_date , mmt.organization_id , mmt.transfer_organization_id , mmt.inventory_item_id , mmt.transaction_quantity , mmt.transaction_uom , mmt.primary_quantity , mmt.transaction_cost , mmt.actual_cost , mmt.transfer_price , mmt.currency_code , mmt.currency_conversion_rate , mmt.currency_conversion_type , mmt.currency_conversion_date , mmt.costed_flag , mmt.invoiced_flag from mtl_material_transactions mmt , po_headers_all pha , rcv_transactions rt , po_line_locations_all plla , po_lines_all pla , hr_organization_information hoi1 , hr_organization_information hoi2 , mtl_transaction_flow_headers mtfh , mtl_intercompany_parameters mip where mmt.transaction_source_type_id in (13) -- invenory and mmt.transaction_action_id in (9,14) -- logical sales order issue/logical sales order receipt and mmt.logical_trx_type_code in (1,3) and pha.po_header_id = mmt.transaction_source_id and rt.transaction_id (+) = mmt.rcv_transaction_id and plla.line_location_id (+) = rt.po_line_location_id and pla.po_line_id (+) = rt.po_line_id and hoi1.organization_id = mmt.organization_id and hoi1.org_information_context = 'Accounting Information' and hoi2.organization_id = mmt.transfer_organization_id and hoi2.org_information_context = 'Accounting Information' and mtfh.header_id = mmt.trx_flow_header_id and mtfh.flow_type = 2 and mip.ship_organization_id = to_number(hoi1.org_information3) and mip.sell_organization_id = to_number(hoi2.org_information3) ) , ar_ico as ( select rctla.interface_line_context , rctla.interface_line_attribute6 , rctla.interface_line_attribute7 , rctla.customer_trx_id , rctla.customer_trx_line_id , hp.party_name customer_name , hca.account_number customer_num , hcsua.location customer_location , apsa.trx_number , apsa.trx_date , apsa.invoice_currency_code , case apsa.status when 'OP' then 'Open' when 'CL' then 'Closed' else apsa.status end status , apsa.amount_due_original , apsa.tax_original , apsa.exchange_rate , apsa.exchange_rate_type , apsa.exchange_date , rctla.line_number , rctla.quantity_invoiced , rctla.uom_code , rctla.unit_selling_price , rctla.extended_amount from ra_customer_trx_lines_all rctla , ra_customer_trx_all rcta , ar_payment_schedules_all apsa , hz_cust_accounts hca , hz_parties hp , hz_cust_site_uses_all hcsua where rctla.interface_line_context in ('INTERCOMPANY','GLOBAL_PROCUREMENT') and rctla.line_type = 'LINE' and rcta.customer_trx_id = rctla.customer_trx_id and apsa.customer_trx_id = rctla.customer_trx_id and hca.cust_account_id = rcta.bill_to_customer_id and hp.party_id = hca.party_id and hcsua.site_use_id = rcta.bill_to_site_use_id ) , ar_intf as -- ar interface data ( select rila.interface_line_context , rila.interface_line_attribute6 , rila.interface_line_attribute7 , rila.interface_line_id , rila.interface_status , rila.request_id , listagg(riea.message_text,chr(10)) within group (order by riea.message_text) over (partition by rila.interface_line_context,rila.interface_line_attribute6,rila.interface_line_id,rila.interface_status,rila.request_id) error from ra_interface_lines_all rila , (select distinct interface_line_id , message_text from ra_interface_errors_all ) riea where rila.interface_line_id = riea.interface_line_id (+) and nvl(rila.interface_status,'U') != 'P' ) , ap_ico as -- ap invoice data ( select aia.reference_1 customer_trx_id , aida.reference_1 customer_trx_line_id , aia.invoice_id , asup.vendor_name , asup.segment1 vendor_num , assa.vendor_site_code , aia.invoice_num , aia.invoice_date , aia.invoice_currency_code , aia.invoice_amount , (select sum(aida2.amount) from ap_invoice_distributions_all aida2 where aida2.invoice_id = aia.invoice_id and aida2.line_type_lookup_code = 'TAX' ) total_tax_amount , aia.amount_paid , aia.exchange_rate , aia.exchange_rate_type , aia.exchange_date , aida.distribution_line_number line_number , aida.quantity_invoiced , aida.unit_price , aida.amount line_amount from ap_invoices_all aia , ap_invoice_distributions_all aida , po_vendors asup , po_vendor_sites_all assa where aida.invoice_id = aia.invoice_id and aia.vendor_id = asup.vendor_id and aia.vendor_site_id = assa.vendor_site_id and aia.source = 'Intercompany' and aida.line_type_lookup_code = 'ITEM' ) , ap_intf as -- ap interface data ( select aili.reference_1 customer_trx_line_id , aii.invoice_id , aii.status , aii.request_id , listagg(air1.reject_lookup_code,chr(10)) within group (order by air1.reject_lookup_code) over (partition by aili.reference_1,aii.invoice_id,aii.status,aii.request_id) error_h , listagg(air2.reject_lookup_code,chr(10)) within group (order by air2.reject_lookup_code) over (partition by aili.reference_1,aii.invoice_id,aii.status,aii.request_id) error_l from ap_invoices_interface aii , ap_invoice_lines_interface aili , (select distinct parent_table , parent_id , reject_lookup_code from ap_interface_rejections where parent_table = 'AP_INVOICES_INTERFACE' ) air1 , (select distinct parent_table , parent_id , reject_lookup_code from ap_interface_rejections where parent_table = 'AP_INVOICE_LINES_INTERFACE' ) air2 where aii.invoice_id = aili.invoice_id and air1.parent_id (+) = aii.invoice_id and air2.parent_id (+) = aili.invoice_line_id and aii.source = 'Intercompany' and aii.status != 'PROCESSED' ) -- ****************************************************** -- main query start here -- ****************************************************** select &lp_select_columns1 &lp_select_columns2 from mmt mmt -- inventory material transaction , mtl_trx_types_view mttv , mtl_system_items_kfv msik , mtl_parameters mp1 , mtl_parameters mp2 , hr_all_organization_units haou1 , hr_all_organization_units haou2 , ar_intf ar_intf -- ar invoice interface lines , ar_ico ar_ico -- ar ico invoices , ap_intf ap_intf -- ap invoice interface , ap_ico ap_ico -- ap ico invoices where -- inventory mmt.transaction_type_id = mttv.transaction_type_id and mmt.organization_id = msik.organization_id and mmt.inventory_item_id = msik.inventory_item_id and mmt.organization_id = mp1.organization_id and mmt.transfer_organization_id = mp2.organization_id (+) and mmt.shipping_ou_id = haou1.organization_id and mmt.selling_ou_id = haou2.organization_id and ( mmt.shipping_ou_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) or mmt.selling_ou_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) ) -- ar interface and ar_intf.interface_line_context (+) = mmt.source_line_context and ar_intf.interface_line_attribute6 (+) = to_char(mmt.source_line_id) and ar_intf.interface_line_attribute7 (+) = to_char(mmt.transaction_id) -- ar invoice and ar_ico.interface_line_context (+) = mmt.source_line_context and ar_ico.interface_line_attribute6 (+) = to_char(mmt.source_line_id) and ar_ico.interface_line_attribute7 (+) = to_char(mmt.transaction_id) -- ap interface and ap_intf.customer_trx_line_id (+) = to_char(ar_ico.customer_trx_line_id) -- ap invoice and ap_ico.customer_trx_id (+) = to_char(ar_ico.customer_trx_id) and ap_ico.customer_trx_line_id (+) = to_char(ar_ico.customer_trx_line_id) -- and 1=1 &lp_group_by_columns order by haou1.name , haou2.name , ar_ico.trx_date , ar_ico.trx_number Fixed bug in operating unit access restriction when the default operating unit is set to something else Y General B4BD260CA5599AE5E053B46B6358B59A US INV Intercompany Invoice Reconciliation 11i Intercompany invoice reconciliation for inventory transactions, including shipping and receiving organizations, ordered, transacted and invoiced quantities, amounts and possible discrepancies. It also includes all intercompany Receivables (AR) and Payables (AP) invoice details. Enginatics &lp_group_by_columns &lp_select_columns1 &lp_select_columns2 1=1 1 10 &lp_select_columns1 haou1.name "Shipping/Procuring OU (AR)" , haou2.name "Receiving OU (AP)" , mmt.source_document_qty ordered_qty , -mmt.transaction_quantity inv_transacted_qty , ar_ico.quantity_invoiced ico_invoiced_qty , nvl(mmt.source_document_qty,0) - nvl(ar_ico.quantity_invoiced,0) ico_qty_diff , ar_ico.extended_amount ar_ico_line_amount , ap_ico.line_amount ap_ico_line_amount , nvl(ar_ico.extended_amount,0) - nvl(ap_ico.line_amount,0) ico_amount_diff , mmt.source_document , mmt.source_document_date , mmt.source_document_num , mmt.source_document_line_num "Source Line/Shipment Num" , mmt.source_document_qty , (select muot.unit_of_measure_tl from mtl_units_of_measure_tl muot where mmt.source_document_uom=muot.uom_code and muot.language=userenv('lang')) source_document_uom , msik.concatenated_segments item , mp1.organization_code shipping_warehouse , mp2.organization_code receiving_warehouse , mmt.transaction_id inv_trx_id , mttv.transaction_source_type_name inv_trx_source , xxen_util.meaning(mmt.transaction_action_id,'MTL_TRANSACTION_ACTION',700) inv_action , mttv.transaction_type_name inv_trx_type , mmt.transaction_date inv_trx_date , mmt.transaction_quantity inv_trx_qty , (select muot.unit_of_measure_tl from mtl_units_of_measure_tl muot where mmt.transaction_uom=muot.uom_code and muot.language=userenv('lang')) inv_trx_uom , mmt.primary_quantity inv_primary_qty , mmt.transaction_cost inv_trx_cost , mmt.actual_cost inv_actual_cost , mmt.transfer_price inv_transfer_price , mmt.currency_code inv_currency , mmt.currency_conversion_rate inv_exchange_rate , (select gdct.user_conversion_type from gl_daily_conversion_types gdct where mmt.currency_conversion_type=gdct.conversion_type) inv_exchange_type , mmt.currency_conversion_date inv_exchange_date , xxen_util.meaning(mmt.costed_flag,'YES_NO',0) inv_costed_flag , xxen_util.meaning(mmt.invoiced_flag,'YES_NO',0) inv_invoiced_flag LOV custom Y select value, description from (select 'Invoice Level' value, null description from dual union select 'Invoice Line Level', null from dual ) order by value Invoice Line Level Invoice Line Level Y F Détail du rapport US Report Detail 2 &lp_select_columns1 haou1.name "Shipping/Procuring OU (AR)" , haou2.name "Receiving OU (AP)" , sum(ar_ico.extended_amount) ar_ico_line_amount , sum(ap_ico.line_amount) ap_ico_line_amount , sum(nvl(ar_ico.extended_amount,0) - nvl(ap_ico.line_amount,0)) ico_amount_diff , mmt.source_document , mmt.source_document_date , mmt.source_document_num -- , ar_ico.customer_name ar_ico_customer_name , ar_ico.customer_num ar_ico_customer_num , ar_ico.customer_location ar_ico_customer_location , ar_ico.trx_number ar_ico_inv_num , ar_ico.trx_date ar_ico_inv_date , ar_ico.invoice_currency_code ar_ico_inv_curr , ar_ico.amount_due_original ar_ico_inv_total_amount , ar_ico.tax_original ar_ico_inv_tax_amount , sum(ar_ico.extended_amount) ar_ico_inv_line_amount -- , ap_ico.vendor_name ap_ico_vendor_name , ap_ico.vendor_num ap_ico_vendor_num , ap_ico.vendor_site_code ap_ico_vendor_site , ap_ico.invoice_num ap_ico_inv_num , ap_ico.invoice_date ap_ico_inv_date , ap_ico.invoice_currency_code ap_ico_inv_curr , ap_ico.invoice_amount ap_ico_inv_total_amount , ap_ico.total_tax_amount ap_ico_inv_tax_amount , sum(ap_ico.line_amount) ap_ico_inv_line_amount Invoice Level F Détail du rapport US Report Detail 3 &lp_group_by_columns group by haou1.name , haou2.name , mmt.source_document , mmt.source_document_date , mmt.source_document_num -- , ar_ico.customer_name , ar_ico.customer_num , ar_ico.customer_location , ar_ico.trx_number , ar_ico.trx_date , ar_ico.invoice_currency_code , ar_ico.amount_due_original , ar_ico.tax_original -- , ap_ico.vendor_name , ap_ico.vendor_num , ap_ico.vendor_site_code , ap_ico.invoice_num , ap_ico.invoice_date , ap_ico.invoice_currency_code , ap_ico.invoice_amount , ap_ico.total_tax_amount Invoice Level F Détail du rapport US Report Detail 4 &lp_group_by_columns select null from dual Invoice Line Level F Détail du rapport US Report Detail 5 &lp_select_columns2 select null from dual Invoice Level F Détail du rapport US Report Detail 6 &lp_select_columns2 , ar_ico.customer_name ar_ico_customer_name , ar_ico.customer_num ar_ico_customer_num , ar_ico.customer_location ar_ico_customer_location , ar_ico.trx_number ar_ico_inv_num , ar_ico.trx_date ar_ico_inv_date , ar_ico.invoice_currency_code ar_ico_inv_curr , ar_ico.status ar_ico_inv_status , ar_ico.amount_due_original ar_ico_inv_total_amount , ar_ico.tax_original ar_ico_inv_tax_amount , ar_ico.exchange_rate ar_ico_inv_exchange_rate , (select gdct.user_conversion_type from gl_daily_conversion_types gdct where ar_ico.exchange_rate_type=gdct.conversion_type) ar_ico_inv_exchange_type , ar_ico.exchange_date ar_ico_inv_exchange_date , ar_ico.line_number ar_ico_inv_line_num , ar_ico.quantity_invoiced ar_ico_inv_line_qty , ar_ico.uom_code ar_ico_inv_line_uom , ar_ico.unit_selling_price ar_ico_inv_line_unit_price , ar_ico.extended_amount ar_ico_inv_line_amount -- , ap_ico.vendor_name ap_ico_vendor_name , ap_ico.vendor_num ap_ico_vendor_num , ap_ico.vendor_site_code ap_ico_vendor_site , ap_ico.invoice_num ap_ico_inv_num , ap_ico.invoice_date ap_ico_inv_date , ap_ico.invoice_currency_code ap_ico_inv_curr , ap_ico.invoice_amount ap_ico_inv_total_amount , ap_ico.total_tax_amount ap_ico_inv_tax_amount , ap_ico.exchange_rate ap_ico_inv_exchange_rate , (select gdct.user_conversion_type from gl_daily_conversion_types gdct where ap_ico.exchange_rate_type=gdct.conversion_type) ap_ico_inv_exchange_type , ap_ico.exchange_date ap_ico_inv_exchange_date , ap_ico.line_number ap_ico_inv_line_num , ap_ico.quantity_invoiced ap_ico_inv_qty , ap_ico.unit_price ap_ico_inv_line_unit_price , ap_ico.line_amount ap_ico_inv_line_amount -- , case nvl(ar_ico.customer_trx_id,-99) when -99 then case nvl(ar_intf.interface_line_attribute6,'??') when '??' then 'NOT POPULATED' else case nvl(ar_intf.request_id,-99) when -99 then 'UNPROCESSED' else nvl(ar_intf.interface_status,'ERROR') end end else null end ar_interface_status , case nvl(ar_ico.customer_trx_id,-99) when -99 then ar_intf.error else null end ar_interface_error -- , case nvl(ap_ico.invoice_id,-99) when -99 then case nvl(ap_intf.invoice_id,-99) when -99 then 'NOT POPULATED' else case nvl(ap_intf.request_id,-99) when -99 then 'UNPROCESSED' else ap_intf.status end end else null end ap_interface_status , case nvl(ap_ico.invoice_id,-99) when -99 then ap_intf.error_h || nvl2(ap_intf.error_h || ap_intf.error_l,chr(10),null) || ap_intf.error_l else null end ap_interface_error Invoice Line Level F Détail du rapport US Report Detail 7 20 1=1 haou1.name = :p_ship_ou 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)) F Unité opérationnelle d'expédition/de conditionnement US Shipping/Procuring Operating Unit 8 30 1=1 haou2.name = :p_sell_ou 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é opérationnelle de réception US Receiving Operating Unit 9 40 1=1 mmt.transaction_date >= :p_date_fr DateTime Y F Date d'expédition/réception De US Shipment/Receiving Date From 10 50 1=1 mmt.transaction_date < :p_date_to + 1 DateTime :$flex$.shipment_receiving_date_from Y F Date d'expédition/réception au US Shipment/Receiving Date To 11 60 1=1 nvl(mmt.source_document_qty,0) - nvl(ar_ico.quantity_invoiced,0) != 0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Écart de quantité uniquement US Quantity Variance only 12 70 1=1 nvl(ar_ico.extended_amount,0) - nvl(ap_ico.line_amount,0) != 0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Montant Écart seulement US Amount Variance only :$flex$.shipment_receiving_date_from Shipment/Receiving Date From Y Shipment/Receiving Date To