ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEDC79D2E0530100007F1FF2 BOM Department Y select bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd where :$flex$.organization_code is null and bd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or bd.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by bd.department_code US 8E2FF36EDF0E79D2E0530100007F1FF2 BOM Resource Code Y select br.resource_code value, br.description from bom_resources br where (:$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code US 8E2FF36EDF0C79D2E0530100007F1FF2 BOM Resource Description Y select br.description value, br.resource_code description from bom_resources br where :$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by br.description US 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 US Inventory items, restricted to the accessible inventory organizations 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code 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 mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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) ) 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 AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDEC079D2E0530100007F1FF2 INV Planner Code Y 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 US Planner codes restricted to the currently selected inv organization B58640C5F231626AE0530100007F518E MRP Plan Y select mpsv.compile_designator value, mp.organization_code||' ('||xxen_util.meaning(nvl(mpsv.curr_plan_type,mpsv.plan_type),'MRP_PLAN_TYPE',700)||')' description from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.planned_organization in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mpsv.planned_organization=mp.organization_id and mpsv.plan_completion_date is not null and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and nvl(mpsv.disable_date,sysdate)>=sysdate order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2), nvl(mpsv.curr_plan_type,mpsv.plan_type), mpsv.compile_designator US 8E2FF36EDEC379D2E0530100007F1FF2 WIP Job Y Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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,8) --(Discrete job, Closed discrete job, Lot based job, Closed lot based job) order by we.creation_date desc US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 6A4FEC5B75B63A0CE053F400140A519B select distinct y.order_number, y.department_code, y.department_description, y.resource_code, y.resource_description, y.resource_date, case when nvl(wro.row_number,1)=1 then sum(y.resource_hours) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) end resource_hours, min(y.start_date) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) start_date, max(y.end_date) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) end_date, y.supply_type, y.assembly, y.assembly_description, y.assembly_item_type, y.job_number, y.job_status, y.schedule_group, max(y.daily_rate) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) daily_rate, max(y.schedule_quantity) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) schedule_quantity, min(y.schedule_date) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) schedule_date, max(y.firm) over (partition by y.order_number,y.department_code,y.resource_code,y.resource_date,y.assembly,y.job_number,y.operation_seq_num,y.supply_type &partition_by) firm, y.operation_seq_num operation_sequence, &resource_sequence wo.description operation_description, xxen_util.client_time(wo.date_last_moved) date_last_moved, y.start_quantity, wo.quantity_in_queue in_queue, wo.quantity_running running, wo.quantity_waiting_to_move to_move, wo.quantity_rejected rejected, wo.quantity_scrapped scrapped, wo.quantity_completed completed, (y.start_quantity-wo.quantity_completed+wo.quantity_scrapped) remaining_open, 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, pha.segment1 po_number, xxen_util.client_time(plla.need_by_date) need_by_date, xxen_util.client_time(plla.promised_date) promised_date, &component_columns y.plan, y.organization_code, y.resource_id, y.assembly_item_id, y.wip_entity_id, &transaction_id y.organization_id from ( select x.order_number, bd.department_code, bd.description department_description, br.resource_code, br.description resource_description, (select xxen_util.calendar_date_offset(crp.resource_date,mp.calendar_code,rowgen.column_value-1) from dual) resource_date, crp.daily_resource_hours resource_hours, crp.resource_date start_date, crp.resource_end_date end_date, crp.resource_hours total_hours, xxen_util.meaning(mr.order_type,'MRP_ORDER_TYPE',700) supply_type, msiv.concatenated_segments assembly, msiv.description assembly_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) assembly_item_type, we.wip_entity_name job_number, xxen_util.meaning(wdj.status_type,'WIP_JOB_STATUS',700) job_status, wsg.schedule_group_name schedule_group, wdj.start_quantity, crp.operation_seq_num, crp.resource_seq_num, mr.daily_rate, mr.new_order_quantity schedule_quantity, mr.new_schedule_date schedule_date, xxen_util.meaning(mr.firm_planned_type,'SYS_YES_NO',700) firm, crp.designator plan, mp.organization_code, crp.resource_id, crp.assembly_item_id, we.wip_entity_id, we.organization_id, crp.transaction_id, rowgen.column_value date_sequence from crp_resource_plan crp, table(xxen_util.rowgen(crp.resource_hours/xxen_util.zero_to_null(crp.daily_resource_hours))) rowgen, bom_departments bd, bom_resources br, mtl_parameters mp, mtl_system_items_vl msiv, mrp_recommendations mr, wip_entities we, wip_discrete_jobs wdj, wip_schedule_groups wsg, ( select distinct mfp.transaction_id, listagg(mfp.order_number,', ') within group (order by mfp.order_number) over (partition by mfp.transaction_id) order_number from ( select distinct mfp.transaction_id, ooha.order_number, count(distinct ooha.order_number) over (partition by mfp.transaction_id) order_count from mtl_parameters mp, mrp_full_pegging mfp, mrp_full_pegging mfp0, mrp_gross_requirements mgr, oe_order_lines_all oola, oe_order_headers_all ooha where 2=2 and mfp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=mfp.organization_id and mp.organization_id=mfp0.organization_id and mfp.end_pegging_id=mfp0.pegging_id and mfp0.demand_id=mgr.demand_id and mgr.origination_type=6 and mgr.reservation_id=oola.line_id and oola.header_id=ooha.header_id ) mfp where mfp.order_count<440 ) x where 1=1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and crp.repetitive_type=1 and crp.department_id=bd.department_id and crp.resource_id=br.resource_id and crp.organization_id=mp.organization_id and crp.organization_id=msiv.organization_id and crp.assembly_item_id=msiv.inventory_item_id and crp.source_transaction_id=mr.transaction_id and case when mr.order_type in (3,7,14,15,27,28) then mr.disposition_id end=we.wip_entity_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 crp.source_transaction_id=x.transaction_id(+) ) y, wip_operations wo, (select row_number() over (partition by wro.wip_entity_id, wro.operation_seq_num, wro.organization_id order by wro.inventory_item_id) row_number, wro.* from wip_requirement_operations wro where '&show_wro'='Y' and wro.wip_supply_type<>6) wro, mtl_system_items_vl msiv2, mtl_units_of_measure_tl muot, mtl_item_locations_kfv milk, ( select sum(moqd.primary_transaction_quantity) on_hand, moqd.organization_id, moqd.inventory_item_id from mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi where moqd.subinventory_code=msi.secondary_inventory_name and moqd.organization_id=msi.organization_id and msi.availability_type=1 group by moqd.organization_id, moqd.inventory_item_id ) moqd, ( select distinct pda.wip_entity_id, pda.wip_operation_seq_num, pda.destination_organization_id, max(pda.line_location_id) keep (dense_rank last order by pda.po_distribution_id) over (partition by pda.wip_entity_id, pda.wip_operation_seq_num, pda.destination_organization_id) line_location_id, max(pda.po_line_id) keep (dense_rank last order by pda.po_distribution_id) over (partition by pda.wip_entity_id, pda.wip_operation_seq_num, pda.destination_organization_id) po_line_id, max(pda.po_header_id) keep (dense_rank last order by pda.po_distribution_id) over (partition by pda.wip_entity_id, pda.wip_operation_seq_num, pda.destination_organization_id) po_header_id from po_distributions_all pda ) pda, po_lines_all pla, po_line_locations_all plla, po_headers_all pha where 3=3 and y.wip_entity_id=wo.wip_entity_id(+) and y.operation_seq_num=wo.operation_seq_num(+) and y.organization_id=wo.organization_id(+) and y.wip_entity_id=wro.wip_entity_id(+) and y.operation_seq_num=wro.operation_seq_num(+) and y.organization_id=wro.organization_id(+) and wro.organization_id=msiv2.organization_id(+) and wro.inventory_item_id=msiv2.inventory_item_id(+) and msiv2.primary_uom_code=muot.uom_code(+) and muot.language(+)=userenv('lang') and wro.supply_locator_id=milk.inventory_location_id(+) and wro.organization_id=milk.organization_id(+) and wro.inventory_item_id=moqd.inventory_item_id(+) and wro.organization_id=moqd.organization_id(+) and y.wip_entity_id=pda.wip_entity_id(+) and y.operation_seq_num=pda.wip_operation_seq_num(+) and y.organization_id=pda.destination_organization_id(+) and pda.line_location_id=plla.line_location_id(+) and pda.po_line_id=pla.po_line_id(+) and pda.po_header_id=pha.po_header_id(+) order by y.organization_code, y.plan, y.department_code, y.resource_code, y.resource_date, y.operation_seq_num &component_order_by Y AR CRP Resource Plan تقرير تفصيلي لكل رمز مورد ، يعرض تاريخ المورد والساعات وتاريخ بدء العمل وتاريخ الانتهاء ونوع العمل المجدول والكمية المجدولة. D CRP Resource Plan Detailbericht für jeden Ressourcencode, der das Ressourcendatum, die Stunden, das Datum des Arbeitsbeginns und -endes, die Art der geplanten Arbeit und die geplante Menge anzeigt. E CRP Resource Plan Informe detallado para cada código de recurso, que muestra la fecha del recurso, las horas, la fecha de inicio y fin del trabajo, el tipo de trabajo programado y la cantidad programada. F CRP Resource Plan Rapport détaillé pour chaque code de ressource, indiquant la date de la ressource, les heures, la date de début et de fin du travail, le type de travail prévu et la quantité prévue. I CRP Resource Plan Rapporto dettagliato per ogni codice risorsa, che mostra la data della risorsa, le ore, la data di inizio e fine del lavoro, il tipo di lavoro programmato e la quantità programmata. JA CRP Resource Plan リソースコードごとに、リソースの日付、時間、作業開始日と終了日、予定されている作業の種類、予定されている数量を示す詳細レポート。 KO CRP Resource Plan 리소스 날짜, 시간, 작업 시작 및 종료 날짜, 예약 된 작업 유형 및 예약 된 수량을 보여주는 각 리소스 코드에 대한 상세 보고서입니다. PTB CRP Resource Plan Relatório detalhado para cada código de recurso, mostrando a data do recurso, horas, data de início e fim do trabalho, tipo de trabalho programado e a quantidade programada. RU CRP Resource Plan Подробный отчет по каждому коду ресурса с указанием даты ресурса, часов, даты начала и окончания работ, типа работ по расписанию и количества, запланированного. S CRP Resource Plan Detaljrapport för varje resurskod som visar resursdatum, timmar, start- och slutdatum för arbetet, typ av schemalagt arbete och den schemalagda kvantiteten. TR CRP Resource Plan Kaynak tarihini, saatlerini, iş başlangıç ve bitiş tarihini, planlanan iş türünü ve planlanan miktarı gösteren her kaynak kodu için ayrıntılı rapor. US CRP Resource Plan Detail report for each resource code, showing the resource date, hours, work start and end date, type of work scheduled, and the quantity scheduled. ZHS CRP Resource Plan 每个资源代码的详细报告，显示资源日期、小时数、工作开始和结束日期、计划工作类型和计划数量。 Enginatics &component_columns &component_order_by &partition_by &resource_sequence &show_wro &transaction_id 1=1 2=2 3=3 1 10 1=1 mp.organization_code=:organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 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 mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit 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) ) 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 2=2 mp.organization_code=:organization_code F Code de l'organisation US Organization Code 3 20 1=1 crp.designator=:compile_designator LOV MRP Plan B58640C5F231626AE0530100007F518E Y select mpsv.compile_designator value, mp.organization_code||' ('||xxen_util.meaning(nvl(mpsv.curr_plan_type,mpsv.plan_type),'MRP_PLAN_TYPE',700)||')' description from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.planned_organization in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mpsv.planned_organization=mp.organization_id and mpsv.plan_completion_date is not null and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and nvl(mpsv.disable_date,sysdate)>=sysdate order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2), nvl(mpsv.curr_plan_type,mpsv.plan_type), mpsv.compile_designator select distinct min(mpsv.compile_designator) keep (dense_rank first order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2)) over (partition by mpsv.planned_organization) compile_designator from mrp_plans_sc_v mpsv where mpsv.data_completion_date is not null and mpsv.planned_organization=(select mp.organization_id from mtl_parameters mp where mp.organization_code=:$flex$.organization_code) and nvl(mpsv.plan_type,mpsv.curr_plan_type)=1 and nvl(mpsv.disable_date,sysdate)>=sysdate US Plan 4 2=2 mfp.compile_designator=:compile_designator and mfp0.compile_designator=:compile_designator US Plan 5 30 1=1 bd.department_code=:department_code LOV BOM Department 8E2FF36EDEDC79D2E0530100007F1FF2 Y select bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd where :$flex$.organization_code is null and bd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or bd.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by bd.department_code F Département US Department 6 40 1=1 br.resource_code=:resource_code LOV BOM Resource Code 8E2FF36EDF0E79D2E0530100007F1FF2 Y select br.resource_code value, br.description from bom_resources br where (:$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code F Code des ressources US Resource Code 7 50 1=1 br.description=:resource_description LOV BOM Resource Description 8E2FF36EDF0C79D2E0530100007F1FF2 Y select br.description value, br.resource_code description from bom_resources br where :$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by br.description F Description des ressources US Resource Description 8 60 1=1 crp.source_transaction_id in ( select mfp.transaction_id from mrp_full_pegging mfp, mrp_full_pegging mfp0, mrp_gross_requirements mgr, oe_order_lines_all oola, oe_order_headers_all ooha where ooha.order_number=:order_number and mfp.organization_id=mfp0.organization_id and mfp.compile_designator=mfp0.compile_designator and mfp.end_pegging_id=mfp0.pegging_id and mfp0.organization_id=:organization_id and mfp0.compile_designator=:compile_designator and mfp0.demand_id=mgr.demand_id and mgr.origination_type=6 and mgr.reservation_id=oola.line_id and oola.header_id=ooha.header_id ) LOV custom Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, hz_cust_accounts hca, oe_transaction_types_tl ottt where ooha.header_id in ( select oola.header_id from mrp_gross_requirements mgr, oe_order_lines_all oola where mgr.organization_id=:$flex$.organization_code and mgr.compile_designator=:$flex$.plan and mgr.origination_type=6 and mgr.reservation_id=oola.line_id ) and ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') F Commande de vente US Sales Order 9 70 1=1 msiv.planner_code=:planner_code LOV INV Planner Code 8E2FF36EDEC079D2E0530100007F1FF2 Y 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 select mp.planner_code from fnd_user fu, per_people_x ppx, mtl_planners mp where 1=2 and fu.user_id=fnd_global.user_id and fu.employee_id=mp.employee_id and nvl(mp.disable_date,sysdate+1)>=sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') F Planificateur US Planner 10 80 1=1 crp.source_transaction_id in ( select mr.transaction_id from wip_entities we, mrp_recommendations mr where we.wip_entity_name=:job_name and we.wip_entity_id=mr.disposition_id and mr.order_type in (3,7,14,15,27,28) ) LOV WIP Job 8E2FF36EDEC379D2E0530100007F1FF2 Y Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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,8) --(Discrete job, Closed discrete job, Lot based job, Closed lot based job) order by we.creation_date desc F Emploi US Job 11 90 1=1 msiv.concatenated_segments like :assembly LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 Montage US Assembly 12 100 1=1 (crp.source_transaction_id,crp.operation_seq_num) in ( select mr.transaction_id, wro.operation_seq_num from mtl_system_items_vl msiv2, wip_requirement_operations wro, mrp_recommendations mr where msiv2.concatenated_segments=:component and msiv2.organization_id=wro.organization_id and msiv2.inventory_item_id=wro.inventory_item_id and wro.wip_entity_id=mr.disposition_id and wro.organization_id=mr.organization_id and mr.order_type in (3,7,14,15,27,28) ) LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y 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 oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) 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 Composant US Component 13 110 1=1 (wo.quantity_in_queue>0 or wo.quantity_running>0 or wo.quantity_waiting_to_move>0) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement Active Limite aux seules opérations WIP actuellement actives, qui ont soit in_queue, running ou to_move > 0 US Show Active only Restricts to the currently active WIP operations only, which either have in_queue, running or to_move > 0 14 120 &partition_by ,y.resource_seq_num, y.transaction_id LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Augmenter la durée du lot US Expand Lot Time 15 &resource_sequence y.resource_seq_num resource_sequence, F Augmenter la durée du lot US Expand Lot Time 16 &transaction_id y.transaction_id, F Augmenter la durée du lot US Expand Lot Time 17 130 &show_wro Y LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y nvl2(:$flex$.component,'Y',null) F Afficher les composants US Show Components 18 &component_columns msiv2.concatenated_segments component, msiv2.description component_description, wro.required_quantity, wro.quantity_issued, greatest(wro.required_quantity-wro.quantity_issued,0) quantity_open, moqd.on_hand, wro.date_required, xxen_util.meaning(wro.wip_supply_type,'WIP_SUPPLY',700) supply_type, wro.supply_subinventory supply_subinv, milk.concatenated_segments supply_locator, xxen_util.meaning(msiv2.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_buy, Y F Afficher les composants US Show Components 19 &component_order_by ,resource_hours Y F Afficher les composants US Show Components 20 &partition_by ,wro.inventory_item_id Y F Afficher les composants US Show Components :$flex$.component Component Show Components :$flex$.organization_code Organization Code Assembly :$flex$.organization_code Organization Code Component :$flex$.organization_code Organization Code Department :$flex$.organization_code Organization Code Job :$flex$.organization_code Organization Code Plan :$flex$.organization_code Organization Code Resource Code :$flex$.organization_code Organization Code Resource Description :$flex$.organization_code Organization Code Sales Order :$flex$.plan Plan Sales Order