ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 8E2FF36EDF2F79D2E0530100007F1FF2 PO Buyer Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name Corrected restriction to show buyers of the inventory orgs business group US 41DAA57978CCCF93E06362FB0905DD8A Project Number Y Y 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 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 ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc US 2CCA4AA5DF11078EE06362FB0905B30B with wip_detail as ( select mp.organization_code organization_code , wdj.organization_id organization_id , we.wip_entity_name job , we.wip_entity_id job_id , we.description job_desc , trunc(wdj.scheduled_start_date) job_scheduled_start , trunc(wdj.scheduled_completion_date) job_scheduled_complete , trunc(wdj.date_released) job_released_date , trunc(wdj.date_completed) job_completed_date , trunc(wdj.date_closed) job_closed_date , wdj.start_quantity job_start_qty , xxen_util.meaning(wdj.job_type ,'WIP_DISCRETE_JOB',700) job_type , xxen_util.meaning(wdj.status_type ,'WIP_JOB_STATUS',700) job_status , xxen_util.meaning(wdj.firm_planned_flag,'SYS_YES_NO',700) firm , case when wdj.common_bom_sequence_id is not null then 'Yes' else 'No' end bom_exists , case when wdj.common_routing_sequence_id is not null then 'Yes' else 'No' end routing_exists , ppa.segment1 project , mso.segment1 sales_order_reservation , wsg.schedule_group_name schedule_group_name , wdj.build_sequence build_sequence , wro.operation_seq_num operation_seq_num , min(wro.operation_seq_num) over (partition by wro.wip_entity_id, wro.organization_id) first_operation_seq_num , wl.line_code wip_line_code , msiv1.concatenated_segments assembly , msiv1.description assembly_desc , xxen_util.meaning(msiv1.item_type ,'ITEM_TYPE',3) assembly_type , (select mck.concatenated_segments from mtl_default_category_sets mdcs , mtl_item_categories mic , mtl_categories_kfv mck where mdcs.functional_area_id = 5 and mic.category_set_id = mdcs.category_set_id and mic.organization_id = wdj.organization_id and mic.inventory_item_id = wdj.primary_item_id and mck.category_id = mic.category_id and rownum=1 ) assembly_costing_category , msiv1.inventory_item_id assembly_id , trunc(wro.date_required) date_required , bd.department_code department , bd.description department_desc , bcb.item_num component_seq_num , msiv2.concatenated_segments component , msiv2.description component_desc , xxen_util.meaning(msiv2.item_type ,'ITEM_TYPE',3) component_type , msiv2.inventory_item_id component_id , xxen_util.meaning(msiv2.planning_make_buy_code ,'MTL_PLANNING_MAKE_BUY',700) make_or_buy , xxen_util.meaning(wro.wip_supply_type ,'WIP_SUPPLY',700) wip_supply_type , xxen_util.meaning(wro.mrp_net_flag ,'SYS_YES_NO',700) mrp_net_flag , msiv2.planner_code planner , ppx.full_name buyer , wro.supply_subinventory supply_subinventory , milk.concatenated_segments supply_locator , milk.inventory_location_id locator_id -- , msiv2.primary_uom_code uom , wro.quantity_per_assembly wro_qty_per_assembly , wro.required_quantity wro_qty_required , wro.quantity_issued wro_qty_issued , greatest(wro.required_quantity - wro.quantity_issued,0) wro_qty_open -- , nvl(miqv1.quantity,0) total_qty , nvl(miqv1.nettable_quantity,0) net_total_qty , nvl(miqv2.quantity,0) subloc_total_qty from mtl_parameters mp , wip_discrete_jobs wdj , wip_entities we , wip_lines wl , wip_requirement_operations wro , wip_schedule_groups wsg , bom_departments bd , bom_components_b bcb -- , mtl_system_items_vl msiv1 , mtl_system_items_vl msiv2 -- , ( select miqv.organization_id , miqv.inventory_item_id , nvl(sum(miqv.quantity),0) quantity , nvl(sum(miqv.quantity * decode(msi.availability_type,1,1,0)) ,0) nettable_quantity from mtl_item_quantities_view miqv , mtl_secondary_inventories msi where msi.organization_id = miqv.organization_id and msi.secondary_inventory_name = miqv.subinventory_code and nvl(msi.disable_date,sysdate) >= sysdate group by miqv.organization_id , miqv.inventory_item_id ) miqv1 , ( select miqv.organization_id , miqv.inventory_item_id , miqv.subinventory_code , miqv.locator_id , nvl(sum(miqv.quantity),0) quantity from mtl_item_quantities_view miqv , mtl_secondary_inventories msi where msi.organization_id = miqv.organization_id and msi.secondary_inventory_name = miqv.subinventory_code and nvl(msi.disable_date,sysdate) >= sysdate group by miqv.organization_id , miqv.inventory_item_id , miqv.subinventory_code , miqv.locator_id ) miqv2 , mtl_item_locations_kfv milk , mtl_reservations mr , mtl_sales_orders mso , per_people_x ppx , pa_projects_all ppa where 2=2 and wdj.organization_id = mp.organization_id and wdj.status_type in (1,3,4,6) and we.wip_entity_id = wdj.wip_entity_id and we.organization_id = wdj.organization_id and we.entity_type in (1,5) and wl.line_id (+) = wdj.line_id and wl.organization_id (+) = wdj.organization_id and wro.wip_entity_id = wdj.wip_entity_id and wro.organization_id = wdj.organization_id and wro.wip_supply_type != 6 and wro.required_quantity > 0 and wsg.organization_id (+) = wdj.organization_id and wsg.schedule_group_id (+) = wdj.schedule_group_id and wro.required_quantity > wro.quantity_issued and bd.organization_id (+) = wro.organization_id and bd.department_id (+) = wro.department_id and bcb.component_sequence_id (+) = wro.component_sequence_id -- and msiv1.organization_id (+) = wdj.organization_id and msiv1.inventory_item_id (+) = wdj.primary_item_id and msiv2.organization_id = wro.organization_id and msiv2.inventory_item_id = wro.inventory_item_id -- and miqv1.organization_id (+) = wro.organization_id and miqv1.inventory_item_id (+) = wro.inventory_item_id and miqv2.organization_id (+) = wro.organization_id and miqv2.inventory_item_id (+) = wro.inventory_item_id and miqv2.subinventory_code (+) = nvl(wro.supply_subinventory,'@@@') and nvl(miqv2.locator_id,-1) = nvl(wro.supply_locator_id,-1) -- and milk.organization_id (+) = wro.organization_id and milk.inventory_location_id (+) = wro.supply_locator_id -- and mr.supply_source_header_id (+) = we.wip_entity_id and mr.organization_id (+) = we.organization_id and mr.supply_source_type_id (+) = 5 -- job or schedule and mr.demand_source_type_id (+) = 2 -- sales order and mso.sales_order_id (+) = mr.demand_source_header_id -- and ppx.person_id (+) = msiv2.buyer_id -- and ppa.project_id (+) = wdj.project_id ) , wip_total as ( select wro.organization_id , wro.inventory_item_id , nvl(wro.supply_subinventory,'@@@') supply_subinventory , nvl(wro.supply_locator_id,-1) supply_locator_id , sum(wro.required_quantity) - sum(wro.quantity_issued) &lp_wip_reservations_api_call open_quantity from wip_requirement_operations wro where 3=3 and wro.required_quantity > 0 and wro.required_quantity > wro.quantity_issued and ( ( wro.repetitive_schedule_id is null and exists ( select null from wip_discrete_jobs wdj where wdj.wip_entity_id = wro.wip_entity_id and wdj.organization_id = wro.organization_id and wdj.status_type in (1,3,4,6) ) ) or ( wro.repetitive_schedule_id is not null and exists ( select null from wip_repetitive_schedules wrs where wrs.organization_id = wro.organization_id and wrs.repetitive_schedule_id = wro.repetitive_schedule_id and wrs.status_type in (1,3,4,6) ) ) ) group by wro.organization_id , wro.inventory_item_id , nvl(wro.supply_subinventory,'@@@') , nvl(wro.supply_locator_id,-1) ) , mrp_supply as ( select mgr.disposition_id , mgr.organization_id , mgr.inventory_item_id , mosv.order_type_text supply_type , mosv.buyer_name supply_buyer_name , mosv.order_number supply_order_number , mosv.source_vendor_name supply_vendor_name , mosv.source_vendor_site_code supply_vendor_site , trunc(mfp.supply_date) supply_date , mfp.supply_quantity supply_qty , mfp.allocated_quantity allocated_qty from mrp_gross_requirements mgr , mrp_full_pegging mfp , mrp_orders_sc_v mosv where mgr.origination_type in (2,3,17,25,26) and mfp.demand_id = mgr.demand_id and mfp.compile_designator = :p_compile_designator and mosv.transaction_id = mfp.transaction_id and mosv.order_type = mfp.supply_type and mosv.source_table = 'MRP_RECOMMENDATIONS' ) -- -- Main Query Starts here -- select wip_dtl.organization_code , wip_dtl.job , wip_dtl.job_desc , wip_dtl.job_scheduled_start , wip_dtl.job_scheduled_complete , wip_dtl.job_released_date , wip_dtl.job_completed_date , wip_dtl.job_closed_date , wip_dtl.job_start_qty , wip_dtl.job_type , wip_dtl.job_status , wip_dtl.firm firm_status , wip_dtl.bom_exists , wip_dtl.routing_exists , wip_dtl.project , wip_dtl.sales_order_reservation , wip_dtl.schedule_group_name , wip_dtl.build_sequence , wip_dtl.operation_seq_num , wip_dtl.wip_line_code , wip_dtl.assembly , wip_dtl.assembly_desc , wip_dtl.assembly_type , wip_dtl.assembly_costing_category , wip_dtl.date_required , wip_dtl.department , wip_dtl.department_desc , case when wip_dtl.operation_seq_num=wip_dtl.first_operation_seq_num then ( select br.resource_code from ( select * from ( select wor.wip_entity_id,wor.organization_id,wor.operation_seq_num,wor.resource_id, min(wor.resource_seq_num) over (partition by wor.wip_entity_id,wor.organization_id,wor.operation_seq_num) min_resource_seq_num, resource_seq_num from wip_operation_resources wor where wor.wip_entity_id= wip_dtl.job_id and wor.organization_id=wip_dtl.organization_id and wor.operation_seq_num=wip_dtl.operation_seq_num ) where min_resource_seq_num=resource_seq_num )wor, bom_resources br where br.resource_id=wor.resource_id and br.organization_id=wor.organization_id and rownum=1 ) end resource_code_first_operation , wip_dtl.component_seq_num , wip_dtl.component , wip_dtl.component_desc , wip_dtl.component_type , wip_dtl.make_or_buy , case when wip_dtl.make_or_buy='Make' then ( select bd.department_code from ( select * from( select min(bos.operation_seq_num) over (partition by bos.routing_sequence_id) min_operation_seq_num , bos.operation_seq_num,bos.routing_sequence_id,bos.department_id from bom_operational_routings bor, bom_operation_sequences bos where bos.routing_sequence_id=bor.routing_sequence_id and bos.disable_date is null and bor.assembly_item_id= wip_dtl.component_id and bor.organization_id=wip_dtl.organization_id and bor.cfm_routing_flag=2 ) where min_operation_seq_num=operation_seq_num )bor, bom_departments bd where bd.department_id = bor.department_id and rownum=1 ) end component_department , wip_dtl.wip_supply_type , wip_dtl.mrp_net_flag , wip_dtl.planner component_planner , wip_dtl.buyer , wip_dtl.supply_subinventory , wip_dtl.supply_locator , wip_dtl.uom , wip_dtl.wro_qty_per_assembly , wip_dtl.wro_qty_issued , wip_dtl.wro_qty_required , wip_dtl.wro_qty_open -- , wip_dtl.total_open_qty component_open_qty , wip_dtl.total_qty component_onhand_qty , wip_dtl.component_short_qty , wip_dtl.date_req_cum_short_qty -- , wip_dtl.net_total_qty component_net_onhand_qty , wip_dtl.component_net_short_qty , wip_dtl.date_req_cum_net_short_qty -- , case when wip_dtl.supply_subinventory is not null then wip_dtl.subloc_total_open_qty else null end sub_loc_open_qty , case when wip_dtl.supply_subinventory is not null then wip_dtl.subloc_total_qty else null end sub_loc_onhand_qty , case when wip_dtl.supply_subinventory is not null then wip_dtl.sub_loc_short_qty else null end sub_loc_short_qty , case when wip_dtl.supply_subinventory is not null then wip_dtl.date_req_cum_sub_loc_short_qty else null end date_req_cum_sub_loc_short_qty -- mrp pegged suply , mrp_supply.supply_type , mrp_supply.supply_buyer_name , mrp_supply.supply_order_number , mrp_supply.supply_vendor_name , mrp_supply.supply_vendor_site , mrp_supply.supply_date , mrp_supply.supply_qty , mrp_supply.allocated_qty from ( select wip_dtl2.* , wip_dtl2.total_open_qty - wip_dtl2.total_qty component_short_qty , sum(wip_dtl2.wro_qty_open) over (partition by wip_dtl2.organization_code,wip_dtl2.component order by wip_dtl2.date_required,wip_dtl2.job rows between unbounded preceding and current row) - wip_dtl2.total_qty date_req_cum_short_qty , wip_dtl2.total_open_qty - wip_dtl2.net_total_qty component_net_short_qty , sum(wip_dtl2.wro_qty_open) over (partition by wip_dtl2.organization_code,wip_dtl2.component order by wip_dtl2.date_required,wip_dtl2.job rows between unbounded preceding and current row) - wip_dtl2.net_total_qty date_req_cum_net_short_qty , wip_dtl2.subloc_total_open_qty - wip_dtl2.subloc_total_qty sub_loc_short_qty , sum(wip_dtl2.wro_qty_open) over (partition by wip_dtl2.organization_code,wip_dtl2.supply_subinventory,wip_dtl2.supply_locator,wip_dtl2.component order by wip_dtl2.date_required,wip_dtl2.job rows between unbounded preceding and current row) - wip_dtl2.subloc_total_qty date_req_cum_sub_loc_short_qty from ( select wip_dtl3.* -- , (select nvl(sum(wip_tot.open_quantity),0) from wip_total wip_tot where wip_tot.organization_id = wip_dtl3.organization_id and wip_tot.inventory_item_id = wip_dtl3.component_id ) total_open_qty , (select nvl(sum(wip_tot.open_quantity),0) from wip_total wip_tot where wip_tot.organization_id = wip_dtl3.organization_id and wip_tot.inventory_item_id = wip_dtl3.component_id and wip_tot.supply_subinventory = wip_dtl3.supply_subinventory and wip_tot.supply_locator_id = nvl(wip_dtl3.locator_id,-1) ) subloc_total_open_qty from wip_detail wip_dtl3 ) wip_dtl2 ) wip_dtl , mrp_supply where mrp_supply.disposition_id (+) = wip_dtl.job_id and mrp_supply.organization_id (+) = wip_dtl.organization_id and mrp_supply.inventory_item_id (+) = wip_dtl.component_id and 1=1 order by wip_dtl.organization_code , wip_dtl.job , wip_dtl.operation_seq_num , wip_dtl.component Y WIP C81E1E608F1C7EABE0530100007F66AB US LSE: WIP Discrete Job Shortage(New) WIP report that lists discrete job Open Requirements and/or Shortages. Report Modes ========== The report can be run in the following modes: 1. Open Requirements - Reports all Open Requirements 2. Shortage based on Net QOH - Reports requirements with shortages against Nettable Quantity Onhand 3. Shortage based on QOH - Reports requirements with shortages against Total Quantity Onhand 4. Shortage based on Supply Sub/Loc - Reports requirements with Shortages against Onhand Quantity in the same supply Subinventory/Locator as specified in the job requirement. Shortages ======= The report displays the Total Open Requirements, Onhand Supply, and Shortage by Component.Additionally the report includes the cumulative shortage by date required for each component. Display Pegged Supply ================= If the MRP Plan parameter is specified, the report will show any supply that is pegged to the job components by the MRP Plan. Report Templates ============= The following templates are available to restrict the report to showing Total Quantity Onhand, Nettable Quantity Onhand, or Subinventory/Locator matched Quantity Onhand. 1. Nettable QOH - Displays Nettable Onhand Quantities only 2. Nettable QOH with Pegged Supply - Displays Nettable Onhand Quantities only and Pegged Supply 3. Subinventory/Locator Match QOH - Displays Subinventory/Locator Matched Onhand Quantities only 4. Subinventory/Locator Match QOH with Pegged Supply - Displays Subinventory/Locator Matched Onhand Quantities and any Pegged Supply 5. Total QOH - Displays Total (Nettable and Non-Nettable) Onhand Quantities only 6. Total QOH with Pegged Supply - Displays Total (Nettable and Non-Nettable) Onhand Quantities only and any Pegged Supply Nidec changes &lp_wip_reservations_api_call 1=1 2=2 3=3 :p_compile_designator 1 -10 &lp_wip_reservations_api_call - nvl(sum(wip_reservations_pvt.get_resv_qty(wro.organization_id, wro.wip_entity_id, wro.operation_seq_num, wro.inventory_item_id)),0) Char Y select 'Y' from dba_objects where owner = 'APPS' and object_type = 'PACKAGE' and object_name = 'WIP_RESERVATIONS_PVT' F Appel API pour les réservations WIP US WIP Reservations API Call 2 10 1=1 wip_dtl.organization_code=:p_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') Y AR Org_Id Organization_Id D Org_Id Organization_Id F Code de l'organisation Organization_Id I Org_Id Organization_Id US Organization Code Organization_Id ZHS Org_Id Organization_Id 3 20 1=1 (wip_dtl.total_open_qty - wip_dtl.total_qty) > 0 LOV custom Y select x.value , null description from (select 'Open Requirement' value from dual union select 'Shortage based on Net QOH' from dual union select 'Shortage based on QOH' from dual union select 'Shortage based on Supply Sub/Loc' from dual ) x order by x.value Shortage based on QOH Shortage based on Net QOH F Mode rapport US Report Mode 4 1=1 (wip_dtl.total_open_qty - wip_dtl.net_total_qty) > 0 Shortage based on Net QOH F Mode rapport US Report Mode 5 1=1 (wip_dtl.subloc_total_open_qty - wip_dtl.subloc_total_qty) > 0 Shortage based on Supply Sub/Loc F Mode rapport US Report Mode 6 40 2=2 wro.wip_supply_type != 4 LOV Oracle WIP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 2 1 Y AR يتضمن الجملة يتضمن متطلبات الجملة D Mit Massengut Mit Massengut F Inclure le vrac Inclure besoins de dotation atelier I Includi fabbisogni di consumo Includi fabbisogni di consumo US Include Bulk Include Bulk Requirements ZHS 包括批量 包括批量需求 7 50 2=2 wro.wip_supply_type != 5 LOV Oracle WIP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by meaning 2 1 Y AR تضمين المورد يتضمن متطلبات الموردين D Mit Lieferantenbedarf Mit Lieferantenbedarf F Inclure le fournisseur Inclure besoins fournisseur I Includi fornitore Includi fabbisogni fornitore US Include Supplier Include Vendor Requirements ZHS 包括供应商 包括供应商需求 8 60 1=1 wip_dtl.job>=:p_from_job LOV custom Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) and entity_type not in (2,9,10) order by wip_entity_name AR أوامر الشغل من مدى الوظائف من D Von Fertigungsauftrag Von Fertigungsauftrag F Emploi de Fourchette d'OF - De I OdL - Da Intervallo OdL - Da US Job From Jobs Range From ZHS 任务自 任务范围自 9 70 1=1 wip_dtl.job<=:p_from_to LOV custom Y select wip_entity_name id, wip_entity_name value, null description from wip_entities where organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) and entity_type not in (2,9,10) order by wip_entity_name :$flex$.Job_From AR إلى مدى الوظائف إلى D Bis Bis Fertigungsauftrag F Emploi à Fourchette d'OF - A I A Intervallo OdL - A US Job To Jobs Range To ZHS 至 任务范围至 10 80 1=1 wip_dtl.assembly>=:p_from_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 Assemblage De US Assembly From 11 2=2 msiv1.organization_id=mp.organization_id F Assemblage De US Assembly From 12 90 1=1 wip_dtl.assembly<=:p_to_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 :$flex$.Assembly_From F Assemblage à US Assembly To 13 2=2 msiv1.organization_id=mp.organization_id F Assemblage à US Assembly To 14 100 1=1 wip_dtl.component>=:p_from_comp 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 AR المكونات من مدى المكونات من D Von Komponente Von Komponente F Composant De Fourchette de composants - De I Componenti da Intervallo componenti - Da US Component From Components Range From ZHS 组件自 组件范围自 15 2=2 msiv2.organization_id=mp.organization_id F Composant De US Component From 16 110 1=1 wip_dtl.component<=:p_to_comp 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 :$flex$.Component_From AR إلى 2 مدى المكونات إلى D Bis 2 Bis Komponente F Composant à Fourchette de composants - A I A 2 Intervallo componenti - A US Component To Components Range To ZHS 至 2 组件范围至 17 2=2 msiv2.organization_id=mp.organization_id F Composant à US Component To 18 120 1=1 wip_dtl.date_required>=:p_from_date_required Date AR التواريخ من مدى التواريخ من D Datum von Datum von F Date requise du Fourchette de dates - Du I Date - Da Intervallo date - Da US Date Required From Dates Range From ZHS 日期自 日期范围自 19 130 1=1 wip_dtl.date_required<:p_to_date_required+1 Date :$flex$.Date_Required_From AR إلى 3 مدى التواريخ إلى D Bis 3 Datum bis F Date requise pour Fourchette de dates - Au I A 3 Intervallo date - A US Date Required To Dates Range To ZHS 至 3 日期范围至 20 140 1=1 wip_dtl.department>=:p_from_dept LOV custom Y select distinct department_code value, null description from bom_departments where :$flex$.organization_code is null or organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) order by department_code AR الأقسام من مدى الأقسام من D Von Abteilung Von Abteilung F Département De Fourchette de sections - De I Reparti - Da Intervallo reparti - Da US Department From Departments Range From ZHS 部门自 部门范围自 21 150 1=1 wip_dtl.department<=:p_to_dept LOV custom Y select distinct department_code value, null description from bom_departments where :$flex$.organization_code is null or organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) order by department_code :$flex$.Department_From AR إلى 4 مدى الأقسام إلى D Bis 4 Bis Abteilung F Département à Fourchette de sections - A I A 4 Intervallo reparti - A US Department To Departments Range To ZHS 至 4 部门范围至 22 160 1=1 wip_dtl.planner>=:p_from_planner LOV custom Y select distinct planner_code value, null description from mtl_planners where :$flex$.organization_code is null or organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by planner_code AR المخططون من مدى رمز المخطط من D Von Planer Von Planer F Planificateur de Fourchette de codes gestionnaire - De I Planner - Da Intervallo codice planner - Da US Planner From Planner Code Range From ZHS 计划员自 计划员代码范围自 23 170 1=1 wip_dtl.planner<=:p_to_planner LOV custom Y select distinct planner_code value, null description from mtl_planners where :$flex$.organization_code is null or organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by planner_code :$flex$.Planner_From AR إلى 5 مدى رمز المخطط إلى D Bis 5 Bis Planer F Planificateur à Fourchette de codes gestionnaire - A I A 5 Intervallo codici planner - A US Planner To Planner Code Range To ZHS 至 5 计划员代码范围至 24 180 1=1 wip_dtl.buyer>=:p_from_buyer LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name AR المشترون من مدى اسم المشتري من D Von Einkäufer Von Einkäufer F Acheteur de Fourchette de noms d'acheteur - De I Buyer - Da Intervallo nomi buyer - Da US Buyer From Buyer Name Range From ZHS 采购员自 采购员姓名范围自 25 190 1=1 wip_dtl.buyer<=:p_to_buyer LOV PO Buyer 8E2FF36EDF2F79D2E0530100007F1FF2 Y Y select ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) and ppx.person_id in ( select paaf.person_id from per_all_assignments_f paaf where trunc(sysdate) between paaf.effective_start_date and paaf.effective_end_date and (:$flex$.organization_code is null or paaf.business_group_id in (select ood.business_group_id from org_organization_definitions ood where xxen_util.contains(:$flex$.organization_code,ood.organization_code)='Y') ) ) order by ppx.full_name :$flex$.Buyer_From AR إلى 6 مدى اسم المشتري إلى D Bis 6 Bis Einkäufer F Acheteur à Fourchette de noms d'acheteur - A I A 6 Intervallo nomi buyer - A US Buyer To Buyer Name Range To ZHS 至 6 采购员姓名范围至 26 200 1=1 wip_dtl.make_or_buy=xxen_util.meaning(:p_make_buy,'MTL_PLANNING_MAKE_BUY',700) LOV Oracle WIP_SRS_MAKE_BUY_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_PLANNING_MAKE_BUY' order by meaning AR مصنع أو مشترى مصنع أو مشترى D Fertigen/Einkaufen Fertigen/Einkaufen F Fabriquer ou acheter Fabriquer ou acheter I Acquista o produci Acquisti o produzione US Make or Buy Make or Buy ZHS 制造或采购 制造或采购 27 210 1=1 wip_dtl.schedule_group_name=:p_schedule_group LOV custom Y select distinct wsg.schedule_group_name value, null description from wip_schedule_groups wsg where :$flex$.organization_code is null or wsg.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) order by wsg.schedule_group_name AR مجموعة الجدول مجموعة الجدول D Planungsgruppe Planungsgruppe F Groupe d'horaires Groupe de planification I Gruppo di programmi Gruppo di programmi US Schedule Group Schedule Group ZHS 计划组 计划组 28 220 1=1 wip_dtl.project=:project LOV Project Number 41DAA57978CCCF93E06362FB0905DD8A Y Y 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 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 ppa.org_id=haouv.organization_id order by ppa.creation_date desc, ppa.project_number desc F Projet US Project 29 230 3=3 wro.date_required<:p_req_end_date + 1 Date AR تاريخ نهاية المتطلبات حد تاريخ نهاية المتطلب D Bis Bedarfsanforderung Bis Bedarfsanforderung F Date de fin de l'exigence Date limite de fin de besoin I Data fine fabbisogno Limite data fine fabbisogno US Requirement End Date Requirement End Date Limit ZHS 需求终止日期 需求终止日期限制 30 240 :p_compile_designator LOV custom Y select distinct mpsv.compile_designator value, mp.organization_code description from mrp_plans_sc_v mpsv, mtl_parameters mp where mpsv.data_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.plan_type,mpsv.curr_plan_type)=1 and nvl(mpsv.disable_date,sysdate)>=sysdate and mpsv.planned_organization=mp.organization_id order by decode(mpsv.compile_designator,fnd_profile.value('MRP_DEFAULT_PLAN'),1,2), mpsv.compile_designator fnd_profile.value('MRP_DEFAULT_PLAN') F Plan MRP pour l'origine des approvisionnements US MRP Plan for Pegged Supply :$flex$.Assembly_From Assembly From Assembly To :$flex$.Buyer_From Buyer From Buyer To :$flex$.Component_From Component From Component To :$flex$.Date_Required_From Date Required From Y Date Required To :$flex$.Department_From Department From Department To :$flex$.Job_From Job From Job To :$flex$.Planner_From Planner From Planner To :$flex$.organization_code Organization Code Assembly From :$flex$.organization_code Organization Code Assembly To :$flex$.organization_code Organization Code Buyer From :$flex$.organization_code Organization Code Buyer To :$flex$.organization_code Organization Code Component From :$flex$.organization_code Organization Code Component To :$flex$.organization_code Organization Code Department From :$flex$.organization_code Organization Code Department To :$flex$.organization_code Organization Code Job From :$flex$.organization_code Organization Code Job To :$flex$.organization_code Organization Code MRP Plan for Pegged Supply :$flex$.organization_code Organization Code Planner From :$flex$.organization_code Organization Code Planner To :$flex$.organization_code Organization Code Schedule Group