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 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 CCB2939CA7CB0D94E0530100007FA761 with wip_detail_q as ( select wdq.job_type, wdq.class_type_code, wdq.class_type, wdq.class_code, wdq.wip_entity, xxen_util.meaning(wdq.status_type,'WIP_JOB_STATUS',700) status, wdq.period, wdq.period_close_date, wdq.scheduled_start_date, wdq.assembly, wdq.element, wdq.gl_account, -- PTD case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.costs_incurred,:p_precision) end ptd_costs_incurred, case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.costs_relieved,:p_precision) end ptd_costs_relieved, case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.elemental_variances_relieved,:p_precision) end ptd_elemental_var_relieved, case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * wdq.single_variances_relieved,:p_precision) end ptd_single_var_relieved, case when wdq.acct_period_id = :p_acct_period_id then round(:p_exchange_rate * nvl(wdq.costs_incurred,0),:p_precision) - round(:p_exchange_rate * nvl(wdq.costs_relieved,0),:p_precision) - round(:p_exchange_rate * nvl(wdq.elemental_variances_relieved,0),:p_precision) end ptd_net_activity, -- CTD round(:p_exchange_rate * wdq.costs_incurred,:p_precision) ctd_costs_incurred, round(:p_exchange_rate * wdq.costs_relieved,:p_precision) ctd_costs_relieved, round(:p_exchange_rate * wdq.elemental_variances_relieved,:p_precision) ctd_elemental_var_relieved, round(:p_exchange_rate * wdq.single_variances_relieved,:p_precision) ctd_single_var_relieved, round(:p_exchange_rate * nvl(wdq.costs_incurred,0),:p_precision) - round(:p_exchange_rate * nvl(wdq.costs_relieved,0),:p_precision) - round(:p_exchange_rate * nvl(wdq.elemental_variances_relieved,0),:p_precision) ctd_net_activity, -- wdq.organization_id, wdq.wip_entity_id, wdq.repetitive_schedule_id, wdq.acct_period_id, wdq.element_code from ( select /*+ LEADING(WDJ WPB OAP WE) USE_NL(WDJ WPB OAP WE ML2) */ -- Discrete Jobs 'Discrete' job_type, wpb.class_type class_type_code, ml.meaning class_type, wdj.class_code class_code, we.wip_entity_name wip_entity, wdj.status_type, oap.period_name period, oap.schedule_close_date period_close_date, wdj.scheduled_start_date scheduled_start_date, wdj.primary_item_id item_id, msik.concatenated_segments assembly, -- ml2.meaning element, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE'),null) gl_account, -- decode( ml2.lookup_code, 1 , nvl(wpb.pl_material_in,0), 2 , nvl(wpb.pl_material_overhead_in,0), 3 , nvl(wpb.tl_resource_in,0) + nvl(wpb.pl_resource_in,0), 4 , nvl(wpb.tl_outside_processing_in,0) + nvl(wpb.pl_outside_processing_in,0), 5 , nvl(wpb.tl_overhead_in,0) + nvl(wpb.pl_overhead_in,0), 12 , nvl(wpb.tl_scrap_in,0), 0) costs_incurred, decode(ml2.lookup_code, 1 , nvl(wpb.tl_material_out,0) + nvl(wpb.pl_material_out,0), 2 , nvl(wpb.pl_material_overhead_out,0)+nvl(wpb.tl_material_overhead_out,0), 3 , nvl(wpb.tl_resource_out,0) + nvl(wpb.pl_resource_out,0), 4 , nvl(wpb.tl_outside_processing_out,0) + nvl(wpb.pl_outside_processing_out, 0), 5 , nvl(wpb.tl_overhead_out,0) + nvl(wpb.pl_overhead_out,0), 12 , nvl(wpb.tl_scrap_out,0), 0) costs_relieved, decode(ml2.lookup_code, 1 , nvl(wpb.tl_material_var,0) + nvl(wpb.pl_material_var,0), 2 , nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.tl_material_overhead_var,0), 3 , nvl(wpb.tl_resource_var,0) + nvl(wpb.pl_resource_var,0), 4 , nvl(wpb.tl_outside_processing_var,0) + nvl(wpb.pl_outside_processing_var, 0), 5 , nvl(wpb.tl_overhead_var,0) + nvl(wpb.pl_overhead_var,0), 12 , nvl(wpb.tl_scrap_var,0), 0) elemental_variances_relieved, decode(ml2.lookup_code, 6 , nvl(wpb.tl_material_var,0) + nvl(wpb.pl_material_var,0) + nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.pl_resource_var,0) + nvl(wpb.pl_overhead_var,0) + nvl(wpb.pl_outside_processing_var,0) + nvl(wpb.tl_material_overhead_var,0), 7 , nvl(wpb.tl_resource_var,0), 8 , nvl(wpb.tl_outside_processing_var,0), 9 , nvl(wpb.tl_overhead_var,0), 13 , nvl(wpb.tl_scrap_var,0), 0) single_variances_relieved, -- wpb.organization_id, wpb.wip_entity_id, wpb.repetitive_schedule_id, wpb.acct_period_id, ml2.lookup_code element_code from wip_discrete_jobs wdj, wip_period_balances wpb, org_acct_periods oap, mfg_lookups ml, wip_entities we, mtl_system_items_b_kfv msik, mfg_lookups ml2, gl_code_combinations gcc where wpb.wip_entity_id = wdj.wip_entity_id and wpb.organization_id = wdj.organization_id and oap.organization_id = wpb.organization_id and oap.acct_period_id = wpb.acct_period_id and ml.lookup_type = 'WIP_CLASS_TYPE' and ml.lookup_code = wpb.class_type and we.wip_entity_id = wdj.wip_entity_id and we.organization_id = wdj.organization_id and msik.inventory_item_id (+) = wdj.primary_item_id and msik.organization_id (+) = wdj.organization_id and ml2.lookup_type = 'WIP_ELEMENT_VAR_TYPE' and ml2.lookup_code in (1,2,3,4,5,6,7,8,9,12,13) and gcc.code_combination_id = decode(ml2.lookup_code, 1 , wdj.material_account, 2 , wdj.material_overhead_account, 3 , wdj.resource_account, 4 , wdj.outside_processing_account, 5 , wdj.overhead_account, 6 , wdj.material_variance_account, 7 , wdj.resource_variance_account, 8 , wdj.outside_proc_variance_account, 9 , wdj.overhead_variance_account, 12, wdj.est_scrap_account, 13, wdj.est_scrap_var_account, 0) and wdj.organization_id = :p_organization_id and wdj.date_released is not null and trunc(wdj.date_released) <= :p_period_close_date and wpb.organization_id = :p_organization_id and wpb.acct_period_id <= :p_acct_period_id and 2=2 union select /*+ LEADING(WRS) */ -- Repetitive Schedules 'Repetitive' job_type, wpb.class_type class_type_code, ml.meaning class_type, wri.class_code class_code, wl.line_code wip_entity, wrs.status_type, oap.period_name period, oap.schedule_close_date period_close_date, wrs.first_unit_start_date scheduled_start_date, wri.primary_item_id item_id, msik.concatenated_segments assembly, -- ml2.meaning element, nvl2(gcc.code_combination_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', gcc.chart_of_accounts_id, NULL, gcc.code_combination_id, 'ALL', 'Y', 'VALUE'),null) gl_account, -- decode( ml2.lookup_code, 1 , nvl(wpb.pl_material_in,0), 2 , nvl(wpb.pl_material_overhead_in,0), 3 , nvl(wpb.tl_resource_in,0) + nvl(wpb.pl_resource_in,0), 4 , nvl(wpb.tl_outside_processing_in,0) + nvl(wpb.pl_outside_processing_in,0), 5 , nvl(wpb.tl_overhead_in,0) + nvl(wpb.pl_overhead_in,0), 0) costs_incurred, decode(ml2.lookup_code, 1 , nvl(wpb.tl_material_out,0) + nvl(wpb.pl_material_out,0), 2 , nvl(wpb.pl_material_overhead_out,0) + nvl(wpb.tl_material_overhead_out,0), 3 , nvl(wpb.tl_resource_out,0) + nvl(wpb.pl_resource_out,0), 4 , nvl(wpb.tl_outside_processing_out,0) + nvl(wpb.pl_outside_processing_out, 0), 5 , nvl(wpb.tl_overhead_out,0) + nvl(wpb.pl_overhead_out,0), 0) costs_relieved, decode(ml2.lookup_code, 1 , nvl(wpb.tl_material_var,0) + nvl(wpb.pl_material_var,0), 2 , nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.tl_material_overhead_var,0), 3 , nvl(wpb.tl_resource_var,0) + nvl(wpb.pl_resource_var,0), 4 , nvl(wpb.tl_outside_processing_var,0) + nvl(wpb.pl_outside_processing_var, 0), 5 , nvl(wpb.tl_overhead_var,0) + nvl(wpb.pl_overhead_var,0), 0) elemental_variances_relieved, decode(ml2.lookup_code, 6 , nvl(wpb.tl_material_var,0) + nvl(wpb.pl_material_var,0) + nvl(wpb.pl_material_overhead_var,0) + nvl(wpb.pl_resource_var,0) + nvl(wpb.pl_overhead_var,0) + nvl(wpb.pl_outside_processing_var,0) + nvl(wpb.tl_material_overhead_var,0), 7 , nvl(wpb.tl_resource_var,0), 8 , nvl(wpb.tl_outside_processing_var,0), 9 , nvl(wpb.tl_overhead_var,0), 0) single_variances_relieved, -- wpb.organization_id, wpb.wip_entity_id, wpb.repetitive_schedule_id, wpb.acct_period_id, ml2.lookup_code element_code from wip_repetitive_schedules wrs, wip_period_balances wpb, org_acct_periods oap, mfg_lookups ml, wip_entities we, wip_lines wl, wip_repetitive_items wri, mtl_system_items_b_kfv msik, mfg_lookups ml2, gl_code_combinations gcc where wpb.wip_entity_id = wrs.wip_entity_id and wpb.organization_id = wrs.organization_id and wpb.repetitive_schedule_id = wrs.repetitive_schedule_id and oap.organization_id = wpb.organization_id and oap.acct_period_id = wpb.acct_period_id and ml.lookup_type = 'WIP_CLASS_TYPE' and ml.lookup_code = wpb.class_type and we.wip_entity_id = wrs.wip_entity_id and we.organization_id = wrs.organization_id and wl.line_id = wrs.line_id and wl.organization_id = wrs.organization_id and wri.wip_entity_id = wrs.wip_entity_id and wri.line_id = wrs.line_id and wri.organization_id = wrs.organization_id and msik.inventory_item_id = wri.primary_item_id and msik.organization_id = wri.organization_id and ml2.lookup_type = 'WIP_ELEMENT_VAR_TYPE' and ml2.lookup_code in (1,2,3,4,5,6,7,8,9) and gcc.code_combination_id = decode(ml2.lookup_code, 1 , wrs.material_account, 2 , wrs.material_overhead_account, 3 , wrs.resource_account, 4 , wrs.outside_processing_account, 5 , wrs.overhead_account, 6 , wrs.material_variance_account, 7 , wrs.resource_variance_account, 8 , wrs.outside_proc_variance_account, 9 , wrs.overhead_variance_account, 0) and wrs.organization_id = :p_organization_id and wrs.date_released is not null and trunc(wrs.date_released) <= :p_period_close_date and ( wrs.date_closed is null or wrs.date_closed >= :p_period_start_date ) and wpb.organization_id = :p_organization_id and wpb.acct_period_id <= :p_acct_period_id and 3=3 ) wdq ) -- -- Main Query Starts Here -- select :p_organization_code organization, wdq.job_type, wdq.class_type, wdq.class_code class, wdq.wip_entity "Job/Line", wdq.status "Job Status", wdq.period, wdq.period_close_date, wdq.scheduled_start_date start_date, wdq.assembly, wdq.element "Element/Variance", wdq.gl_account, :p_currency_code currency, :p_exchange_rate exchange_rate, -- PTD wdq.ptd_costs_incurred, wdq.ptd_costs_relieved, wdq.ptd_elemental_var_relieved ptd_variances_relieved, wdq.ptd_single_var_relieved ptd_single_level_var_relieved, wdq.ptd_net_activity, -- CTD wdq.ctd_costs_incurred, wdq.ctd_costs_relieved, wdq.ctd_elemental_var_relieved ctd_variances_relieved, wdq.ctd_single_var_relieved ctd_single_level_var_relieved, wdq.ctd_net_activity, -- wdq.class_type_code, wdq.class_type_code || ' ' || wdq.class_type class_type_pivot_label, wdq.element_code, lpad(wdq.element_code,2) || ' ' || wdq.element || ' - ' || wdq.gl_account "Element/Variance Pivot Label" from wip_detail_q wdq where 1=1 order by wdq.job_type, wdq.class_type_code, wdq.class_code, wdq.wip_entity, wdq.period_close_date, wdq.scheduled_start_date Added job status column Y WIP WIPUTVAL_XML AR WIP تقرير قيم ما تحت التنفيذ (بتنسيق XML) Imported from BI Publisher Description: تقرير قيمة ما تحت التنفيذ Application: العمل في الإنجاز Source: تقرير قيم ما تحت التنفيذ (بتنسيق XML) Short Name: WIPUTVAL_XML DB package: WIP_WIPUTVAL_XMLP_PKG D WIP Fertigung - Auftragswerte Imported from BI Publisher Description: Fertigung - Auftragswerte Application: Fertigung Source: Fertigung - Auftragswerte (XML) Short Name: WIPUTVAL_XML DB package: WIP_WIPUTVAL_XMLP_PKG F WIP Etat Valeurs des en-cours Imported from BI Publisher Description: Etat Valeurs des en-cours Application: Work In Process Source: Etat Valeurs des en-cours (XML) Short Name: WIPUTVAL_XML DB package: WIP_WIPUTVAL_XMLP_PKG I WIP Rapporto Valori WIP Imported from BI Publisher Description: Rapporto Valori WIP Application: Work in Process Source: Rapporto Valori WIP (XML) Short Name: WIPUTVAL_XML DB package: WIP_WIPUTVAL_XMLP_PKG US WIP Value Application: Work in Process Description: WIP Value Report This report will display Period To Date (PTD) and Cumulative To Date (CTD) WIP costs/variances for the selected period. The raw data (without template) provides a breakdown of these values by WIP Cost Type, Class, Discrete Job/Repetitive Schedule, Assembly, Element/Variance GL Account, and Period in which the cost is incurred/relieved. Templates are provided to detail or summarize the costs as followed: Applicable Templates: Pivot: WIP Value by Cost Type, Class - WIP Value Summary by Cost Type, Class with Drill Down to WIP Job Details Pivot: WIP Value by Cost Type, Class, Element/Variance GL Account - WIP Value by Cost Type, Class, Element/Variance GL Account Pivot: WIP Value by Element/Variance GL Account - WIP Value Account Summary by Element/Variance GL Account with Drill Down to WIP Job Details Detail: WIP value detail by WIP Job/Repetitive Schedule - Detail: WIP value detail by WIP Job/Repetitive Schedule Detail: WIP value detail by Element/Variance GL Account - WIP value detail breakdown at the Element/Variance GL Account level Provides equivalent functionality to the following standard Oracle Forms/Reports - WIP Value Report Source: WIP Value Report (XML) Short Name: WIPUTVAL_XML DB package: WIP_WIPUTVAL_XMLP_PKG ZHS WIP 值报表 Imported from BI Publisher Description: WIP 值报表 Application: 在制品管理系统 Source: WIP 值报表 (XML) Short Name: WIPUTVAL_XML DB package: WIP_WIPUTVAL_XMLP_PKG Enginatics R12 only 1=1 2=2 3=3 :lp_struct_num :p_acct_flex :p_acct_period_id :p_assy_flex :p_class_type :p_closed_jobs :p_conc_request_id :p_currency_code :p_debug :p_exchange_rate :p_exchange_rate_char :p_flexwhere :p_flexwhere1 :p_flexwhere2 :p_flexwhere3 :p_from_assembly :p_from_class :p_from_job :p_inverse_rate :p_organization_code :p_organization_id :p_outer :p_period_close_date :p_period_start_date :p_precision :p_project_id :p_project_where :p_rate_type :p_report_type :p_struct_num :p_to_assembly :p_to_class :p_to_job 1 -50 :p_precision Number select fc.precision from fnd_currencies fc where fc.currency_code = :$flex$.Currency_Code Y F Précision US Precision 2 -40 :p_organization_id Number select mp.organization_id value from mtl_parameters mp where mp.organization_code=:$flex$.Organization_Code Y F ID de l'organisation US Organization Id 3 -30 :p_acct_period_id Number select acct_period_id from org_acct_periods where organization_id=:$flex$.Organization_ID and period_name=:$flex$.Period Y F ID de la période US Period Id 4 -20 :p_period_start_date Date select oap.period_start_date from org_acct_periods oap where oap.acct_period_id = :$flex$.Period_ID and oap.organization_id = :$flex$.Organization_ID Y F Date de début de la période US Period Start Date 5 -10 :p_period_close_date Date select oap.schedule_close_date from org_acct_periods oap where oap.acct_period_id = :$flex$.Period_ID and oap.organization_id = :$flex$.Organization_ID Y F Date de clôture de la période US Period Close Date 6 10 :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 معرف التنظيم D Org_id Organisationskennung F Code de l'organisation ID organisation I Org_id Id dell'organizzazione US Organization Code Organization Id ZHS Org_id 组织标识 7 20 :p_period_name LOV custom Y select period_name value, null description from org_acct_periods where organization_id=:$flex$.Organization_ID order by schedule_close_date desc Y AR الفترة الفترة D Periode Periode F Période Période I Periodo Periodo US Period period ZHS 期间 期间 8 30 :p_closed_jobs 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 Y Y AR يتضمن أوامر شغل مقفلة أوامر شغل مقفلة D Mit geschlossenen diskreten Aufträgen Geschlossene diskrete Aufträge F Inclure les emplois fermés Ordres de fabrication clôturés I Includi OdL chiusi OdL chiusi US Include Closed Jobs closed jobs ZHS 包括已关闭的任务 已关闭的任务 9 2=2 :p_closed_jobs=1 and nvl(trunc(wdj.date_closed),:p_period_start_date)>=:p_period_start_date 1 F Inclure les emplois fermés US Include Closed Jobs 10 2=2 :p_closed_jobs=2 and nvl(trunc(wdj.date_closed),:p_period_close_date+1)>:p_period_close_date 2 F Inclure les emplois fermés US Include Closed Jobs 11 40 2=2 wpb.class_type=:p_class_type_code LOV Oracle WIP_SRS_CLASS_TYPE_OPT Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where lookup_type='WIP_CLASS_TYPE' order by meaning AR نوع الطبقة نوع الطبقة D Klassenart Klassenart F Type de classe Type classe I Tipo classe Tipo di classe US Class Type class type ZHS 分类类型 分类类型 12 3=3 wpb.class_type=:p_class_type_code F Type de classe US Class Type 13 50 2=2 wdj.class_code>=:p_class_code_from LOV custom Y select class_code value, null description from wip_accounting_classes where organization_id=:$flex$.Organization_ID and class_type=nvl(:$flex$.Class_Type, class_type) order by class_code AR الطبقات من الطبقات من D Von Klasse Von Klasse F Classes de Classes - De I Classi - Da Classi - Da US Classes From classes from ZHS 分类自 分类自 14 3=3 wri.class_code>=:p_class_code_from F Classes de US Classes From 15 60 2=2 wdj.class_code<=:p_class_code_to LOV custom Y select class_code value, null description from wip_accounting_classes where organization_id=:$flex$.Organization_ID and class_type=nvl(:$flex$.Class_Type, class_type) order by class_code :$flex$.Classes_From AR إلى الطبقات إلى D Bis Bis Klasse F Classes à Classes - A I A Classi - A US Classes To classes to ZHS 至 分类至 16 3=3 wri.class_code<=:p_class_code_to F Classes à US Classes To 17 70 2=2 we.wip_entity_name>=:p_job_sch_from LOV custom Y select wip_entity_name value, null description from wip_entities where organization_id=:$flex$.Organization_ID order by wip_entity_name AR أوامر الشغل/الجداول من أوامر شغل/جداول من D Von Fertigungsauftrag Von Fertigungsauftrag F Travail/horaire de OF/Programmes - De I OdL/Programmi da OdL/Programmi - Da US Job/Schedules From job/schedules from ZHS 任务/计划自 任务/计划自 18 3=3 we.wip_entity_name>=:p_job_sch_from F Travail/horaire de US Job/Schedules From 19 80 2=2 we.wip_entity_name<=:p_job_sch_to LOV custom Y select wip_entity_name value, null description from wip_entities where organization_id=:$flex$.Organization_ID order by wip_entity_name :$flex$.Job_Schedules_From AR إلى 2 أوامر شغل/جداول إلى D Bis 2 Bis Fertigungsauftrag F Travail/horaire à OF/Programmes - A I A 2 OdL/Programmi - A US Job/Schedules To job/schedules to ZHS 至 2 任务/计划至 20 3=3 we.wip_entity_name<=:p_job_sch_to F Travail/horaire à US Job/Schedules To 21 90 2=2 msik.concatenated_segments>=:p_assembly_from 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 Baugruppe Von Baugruppe F Assemblages de Produits - De I Assiemi - Da Assiemi - Da US Assemblies From assemblies from ZHS 装配件自 装配件自 22 3=3 msik.concatenated_segments>=:p_assembly_from F Assemblages de US Assemblies From 23 100 2=2 msik.concatenated_segments<=:p_assembly_to 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$.Assemblies_From AR إلى 3 المنتجات إلى D Bis 3 Bis Baugruppe F Assemblages à Produits - A I A 3 Assiemi - A US Assemblies To assemblies to ZHS 至 3 装配件至 24 3=3 msik.concatenated_segments<=:p_assembly_to F Assemblages à US Assemblies To 25 110 :p_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 SELECT GL.CURRENCY_CODE FROM ORG_ORGANIZATION_DEFINITIONS OOD, GL_SETS_OF_BOOKS GL WHERE OOD.ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND GL.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID Y AR رمز العملة رمز العملة D Währungsschlüssel Währung F Code devise Code devise I Codice divisa Codice divisa US Currency Code currency code ZHS 币种代码 币种代码 26 120 :p_exchange_rate_char LOV custom Y select actual_rate value, period description from cst_gl_translation_view where org_id=:$flex$.Organization_ID and code=:$flex$.Currency_Code and inverse=fnd_profile.value('DISPLAY_INVERSE_RATE') and rate_type=2 order by period_year desc,period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Kurs F Taux de change Taux de change I Tasso di cambio Tasso di cambio US Exchange Rate exchange rate ZHS 汇率 汇率 27 130 2=2 wdj.project_id=:p_project_id LOV custom Y select project_id id, name value, segment1 description from pa_projects_all where project_id in( select ppp.project_id from pjm_project_parameters ppp where ppp.organization_id= (select organization_id from mtl_parameters where organization_id=:$flex$.Organization_ID and project_reference_enabled=1 and cost_group_accounting=1 ) ) order by value,description AR معرف المشروع معرف المشروع D Projektkennung Projektkennung F Id. du projet ID projet I Id progetto Id progetto US Project Project Id ZHS 项目标识 项目标识 :$flex$.Assemblies_From Assemblies From Assemblies To :$flex$.Class_Type Class Type Classes From :$flex$.Class_Type Class Type Classes To :$flex$.Classes_From Classes From Classes To :$flex$.Currency_Code Currency Code Exchange Rate :$flex$.Currency_Code Currency Code Precision :$flex$.Job_Schedules_From Job/Schedules From Job/Schedules To :$flex$.Organization_Code Organization Code Organization Id :$flex$.Organization_ID Organization Id Classes From :$flex$.Organization_ID Organization Id Classes To :$flex$.Organization_ID Organization Id Exchange Rate :$flex$.Organization_ID Organization Id Job/Schedules From :$flex$.Organization_ID Organization Id Job/Schedules To :$flex$.Organization_ID Organization Id Period :$flex$.Organization_ID Organization Id Period Close Date :$flex$.Organization_ID Organization Id Period Id :$flex$.Organization_ID Organization Id Period Start Date :$flex$.Organization_ID Organization Id Project :$flex$.Period Period Period Id :$flex$.Period_ID Period Id Period Close Date :$flex$.Period_ID Period Id Period Start Date :$flex$.organization_code Organization Code Assemblies From :$flex$.organization_code Organization Code Assemblies To Detail: WIP value detail by Element/Variance GL Account WIP value detail breakdown at the Element/Variance GL Account level SYSADMIN 5 ASSEMBLY 6 3 CLASS 4 2 CLASS_TYPE 22 CLASS_TYPE_CODE 3 16 CTD_COSTS_INCURRED SUM 17 CTD_COSTS_RELIEVED SUM 20 CTD_NET_ACTIVITY SUM 19 CTD_SINGLE_LEVEL_VAR_RELIEVED SUM 18 CTD_VARIANCES_RELIEVED SUM 9 CURRENCY 23 ELEMENT_CODE 8 10 EXCHANGE_RATE 7 Element/Variance 8 GL_ACCOUNT 21 JOB_TYPE 2 4 Job/Line 5 1 ORGANIZATION 1 11 PTD_COSTS_INCURRED SUM 12 PTD_COSTS_RELIEVED SUM 15 PTD_NET_ACTIVITY SUM 14 PTD_SINGLE_LEVEL_VAR_RELIEVED SUM 13 PTD_VARIANCES_RELIEVED SUM 6 START_DATE 7 S Site Detail: WIP value detail by WIP Job/Repetitive Schedule WIP value detail by WIP Job/Repetitive Schedule SYSADMIN 5 ASSEMBLY 6 3 CLASS 4 2 CLASS_TYPE 18 CLASS_TYPE_CODE 3 13 CTD_COSTS_INCURRED SUM 14 CTD_COSTS_RELIEVED SUM 16 CTD_NET_ACTIVITY SUM 15 CTD_VARIANCES_RELIEVED SUM 7 CURRENCY 8 EXCHANGE_RATE 17 JOB_TYPE 2 4 Job/Line 5 1 ORGANIZATION 1 9 PTD_COSTS_INCURRED SUM 10 PTD_COSTS_RELIEVED SUM 12 PTD_NET_ACTIVITY SUM 11 PTD_VARIANCES_RELIEVED SUM 6 START_DATE 7 S Site Pivot: WIP Value by Cost Type, Class WIP Value Summary by Cost Type, Class with Drill Down to WIP Job Details SYSADMIN 5 ASSEMBLY 5 3 CLASS 3 2 CLASS_TYPE 18 CLASS_TYPE_CODE 2 19 CLASS_TYPE_PIVOT_LABEL 13 CTD_COSTS_INCURRED SUM 14 CTD_COSTS_RELIEVED SUM 16 CTD_NET_ACTIVITY SUM 15 CTD_VARIANCES_RELIEVED SUM 7 CURRENCY 8 EXCHANGE_RATE 17 JOB_TYPE 4 Job/Line 4 1 ORGANIZATION 1 9 PTD_COSTS_INCURRED SUM 10 PTD_COSTS_RELIEVED SUM 12 PTD_NET_ACTIVITY SUM 11 PTD_VARIANCES_RELIEVED SUM 6 START_DATE 6 CLASS ROW 3 CLASS_TYPE_PIVOT_LABEL ROW 2 CTD_COSTS_INCURRED VALUE 5 SUM CTD_COSTS_RELIEVED VALUE 6 SUM CTD_NET_ACTIVITY VALUE 8 SUM CTD_VARIANCES_RELIEVED VALUE 7 SUM JOB_TYPE ROW 1 PTD_COSTS_INCURRED VALUE 1 SUM PTD_COSTS_RELIEVED VALUE 2 SUM PTD_NET_ACTIVITY VALUE 4 SUM PTD_VARIANCES_RELIEVED VALUE 3 SUM S Site Pivot: WIP Value by Cost Type, Class, Element/Variance GL Account WIP Value Summary by Cost Type, Class, Element/Variance with Drill Down to WIP Job Details SYSADMIN 5 ASSEMBLY 6 3 CLASS 4 2 CLASS_TYPE 22 CLASS_TYPE_CODE 23 CLASS_TYPE_PIVOT_LABEL 3 16 CTD_COSTS_INCURRED SUM 17 CTD_COSTS_RELIEVED SUM 20 CTD_NET_ACTIVITY SUM 19 CTD_SINGLE_LEVEL_VAR_RELIEVED SUM 18 CTD_VARIANCES_RELIEVED SUM 9 CURRENCY 24 ELEMENT_CODE 8 10 EXCHANGE_RATE 7 Element/Variance 25 Element/Variance Pivot Label 8 GL_ACCOUNT 9 21 JOB_TYPE 2 4 Job/Line 5 1 ORGANIZATION 1 11 PTD_COSTS_INCURRED SUM 12 PTD_COSTS_RELIEVED SUM 15 PTD_NET_ACTIVITY SUM 14 PTD_SINGLE_LEVEL_VAR_RELIEVED SUM 13 PTD_VARIANCES_RELIEVED SUM 6 START_DATE 7 CLASS ROW 3 CLASS_TYPE_PIVOT_LABEL ROW 2 CTD_COSTS_INCURRED VALUE 6 SUM CTD_COSTS_RELIEVED VALUE 7 SUM CTD_NET_ACTIVITY VALUE 10 SUM CTD_SINGLE_LEVEL_VAR_RELIEVED VALUE 9 SUM CTD_VARIANCES_RELIEVED VALUE 8 SUM Element/Variance Pivot Label ROW 4 JOB_TYPE ROW 1 PTD_COSTS_INCURRED VALUE 1 SUM PTD_COSTS_RELIEVED VALUE 2 SUM PTD_NET_ACTIVITY VALUE 5 SUM PTD_SINGLE_LEVEL_VAR_RELIEVED VALUE 4 SUM PTD_VARIANCES_RELIEVED VALUE 3 SUM S Site Pivot: WIP Value by Element/Variance GL Account WIP Value Account Summary by Element/Variance GL Account with Drill Down to WIP Job Details SYSADMIN 19 ASSEMBLY 7 17 CLASS 6 16 CLASS_TYPE 24 CLASS_TYPE_CODE 5 25 CLASS_TYPE_PIVOT_LABEL 11 CTD_COSTS_INCURRED SUM 12 CTD_COSTS_RELIEVED SUM 15 CTD_NET_ACTIVITY SUM 14 CTD_SINGLE_LEVEL_VAR_RELIEVED SUM 13 CTD_VARIANCES_RELIEVED SUM 4 CURRENCY 21 ELEMENT_CODE 2 5 EXCHANGE_RATE 2 Element/Variance 22 Element/Variance Pivot Label 3 GL_ACCOUNT 3 23 JOB_TYPE 4 18 Job/Line 1 ORGANIZATION 1 6 PTD_COSTS_INCURRED SUM 7 PTD_COSTS_RELIEVED SUM 10 PTD_NET_ACTIVITY SUM 9 PTD_SINGLE_LEVEL_VAR_RELIEVED SUM 8 PTD_VARIANCES_RELIEVED SUM 20 START_DATE 8 CTD_COSTS_INCURRED VALUE 6 SUM CTD_COSTS_RELIEVED VALUE 7 SUM CTD_NET_ACTIVITY VALUE 10 SUM CTD_SINGLE_LEVEL_VAR_RELIEVED VALUE 9 SUM CTD_VARIANCES_RELIEVED VALUE 8 SUM Element/Variance Pivot Label ROW 1 PTD_COSTS_INCURRED VALUE 1 SUM PTD_COSTS_RELIEVED VALUE 2 SUM PTD_NET_ACTIVITY VALUE 5 SUM PTD_SINGLE_LEVEL_VAR_RELIEVED VALUE 4 SUM PTD_VARIANCES_RELIEVED VALUE 3 SUM S Site SYSADMIN Pivot: WIP Value by Cost Type, Class, Element/Variance GL Account DEVELOPER Pivot: WIP Value by Cost Type, Class, Element/Variance GL Account Pivot: WIP Value by Cost Type, Class