ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 49A8B1A803A208ACE0530100007FEB91Y select mp.organization_code, we.wip_entity_name job, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) type, xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) status, msiv.planner_code, mpl.description planner, wsg.schedule_group_name schedule_group, msiv.concatenated_segments item, msiv.description item_description, &category_columns xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, xxen_util.meaning(msiv.mrp_planning_code,'MRP_PLANNING_CODE',700) planning_method, xxen_util.meaning(msiv.end_assembly_pegging_flag,'ASSEMBLY_PEGGING_CODE',0) pegging, we.description entity_description, wdj.description job_description, nvl(cii.instance_number,wdj.asset_number) asset_number, ppa.project_number, pt.task_number, wdj.source_code, wdj.source_line_id, ooha.order_number sales_order_number, rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') sales_order_line, xxen_util.meaning(wdj.firm_planned_flag,'SYS_YES_NO',700) firm, xxen_util.meaning(wdj.job_type,'WIP_DISCRETE_JOB',700) job_type, xxen_util.meaning(wdj.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, wdj.class_code, xxen_util.client_time(wdj.scheduled_start_date) scheduled_start_date, xxen_util.client_time(wdj.scheduled_completion_date) scheduled_completion_date, xxen_util.client_time(wdj.date_released) released_date, xxen_util.client_time(wdj.date_completed) completed_date, xxen_util.client_time(wdj.date_closed) closed_date, decode(row_number() over (partition by we.wip_entity_id order by wo.operation_seq_num, wor.resource_seq_num),1,wdj.start_quantity) start_quantity, decode(row_number() over (partition by we.wip_entity_id order by wo.operation_seq_num, wor.resource_seq_num),1,nullif(wdj.quantity_scrapped,0)) quantity_scrapped, decode(row_number() over (partition by we.wip_entity_id order by wo.operation_seq_num, wor.resource_seq_num),1,nullif(wdj.quantity_completed,0)) quantity_completed, decode(row_number() over (partition by we.wip_entity_id order by wo.operation_seq_num, wor.resource_seq_num),1,nullif(wdj.start_quantity-wdj.quantity_completed-wdj.quantity_scrapped,0)) quantity_remaining, wdj.completion_subinventory, bd.department_code, wo.operation_seq_num operation_sequence, bso.operation_code, wo.description operation_description, br.resource_code, br.description resource_description, &resource_columns xxen_util.client_time(wo.date_last_moved) date_last_moved, case when nvl(wor.resource_rank,1)=1 then wo.in_queue end in_queue, case when nvl(wor.resource_rank,1)=1 then wo.running end running, case when nvl(wor.resource_rank,1)=1 then wo.to_move end to_move, case when nvl(wor.resource_rank,1)=1 then wo.rejected end rejected, case when nvl(wor.resource_rank,1)=1 then wo.scrapped end scrapped, case when nvl(wor.resource_rank,1)=1 then wo.completed end completed, xxen_util.client_time(wo.first_unit_start_date) first_unit_start_date, xxen_util.client_time(wo.last_unit_completion_date) last_unit_completion_date, xxen_util.user_name(wo.last_updated_by) operation_last_updated_by, xxen_util.user_name(we.created_by) created_by, xxen_util.client_time(we.creation_date) creation_date, haouv.name organization, we.wip_entity_id from hr_all_organization_units_vl haouv, mtl_parameters mp, wip_entities we, mtl_system_items_vl msiv, mtl_planners mpl, wip_discrete_jobs wdj, wip_schedule_groups wsg, csi_item_instances cii, ( select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union select psm.project_id, psm.project_number from pjm_seiban_numbers psm ) ppa, pa_tasks pt, ( select wo.wip_entity_id, wo.organization_id, wo.repetitive_schedule_id, wo.operation_seq_num, wo.department_id, wo.standard_operation_id, wo.description, wo.date_last_moved, nullif(wo.quantity_in_queue,0) in_queue, nullif(wo.quantity_running,0) running, nullif(wo.quantity_waiting_to_move,0) to_move, nullif(wo.quantity_rejected,0) rejected, nullif(wo.quantity_scrapped,0) scrapped, nullif(wo.quantity_completed,0) completed, nvl(wo.cumulative_scrap_quantity,0) cumulative_scrap_quantity, wo.first_unit_start_date, wo.last_unit_completion_date, wo.last_updated_by from wip_operations wo where 2=2 ) wo, bom_departments bd, (select bso.* from bom_standard_operations bso where nvl(bso.operation_type,1)=1 and bso.line_id is null) bso, ( select x.* from (select row_number() over (partition by wor.wip_entity_id, wor.organization_id, wor.operation_seq_num, wor.repetitive_schedule_id order by wor.resource_seq_num) resource_rank, wor.* from wip_operation_resources wor) x where (x.resource_rank=1 or :show_resources='Y') ) wor, bom_resources br, oe_order_headers_all ooha, oe_order_lines_all oola where 1=1 and we.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and haouv.organization_id=mp.organization_id and mp.organization_id=we.organization_id and we.primary_item_id=msiv.inventory_item_id(+) and we.organization_id=msiv.organization_id(+) and msiv.planner_code=mpl.planner_code(+) and msiv.organization_id=mpl.organization_id(+) and we.wip_entity_id=wdj.wip_entity_id(+) and we.organization_id=wdj.organization_id(+) and wdj.schedule_group_id=wsg.schedule_group_id(+) and decode(wdj.maintenance_object_type,3,wdj.maintenance_object_id)=cii.instance_id(+) and wdj.project_id=ppa.project_id(+) and wdj.task_id=pt.task_id(+) and wdj.wip_entity_id=wo.wip_entity_id(+) and wdj.organization_id=wo.organization_id(+) and wo.department_id=bd.department_id(+) and wo.standard_operation_id=bso.standard_operation_id(+) and wo.wip_entity_id=wor.wip_entity_id(+) and wo.organization_id=wor.organization_id(+) and wo.operation_seq_num=wor.operation_seq_num(+) and wor.resource_id=br.resource_id(+) and wdj.source_line_id=oola.line_id(+) and oola.header_id=ooha.header_id(+) order by mp.organization_code, we.creation_date desc, wo.operation_seq_num, wor.resource_seq_num Organization security from the Blitz Report organization access, which follows profiles Blitz Report Organization Access All Responsibilities, Blitz Report Use Operating Unit Security and Blitz Report Use Ledger Security. AR WIP Entities تقرير العمل قيد التقدم التفصيلي الذي يسرد الوظيفة ، والنوع ، والحالة ، والمخطط ، والعنصر ، ووصف العنصر ، وطريقة التخطيط ، ونوع الربط ، والكيان ، ووصف الوظيفة ، وتوزيعات حساب حركة موارد العمل قيد التقدم ، ورقم المشروع ، والمهمة ، والتعليمات البرمجية المصدر ، والبند المصدر ، ونوع العمل قيد التقدم ، رمز الفصل وجدولة التواريخ والكميات والقسم والموارد والتنظيم. D WIP Entities Detaillierter WIP-Bericht, der Auftrag, Typ, Status, Planer, Artikel, Artikelbeschreibung, Planungsmethode, Pegging-Typ, Entität, Auftragsbeschreibung, WIP-Ressourcen-Transaktionskontoverteilungen, Projektnummer, Aufgabe, Quellcode, Quellposition, WIP-Typ, Klassencode, Terminierungsdaten, Mengen, Abteilung, Ressource und Organisation auflistet. E WIP Entities Informe WIP detallado que enumera el trabajo, el tipo, el estado, el planificador, el artículo, la descripción del artículo, el método de planificación, el tipo de vinculación, la entidad, la descripción del trabajo, las distribuciones de cuentas de transacciones de recursos WIP, el número de proyecto, la tarea, el código de origen, la partida de origen, el tipo WIP, el código de clase, las fechas de programación, las cantidades, el departamento, el recurso y la organización. F WIP Entities Rapport détaillé sur les encours de fabrication qui répertorie les travaux, le type, le statut, le planificateur, l'article, la description de l'article, la méthode de planification, le type de rattachement, l'entité, la description des travaux, la répartition des comptes de transaction des ressources d'encours de fabrication, le numéro de projet, la tâche, le code source, l'article source, le type d'encours de fabrication, le code de classe, les dates de planification, les quantités, le département, la ressource et l'organisation. I WIP Entities Rapporto WIP dettagliato che elenca il lavoro, il tipo, lo stato, il pianificatore, l'articolo, la descrizione dell'articolo, il metodo di pianificazione, il tipo di pegging, l'entità, la descrizione del lavoro, le distribuzioni dei conti delle transazioni delle risorse WIP, il numero del progetto, l'attività, il codice sorgente, la voce della linea sorgente, il tipo WIP, il codice della classe, le date di programmazione, le quantità, il dipartimento, la risorsa e l'organizzazione. JA WIP Entities ジョブ、タイプ、ステータス、プランナー、アイテム、アイテム説明、計画方法、ペギングタイプ、エンティティ、ジョブ説明、WIPリソースのトランザクションアカウントの分布、プロジェクト番号、タスク、ソースコード、ソースラインアイテム、WIPタイプ、クラスコード、スケジューリング日、数量、部門、リソース、組織を一覧にした詳細WIPレポートです。 KO WIP Entities 작업, 유형, 상태, 계획자, 품목, 품목 설명, 계획 방법, 페깅 유형, 엔티티, 작업 설명, WIP 자원 트랜잭션 계정 분배, 프로젝트 번호, 태스크, 출처 코드, 출처 개별 항목, WIP 유형, 클래스 코드, 스케줄링 날짜, 수량, 부서, 자원 및 조직. PTB WIP Entities Relatório detalhado WIP que lista trabalho, tipo, status, planejador, item, descrição do item, método de planejamento, tipo de vínculo, entidade, descrição do trabalho, distribuição de contas de transações de recursos WIP, número do projeto, tarefa, código fonte, item de linha de origem, tipo WIP, código de classe, datas de programação, quantidades, departamento, recurso e organização. RU WIP Entities Подробный отчет WIP, в котором перечислены задание, тип, статус, планировщик, элемент, описание элемента, метод планирования, тип привязки, объект, задание Описание, распределение счетов операций с ресурсами WIP, номер проекта, задание, исходный код, исходная строка, тип WIP, код класса, даты планирования, количество, отдел, ресурс и организация. S WIP Entities Detalj WIP-rapport som visar jobb, typ, status, planerare, artikel, artikelbeskrivning, planeringsmetod, pegningstyp, enhet, jobbbeskrivning, WIP-resurstransaktionskontofördelningar, projektnummer, uppgift, källkod, källrad, WIP-typ, klasskod, schemaläggningsdatum, kvantiteter, avdelning, resurs och organisation. TR WIP Entities İş, tür, durum, planlayıcı, öğe, öğe açıklaması, planlama yöntemi, pimleme türü, varlık, iş tanımı, yarı mamul kaynak işlem hesabı dağıtımları, proje numarası, görev, kaynak kodu, kaynak satır öğesi, Devam Eden Çalışma türünü listeleyen ayrıntılı yarı mamul raporu, sınıf kodu, planlama tarihleri, miktarlar, departman, kaynak ve organizasyon. US WIP Entities Detail WIP report that lists job, type, status, planner, item, item description, planning method, pegging type, entity, job Description, WIP resource transaction account distributions, project number, task, source code, source line item,Sales Order,Sales Order Line, WIP type, class code, scheduling dates, quantities, department, resource and organization. Show Resources lists every resource requirement of an operation instead of its first resource only. Required units are the usage rate times the job start quantity less the operation's cumulative scrap for item basis, and the usage rate for lot basis. Remaining units are required less applied units, negative where more was charged than required. Operation quantities are shown on the first resource row of each operation only, so they can be summed. ZHS WIP Entities 详细的WIP报告，列出了工作、类型、状态、计划员、项目、项目描述、计划方法、挂接类型、实体、工作描述、WIP资源交易账户分布、项目编号、任务、源码、源行项目、WIP类型、类码、计划日期、数量、部门、资源和组织。 Enginatics &category_columns &resource_columns 1=1 2=2 :show_resources 1 -10 1=1 (msiv.organization_id,msiv.inventory_item_id) in ( select distinct xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',1) organization_id, xxen_util.instring(dbms_lob.substr(xrrpv.value),'|',2) inventory_item_id from xxen_report_run_param_values xrrpv where xrrpv.parameter_id in (select xrpv.parameter_id from xxen_report_parameters_v xrpv where xrpv.parameter_name='organization_id|inventory_item_id') and xrrpv.run_id=:run_id ) and wdj.status_type in (1,3,6,8,9,10,11,13,14,15,16,17) Char F organisation_id|inventory_item_id US organization_id|inventory_item_id 2 10 1=1 mp.organization_code=:organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 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 mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or not exists (select null from xxen_report_org_access xroa where xroa.access_type='INV') and ood.operating_unit in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) 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') D Organization F Code de l'organisation US Organization Code 3 20 1=1 wdj.scheduled_start_date>=:scheduled_start_date_from Date US Scheduled Start Date From 4 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 5 32 1=1 wdj.date_released>=:released_date_from Date US Released Date From 6 34 1=1 wdj.date_released<:released_date_to+1 Date last_day(:$flex$.released_date_from) US Released Date To 7 36 1=1 wdj.date_completed>=:completed_date_from Date US Completed Date From Date the job status changed to Complete. 8 38 1=1 wdj.date_completed<:completed_date_to+1 Date last_day(:$flex$.completed_date_from) US Completed Date To 9 40 1=1 msiv.planner_code=:planner_code LOV INV Planner Code 8E2FF36EDEC079D2E0530100007F1FF2 select x.* from ( select mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by mp.planner_code ) x union all select '<null>' value, null description from dual F Code du planificateur US Planner Code 10 50 1=1 wsg.schedule_group_name=:schedule_group LOV WIP Schedule Group 8E2FF36EDF0379D2E0530100007F1FF2 select wsg.schedule_group_name value, wsg.description from mtl_parameters mp, wip_schedule_groups wsg where mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and mp.organization_id=wsg.organization_id order by wsg.schedule_group_name F Groupe d'horaires US Schedule Group 11 60 1=1 msiv.concatenated_segments=:item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item 12 70 1=1 we.wip_entity_name=:job_name LOV WIP Job including Maintenance 269588A5C212476AAFECBF7BC514E0AD select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700)||' ('||ood.organization_code||')'||nvl2(we.description,': '||we.description,null) description from wip_entities we, org_organization_definitions ood where (:$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 ( :$flex$.organization_code is null and ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y' ) and we.organization_id=ood.organization_id and nvl(ood.disable_date,sysdate)>=sysdate and we.entity_type in (1,3,5,6,7,8) --(Discrete job, Closed discrete job, Lot based job, Maintenance work order, Closed maintenance work order, Closed lot based job) order by we.creation_date desc F Emploi US Job 13 75 1=1 we.entity_type=to_number(xxen_util.lookup_code(:wip_entity_type,'WIP_ENTITY',700)) LOV WIP Entity Type AEE03FBC64944057B6CDA3A306FB8638 select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_ENTITY' order by ml.lookup_code US WIP Entity Type Maintenance job and Closed maintenance job are eAM work orders. 14 76 1=1 nvl(cii.instance_number,wdj.asset_number)=:asset_number LOV custom select distinct nvl(cii.instance_number,wdj.asset_number) value, mp.organization_code||': '||msiv.concatenated_segments description from mtl_parameters mp, wip_discrete_jobs wdj, csi_item_instances cii, mtl_system_items_vl msiv where ( :$flex$.organization_code is null and mp.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and mp.organization_id=wdj.organization_id and decode(wdj.maintenance_object_type,3,wdj.maintenance_object_id)=cii.instance_id(+) and nvl(cii.instance_number,wdj.asset_number) is not null and nvl(wdj.asset_group_id,wdj.rebuild_item_id)=msiv.inventory_item_id(+) and wdj.organization_id=msiv.organization_id(+) order by 1 US Asset Number eAM asset or rebuildable serial number of a maintenance work order. 15 80 1=1 wdj.status_type=xxen_util.lookup_code(:job_status,'WIP_JOB_STATUS',700) LOV WIP Job Status 8E2FF36EDE9579D2E0530100007F1FF2 select ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='WIP_JOB_STATUS' order by ml.meaning F Statut de l'emploi US Job Status 16 90 1=1 ppa.project_number=:project_number LOV PA Project Number 8E2FF36EDEDB79D2E0530100007F1FF2 select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date from pjm_seiban_numbers psm ) ppa, hr_all_organization_units_vl haouv where ( xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y' or :$flex$.operating_unit is null and ppa.org_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') ) and ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc F Projet US Project 17 100 1=1 wdj.status_type in (1,10,11,13,14,15,16,17,3,4,5,6,8,9) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.Scheduled_Start_Date_From is null and :$flex$.Scheduled_Start_Date_To is null and :$flex$.Released_Date_From is null and :$flex$.Released_Date_To is null and :$flex$.Completed_Date_From is null and :$flex$.Completed_Date_To is null and :$flex$.job_status is null and :$flex$.project is null F Ouvert uniquement US Open only 18 105 2=2 (wo.quantity_in_queue>0 or wo.quantity_running>0 or wo.quantity_waiting_to_move>0) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Op. with Qty in Progress only 19 107 &resource_columns wor.resource_seq_num resource_sequence, xxen_util.meaning(wor.basis_type,'CST_BASIS',700) basis, wor.uom_code resource_uom, wor.usage_rate_or_amount usage_rate, wor.assigned_units, xxen_util.meaning(wor.scheduled_flag,'BOM_RESOURCE_SCHEDULE_TYPE',700) scheduled, nullif(wor.usage_rate_or_amount*decode(wor.basis_type,1,wdj.start_quantity-wo.cumulative_scrap_quantity,sign(greatest(wdj.start_quantity-wo.cumulative_scrap_quantity,0))),0) required_units, nullif(wor.applied_resource_units,0) applied_units, nullif(wor.usage_rate_or_amount*decode(wor.basis_type,1,wdj.start_quantity-wo.cumulative_scrap_quantity,sign(greatest(wdj.start_quantity-wo.cumulative_scrap_quantity,0)))-wor.applied_resource_units,0) remaining_units, xxen_util.client_time(wor.start_date) resource_start_date, trunc(xxen_util.client_time(wor.start_date),'IW') resource_start_week, xxen_util.client_time(wor.completion_date) resource_completion_date, xxen_util.meaning(wor.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) autocharge_type, (select ca.activity from cst_activities ca where wor.activity_id=ca.activity_id) activity, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Resources Lists every resource requirement of each operation instead of its first resource only. 20 :show_resources US Show Resources 21 110 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=1)) US Category Set 1 22 120 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=2)) US Category Set 2 23 130 &category_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name xxen_util.previous_parameter_value(:parameter_id) US Category Set 3 24 140 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_item_categories mic where mcsv.category_set_name=:category_set_name and mcsv.category_set_id=mic.category_set_id) LOV INV Category Set (restricted) 8E2FF36EDF2D79D2E0530100007F1FF2 select mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where mcsv.category_set_id in (select /*+ index(mic mtl_item_categories_n1) */ mic.category_set_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by mcsv.category_set_name US Category Set 25 150 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_item_categories mic where mck.concatenated_segments=:category and mcsv.category_set_name=:category_set_name and mcsv.category_set_id=mic.category_set_id and mcsv.structure_id=mck.structure_id and mck.category_id=mic.category_id ) LOV INV Category (restricted) 8E2FF36EDF2E79D2E0530100007F1FF2 select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments US Category 5F1AD22504F04D9094616F566470AA0B EAM Work Order Operations Maintenance work order operations by asset number with department, scheduled and operation dates and completed quantity. SYSADMIN 2 ASSET_NUMBER 1 16 COMPLETED 17 COMPLETED_DATE 15 DATE_LAST_MOVED 9 DEPARTMENT_CODE 13 FIRST_UNIT_START_DATE 6 ITEM 3 JOB 2 5 JOB_DESCRIPTION 14 LAST_UNIT_COMPLETION_DATE 11 OPERATION_DESCRIPTION 10 OPERATION_SEQUENCE 3 1 ORGANIZATION_CODE 12 RESOURCE_CODE 8 SCHEDULED_COMPLETION_DATE 7 SCHEDULED_START_DATE 4 STATUS WIP Entity Type Maintenance job S Site Op. with Qty in Progress only 63BA261FFB74450589A5DBCC11814965 Open Resource Load by Department Capacity load: remaining resource units of open jobs by department and resource per week of the resource start date. SYSADMIN 12 APPLIED_UNITS 2 DEPARTMENT_CODE 1 8 ITEM 6 JOB 4 9 OPERATION_SEQUENCE 1 ORGANIZATION_CODE 13 REMAINING_UNITS 11 REQUIRED_UNITS 3 RESOURCE_CODE 2 16 RESOURCE_COMPLETION_DATE 4 RESOURCE_DESCRIPTION 10 RESOURCE_SEQUENCE 14 RESOURCE_START_DATE 3 15 RESOURCE_START_WEEK 5 RESOURCE_UOM 7 STATUS DEPARTMENT_CODE ROW 2 ORGANIZATION_CODE FILTER 1 REMAINING_UNITS VALUE 5 SUM RESOURCE_CODE ROW 3 RESOURCE_START_WEEK COLUMN 4 Open only Y Show Resources Y S Site Op. with Qty in Progress only 2019DA9DA4F340EAB9BAC370239E7830 Shop Floor Dispatch List Dispatch list of open job operations with quantity in queue, running or waiting to move, by department and first unit start date. SYSADMIN 2 DEPARTMENT_CODE 1 13 FIRST_UNIT_START_DATE 2 10 IN_QUEUE 8 ITEM 9 ITEM_DESCRIPTION 6 JOB 3 14 LAST_UNIT_COMPLETION_DATE 4 OPERATION_CODE 5 OPERATION_DESCRIPTION 3 OPERATION_SEQUENCE 4 1 ORGANIZATION_CODE 11 RUNNING 15 SCHEDULED_COMPLETION_DATE 7 STATUS 12 TO_MOVE Op. with Qty in Progress only Y Open only Y S Site 9222AB979E4940509AF6E9178C67E5AB WIP Entity Summary SYSADMIN 23 CLASS_CODE 29 CLOSED_DATE 28 COMPLETED_DATE 24 COMPLETION_SUBINVENTORY 38 CREATED_BY 39 CREATION_DATE 13 ENTITY_DESCRIPTION 20 FIRM 34 IN_QUEUE SUM 8 ITEM 9 ITEM_DESCRIPTION 2 JOB 2 14 JOB_DESCRIPTION 21 JOB_TYPE 40 ORGANIZATION 1 ORGANIZATION_CODE 1 12 PEGGING 6 PLANNER 5 PLANNER_CODE 11 PLANNING_METHOD 15 PROJECT_NUMBER 32 QUANTITY_COMPLETED SUM 33 QUANTITY_REMAINING SUM 31 QUANTITY_SCRAPPED SUM 37 REJECTED SUM 27 RELEASED_DATE 35 RUNNING SUM 19 SALES_ORDER_LINE 18 SALES_ORDER_NUMBER 26 SCHEDULED_COMPLETION_DATE 25 SCHEDULED_START_DATE 7 SCHEDULE_GROUP 17 SOURCE_CODE 30 START_QUANTITY SUM 4 STATUS 16 TASK_NUMBER 36 TO_MOVE SUM 3 TYPE Y 10 USER_ITEM_TYPE 22 WIP_SUPPLY_TYPE S Site ERIC.CLEGG 9222AB979E4940509AF6E9178C67E5AB VYBHAV.REDDY 9222AB979E4940509AF6E9178C67E5AB