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）限制的操作单元。 EEE75CEB4A916AD8E05362FB09051F8BY select x.* from ( select * from (SELECT 'OKL - '|| to_char (ccr.khr_id)|| to_char (crb.id) ecc_spec_id ,'OKL' record_type ,ccr.contract_number ,ccr.khr_id ,crb.id batch_id ,crb.batch_name ,crb.batch_reference_external ,crb.batch_date ,flv.meaning batch_status_code ,decode (crb.batch_reference_external,NULL,flv2.lookup_code ,crb.batch_reference_external) reading_source_code ,crb.batch_status_code batch_status ,decode(crb.batch_reference_external,null,flv2.meaning,crb.batch_reference_external) source_type_code ,pov.vendor_name ,oeu.vendor_id vendor_id ,pov.segment1 vendor_number ,(SELECT count(1) FROM okl_counter_readings ccr WHERE ccr.ocb_id = crb.id) total_reads ,(SELECT count(1) FROM okl_counter_readings ccr WHERE ccr.ocb_id = crb.id AND ccr.trx_status_code = 'PROCESSED') total_passed ,(SELECT count(1) FROM okl_counter_readings ccr WHERE ccr.ocb_id = crb.id AND ccr.trx_status_code = 'ERROR') total_error ,(SELECT count(1) FROM okl_counter_readings ccr WHERE ccr.ocb_id = crb.id AND ccr.trx_status_code IN ('PASSED','PENDING')) total_pending ,(SELECT count(1) FROM okl_counter_readings ccr WHERE ccr.ocb_id = crb.id AND ccr.trx_status_code = ('DISCARDED')) total_discarded ,(SELECT count(1) FROM okl_counter_readings ccr WHERE ccr.ocb_id = crb.id AND ccr.trx_status_code = ('WARNING')) total_warning ,flv1.description update_reads ,(SELECT inv_organization_id FROM okc_k_headers_all_b WHERE id = ccr.khr_id) org_id ,flv.language language_code FROM okl_ctr_reading_batches_all crb ,okl_counter_readings ccr ,okl_ecc_usage_vendor_v oeu ,po_vendors pov ,fnd_lookup_values flv ,fnd_lookup_values flv1 ,fnd_lookup_values flv2 WHERE crb.id (+) = ccr.ocb_id AND oeu.contract_id (+) = ccr.khr_id AND oeu.asset_line_id (+) = ccr.kle_id AND pov.vendor_id (+) = oeu.vendor_id AND flv.LOOKUP_TYPE ='OKL_METER_READS_STATUS_TYPE' AND flv.LOOKUP_CODE = crb.batch_status_code and nvl(flv.END_DATE_ACTIVE,sysdate+1) >= sysdate AND flv1.LOOKUP_TYPE ='OKL_ECC_ACTION_EVENTS' AND flv1.LOOKUP_CODE = 'UPDATE' and nvl(flv1.END_DATE_ACTIVE,sysdate+1) >= sysdate AND flv2.LOOKUP_TYPE = 'OKL_ECC_MM_SRC_MAPING' AND flv2.LOOKUP_CODE = crb.source_type_code and nvl(flv2.END_DATE_ACTIVE,sysdate+1) >= sysdate AND flv2.language = flv1.language AND flv.language = flv1.language(+) AND flv.language in ('US') AND nvl(ccr.value_timestamp,batch_date) > (sysdate -365*nvl(fnd_profile.value ('OKL_ECC_MM_HIST_YEARS'),1)) GROUP BY ccr.contract_number ,ccr.khr_id ,crb.id ,crb.batch_name ,crb.batch_reference_external ,crb.batch_date ,flv.meaning ,crb.source_type_code ,pov.vendor_name ,oeu.vendor_id ,flv1.description ,flv2.meaning ,crb.batch_status_code ,flv2.lookup_code ,pov.segment1,flv.language) pivot (max(batch_status_code) as batch_status_code, max(source_type_code) as source_type_code , max(update_reads) as update_reads for language_code in('US' "US")) ) x where 2=2 AR ECC عقود الإيجار, تفاصيل مجموعة عقد الإيجار Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Leasingverträge, Leasing - Stapeldetails Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Lease Contracts, Detalles de Lote de Leasing Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Contrats Lease, Détails de lot Lease Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Contratti leasing, Lease: dettagli batch Imported from Enterprise Command Center Description: Lease: dettagli del batch Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC リース契約, リース・バッチ詳細 Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC 리스 계약, 리스 배치 상세내역 Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Контракты на лизинг, Лизинг: сведения о пакете Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Hyresavtal: Kontrakt, Hyresavtal: Buntdetaljer Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Kiralama Sözleşmeleri, Kiralama İşlem Grubu Detayları Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Lease Contracts, Lease Batch Details Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Lease Contracts, 租赁批详细信息 Imported from Enterprise Command Center Dataset Key: okl-batch-details Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center 1 10 2=2 x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where 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 select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) US Operating Unit