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）限制的操作单元。 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 8B41ABAF9404402DA76BBCB0594ECAC1Y select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, haouv.name operating_unit, okhab.contract_number, okhab.contract_number_modifier contract_modifier, osv.meaning contract_status, okhab.start_date contract_start_date, okhab.end_date contract_end_date, nvl2(oklb.cle_id,oklb_p.line_number||'.',null)||oklb.line_number line_number, olst.name line_type, ( select case when oki.jtot_object1_code in ('OKX_SERVICE','OKX_USAGE') then (select msiv.concatenated_segments from mtl_system_items_vl msiv where to_number(oki.object1_id1)=msiv.inventory_item_id and to_number(oki.object1_id2)=msiv.organization_id) when oki.jtot_object1_code='OKX_CUSTPROD' then (select cii.instance_number||' '||msiv.concatenated_segments from csi_item_instances cii, mtl_system_items_vl msiv where to_number(oki.object1_id1)=cii.instance_id and cii.inventory_item_id=msiv.inventory_item_id and cii.inv_master_organization_id=msiv.organization_id) when oki.jtot_object1_code='OKX_COUNTER' then (select cct.name from csi_counters_tl cct where to_number(oki.object1_id1)=cct.counter_id and cct.language=userenv('lang')) else oki.object1_id1 end from okc_k_items oki where oklb.id=oki.cle_id and rownum=1 ) item, osv_l.meaning line_status, oklb.start_date line_start_date, oklb.end_date line_end_date, oklb.price_negotiated negotiated_amount, to_char(null) terminate_contract, to_char(null) terminate_line, to_date(null) termination_date, to_char(null) termination_reason, to_char(null) delete_line, to_char(okhab.id) chr_id, to_char(oklb.id) cle_id, null upload_row from okc_k_headers_all_b okhab, hr_all_organization_units_vl haouv, okc_statuses_v osv, okc_k_lines_b oklb, okc_k_lines_b oklb_p, okc_line_styles_tl olst, okc_statuses_v osv_l where 1=1 and okhab.scs_code='SERVICE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.authoring_org_id=haouv.organization_id and okhab.sts_code=osv.code and okhab.id=oklb.dnz_chr_id and oklb.lse_id in (1,7,8,9,10,11,12,13,14,35) and oklb.cle_id=oklb_p.id(+) and oklb.lse_id=olst.id and olst.language=userenv('lang') and oklb.sts_code=osv_l.code Initial version. Full and partial service contract termination and line deletion via okc_terminate_pub / okc_contract_pub U A xxen_oks_upload.process_termination US OKS Contract Termination Upload Terminates service contracts (full termination), terminates individual contract lines and sublines (partial termination), and deletes lines from Entered contracts - the Terminate action of the Service Contracts Authoring form (okc_terminate_pub / okc_contract_pub). Set Terminate Contract to Yes on any row of the contract for a full termination, Terminate Line to Yes to terminate that row's line or subline, or Delete Line to Yes to delete the line (Entered contracts only). Termination Date and Termination Reason are required for terminations. A termination cannot be undone by this upload - statuses, credits, billing schedules and history are produced by the Oracle termination engine exactly as from the form. 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 US Operating Unit 3 30 1=1 okhab.contract_number=:contract_number LOV custom Y Y select okhab.contract_number value, okht.short_description description from okc_k_headers_all_b okhab, okc_k_headers_tl okht where okhab.scs_code='SERVICE' and okhab.authoring_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat) and okhab.id=okht.id and okht.language=userenv('lang') order by okhab.contract_number US Contract Number 4 40 1=1 okhab.sts_code=:contract_status LOV custom Y select osv.code id, osv.meaning value, null description from okc_statuses_v osv order by osv.meaning US Contract Status 5 50 1=1 oklb.sts_code=:line_status LOV custom Y select osv.code id, osv.meaning value, null description from okc_statuses_v osv order by osv.meaning US Line Status 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 OPERATING_UNIT Char varchar2 Y 6 CONTRACT_NUMBER Char varchar2 Y Y 7 CONTRACT_MODIFIER Char varchar2 Y 8 CONTRACT_STATUS Char varchar2 Y 9 CONTRACT_START_DATE Date date Y 10 CONTRACT_END_DATE Date date Y 11 LINE_NUMBER Char varchar2 Top line number, or parent.child for a subline. Required together with Terminate Line or Delete Line. Y 12 LINE_TYPE Char varchar2 Y 13 ITEM Char varchar2 Y 14 LINE_STATUS Char varchar2 Y 15 LINE_START_DATE Date date Y 16 LINE_END_DATE Date date Y 17 NEGOTIATED_AMOUNT Number number Y 18 TERMINATE_CONTRACT LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes on any row of the contract to terminate the whole contract including all its lines. Processed once per contract. 19 TERMINATE_LINE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to terminate this rows line or subline only (partial termination). 20 TERMINATION_DATE Date date Required for terminations. A date on or before today terminates immediately; a future date schedules the termination. 21 TERMINATION_REASON LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='OKC_TERMINATION_REASON' and flvv.view_application_id=0 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning Required for terminations. 22 DELETE_LINE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set to Yes to delete this rows line. Lines can only be deleted while the contract is in Entered status. 23 CHR_ID Char varchar2 Y 24 CLE_ID Char varchar2 Y 25 UPLOAD_ROW Char varchar2 Y U 10 p_contract_number in Char CONTRACT_NUMBER U 20 p_contract_modifier in Char CONTRACT_MODIFIER U 30 p_line_number in Char LINE_NUMBER U 40 p_terminate_contract in Char TERMINATE_CONTRACT U 50 p_terminate_line in Char TERMINATE_LINE U 60 p_termination_date in Date TERMINATION_DATE U 70 p_termination_reason in Char TERMINATION_REASON U 80 p_delete_line in Char DELETE_LINE U 90 p_chr_id in Char CHR_ID U 100 p_cle_id in Char CLE_ID U 110 status_ out Char STATUS_CODE_ U 120 message_ out Char MESSAGE_ Error SQL Order By upload_row, contract_number, contract_modifier, line_number Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.operating_unit, xu.contract_number, xu.contract_modifier, nvl(osv.meaning,xu.contract_status) contract_status, nvl(okhab.start_date,xu.contract_start_date) contract_start_date, nvl(okhab.end_date,xu.contract_end_date) contract_end_date, xu.line_number, xu.line_type, xu.item, nvl(osv_l.meaning,xu.line_status) line_status, nvl(oklb.start_date,xu.line_start_date) line_start_date, nvl(oklb.end_date,xu.line_end_date) line_end_date, nvl(oklb.price_negotiated,xu.negotiated_amount) negotiated_amount, xu.terminate_contract, xu.terminate_line, xu.termination_date, xu.termination_reason, xu.delete_line, xu.chr_id, xu.cle_id, xu.upload_row from xxen_oks_contract_termi_9843_u xu, okc_k_headers_all_b okhab, okc_statuses_v osv, okc_k_lines_b oklb, okc_statuses_v osv_l where xu.status_code_=xxen_upload.status_success and to_number(xu.chr_id)=okhab.id(+) and okhab.sts_code=osv.code(+) and to_number(xu.cle_id)=oklb.id(+) and oklb.sts_code=osv_l.code(+)