ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470C751A9E05362FB09050512Y SELECT null C_FLEXDATA, parm.organization_code C_PLANNED_ORG_CODE, to_char(&P_WIP_START,'DD-MON-YY') C_old_start_date, rec.order_type C_order_type, rec.inventory_item_id C_item_id, sys.description C_description, req.planner_code C_planner_code, req.buyer_name C_buyer_id, &C_PO_ORDER_NUM C_po_order_num, &C_REQ_ORDER_NUM C_req_order_num, &C_WIP_ORDER_NUM C_wip_order_num, rec.disposition_id C_disposition_id, rec.purch_line_num C_purch_line_num, vendors.vendor_name C_vendor_name, round(rec.new_order_quantity,:P_QTY_PRECISION) C_new_order_qty, DECODE(rec.disposition_status_type, 2, :P_CANCEL_TEXT, NVL(TO_CHAR(rec.new_wip_start_date), ' ')) C_new_start_date, DECODE(rec.disposition_status_type, 2, :P_CANCEL_TEXT, NVL(TO_CHAR(rec.new_order_placement_date,'DD-MON-YY'), ' ')) C_new_order_plcmnt_date, DECODE(rec.disposition_status_type, 2, :P_CANCEL_TEXT, NVL(TO_CHAR(rec.new_dock_date), ' ')) C_new_dock_date, DECODE(rec.disposition_status_type, 2, :P_CANCEL_TEXT, TO_CHAR(rec.new_schedule_date,'DD-MON-YY')) C_new_schedule_date, TO_CHAR(rec.old_schedule_date,'DD-MON-YY') C_old_schedule_date, TO_CHAR(rec.old_order_placement_date,'DD-MON-YY') C_old_order_plcmnt_date, NVL(TO_CHAR(rec.old_dock_date,'DD-MON-YY'), ' ') C_old_dock_date, round(rec.new_order_quantity * NVL(standard_cost,0),:P_PRECISION) C_standard_cost &C_SORT_COLUMN, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'INV', 'MSTK', 101, sys.ORGANIZATION_ID, sys.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD FROM mtl_item_categories ic, po_vendors_view vendors, mrp_system_items req, mtl_system_items sys, mrp_recommendations rec, mrp_plan_organizations_v mpo, mtl_parameters parm &C_WIP_FROM &C_PO_FROM &C_CATEGORY_FROM &C_ABC_FROM WHERE mpo.planned_organization = rec.organization_id AND rec.compile_designator = mpo.compile_designator AND rec.vendor_id = vendors.vendor_id(+) AND sys.organization_id = rec.organization_id AND sys.inventory_item_id = rec.inventory_item_id &C_PLANNER_RANGE &C_BUYER_RANGE &C_ABC_WHERE &C_ABC_RANGE &C_DAYS_RANGE &C_WIP_WHERE &C_PO_WHERE &C_CATEGORY_WHERE AND &P_ITEM_RANGE AND &P_CAT_RANGE AND req.organization_id = rec.organization_id AND req.compile_designator = rec.compile_designator AND req.inventory_item_id = rec.inventory_item_id &C_CUTOFF_COLUMN AND rec.order_type = decode (:P_ORDER_TYPE, 1,1, 2,2, 3,3, rec.order_type) AND rec.order_type in (1,2,3) AND ((rec.new_schedule_date <> rec.old_schedule_date) OR (rec.disposition_status_type = 2)) 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 mpo.planned_organization = parm.organization_id AND DECODE(:P_REPORT_MULTIORG, 1, mpo.planned_organization, mpo.organization_id) = :P_ORG_ID AND mpo.compile_designator = :P_PLAN_NAME ORDER BY &C_ORDER_BY DECODE(rec.disposition_status_type, 2, TO_DATE('9999/12/31', 'YYYY/MM/DD'), new_schedule_date), :P_ITEM_ORDER_BY, parm.organization_code, vendors.vendor_name, rec.new_order_quantity, req.buyer_name, req.planner_code, &C_PO_ORDER_NUM, &C_REQ_ORDER_NUM, &C_WIP_ORDER_NUM, rec.purch_line_num MRP MRPRPRSC_XML AR MRP تقرير إعادة جدولة الطلبات (بتنسيق XML) Imported from BI Publisher Description: تقرير جدول الطلب Application: الجدولة الرئيسية/MRP Source: تقرير إعادة جدولة الطلبات (بتنسيق XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG D MRP Auftragsänderungen Imported from BI Publisher Description: Auftragsänderungen Application: Materialbedarfsplanung/Produktionsplanung Source: Auftragsänderungen (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG E MRP Reprogramación de Pedidos Imported from BI Publisher Description: Informe de reprogramación de pedidos Application: Master Scheduling/MRP Source: Reprogramación de Pedidos (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG F MRP Etat Ordres à replanifier Imported from BI Publisher Description: Etat Ordres à replanifier Application: Master Scheduling/MRP Source: Etat Ordres à replanifier (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG I MRP Rapporto Riprogrammazione ordini Imported from BI Publisher Description: Rapporto Riprogrammazione ordini Application: Master Scheduling/MRP Source: Rapporto Riprogrammazione ordini (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG JA MRP オーダー再計画レポート Imported from BI Publisher Description: オーダー再計画レポート Application: Master Scheduling/MRP Source: オーダー再計画レポート(XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG KO MRP 주문 스케줄 조정 보고서 Imported from BI Publisher Description: 주문 스케줄 조정 보고서 Application: Master Scheduling/MRP Source: 주문 스케줄 조정 보고서(XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG PTB MRP Relatório de Reprogramação da Ordem Imported from BI Publisher Description: Relat. Reprogramação Ordem Application: Master Scheduling/MRP Source: Relatório de Reprogramação da Ordem (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG RU MRP Отчет о пересмотре заказов Imported from BI Publisher Description: Отчет о пересмотре заказов Application: Основное планирование Source: Отчет о пересмотре заказов (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG S MRP Omplanering av order - rapport Imported from BI Publisher Description: Omplanering av order - rapport Application: Master Scheduling/MRP Source: Omplanering av order - rapport (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG TR MRP Sipariş Yeniden Çizelgeleme Raporu Imported from BI Publisher Description: Sipariş Yeniden Çizelgeleme Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Sipariş Yeniden Çizelgeleme Raporu (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG US MRP Order Reschedule Imported from BI Publisher Description: Order Reschedule Report Application: Master Scheduling/MRP Source: Order Reschedule Report (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_XMLP_PKG ZHS MRP 订单重新计划报表 Imported from BI Publisher Description: 重新计划订货报表 Application: 主计划/MRP 管理系统 Source: 订单重新计划报表 (XML) Short Name: MRPRPRSC_XML DB package: MRP_MRPRPRSC_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_days_range &c_order_by &c_planner_range &c_po_from &c_po_order_num &c_po_where &c_req_order_num &c_sort_column &c_wip_from &c_wip_order_num &c_wip_where &p_cat_range &p_item_range &p_wip_start :c_order_num :p_abc_assgn :p_abc_class :p_buyer :p_cancel_text :p_cat_order :p_cat_range :p_cat_set :p_cat_struct_num :p_cat_structure :p_conc_request_id :p_currency_code :p_currency_desc :p_cutoff_date :p_cutoff_date_1 :p_cutoff_date_2 :p_cutoff_date_yy :p_cutoff_type :p_debug :p_flexcat :p_flexdata :p_high_cat :p_high_item :p_in_days :p_item_order :p_item_order_by :p_item_range :p_low_cat :p_low_item :p_order_by :p_order_type :p_org_id :p_out_days :p_plan_name :p_planner :p_precision :p_qty_precision :p_report_multiorg :p_sort :p_struct_num :p_wip_start :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_structure 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_order_type LOV Oracle MRP_SRS_RESCHED_ORDER_TYPE Y select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='MRP_RESCHEDULE_SELECT' order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_RESCHEDULE_SELECT' and lookup_code = 10 Y AR نوع الطلب نوع الطلب D Auftragsart Auftragsart E Tipo de Pedido Tipo de Pedido F Type d'ordre Type de commande I Tipo di ordine Tipo di ordine JA 受注タイプ 受注タイプ KO 주문 유형 주문 유형 PTB Tipo de Ordem Tipo de Ordem RU Тип заказа Тип заказа S Ordertyp Ordertyp TR Sipariş Tipi Sipariş Tipi US Order Type Order Type ZHS 订单类型 订单类型 7 30 :p_sort LOV Oracle MRP_SRS_RESCHED_REPORT_SORT Y select lookup_code id, meaning value, null description from mfg_lookups lu where lu.lookup_type='MRP_RESCHEDULE_SORT' and nvl(lu.start_date_active,sysdate)>sysdate-1 and nvl(lu.end_date_active-1,sysdate-1)<sysdate and lu.enabled_flag='Y' and lu.lookup_code in (7,2,1,5,3, decode(:$flex$.mrp_srs_resched_order_type,1,4,2,4,1), decode(:$flex$.mrp_srs_resched_order_type,1,6,2,6,1)) order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_DATA_SELECT' 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 排序 排序 8 40 :p_out_days Number 0 Y AR مرشح أيام خارجي مرشح أيام خارجي D Filter nicht berücksichtigte Tage Filter nicht berücksichtigte Tage E Filtro Fuera de Días Filtro Fuera de Días F Filtre Jours Filtre Jours I Filtro gg successivi a riprogrammazione Filtro gg successivi a riprogrammazione JA 外日数フィルタ 外日数フィルタ KO Out 일수 필터 Out 일수 필터 PTB Filtro Fora dos Dias Filtro Fora dos Dias RU Фильтр переноса назад Фильтр переноса назад S Filter för senareläggning Filter för senareläggning TR Ötelenecek Gün Filtresi Ötelenecek Gün Filtresi US Out Days Filter Out Days Filter ZHS 延后日期过滤器 延后日期过滤器 9 50 :p_in_days Number 0 Y AR مرشح أيام داخلي مرشح أيام داخلي D Filter berücksichtigte Tage Filter berücksichtigte Tage E Filtro Dentro de Días Filtro Dentro de Días F Filtre jours Filtre jours I Filtro gg precedenti a riprogrammazione Filtro gg precedenti a riprogrammazione JA 内日数フィルタ 内日数フィルタ KO In 일수 필터 In 일수 필터 PTB Filtro (Dias Dentro) Filtro (Dias Dentro) RU Фильтр переноса вперед Фильтр переноса вперед S Filter för tidigareläggning Filter för tidigareläggning TR Öne Alınacak Gün Filtresi Öne Alınacak Gün Filtresi US In Days Filter In Days Filter ZHS 提前日期过滤器 提前日期过滤器 10 60 :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 计划员 计划员 11 70 :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 采购员 采购员 12 80 :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 物料自 物料下限 13 90 :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 至 物料上限 14 100 :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 类别集 类别集 15 110 :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 类别自 类别下限 16 120 :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 类别上限 17 130 :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 分配组 18 140 :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 分类 19 150 :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 截止类型 截止类型 20 160 :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 截止日期 截止日期