ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 562AC47D3E474B5BE0530100007FB0B9Y select /*+ parallel*/ count(*) count, x.wo_exists, x.wro_exists, x.type, x.job_type, x.status, x.wip_supply_type, x.we_entity_type, x.wdj_job_type, x.wdj_status_type, x.wdj_wip_supply_type from ( select (select 'Y' from wip_operations wo where we.wip_entity_id=wo.wip_entity_id and we.organization_id=wo.organization_id and rownum=1) wo_exists, (select 'Y' from wip_requirement_operations wro where we.wip_entity_id=wro.wip_entity_id and we.organization_id=wro.organization_id and rownum=1) wro_exists, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) type, xxen_util.meaning(wdj.job_type,'WIP_DISCRETE_JOB',700) job_type, xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) status, xxen_util.meaning(wdj.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, we.entity_type we_entity_type, wdj.job_type wdj_job_type, wdj.status_type wdj_status_type, wdj.wip_supply_type wdj_wip_supply_type from mtl_parameters mp, wip_entities we, wip_discrete_jobs wdj where 1=1 and mp.organization_id=we.organization_id and we.wip_entity_id=wdj.wip_entity_id(+) and we.organization_id=wdj.organization_id(+) ) x group by x.wo_exists, x.wro_exists, x.type, x.job_type, x.status, x.wip_supply_type, x.we_entity_type, x.wdj_job_type, x.wdj_status_type, x.wdj_wip_supply_type order by count(*) desc AR WIP Entities Summary نظرة عامة على كيانات العمل قيد التقدم بمختلف أنواعها وحالاتها المختلفة. D WIP Entities Summary Übersicht über WIP-Entitäten verschiedener Typen und deren unterschiedliche Status. E WIP Entities Summary Visión general de las entidades WIP de diferentes tipos y sus diversos estados. F WIP Entities Summary Vue d'ensemble des entités WIP de différents types et de leurs différents statuts. I WIP Entities Summary Panoramica delle entità WIP di diversi tipi e dei loro vari stati. JA WIP Entities Summary さまざまなタイプのWIPエンティティとそのさまざまなステータスの概要。 KO WIP Entities Summary 다양한 유형 및 다양한 상태의 WIP 엔티티 개요. PTB WIP Entities Summary Visão geral das entidades WIP de diferentes tipos e seus vários status. RU WIP Entities Summary Обзор WIP объектов различных типов и их различных статусов. S WIP Entities Summary Översikt över WIP-enheter av olika slag och deras olika status. TR WIP Entities Summary Farklı türlerdeki yarı mamul varlıklarına ve bunların çeşitli durumlarına genel bakış. US WIP Entities Summary Overview of WIP entities of different types and their various statuses. ZHS WIP Entities Summary 不同类型的WIP实体及其各种状态的概述； Enginatics 1=1 1 10 1=1 mp.organization_code=:organization_code LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Code de l'organisation US Organization Code 2 20 1=1 wdj.scheduled_start_date>=:scheduled_start_date_from Date US Scheduled Start Date From 3 30 1=1 wdj.scheduled_start_date<:scheduled_start_date_to+1 Date last_day(:$flex$.scheduled_start_date_from) US Scheduled Start Date To :$flex$.scheduled_start_date_from Scheduled Start Date From Y Scheduled Start Date To