ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470C451A9E05362FB09050512 SELECT null C_item , sys.description C_item_description , par.organization_code C_organization , req.uom_code C_uom , req.planner_code C_planner , req.buyer_name C_buyer , NVL(rec.schedule_compression_days, 0) C_compression_days , rec.new_order_placement_date C_order_date , rec.new_wip_start_date C_start_date , rec.new_dock_date C_dock_date , rec.new_schedule_date C_due_date , round(rec.new_order_quantity,:P_QTY_PRECISION) C_quantity , round(rec.new_order_quantity * NVL(req.standard_cost, 0),:P_PRECISION) C_value &C_SORT_COLUMN, 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 FROM mtl_item_categories ic , mrp_system_items req , mtl_system_items sys , mrp_recommendations rec , mrp_plan_organizations_v org_v , mtl_parameters par &C_CATEGORY_FROM &C_ABC_FROM WHERE sys.organization_id = rec.organization_id AND sys.inventory_item_id = rec.inventory_item_id &C_PLANNER_RANGE &C_BUYER_RANGE &C_ABC_RANGE &C_CATEGORY_WHERE &C_ABC_WHERE AND &P_ITEM_RANGE AND &P_CAT_RANGE AND ic.inventory_item_id = req.inventory_item_id AND ic.organization_id = req.organization_id AND ic.category_set_id = :P_CAT_SET AND req.organization_id = rec.organization_id AND req.planning_make_buy_code = NVL(:P_ITEM_SELECT,req.planning_make_buy_code) AND req.compile_designator = rec.compile_designator AND req.inventory_item_id = rec.inventory_item_id AND req.wip_supply_type != 6 AND &C_CUTOFF_COLUMN <= :P_CUTOFF_DATE AND rec.order_type = 5 AND rec.organization_id = org_v.planned_organization AND par.organization_id = rec.organization_id AND rec.compile_designator = org_v.compile_designator AND DECODE(:P_ORG_TYPE,1,org_v.planned_organization, org_v.organization_id) = :P_ORG_ID AND org_v.compile_designator = :P_PLAN_NAME ORDER BY &CP_ORDER_BY_1 &C_ORDER_BY Y MRP MRPRPPLO_XML AR MRP تقرير الأوامر المخططة (بتنسيق XML) Imported from BI Publisher Description: تقرير الأوامر المخططة Application: الجدولة الرئيسية/MRP Source: تقرير الأوامر المخططة (بتنسيق XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG D MRP Planaufträge Imported from BI Publisher Description: Planaufträge Application: Materialbedarfsplanung/Produktionsplanung Source: Planaufträge (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG E MRP Órdenes Planificadas Imported from BI Publisher Description: Informe de órdenes planificadas Application: Master Scheduling/MRP Source: Órdenes Planificadas (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG F MRP Etat Ordres planifiés Imported from BI Publisher Description: Etat Ordres planifiés Application: Master Scheduling/MRP Source: Etat Ordres planifiés (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG I MRP Rapporto Ordini pianificati Imported from BI Publisher Description: Rapporto Ordini pianificati Application: Master Scheduling/MRP Source: Rapporto Ordini pianificati (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG JA MRP 計画オーダー・レポート Imported from BI Publisher Description: 計画オーダー・レポート Application: Master Scheduling/MRP Source: 計画オーダー・レポート(XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG KO MRP 계획된 주문 보고서 Imported from BI Publisher Description: 계획된 주문 보고서 Application: Master Scheduling/MRP Source: 계획된 주문 보고서(XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG PTB MRP Relatório da Ordem Planejada Imported from BI Publisher Description: Relatório da Ordem Planejada Application: Master Scheduling/MRP Source: Relatório da Ordem Planejada (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG RU MRP Отчет о плановых заказах Imported from BI Publisher Description: Отчет о плановых заказах Application: Основное планирование Source: Отчет о плановых заказах (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG S MRP Planerad order - rapport Imported from BI Publisher Description: Planerad order - rapport Application: Master Scheduling/MRP Source: Planerad order - rapport (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG TR MRP Planlı Sipariş Raporu Imported from BI Publisher Description: Planlı Sipariş Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Planlı Sipariş Raporu (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG US MRP Planned Order Imported from BI Publisher Description: Planned Order Report Application: Master Scheduling/MRP Source: Planned Order Report (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG ZHS MRP 计划单报表 Imported from BI Publisher Description: 计划单报表 Application: 主计划/MRP 管理系统 Source: 计划单报表 (XML) Short Name: MRPRPPLO_XML DB package: MRP_MRPRPPLO_XMLP_PKG BI Publisher &c_abc_from &c_abc_range &c_abc_where &c_buyer_range &c_category_from &c_category_where &c_cutoff_column &c_order_by &c_planner_range &c_sort_column &cp_order_by_1 &p_cat_range &p_item_range :p_abc_assgn :p_abc_class :p_buyer :p_cat_range :p_cat_set :p_cat_struct :p_cat_struct_num :p_conc_request_id :p_currency_code :p_currency_desc :p_cutoff_column :p_cutoff_date :p_cutoff_date_1 :p_cutoff_type :p_debug :p_flexdata_item :p_high_cat :p_high_item :p_include_cost :p_item_order_by :p_item_range :p_item_select :p_low_cat :p_low_item :p_order_by :p_org_id :p_org_type :p_plan_name :p_planner :p_precision :p_qty_precision :p_sort :p_struct_num :qty_precision 1 -50 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Org.-Kennung Org.-Kennung E Id Organización Id Organización F ID org. ID org. I Id organizzazione ID org. JA 組織ID 組織ID KO 조직 ID 조직 ID PTB Id da Org. Id da Org. RU Идент. организации Идентификатор организации S Org.-id Org.-id TR Org no Org no US Org id Org id ZHS 组织标识 组织标识 2 -40 :p_cat_struct 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 -30 :p_currency_code LOV Oracle MRP_SRS_CURRENCY_CODES Y select currency_code id, currency_code value, name description from fnd_currencies_vl where trunc(nvl(end_date_active,sysdate +1))>trunc(sysdate) and trunc(nvl( start_date_active,sysdate-1))< trunc(sysdate) order by value,description select currency_code from GL_SETS_OF_BOOKS where set_of_books_id IN (select SET_OF_BOOKS_ID from org_organization_definitions where ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID')) Y AR رمز العملة رمز العملة D Währungsschlüssel Währungsschlüssel E Código de Divisa Código de Divisa F Code devise Code devise I Codice divisa Codice divisa JA 通貨コード 通貨コード KO 통화 코드 통화 코드 PTB Cód. da Moeda Cód. da Moeda RU Код валюты Код валюты S Valutakod Valutakod TR Para Birimi Kodu Para Birimi Kodu US Currency Code Currency Code ZHS 币种代码 币种代码 4 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية الدقة المستخدمة للكميات D Nachkommastellen Nachkommastellen bei Mengen E Precisión de Cantidad Precisión para utilizar con las cantidades F Précision des quantités Précision à utiliser pour les quantités I Precisione quantità Precisione da utilizzare per quantità JA 数量精度 数量に使用する精度 KO 수량 소수점이하 자리수 수량에 대해 사용할 소수점자리 PTB Precisão da Quantidade Precisão a ser utilizada para quantidades RU Точность количества Точность измерения количества S Kvantitetsprecision Precision för kvantiteter TR Miktar Duyarlılığı Miktarlar için kullanılacak duyarlılık US Quantity Precision Precision to use for quantities ZHS 数量精确度 数量精确度 5 10 :p_plan_name LOV Oracle MRP_SRS_PLAN_NAME Y select plan.compile_designator id, plan.compile_designator value, plan.description description from mrp_plans plan,mfg_lookups lu,mrp_plan_organizations_v pv where plan.organization_id= pv.organization_id and plan.compile_designator=pv.compile_designator and lu.lookup_type='MRP_PLAN_TYPE' and lu.lookup_code=plan.plan_type and pv.planned_organization= fnd_profile.value('MFG_ORGANIZATION_ID') and plan.plan_completion_date is not null and plan.data_completion_date is not null order by value,description select :parameter.char1 from dual Y AR اسم الخطة اسم الخطة D Plan Plan E Nombre del Plan Nombre del Plan F Nom du plan Nom du plan I Nome piano Nome del piano JA 計画名 計画名 KO 계획명 계획명 PTB Nome do Plano Nome do Plano RU Имя плана Имя плана S Plan Plan TR Plan Adı Plan Adı US Plan Name Plan Name ZHS 计划名称 计划名称 6 20 :p_item_select LOV Oracle MRP_SRS_PLANNING Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_PLANNING_MAKE_BUY' and lookup_code in (1,2) order by value,description select meaning from mfg_lookups where lookup_type = 'MTL_PLANNING_MAKE_BUY' and lookup_code = 1 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 物料选择 物料选择 7 30 :p_include_cost 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 Einschließlich Kosten Einschließlich Kosten E Incluir Costes Incluir Costes F Inclure coûts Inclure coûts I Includi costi Include i costi JA 原価を含む 原価を含む KO 원가 포함 원가 포함 PTB Incluir Custos Incluir Custos RU Включить затраты Включить затраты S Inkludera kostnader Inkludera kostnader TR Maliyetleri Dahil Et Maliyetleri Dahil Et US Include Costs Include Costs ZHS 包括成本 包括成本 8 40 :p_sort LOV Oracle MRP_SRS_PLANNED_ORDER_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_PLANNED_ORDER_SORT' order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_PLANNED_ORDER_SORT' and lookup_code = 1 Y AR فرز فرز D Sortieren Sortieren E Ordenar Ordenar F Trier Trier I Ordina Ordina JA ソート ソート KO 정렬 정렬 PTB Classificar Classificar RU Сортировка Сортировка S Sortering Sortering TR Sırala Sırala US Sort Sort ZHS 排序 排序 9 50 :p_planner LOV Oracle MRP_SRS_PLANNERS Y select planner_code id, planner_code value, description description from mtl_planners where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description AR المخطط المخطط D Planer Planer E Planificador Planificador F Gestionnaire Gestionnaire JA 計画担当 計画担当 KO 계획자 계획자 PTB Planejador Planejador RU Плановик Плановик S Planerare Planerare TR Planlayıcı Planlayıcı US Planner Planner ZHS 计划员 计划员 10 60 :p_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 Einkäufer Einkäufer E Comprador Comprador F Acheteur Acheteur JA 購買担当 購買担当 KO 구매자 구매자 PTB Comprador Comprador RU Покупатель Покупатель S Köpare Köpare TR Satın Alan Satın Alan US Buyer Buyer ZHS 采购员 采购员 11 70 :p_low_item Char AR الأصناف من الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Article - De I Articoli - Da Articolo - minimo JA 品目:自 品目:下位 KO 품목: 부터 하한 품목 PTB Itens - De Item Inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler, İlk Alt Kalem US Items From Low Item ZHS 物料自 物料下限 12 80 :p_high_item Char AR إلى صنف إلى D Bis Bis Artikel E A A Artículo F A Article - A I A Articolo - massimo JA 至 品目:上位 KO 까지 상한 품목 PTB Até Item Superior RU По Позиция по S Till Till artikel TR Son Kalem, Üst Değer US To High Item ZHS 至 物料上限 13 90 :p_cat_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 类别集 类别集 14 100 :p_low_cat Char AR الفئات من من الفئة D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégorie - De I Categorie - Da Categoria inferiore JA カテゴリ:自 カテゴリ:下位 KO 범주: 부터 하한 범주 PTB Categorias - De Categoria Inferior RU Категории с Категория с S Från kategorier Från kategori TR Kategoriler, İlk Alt Kategori US Categories From Low Category ZHS 类别自 类别下限 15 110 :p_high_cat Char AR إلى 2 إلى الفئة D Bis 2 Bis Kategorie E A 2 A Categoría F A 2 Catégorie - A I A 2 Categoria superiore JA 至 2 カテゴリ:上位 KO 까지 2 상한 범주 PTB Até 2 Categoria Superior RU По 2 Категория по S Till 2 Till kategori TR Son 2 Üst Kategori US To 2 High Category ZHS 至 2 类别上限 16 120 :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 分配组 17 130 :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 分类 18 140 :p_cutoff_type LOV Oracle MRP_SRS_CUTOFF_TYPE Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MRP_PL_ORDER_CUTOFF_TYPE' order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_PL_ORDER_CUTOFF_TYPE' and lookup_code = 2 Y AR نوع القطع نوع القطع D Terminart Terminart E Tipo de Corte Tipo de Corte F Type limite Type limite I Tipo di limite Tipo di limite JA 期限タイプ 期限タイプ KO 마감유형 마감유형 PTB Tipo de Limite Tipo de Limite RU Тип прекращения Тип прекращения S Bryttyp Bryttyp TR Bitiş Tipi Bitiş Tipi US Cutoff Type Cutoff Type ZHS 截止类型 截止类型 19 150 :p_cutoff_date LOV Oracle MRP_SRS_VALIDATED_DATE_STANDARD Y select calendar_date id, calendar_date value, null description from bom_calendar_dates where (calendar_code,exception_set_id) in (select calendar_code,calendar_exception_set_id from mtl_parameters where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) order by calendar_date select fnd_date.date_to_chardate(cutoff_date) from mrp_plan_organizations_v where compile_designator = :$flex$.plan_name and planned_organization=fnd_profile.value('MFG_ORGANIZATION_ID') Y AR تاريخ القطع تاريخ القطع D Horizontende Horizontende E Fecha de Corte Fecha de Corte F Date limite Date limite I Data limite Data limite JA 期限日 期限日 KO 마감 일자 마감 일자 PTB Data-Limite Data-Limite RU Дата прекращения Дата прекращения S Brytdatum Brytdatum TR Bitiş Tarihi Bitiş Tarihi US Cutoff Date Cutoff Date ZHS 截止日期 截止日期 :$flex$.category_set Category Set Category Structure :$flex$.mrp_srs_abc_assignments ABC Assignment Group ABC Class :$flex$.plan_name Plan Name Cutoff Date