ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual 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）限制的操作单元。 FFC2383846CB458D8BA9284138523394Y select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, haouv.name operating_unit, ooha.order_number quote_number, ottt.name order_type, hp.party_name customer, hca.account_number customer_number, ooha.ordered_date, ooha.transactional_curr_code currency, xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660) quote_status, ooha.creation_date, null close_reason, null close_comments, null upload_row from hr_all_organization_units_vl haouv, oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca, hz_parties hp where 1=1 and haouv.organization_id=ooha.org_id and nvl(ooha.transaction_phase_code,'F')='N' and ooha.open_flag='Y' and ooha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and ooha.sold_to_org_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) Identify quotes by the visible Quote Number + Operating Unit (works with pasted rows), re-read live state and re-validate it is an open quote before closing. Leave Action/Status/Message for the add-in to populate. U A xxen_ont_upload.close_sales_quotes US ONT Sales Quote Close Upload Bulk closes open Oracle Order Management sales quotes (documents in the Negotiation transaction phase) - useful for cleaning up large volumes of old draft quotes. Download the open quotes, keep the rows you want to close, set a Close Reason, and upload. Each quote is driven to the Lost terminal (status Lost, no longer open) through the standard negotiation workflow, and the reason is recorded against the quote. Quotes are identified by Quote Number and Operating Unit, so you can also paste those two values from an external list instead of downloading. Only open quotes are closed - an order number or an already-closed quote is reported back and left untouched. Cancelled and Closed are order (fulfillment) statuses and do not apply to a quote - Lost is the correct terminal for a quote you are no longer pursuing. To keep win/loss reporting clean, add a custom OFFER_LOST lookup value (for example Obsolete) and select it as the Close Reason, so data-cleanup closures are distinguishable from genuine competitive losses. Use the Created Before parameter to target quotes older than a given date, and Quote Number to close a single quote. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 30 1=1 ooha.creation_date<:created_before Date US Created Before 4 40 1=1 ooha.order_number=:quote_number LOV custom 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')='N' and ooha.open_flag='Y' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$flex$.operating_unit)) and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') and ooha.sold_to_org_id=hca.cust_account_id order by ooha.order_number desc US Quote Number 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT LOV custom varchar2 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 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 :$flex$.Operating_Unit Y Y 6 QUOTE_NUMBER Number number Y Y 7 ORDER_TYPE Char varchar2 select ottt.name from oe_order_headers_all ooha, oe_transaction_types_tl ottt where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') Y 8 CUSTOMER Char varchar2 select hp.party_name from oe_order_headers_all ooha, hz_cust_accounts hca, hz_parties hp where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and ooha.sold_to_org_id=hca.cust_account_id and hca.party_id=hp.party_id Y 9 CUSTOMER_NUMBER Char varchar2 select hca.account_number from oe_order_headers_all ooha, hz_cust_accounts hca where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) and ooha.sold_to_org_id=hca.cust_account_id Y 10 ORDERED_DATE Date date select ooha.ordered_date from oe_order_headers_all ooha where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) Y 11 CURRENCY Char varchar2 select ooha.transactional_curr_code from oe_order_headers_all ooha where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) Y 12 QUOTE_STATUS Char varchar2 select xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660) from oe_order_headers_all ooha where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) Y 13 CREATION_DATE Date date select ooha.creation_date from oe_order_headers_all ooha where ooha.order_number=:$column$.quote_number and ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=:$column$.operating_unit) Y 14 CLOSE_REASON LOV custom varchar2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='OFFER_LOST' and flvv.enabled_flag='Y' order by flvv.meaning Y 15 CLOSE_COMMENTS Char varchar2 16 UPLOAD_ROW Char varchar2 Y Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.operating_unit, ooha.order_number quote_number, ottt.name order_type, hp.party_name customer, hca.account_number customer_number, ooha.ordered_date, ooha.transactional_curr_code currency, xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660) quote_status, ooha.creation_date, xu.close_reason, xu.close_comments, xu.upload_row from (select xu.*, (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=xu.operating_unit) resolved_org_id from xxen_ont_sales_quote_cl_0135_u xu) xu, oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca, hz_parties hp where ooha.order_number(+)=xu.quote_number and ooha.org_id(+)=xu.resolved_org_id and ooha.order_type_id=ottt.transaction_type_id(+) and ottt.language(+)=userenv('lang') and ooha.sold_to_org_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) and xu.status_code_=xxen_upload.status_success