ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470C651A9E05362FB09050512Y SELECT null C_item, null C_category, sys.planner_code C_planner, emp.full_name C_buyer, &P_DYNAMIC_ABC C_abc_class_name, sys.description C_description, nvl(sys.preprocessing_lead_time,0) + nvl(sys.full_lead_time,0) + nvl(sys.postprocessing_lead_time,0) C_ord_lead_time, nvl(sys.preprocessing_lead_time,0) + nvl(sys.full_lead_time,0) C_pur_lead_time, sys.inventory_item_id C_item_id, sys.planning_make_buy_code C_make_buy, sys.fixed_lead_time C_fixed_lead_time, sys.variable_lead_time C_variable_lead_time, sys.primary_uom_code C_primary_uom, sys.fixed_lot_multiplier C_fix_lot_mult, sys.minimum_order_quantity C_min_ord_qty, sys.maximum_order_quantity C_max_ord_qty, param.ap_accrual_account C_accrual_acct, param.invoice_price_var_account C_ipv_acct, NVL(sys.encumbrance_account, param.encumbrance_account) C_budget_acct, DECODE(sys.inventory_asset_flag, 'Y', param.material_account, NVL(sys.expense_account, param.expense_account)) C_charge_acct, sys.purchasing_enabled_flag C_purch_flag, sys.internal_order_enabled_flag C_order_flag, sys.list_price_per_unit C_unit_price, sys.build_in_wip_flag C_build_in_wip, sys.pick_components_flag C_pick_components, NVL(param.process_enabled_flag,'N') C_process_enabled, NVL(sys.recipe_enabled_flag,'N') C_recipe_enabled, NVL(sys.process_execution_enabled_flag,'N') C_execution_enabled, sys.repetitive_planning_flag C_repetitive_planned_item, NVL(sys.source_type, param.source_type) C_src_type, DECODE(sys.source_type, NULL, DECODE(param.source_type, NULL, NULL, param.source_organization_id), sys.source_organization_id) C_SRC_ORG, DECODE(sys.source_type, NULL, DECODE(param.source_type, NULL, NULL, param.source_subinventory), sys.source_subinventory) C_src_subinv, sys.lot_control_code C_lot_control, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item', 'INV', 'MSTK', 101, sys.ORGANIZATION_ID, sys.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat', 'INV', 'MCAT', cat.STRUCTURE_ID, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT, MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 )) C_SAFETY_STOCK, MRP_MRPRPROP_XMLP_PKG.c_reorder_pointformula(MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ))) C_REORDER_POINT, MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code) C_DEMAND_QTY, MRP_MRPRPROP_XMLP_PKG.c_reorder_qtyformula(sys.inventory_item_id, MRP_MRPRPROP_XMLP_PKG.c_tot_availformula(MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code)), MRP_MRPRPROP_XMLP_PKG.c_reorder_pointformula(MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ))), sys.fixed_lot_multiplier, sys.minimum_order_quantity, sys.maximum_order_quantity) C_REORDER_QTY, MRP_MRPRPROP_XMLP_PKG.c_tot_availformula(MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code)) C_TOT_AVAIL, MRP_MRPRPROP_XMLP_PKG.c_run_restockformula(MRP_MRPRPROP_XMLP_PKG.c_tot_availformula(MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code)), MRP_MRPRPROP_XMLP_PKG.c_reorder_pointformula(MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ))), sys.repetitive_planning_flag, sys.planning_make_buy_code, DECODE ( sys.inventory_asset_flag , 'Y' , param.material_account , NVL ( sys.expense_account , param.expense_account ) ), param.ap_accrual_account, param.invoice_price_var_account, NVL ( sys.encumbrance_account , param.encumbrance_account ), NVL ( sys.source_type , param.source_type ), DECODE ( sys.source_type , NULL , DECODE ( param.source_type , NULL , NULL , param.source_organization_id ) , sys.source_organization_id ), sys.internal_order_enabled_flag, sys.purchasing_enabled_flag, NVL ( param.process_enabled_flag , 'N' ), sys.build_in_wip_flag, sys.pick_components_flag, NVL ( sys.recipe_enabled_flag , 'N' ), NVL ( sys.process_execution_enabled_flag , 'N' ), sys.inventory_item_id, :C_REORDER_QTY, sys.fixed_lead_time, sys.variable_lead_time, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ), sys.primary_uom_code, sys.list_price_per_unit, sys.description, DECODE ( sys.source_type , NULL , DECODE ( param.source_type , NULL , NULL , param.source_subinventory ) , sys.source_subinventory )) C_RUN_RESTOCK, MRP_MRPRPROP_XMLP_PKG.C_LEAD_TIME_DEMAND_p C_LEAD_TIME_DEMAND, MRP_MRPRPROP_XMLP_PKG.C_ONHAND_QTY_p C_ONHAND_QTY, MRP_MRPRPROP_XMLP_PKG.C_SUPPLY_QTY_p C_SUPPLY_QTY FROM mtl_categories cat, per_all_people_f emp, &C_ABC_FROM mtl_item_categories ic, mtl_parameters param, mtl_system_items_vl sys WHERE cat.category_id = ic.category_id AND sys.inventory_item_flag = 'Y' &C_PLANNER_RANGE &C_BUYER_RANGE &C_ABC_RANGE &C_ABC_WHERE &C_CATEGORY_WHERE AND &P_ITEM_RANGE AND &P_CAT_RANGE AND emp.person_id(+) = sys.buyer_id AND sysdate between emp.effective_start_date(+) and emp.effective_end_date(+) AND ic.organization_id = sys.organization_id AND sys.organization_id = :P_ORG_ID AND param.organization_id = sys.organization_id AND sys.inventory_planning_code = '1' AND :P_LEVEL = 1 AND sys.inventory_item_flag = 'Y' AND ic.category_set_id = :P_CATEGORY_SET AND ic.inventory_item_id = sys.inventory_item_id UNION SELECT null C_item, null C_category, sys.planner_code C_planner, emp.full_name C_buyer, &P_DYNAMIC_ABC C_abc_class_name, sys.description C_description, nvl(sub.preprocessing_lead_time,0) + nvl(sub.processing_lead_time,0) + nvl(sub.postprocessing_lead_time,0) C_ord_lead_time, nvl(sub.preprocessing_lead_time,0) + nvl(sub.processing_lead_time,0) C_pur_lead_time, sys.inventory_item_id C_item_id, sys.planning_make_buy_code C_make_buy, sys.fixed_lead_time C_fixed_lead_time, sys.variable_lead_time C_variable_lead_time, sys.primary_uom_code C_primary_uom, sub.fixed_lot_multiple C_fix_lot_mult, sub.minimum_order_quantity C_min_ord_qty, sub.maximum_order_quantity C_max_ord_qty, param.ap_accrual_account C_accrual_acct, param.invoice_price_var_account C_ipv_acct, NVL(sec.encumbrance_account, NVL(sec.encumbrance_account,NVL(sys.encumbrance_account, param.encumbrance_account))) C_budget_acct, DECODE(sys.inventory_asset_flag, 'Y', sec.material_account, NVL(sec.expense_account, NVL(sys.expense_account, param.expense_account))) C_charge_acct, sys.purchasing_enabled_flag C_purch_flag, sys.internal_order_enabled_flag C_order_flag, sys.list_price_per_unit C_unit_price, sys.build_in_wip_flag C_build_in_wip, sys.pick_components_flag C_pick_components, NVL(param.process_enabled_flag,'N') C_process_enabled, NVL(sys.recipe_enabled_flag,'N') C_recipe_enabled, NVL(sys.process_execution_enabled_flag,'N') C_execution_enabled, sys.repetitive_planning_flag C_repetitive_planned_item, NVL(sub.source_type, NVL(sec.source_type, NVL(sys.source_type, param.source_type))) C_src_type, DECODE(sub.source_type, NULL, DECODE(sec.source_type, NULL, DECODE(sys.source_type, NULL, DECODE(param.source_type, NULL, NULL, param.source_organization_id), sys.source_organization_id), sec.source_organization_id), sub.source_organization_id) C_SRC_ORG, DECODE(sub.source_type, NULL, DECODE(sec.source_type, NULL, DECODE(sys.source_type, NULL, DECODE(param.source_type, NULL, NULL, param.source_subinventory), sys.source_subinventory), sec.source_subinventory), sub.source_subinventory) C_src_subinv, sys.lot_control_code C_lot_control, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item', 'INV', 'MSTK', 101, sys.ORGANIZATION_ID, sys.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat', 'INV', 'MCAT', cat.STRUCTURE_ID, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT, MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 )) C_SAFETY_STOCK, MRP_MRPRPROP_XMLP_PKG.c_reorder_pointformula(MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ))) C_REORDER_POINT, MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code) C_DEMAND_QTY, MRP_MRPRPROP_XMLP_PKG.c_reorder_qtyformula(sys.inventory_item_id,MRP_MRPRPROP_XMLP_PKG.c_tot_availformula(MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code)), MRP_MRPRPROP_XMLP_PKG.c_reorder_pointformula(MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ))), sys.fixed_lot_multiplier, sys.minimum_order_quantity, sys.maximum_order_quantity) C_REORDER_QTY, MRP_MRPRPROP_XMLP_PKG.c_tot_availformula(MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code)) C_TOT_AVAIL, MRP_MRPRPROP_XMLP_PKG.c_run_restockformula(MRP_MRPRPROP_XMLP_PKG.c_tot_availformula(MRP_MRPRPROP_XMLP_PKG.c_demand_qtyformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ), sys.lot_control_code)), MRP_MRPRPROP_XMLP_PKG.c_reorder_pointformula(MRP_MRPRPROP_XMLP_PKG.c_safety_stockformula(sys.inventory_item_id, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ) + nvl ( sys.postprocessing_lead_time , 0 ))), sys.repetitive_planning_flag, sys.planning_make_buy_code, DECODE ( sys.inventory_asset_flag , 'Y' , param.material_account , NVL ( sys.expense_account , param.expense_account ) ), param.ap_accrual_account, param.invoice_price_var_account, NVL ( sys.encumbrance_account , param.encumbrance_account ), NVL ( sys.source_type , param.source_type ), DECODE ( sys.source_type , NULL , DECODE ( param.source_type , NULL , NULL , param.source_organization_id ) , sys.source_organization_id ), sys.internal_order_enabled_flag, sys.purchasing_enabled_flag, NVL ( param.process_enabled_flag , 'N' ), sys.build_in_wip_flag, sys.pick_components_flag, NVL ( sys.recipe_enabled_flag , 'N' ), NVL ( sys.process_execution_enabled_flag , 'N' ), sys.inventory_item_id, :C_REORDER_QTY, sys.fixed_lead_time, sys.variable_lead_time, nvl ( sys.preprocessing_lead_time , 0 ) + nvl ( sys.full_lead_time , 0 ), sys.primary_uom_code, sys.list_price_per_unit, sys.description, DECODE ( sys.source_type , NULL , DECODE ( param.source_type , NULL , NULL , param.source_subinventory ) , sys.source_subinventory )) C_RUN_RESTOCK, MRP_MRPRPROP_XMLP_PKG.C_LEAD_TIME_DEMAND_p C_LEAD_TIME_DEMAND, MRP_MRPRPROP_XMLP_PKG.C_ONHAND_QTY_p C_ONHAND_QTY, MRP_MRPRPROP_XMLP_PKG.C_SUPPLY_QTY_p C_SUPPLY_QTY FROM mtl_categories cat, per_all_people_f emp, &C_ABC_FROM mtl_item_categories ic, mtl_parameters param, mtl_system_items_vl sys, mtl_secondary_inventories sec, mtl_item_sub_inventories sub WHERE cat.category_id = ic.category_id AND sys.inventory_item_flag = 'Y' &C_PLANNER_RANGE &C_BUYER_RANGE &C_ABC_RANGE &C_ABC_WHERE &C_CATEGORY_WHERE AND &P_ITEM_RANGE AND &P_CAT_RANGE AND emp.person_id(+) = sys.buyer_id AND sysdate between emp.effective_start_date(+) and emp.effective_end_date(+) AND ic.organization_id = sys.organization_id AND sys.organization_id = :P_ORG_ID AND param.organization_id = sys.organization_id AND sub.inventory_planning_code = '1' AND :P_LEVEL = 2 AND sys.inventory_item_flag = 'Y' AND ic.category_set_id = :P_CATEGORY_SET AND ic.inventory_item_id = sys.inventory_item_id AND sub.inventory_item_id = sys.inventory_item_id AND sub.organization_id = sys.organization_id AND sec.organization_id = sys.organization_id AND sec.secondary_inventory_name = :P_SUBINV AND sec.secondary_inventory_name = sub.secondary_inventory ORDER BY &C_ORDER_BY MRP MRPRPROP_XML AR MRP تقرير نقاط إعادة الطلب (بتنسيق XML) Imported from BI Publisher Description: تقرير نقطة إعادة الطلب Application: الجدولة الرئيسية/MRP Source: تقرير نقاط إعادة الطلب (بتنسيق XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG D MRP Bestellpunktplanung Imported from BI Publisher Description: Bestellpunktplanung Application: Materialbedarfsplanung/Produktionsplanung Source: Bestellpunktplanung (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG E MRP Punto de Pedido Imported from BI Publisher Description: Informe de punto de pedido Application: Master Scheduling/MRP Source: Punto de Pedido (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG F MRP Etat des points de commande Imported from BI Publisher Description: Etat Point de commande Application: Master Scheduling/MRP Source: Etat des points de commande (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG I MRP Rapporto Punto di riordino Imported from BI Publisher Description: Rapporto Punto di riordino Application: Master Scheduling/MRP Source: Rapporto Punto di riordino (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG JA MRP 再発注点レポート Imported from BI Publisher Description: 再発注点レポート Application: Master Scheduling/MRP Source: 再発注点レポート(XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG KO MRP 재주문점 보고서 Imported from BI Publisher Description: 재주문점 보고서 Application: Master Scheduling/MRP Source: 재주문점 보고서(XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG PTB MRP Relatório de Ponto de Reposição Imported from BI Publisher Description: Relatório de Ponto de Reposição Application: Master Scheduling/MRP Source: Relatório de Ponto de Reposição (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG RU MRP Отчет о планировании повторных заказов Imported from BI Publisher Description: Отчет о планировании повторных заказов Application: Основное планирование Source: Отчет о планировании повторных заказов (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG S MRP Beställningspunkt - rapport Imported from BI Publisher Description: Beställningspunkt - rapport Application: Master Scheduling/MRP Source: Beställningspunkt - rapport (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG TR MRP Yeniden Sipariş Noktası Raporu Imported from BI Publisher Description: Yeniden Sipariş Noktası Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Yeniden Sipariş Noktası Raporu (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG US MRP Reorder Point Imported from BI Publisher Description: Reorder Point Report Application: Master Scheduling/MRP Source: Reorder Point Report (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG ZHS MRP 再订购点报表 Imported from BI Publisher Description: 再订购点报表 Application: 主计划/MRP 管理系统 Source: 再订购点报表 (XML) Short Name: MRPRPROP_XML DB package: MRP_MRPRPROP_XMLP_PKG BI Publisher &c_abc_from &c_abc_range &c_abc_where &c_buyer_range &c_category_where &c_order_by &c_planner_range &p_cat_range &p_dynamic_abc &p_item_range :c_lead_time_demand :c_onhand_qty :c_reorder_qty :c_supply_qty :char_qty :dp_demand_cutoff_date :dp_supply_cutoff_date :p_abc_assgn :p_abc_class :p_approval :p_cal_code :p_cat_range :p_cat_struct_num :p_category_set :p_conc_request_id :p_current_date :p_customer_id :p_debug :p_default_delivery_to :p_demand_cutoff_date :p_display_add_info :p_display_description :p_dynamic_abc :p_employee_id :p_encum_flag :p_exc_set_id :p_first_sort :p_flexdata_cat :p_flexdata_item :p_forecast :p_high_buyer :p_high_cat :p_high_item :p_high_planner :p_include_if :p_include_nonnet :p_include_po :p_include_wip :p_item_order_by :p_item_range :p_item_selection :p_level :p_low_buyer :p_low_cat :p_low_item :p_low_planner :p_message_batch :p_message_po1 :p_message_po2 :p_message_po3 :p_message_po4 :p_message_wip1 :p_message_wip2 :p_net_rsv :p_net_unrsv :p_net_wip :p_order_by :p_org_id :p_po_org_id :p_profile :p_pur_revision :p_repetitive_item :p_repetitive_message :p_restock :p_second_sort :p_subinv :p_supply_cutoff_date :p_third_sort :p_user_id :p_wip_batch_id 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F ID organisation ID organisation I Id organizzazione Id dell'organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB Id da Organização Id da Organização RU Идент. организ. Идент. организ. S Organisations-id Organisations-id TR Organizasyon No Organizasyon No US Organization Id Organization Id ZHS 组织标识 组织标识 2 -30 :p_cat_struct_num Number select structure_id from mtl_category_sets where category_set_id = :$flex$.category_set AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de catégorie Structure de catégorie I Struttura categoria Struttura categoria JA カテゴリ体系 カテゴリ体系 KO 범주 구조 범주 구조 PTB Estrutura da Categoria Estrutura da Categoria RU Структура категорий Структура категорий S Kategoristruktur Kategoristruktur TR Kategori Yapısı Kategori Yapısı US Category Structure Category Structure ZHS 类别结构 类别结构 3 -20 :p_user_id Number fnd_profile.value('USER_ID') AR معرف المستخدم معرف المستخدم D Benutzerkennung Benutzerkennung E Id Usuario Id Usuario F ID utilisateur ID utilisateur I ID utente ID utente JA ユーザーID ユーザーID KO 사용자 ID 사용자 ID PTB Id do Usuário Id do Usuário RU Идентификатор пользователя Идентификатор пользователя S Användar-id Användar-id TR Kullanıcı No Kullanıcı No US User Id User Id ZHS 用户标识 用户标识 4 10 :p_item_selection LOV Oracle INV_SRS_REORDER_RPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_REORDER_RPT' order by lookup_code select meaning from mfg_lookups where lookup_type = 'MTL_REORDER_RPT' and lookup_code = 1 Y AR اختيار الصنف اختيار الصنف D Artikelauswahl Artikelauswahl E Selección de Artículos Selección de Artículos F Sélection article Sélection article I Selezione articolo Selezione articolo JA 品目選択 品目選択 KO 품목 선택 품목 선택 PTB Seleção de Item Seleção de Item RU Отбор позиций Отбор позиций S Artikelurval Artikelurval TR Kalem Seçimi Kalem Seçimi US Item Selection Item Selection ZHS 物料选择 物料选择 5 20 :p_demand_cutoff_date Date sysdate Y AR تاريخ قطع الطلب تاريخ قطع الطلب D Bedarfshorizont Bedarfshorizont E Fecha de Corte de Demanda Fecha de Corte de Demanda F Date limite de besoin Date limite de besoin I Data limite domanda Data limite domanda JA 需要切捨て日 需要切捨て日 KO 수요 마감 일자 수요 마감 일자 PTB Data-Limite de Demanda Data-Limite de Demanda RU Дата прекращения спроса Дата прекращения спроса S Brytdatum för behov Brytdatum för behov TR Talep Bitiş Tarihi Talep Bitiş Tarihi US Demand Cutoff Date Demand Cutoff Date ZHS 需求截止日期 需求截止日期 6 30 :p_supply_cutoff_date Date sysdate Y AR تاريخ قطع التوريد تاريخ قطع التوريد D Bedarfsdeckungshorizont Bedarfsdeckungshorizont E Fecha de Corte de Aprovisionamiento Fecha de Corte de Aprovisionamiento F Date limite d'approvisionnement Date limite d'approvisionnement I Data limite fornitura Data limite fornitura JA 供給切捨て日 供給切捨て日 KO 공급 마감 일자 공급 마감 일자 PTB Data-Limite para Suprimento Data-Limite para Suprimento RU Дата прекращения предложения Дата прекращения предложения S Brytdatum för tillgångar Brytdatum för tillgångar TR Tedarik Bitiş Tarihi Tedarik Bitiş Tarihi US Supply Cutoff Date Supply Cutoff Date ZHS 供应截止日期 供应截止日期 7 40 :p_restock LOV Oracle MRP_SRS_ROP_RESTOCK Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR إعادة تخزين إعادة تخزين D Wiederauffüllen Wiederauffüllen E Reabastecer Reabastecer F Réapprovisionner Réapprovisionner I Nuova scorta Nuova scorta JA 仕入 仕入 KO 재저장 재저장 PTB Reabastecer Reabastecer RU Пополнение запасов Пополнение запасов S Fylla på lagret Fylla på lagret TR Yeniden stoklar Yeniden stoklar US Restock Restock ZHS 重新进货 重新进货 8 50 :p_default_delivery_to LOV Oracle MRP_SRS_ROP_DEF_LOC Y select location_id id, location_code value, description description from hr_locations where nvl(inventory_organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description select location_code from hr_organization_units org, hr_locations loc where org.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') and org.location_id = loc.location_id Y AR تسليم افتراضي إلى تسليم افتراضي إلى D Standardlieferung an Standardlieferung an E Dirección de Entrega por Defecto Dirección de Entrega por Defecto F Mise à disposition par défaut à Mise à disposition par défaut à I Ubicazione di consegna predefinita Ubicazione di consegna predefinita JA デフォルト搬送先 デフォルト搬送先 KO 기본 납품처 기본 납품처 PTB Distribuição Interna Padrão para Distribuição Interna Padrão para RU Конечный получатель по умолчанию Конечный получатель по умолчанию S Standardleveransadress Standardleveransadress TR Teslimat Öndeğeri: Son Teslimat Öndeğeri: Son US Default Delivery To Default Delivery To ZHS 默认收货方 默认收货方 9 60 :p_forecast LOV Oracle MRP_SRS_FORECAST_NAME Y select forecast_designator id, forecast_designator value, description description from mrp_forecast_designators forecast where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(disable_date,sysdate)>=sysdate order by value,description Y AR تقدير تقدير E Previsión Previsión F Prévision Prévision I Previsione Previsione JA 需要予測 需要予測 KO 예측 예측 PTB Previsão Previsão RU Прогноз Прогноз S Prognos Prognos TR Tahmin Tahmin US Forecast Forecast ZHS 预测 预测 10 70 :p_first_sort LOV Oracle MRP_SRS_FIRST_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_DATA_SELECT' order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_DATA_SELECT' and lookup_code = 1 Y AR فرز أول فرز أول D Erste Sortierung Erste Sortierung E Primera Ordenación Primera Ordenación F Premier tri Premier tri I Primo ordinamento Primo ordinamento JA 第1ソート 第1ソート KO 1차 정렬 1차 정렬 PTB Primeira Classificação Primeira Classificação RU Первая сортировка Первая сортировка S Första sortering Första sortering TR İlk Sıralama İlk Sıralama US First Sort First Sort ZHS 第一种排序 第一种排序 11 80 :p_second_sort LOV Oracle MRP_SRS_SECOND_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_DATA_SELECT' and ((lookup_code<>:$flex$.mrp_srs_first_sort and :$flex$.mrp_srs_first_sort<>0) or lookup_code=0) order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_DATA_SELECT' and lookup_code = 0 Y AR الفرز الثاني الفرز الثاني D Zweite Sortierung Zweite Sortierung E Segunda Ordenación Segunda Ordenación F Deuxième tri Deuxième tri I Secondo ordinamento Secondo ordinamento JA 第2ソート 第2ソート KO 2차 정렬 2차 정렬 PTB Segunda Classificação Segunda Classificação RU Вторая сортировка Вторая сортировка S Andra sortering Andra sortering TR İkinci Sıralama İkinci Sıralama US Second Sort Second Sort ZHS 第二种排序 第二种排序 12 90 :p_third_sort LOV Oracle MRP_SRS_THIRD_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_DATA_SELECT' and ((lookup_code<>:$flex$.mrp_srs_first_sort and lookup_code<>:$flex$.mrp_srs_second_sort and :$flex$.mrp_srs_second_sort<>0) or (lookup_code=0) ) order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_DATA_SELECT' and lookup_code = 0 Y AR فرز ثالث فرز ثالث D Dritte Sortierung Dritte Sortierung E Tercera Ordenación Tercera Ordenación F Troisième tri Troisième tri I Terzo ordinamento Terzo ordinamento JA 第3ソート 第3ソート KO 3차 정렬 3차 정렬 PTB Terceira Classific. Terceira Classific. RU Третья сортировка Третья сортировка S Tredje sortering Tredje sortering TR Üçüncü Sıralama Üçüncü Sıralama US Third Sort Third Sort ZHS 第三种排序 第三种排序 13 100 :p_low_item Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 14 110 :p_high_item Char AR إلى الأصناف إلى D Bis Bis Artikel E A A Artículo F A Articles - A I A Articoli - A JA 至 品目:至 KO 까지 품목: 까지 PTB Até Itens - Até RU По Позиции по S Till Till artiklar TR Son Kalemler, Son US To Items To ZHS 至 物料至 15 120 :p_low_planner LOV Oracle WIP_SRS_PLANNER_CODE_FROM_OPT Y select planner_code id, planner_code value, null description from mtl_planners where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by planner_code AR مخططون من مخططون من D Von Planer Von Planer E De Planificador De Planificador F Gestionnaires - De Gestionnaires - De I Planner - Da Planner - Da JA 計画担当:自 計画担当:自 KO 계획자: 부터 계획자: 부터 PTB Planejadores - De Planejadores - De RU Плановики с Плановики с S Från planerare Från planerare TR Planlayıcılar: İlk Planlayıcılar: İlk US Planners From Planners From ZHS 计划员自 计划员自 16 130 :p_high_planner LOV Oracle WIP_SRS_PLANNER_CODE_TO_OPT Y select planner_code id, planner_code value, null description from mtl_planners where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by planner_code AR إلى 2 مخططون إلى D Bis 2 Bis Planer E A 2 A Planificador F A 2 Gestionnaires - A I A 2 Planner - A JA 至 2 計画担当 至 KO 까지 2 계획자: 까지 PTB Até 2 Planejadores Até RU По 2 Плановики по S Till 2 Planerare till TR Son 2 Planlayıcılar: Son US To 2 Planners To ZHS 至 2 计划员至 17 140 :p_low_buyer LOV Oracle MRP_SRS_BUYER Y select a.agent_id id, h.full_name value, null description from po_agents a,hr_employees h where a.agent_id=h.employee_id order by value,description AR مشترون من مشترون من D Von Einkäufer Von Einkäufer E De Comprad. De Comprad. F Acheteurs - De Acheteurs - De I Buyer - Da Buyer - Da JA 購買担当:自 購買担当:自 KO 구매자: 부터 구매자: 부터 PTB Compradores - De Compradores - De RU Покупатели с Покупатели с S Från inköpare Från inköpare TR Satın Alanlar: İlk Satın Alanlar: İlk US Buyers From Buyers From ZHS 采购员自 采购员自 18 150 :p_high_buyer LOV Oracle MRP_SRS_BUYER Y select a.agent_id id, h.full_name value, null description from po_agents a,hr_employees h where a.agent_id=h.employee_id order by value,description AR إلى 3 مشترون إلى D Bis 3 Bis Einkäufer E A 3 A Comprador F A 3 Acheteurs - A I A 3 Buyer - A JA 至 3 購買担当:至 KO 까지 3 구매자: 까지 PTB Até 3 Compradores Até RU По 3 Покупатели по S Till 3 Till inköpare TR Son 3 Satın Alanlar, Son US To 3 Buyers To ZHS 至 3 采购员至 19 160 :p_category_set 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 category_set_name from mtl_default_sets_view where functional_area_id = 3 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conj. Categorias RU Набор катег. Набор катег. S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 20 170 :p_low_cat Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 21 180 :p_high_cat Char AR إلى 4 الفئات إلى D Bis 4 Bis Kategorie E A 4 A F A 4 Catégories - A I A 4 Categorie - A JA 至 4 カテゴリ:至 KO 까지 4 범주: 까지 PTB Até 4 Categorias - Até RU По 4 Категории по S Till 4 Till kategorier TR Son 4 Kategoriler: Son US To 4 Categories To ZHS 至 4 类别至 22 190 :p_abc_assgn LOV Oracle MRP_SRS_ABC_ASSIGNMENTS Y select assignment_group_id id, assignment_group_name value, null description from mtl_abc_assignment_groups where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description AR مجموعة تخصيص ABC مجموعة تخصيص ABC D ABC-Zuordnungsgruppe ABC-Zuordnungsgruppe E Grupo de Asignaciones ABC Grupo de Asignaciones ABC F Groupe d'affectations ABC Groupe d'affectations ABC I Gruppo Classificazione ABC Gruppo Classificazione ABC JA ABC割当グループ ABC割当グループ KO ABC 그룹 지정 ABC 그룹 지정 PTB Grupo de Atribuições ABC Grupo de Atribuições ABC RU Группа назначения ABC Группа назначения ABC S ABC-tilldelningsgrupp ABC-tilldelningsgrupp TR ABC Atama Grubu ABC Atama Grubu US ABC Assignment Group ABC Assignment Group ZHS ABC 分配组 ABC 分配组 23 200 :p_abc_class LOV Oracle MRP_SRS_ABC_CLASS Y select assgn.abc_class_id id, abc_class_name value, description description from mtl_abc_assgn_group_classes assgn,mtl_abc_classes class where assgn.abc_class_id=class.abc_class_id and assgn.assignment_group_id= :$flex$.mrp_srs_abc_assignments order by value,description AR طبقة ABC طبقة ABC D ABC-Klasse ABC-Klasse E Clase ABC Clase ABC F Classe ABC Classe ABC I Classe ABC Classe ABC JA ABC区分 ABC区分 KO ABC 분류 ABC 분류 PTB Classe ABC Classe ABC RU Класс ABC Класс ABC S ABC-klass ABC-klass TR ABC Sınıfı ABC Sınıfı US ABC Class ABC Class ZHS ABC 分类 ABC 分类 24 210 :p_include_po LOV Oracle MRP_SRS_SYS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 1 Y AR يتضمن توريد أمر الشراء يتضمن توريد أمر الشراء D Mit Bestellbestand Mit Bestellbestand E Incluir Aprovisionamiento de Pedido de Compra Incluir Aprovisionamiento de Pedido de Compra F Inclure l'approvisionnement de commande Inclure l'approvisionnement de commande I Includi fornitura OA Includi fornitura OA JA PO供給を含む PO供給を含む KO PO 공급 포함 PO 공급 포함 PTB Incluir Suprimento da OC Incluir Suprimento da OC RU Включить предложение ЗП Включить предложение ЗП S Inkludera inköpsorder Inkludera inköpsorder TR SS Tedariği Dahil SS Tedariği Dahil US Include PO Supply Include PO Supply ZHS 包括 PO 供应 包括 PO 供应 25 220 :p_include_wip LOV Oracle MRP_SRS_SYS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR يتضمن توريد ما تحت التنفيذ يتضمن توريد ما تحت التنفيذ D Mit Fertigungsbestand Mit Fertigungsbestand E Incluir Aprovisionamiento de Obra en Curso Incluir Aprovisionamiento de Obra en Curso F Inclure l'approvisionnement atelier Inclure l'approvisionnement atelier I Includi fornitura WIP Includi fornitura WIP JA WIP供給を含む WIP供給を含む KO WIP 공급 포함 WIP 공급 포함 PTB Incluir Suprimento do WIP Incluir Suprimento do WIP RU Включить предложение НзП Включить предложение НзП S Inkludera PIA Inkludera PIA TR WIP Tedariğini Dahil Et WIP Tedariğini Dahil Et US Include WIP Supply Include WIP Supply ZHS 包括 WIP 供应 包括 WIP 供应 26 230 :p_include_if LOV Oracle MRP_SRS_SYS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 1 Y AR يتضمن توريد الوسيط يتضمن توريد الوسيط D Mit Bedarfsdeckung aus Schnittstelle Mit Bedarfsdeckung aus Schnittstelle E Incluir Aprovisionamiento de Interfaz Incluir Aprovisionamiento de Interfaz F Inclure approvisionnement importation Inclure approvisionnement importation I Includi fornitura interfaccia Includi fornitura interfaccia JA 供給インタフェースを含む 供給インタフェースを含む KO 인터페이스 공급 포함 인터페이스 공급 포함 PTB Incluir Suprimento de Interface Incluir Suprimento de Interface RU Включить предложение интерфейса Включить предложение интерфейса S Inkludera gränssnittstillgångar Inkludera gränssnittstillgångar TR Arayüz Tedariğini Dahil Et Arayüz Tedariğini Dahil Et US Include Interface Supply Include Interface Supply ZHS 包括接口供应 包括接口供应 27 240 :p_include_nonnet LOV Oracle MRP_SRS_SYS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR يتضمن غير القابل للتصفية يتضمن المخازن غير القابلة للتصفية D Mit nicht nettierbaren Lägern Mit nicht nettierbaren Lägern E Incluir Almacenes con Cantidades Netas no Permitidas Incluir Subalmacenes con Cantidades Netas no Permitidas F Inclure non disponible Inclure magasins non disponibles pour le MRP I Includi sottomagazzini non nettabili Includi sottomagazzini non nettabili JA MRP算入不可を含む MRP算入不可保管場所を含む KO 비감안 포함 비감안 창고 포함 PTB Incluir Não-disponíveis Incluir Subinventários Não-disponíveis RU Включение не допускающих компенсацию Включение складских подразделений, не допускающих компенсацию S Inkludera icke-nettobehovsberäknade Inkludera icke-nettobehovsberäknade dellager TR Netlenemeyeni Dahil Et Netlenemeyen Stok Yerlerini Dahil Et US Include Non-nettable Include Non-nettable Subinventories ZHS 包括不可净得 包括不可净得子库存 28 250 :p_display_description LOV Oracle MRP_SRS_SYS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR عرض بيان الصنف عرض بيان الصنف D Artikelbeschreibung anzeigen Artikelbeschreibung anzeigen E Mostrar Descripción del Artículo Mostrar Descripción del Artículo F Afficher description article Afficher description article I Visualizza descrizione articolo Visualizza descrizione articolo JA 品目摘要表示 品目摘要表示 KO 품명 표시 품명 표시 PTB Exibir Item de Descrição Exibir Item de Descrição RU Вывод описания позиции Вывод описания позиции S Beskrivning av visningsobjekt Beskrivning av visningsobjekt TR Kalem Tanımlamasını Görüntüle Kalem Tanımlamasını Görüntüle US Display Item Description Display Item Description ZHS 显示物料说明 显示物料说明 29 260 :p_display_add_info LOV Oracle MRP_SRS_SYS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR عرض معلومات إضافية عرض معلومات إضافية D Weitere Daten anzeigen Weitere Daten anzeigen E Mostrar Información Adicional Mostrar Información Adicional F Afficher informations supplémentaires Afficher informations supplémentaires I Visualizza informazioni supplementari Visualizza informazioni supplementari JA 追加情報の表示 追加情報の表示 KO 추가 정보 표시 추가 정보 표시 PTB Exibir Informações Adicionais Exibir Informações Adicionais RU Вывод дополнительных сведений Вывод дополнительных сведений S Visa ytterligare information Visa ytterligare information TR Ek Bilgileri Görüntüle Ek Bilgileri Görüntüle US Display Additional Information Display Additional Information ZHS 显示附加信息 显示附加信息