ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 4DE9435437EA6EF1E0530100007F6367 select count (*) count, x.type, xxen_util.meaning(x.instance_usage_code,'CSI_INSTANCE_USAGE_CODE',542) parent_instance_usage, &status_column x.sold_from_operating_unit, x.owner_operating_unit, x.inventory_org, x.last_validation_org, x.inventory_master_org from ( select nvl2(cir.object_id,'Child','Parent') type, nvl(cii0.instance_usage_code,cii.instance_usage_code) instance_usage_code, cis.name status, haouv.name sold_from_operating_unit, ( select haouv2.name from hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hr_all_organization_units_vl haouv2 where cii.owner_party_id=hca.party_id and hca.cust_account_id=hcasa.cust_account_id and hcasa.cust_acct_site_id=hcsua.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and hcsua.org_id=haouv2.organization_id and rownum=1 ) owner_operating_unit, haouv3.name inventory_org, haouv4.name last_validation_org, haouv5.name inventory_master_org from csi_item_instances cii, ( select cir.object_id, connect_by_root cir.subject_id root_subject_id, connect_by_isleaf from (select cir.* from csi_ii_relationships cir where sysdate between cir.active_start_date and nvl(cir.active_end_date,sysdate) and cir.relationship_type_code='COMPONENT-OF') cir where connect_by_isleaf=1 connect by prior cir.object_id=cir.subject_id ) cir, csi_item_instances cii0, hz_parties hp, (select cioa.* from csi_i_org_assignments cioa where cioa.relationship_type_code='SOLD_FROM' and sysdate between nvl(cioa.active_start_date,sysdate) and nvl(cioa.active_end_date,sysdate)) cioa, hr_all_organization_units_vl haouv, fnd_user fu, hr_all_organization_units_vl haouv3, hr_all_organization_units_vl haouv4, hr_all_organization_units_vl haouv5, csi_instance_statuses cis where cii.owner_party_id=hp.party_id(+) and cii.instance_id=cioa.instance_id(+) and cioa.operating_unit_id=haouv.organization_id(+) and cii.created_by=fu.user_id and cii.inv_organization_id=haouv3.organization_id(+) and cii.last_vld_organization_id=haouv4.organization_id(+) and cii.inv_master_organization_id=haouv5.organization_id and cii.instance_id=cir.root_subject_id(+) and cir.object_id=cii0.instance_id(+) and cii.instance_status_id=cis.instance_status_id(+) ) x group by x.type, xxen_util.meaning(x.instance_usage_code,'CSI_INSTANCE_USAGE_CODE',542), &status_column x.sold_from_operating_unit, x.owner_operating_unit, x.inventory_org, x.last_validation_org, x.inventory_master_org order by count (*) desc Y AR CSI Installed Base Summary by Organization عدد المنتجات الأساسية المثبتة حسب نوع التدرج الهرمي (الأصل / الفرعي) ، واستخدام المثيل والمؤسسات ذات الصلة ، مثل المباعة من وحدة التشغيل المالكة ، والتحقق الأخير من الصحة وتنظيم المخزون الرئيسي D CSI Installed Base Summary by Organization Anzahl der installierten Basisprodukte nach Hierarchietyp (übergeordnetes/untergeordnetes Produkt), Instanznutzung und zugehörigen Organisationen, wie z. B. Verkauft von und Eigentümerbetriebseinheit, letzte Validierung und Master-Inventarisierungsorganisation E CSI Installed Base Summary by Organization Recuento de productos base instalados por tipo de jerarquía (padre / hijo), uso de la instancia y organizaciones relacionadas, como vendido desde y unidad operativa propietaria, última validación y organización del inventario maestro F CSI Installed Base Summary by Organization Comptage des produits de base installés par type de hiérarchie (parent / enfant), utilisation des instances et organisations connexes, telles que l'unité d'exploitation vendue et propriétaire, la dernière validation et l'organisation de l'inventaire principal I CSI Installed Base Summary by Organization Conteggio dei prodotti di base installati per tipo di gerarchia (genitore/figlio), uso dell'istanza e organizzazioni correlate, come unità operativa venduta da e proprietario, ultima convalida e organizzazione dell'inventario principale JA CSI Installed Base Summary by Organization 階層タイプ（親/子）、インスタンスの使用状況、および関連組織（販売元や所有者の操作ユニット、最終検証、マスターインベントリ組織など）ごとのインストールされたベース製品の数 KO CSI Installed Base Summary by Organization 계층 유형 (상위 / 하위), 인스턴스 사용 및 관련 조직 (예 : 판매처 및 소유자 운영 단위, 마지막 검증 및 마스터 재고 조직) 별 설치 기반 제품 수 PTB CSI Installed Base Summary by Organization Contagem de produtos de base instalados por tipo de hierarquia (pai/filho), uso de instância e organizações relacionadas, tais como vendas de e unidade operacional proprietária, última validação e organização mestre de inventário RU CSI Installed Base Summary by Organization Подсчет установленных базовых продуктов по типу иерархии (родитель/потомок), использованию экземпляров и связанным с ними организациям, таким как проданные от операционной единицы и операционной единицы владельца, последняя валидация и организация основной инвентаризации S CSI Installed Base Summary by Organization Antal installerade basprodukter efter hierarkityp (förälder / barn), instansanvändning och relaterade organisationer, så som säljs från och ägarenhet, senaste validering och huvudlagerorganisation TR CSI Installed Base Summary by Organization Hiyerarşi türüne (üst / alt), örnek kullanımına ve mal sahibi işletim biriminden satılanlar, son doğrulama ve ana envanter organizasyonu gibi ilgili kuruluşlara göre kurulu temel ürünlerin sayısı US CSI Installed Base Summary by Organization Count of installed base products by hierarchy type (parent / child), instance usage and related organizations, such as sold from and owner operating unit, last validation and master inventory organization ZHS CSI Installed Base Summary by Organization 按层次结构类型（父/子）、实例用途和相关组织（如销售来源和所有者经营单位）、最后一次验证和主存货组织分列的已安装基础产品的数量。 Enginatics &status_column 1 10 &status_column x.status, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher le statut US Show Status