ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 681073D8ADC06CFFE053F400140A43FEY select gl.name ledger, haouv.name operating_unit, ood.organization_code, wta.transaction_date, (select gp.period_name from gl_periods gp where wta.transaction_date>=gp.start_date and wta.transaction_date<gp.end_date+1 and gl.period_set_name=gp.period_set_name and gl.accounted_period_type=gp.period_type and gp.adjustment_period_flag='N') period, to_number(to_char(wta.transaction_date,'yyyy')) year, to_number(to_char(wta.transaction_date,'ww')) week, we.wip_entity_name job_schedule, msiv.concatenated_segments assembly, msiv.description assembly_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, wl.line_code line, wta.transaction_id, wt.operation_seq_num operation_seq, bd.department_code department, wt.resource_seq_num resource_seq, br.resource_code, br.description resource_description, muot.unit_of_measure_tl uom, xxen_util.meaning(wta.basis_type,'CST_BASIS',700) basis, wta.primary_quantity quantity, wta.rate_or_amount unit_cost, xxen_util.meaning(br.cost_code_type,'CST_COST_CODE_TYPE',700) cost_type, xxen_util.meaning(wta.accounting_line_type,'CST_ACCOUNTING_LINE_TYPE',700) accounting_line_type, gcck.concatenated_segments account, wta.base_transaction_value value, gl.currency_code, wta.transaction_value orig_value, decode(wta.currency_code,gl.currency_code,null,wta.currency_code) orig_currency, decode(wta.currency_code,gl.currency_code,null,wta.currency_conversion_rate) conversion_rate, decode(wta.currency_code,gl.currency_code,null,wta.currency_conversion_date) conversion_date, xxen_util.meaning(wt.transaction_type,'WIP_TRANSACTION_TYPE',700) transaction_type, ca.activity, xxen_util.meaning(wt.standard_rate_flag,'SYS_YES_NO',700) standard_rate, xxen_util.segments_description(wta.reference_account,gl.chart_of_accounts_id) account_description, &gl_account_segments nvl(wri.class_code,wdj.class_code) accounting_class, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700) type, xxen_util.meaning(wdj.job_type,'WIP_DISCRETE_JOB',700) job_type, xxen_util.meaning(wdj.wip_supply_type,'WIP_SUPPLY',700) wip_supply_type, mck.concatenated_segments item_category, nvl(ppx.npw_number,ppx.employee_number) employee_num, ppx.full_name employee, poh.segment1 po_number, ppa.segment1 project_number, ppa.name project_name, pt.task_number, pt.task_name, wta.gl_batch_id gl_batch, ogb.gl_batch_date, ogb.description gl_batch_description, wta.wip_entity_id from gl_ledgers gl, hr_all_organization_units_vl haouv, org_organization_definitions ood, wip_transaction_accounts wta, wip_transactions wt, wip_entities we, wip_discrete_jobs wdj, gl_code_combinations_kfv gcck, wip_lines wl, mtl_item_categories mic, mtl_categories_kfv mck, mtl_system_items_vl msiv, wip_repetitive_items wri, bom_departments bd, bom_resources br, mtl_units_of_measure_tl muot, cst_activities ca, org_gl_batches ogb, per_people_x ppx, po_headers_all poh, pa_projects_all ppa, pa_tasks pt where 1=1 and &account_where_clause wta.organization_id=ood.organization_id and ood.set_of_books_id=gl.ledger_id and ood.operating_unit=haouv.organization_id and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and haouv.organization_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 wta.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 wta.accounting_line_type<>15 and wta.transaction_id=wt.transaction_id and wta.wip_entity_id=we.wip_entity_id and wta.wip_entity_id=wdj.wip_entity_id(+) and wta.organization_id=wdj.organization_id(+) and wta.reference_account=gcck.code_combination_id and wt.line_id=wl.line_id(+) and wt.organization_id=wl.organization_id(+) and we.organization_id=mic.organization_id(+) and we.primary_item_id=mic.inventory_item_id(+) and mic.category_set_id(+)=:category_set_id and mic.category_id=mck.category_id(+) and we.organization_id=msiv.organization_id(+) and we.primary_item_id=msiv.inventory_item_id(+) and wt.organization_id=wri.organization_id(+) and wt.wip_entity_id=wri.wip_entity_id(+) and wt.line_id=wri.line_id(+) and wt.department_id=bd.department_id(+) and wta.resource_id=br.resource_id(+) and br.unit_of_measure=muot.uom_code(+) and muot.language(+)=userenv('lang') and wta.activity_id=ca.activity_id(+) and wta.organization_id=ogb.organization_id(+) and wta.gl_batch_id=ogb.gl_batch_id(+) and wt.employee_id=ppx.person_id(+) and wt.po_header_id=poh.po_header_id(+) and wdj.project_id=ppa.project_id(+) and wdj.task_id=pt.task_id(+) order by ood.organization_code, ood.organization_name, wta.transaction_date desc, wta.transaction_id desc, cost_type, accounting_line_type Added project number, project name, task number, task name columns via pa_projects_all and pa_tasks joined through wdj.project_id/task_id. Fixed Project Id parameter filtering. WIP :Date_From is not null or :Date_To is not null or :Job is not null or :Line is not null or :Item is not null or :Transaction_Type is not null or :Department is not null or :Activity is not null or :Project is not null AR WIP Account Distribution تقرير العمل قيد التقدم التفصيلي الذي يسرد توزيعات حساب حركة الموارد. الرجاء إدخال المزيد من المعلمات D WIP Account Distribution Detail-WIP-Bericht, der die Verteilungen der Ressourcentransaktionskonten auflistet. Bitte weitere Parameter eingeben E WIP Account Distribution Informe WIP detallado que enumera las distribuciones de cuentas de transacciones de recursos. Por favor, introduzca más parámetros F WIP Account Distribution Rapport détaillé sur l'encours de travail qui énumère les distributions des comptes de transactions de ressources. Veuillez saisir d'autres paramètres I WIP Account Distribution Rapporto WIP dettagliato che elenca le distribuzioni dei conti delle transazioni delle risorse. Si prega di inserire altri parametri JA WIP Account Distribution 資源取引口座の分配金を一覧にしたWIPレポートの詳細 より多くのパラメータを入力してください KO WIP Account Distribution 자원 트랜잭션 계정 분배를 나열하는 상세 WIP 보고서. 더 많은 매개 변수를 입력하십시오 PTB WIP Account Distribution Relatório detalhado do WIP que lista as distribuições de contas de transações de recursos. Favor inserir mais parâmetros RU WIP Account Distribution Подробный отчет WIP, в котором перечислены распределения учетных записей операций с ресурсами. Пожалуйста, введите дополнительные параметры S WIP Account Distribution Detalj WIP-rapport som visar resurstransaktionskontofördelningar. Ange fler parametrar TR WIP Account Distribution Kaynak işlemi hesabı dağıtımlarını listeleyen ayrıntılı yarı mamul raporu. Lütfen daha fazla parametre girin US WIP Account Distribution Detail WIP report that lists resource transaction account distributions. Please enter more parameters ZHS WIP Account Distribution 详细的WIP报告，列出了资源交易账户的分配情况。 请输入更多参数 Enginatics &account_where_clause &gl_account_segments 1=1 :category_set_id 1 -10 &gl_account_segments select distinct 'gcck.'||lower(fifsv.application_column_name)||' "'||substrb(fifsv.form_left_prompt_,1,xxen_report.max_column_length)||'",'||chr(10)|| 'xxen_util.segment_description(gcck.'||lower(fifsv.application_column_name)||', '''||fifsv.application_column_name||''', gcck.chart_of_accounts_id'|| ( select ', gcck.'||lower(fifs.application_column_name) from fnd_id_flex_segments fifs where fifsv.application_id=fifs.application_id and fifsv.id_flex_code=fifs.id_flex_code and fifsv.id_flex_num=fifs.id_flex_num and fifsv.enabled_flag=fifs.enabled_flag and fifs.flex_value_set_id=(select ffvs.parent_flex_value_set_id from fnd_flex_value_sets ffvs where fifsv.flex_value_set_id=ffvs.flex_value_set_id) )||') "'||substrb(fifsv.form_left_prompt,1,xxen_report.max_column_length-5)||' desc",' text, min(fifsv.id_flex_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_id_flex_num, min(fifsv.segment_num) over (partition by fifsv.application_column_name, fifsv.form_left_prompt) min_segment_num from (select xxen_util.init_cap(fifsv.form_left_prompt) form_left_prompt_, fifsv.* from fnd_id_flex_segments_vl fifsv) fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=(select oav.chart_of_accounts_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 rownum=1) and fifsv.enabled_flag='Y' order by min_id_flex_num, min_segment_num Char x US Chart of Accounts Id 2 10 1=1 gl.name=:ledger and haouv.organization_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) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name coalesce(xxen_util.previous_parameter_value(:parameter_id),xxen_util.default_ledger) US Ledger 3 20 1=1 haouv.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_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) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 4 30 1=1 ood.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 5 40 1=1 wta.transaction_date>=:date_from DateTime D Datum von F Date du I Date - Da US Date From 6 50 1=1 wta.transaction_date<:date_to+1 DateTime :$flex$.date_from D Bis F Date à I A US Date To 7 60 &account_where_clause select 'gcck.'||lower(fifsv.application_column_name)||'=:account and ' sql_text from fnd_id_flex_segments_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsv.id_flex_num=( select gl.chart_of_accounts_id from org_organization_definitions ood, gl_ledgers gl, hr_all_organization_units_vl haouv where ( :ledger is null and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) or xxen_util.contains(:ledger,gl.name)='Y' ) and ( :operating_unit is null and haouv.organization_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) or xxen_util.contains(:operating_unit,haouv.name)='Y' ) and ( :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(:organization_code,ood.organization_code)='Y' ) and ood.set_of_books_id=gl.ledger_id and ood.operating_unit=haouv.organization_id and rownum=1 ) and (fifsv.application_id, fifsv.id_flex_code, fifsv.id_flex_num, fifsv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y') LOV custom Y select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_id_flex_segments_vl fifsgv, fnd_flex_values_vl ffvv where xxen_util.flex_value_accessible(fnd_global.resp_appl_id,fnd_global.resp_id,ffvv.flex_value_set_id,fifsgv.security_enabled_flag,ffvv.flex_value)='Y' and fifsgv.application_id=101 and fifsgv.id_flex_code='GL#' and fifsgv.enabled_flag='Y' and (fifsgv.application_id, fifsgv.id_flex_code, fifsgv.id_flex_num, fifsgv.application_column_name) in (select fsav.application_id, fsav.id_flex_code, fsav.id_flex_num, fsav.application_column_name from fnd_segment_attribute_values fsav where fsav.segment_attribute_type='GL_ACCOUNT' and fsav.attribute_value='Y') and fifsgv.flex_value_set_id=ffvv.flex_value_set_id and fifsgv.id_flex_num in ( select /*+ no_unnest*/ fifsv.id_flex_num from fnd_id_flex_structures_vl fifsv where fifsv.application_id=101 and fifsv.id_flex_code='GL#' and fifsgv.id_flex_num in ( select gl.chart_of_accounts_id from org_organization_definitions ood, gl_ledgers gl, hr_all_organization_units_vl haouv where ( :$flex$.ledger is null and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) or xxen_util.contains(:$flex$.ledger,gl.name)='Y' ) and ( :$flex$.operating_unit is null and haouv.organization_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) or xxen_util.contains(:$flex$.operating_unit,haouv.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 ood.set_of_books_id=gl.ledger_id and ood.operating_unit=haouv.organization_id and rownum=1 ) ) order by ffvv.flex_value D Konto F Compte I Conto US Account 8 70 1=1 we.wip_entity_name=:job_name LOV custom Y Y select we.wip_entity_name value, xxen_util.meaning(we.entity_type,'WIP_ENTITY',700)||nvl2(we.description,': '||we.description,null) description from wip_entities we where we.organization_id=:$flex$.organization_code order by we.creation_date desc D Auftrag F Emploi I OdL/programma US Job 9 80 1=1 wt.line_id=:line_id LOV Oracle WIP_SRS_LINE_ID_OPT Y select wl.line_id id, wl.line_code value, null description from wip_lines wl where wl.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(wl.disable_date,sysdate+1)>sysdate order by value,description D Linie F Ligne I Linea US Line 10 90 1=1 msiv.concatenated_segments like :item LOV custom Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=:$flex$.organization_code order by msiv.concatenated_segments D Baugruppe F Article I Assieme US Item 11 100 1=1 wt.transaction_type=:transaction_type LOV Oracle WIP_SRS_TRANSACTION_TYPES_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_TRANSACTION_TYPE' and enabled_flag='Y' order by lookup_code D Transaktionsart F Type de transaction I Tipo transazione US Transaction Type 12 110 1=1 wt.department_id=:department_id LOV Oracle WIP_SRS_DEPT_ID_OPT Y select department_id id, department_code value, null description from bom_departments where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by department_code D Abteilung F Département I Reparto US Department 13 120 1=1 br.resource_code=:resource_code LOV Oracle WIP_SRS_RESOURCES_OPT Y select resource_code id, resource_code value, null description from bom_resources where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by resource_code F Ressources US Resource 14 130 1=1 wta.activity_id=:activity_id LOV Oracle WIP_SRS_ACTIVITY_ID_OPT Y select activity_id id, activity value, null description from cst_activities where (organization_id is null or organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) order by activity D Prozess F Activité I Attività US Activity 15 140 1=1 nvl(wri.class_code,wdj.class_code)=:class_code LOV custom Y select distinct wac.class_code value, wac.description from gl_ledgers gl, hr_all_organization_units_vl haouv, org_organization_definitions ood, wip_accounting_classes wac where gl.ledger_id=ood.set_of_books_id and haouv.organization_id=ood.operating_unit and ood.organization_id=wac.organization_id and ( :$flex$.ledger is null and gl.ledger_id in (select nvl(glsnav.ledger_id,gasna.ledger_id) from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and gasna.ledger_id=glsnav.ledger_set_id(+)) or xxen_util.contains(:$flex$.ledger,gl.name)='Y' ) and ( :$flex$.operating_unit is null and haouv.organization_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) or xxen_util.contains(:$flex$.operating_unit,haouv.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' ) order by wac.class_code D Klasse F Classe I Classe US Class 16 150 1=1 wta.currency_code=:currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description D Währung F Monnaie I Divisa US Currency 17 160 :category_set_id LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description select mdcs.category_set_id from mtl_default_category_sets mdcs where mdcs.functional_area_id=5 Y D KategorieSet F Ensemble de la catégorie I Serie di categorie US Category Set 18 170 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_item_categories mic, mtl_category_sets mcs, mtl_categories_kfv mck where mck.concatenated_segments=:category and mck.structure_id=mcs.structure_id and mck.category_id=mic.category_id and mcs.category_set_id=mic.category_set_id ) LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs D Von Kategorie F Catégorie I Categoria - Da US Category 19 180 1=1 ppa.project_id=:project_id LOV custom Y select ppa.project_id id, ppa.name value, ppa.segment1 description from pa_projects_all ppa, pjm_project_parameters ppp where ppa.project_id=ppp.project_id and (:$flex$.organization_code is null or ppp.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) order by ppa.name D Projektkennung F Id. du projet I Id progetto US Project 20 190 1=1 nvl(ppx.npw_number,ppx.employee_number)=:employee_num LOV custom select nvl(ppx.npw_number,ppx.employee_number) value, ppx.full_name description from per_people_x ppx, hr_organization_units hou where ppx.business_group_id+0=hou.business_group_id and hou.organization_id=nvl((select mp.organization_id from mtl_parameters mp where mp.organization_code = :$flex$.organization_code),fnd_profile.value('MFG_ORGANIZATION_ID')) order by nvl(ppx.npw_number,ppx.employee_number), ppx.full_name F Numéro d'employé US Employee Number 21 200 1=1 poh.segment1=:po_number Char F Numéro de PO US PO Number