ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470C051A9E05362FB09050512 SELECT null C_wip2_item , sys.description C_wip2_description , par.organization_code C_wip2_organization , wip.wip_entity_name C_wip2_job_number , round(wip.job_quantity,:P_QTY_PRECISION) C_wip2_quantity , bom2.calendar_date C_wip2_order_date , wip.start_date C_wip2_start_date , wip.schedule_completion_date C_wip2_due_date , lu1.meaning C_wip2_firm , lu2.meaning C_wip2_job_status &C_SORT_COLUMN, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_wip2_flex_item', 'INV', 'MSTK', 101, sys.ORGANIZATION_ID, sys.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_wip2_FLEX_ITEM FROM mrp_item_wip_entities wip , mrp_system_items req , mtl_system_items sys , mtl_item_categories ic , mfg_lookups lu1 , mfg_lookups lu2 , bom_calendar_dates bom1 , bom_calendar_dates bom2 , mrp_plan_organizations_v org_v , mtl_parameters par &C_CATEGORY_FROM &C_ABC_FROM WHERE lu1.lookup_type = 'SYS_YES_NO' AND lu1.lookup_code = wip.firm_planned_status_type AND lu2.lookup_type = 'WIP_JOB_STATUS' AND lu2.lookup_code = wip.status_code &C_PLANNER_RANGE &C_BUYER_RANGE &C_ABC_RANGE &C_CATEGORY_WHERE &C_ABC_WHERE AND &P_ITEM_RANGE AND &P_CAT_RANGE AND req.organization_id = wip.organization_id AND req.inventory_item_id = wip.inventory_item_id AND sys.inventory_item_id = wip.inventory_item_id AND sys.organization_id = wip.organization_id AND bom2.calendar_code = bom1.calendar_code AND bom2.exception_set_id = bom1.exception_set_id AND bom2.seq_num = bom1.prior_seq_num - NVL(req.preprocessing_lead_time,0) AND bom1.calendar_date = wip.start_date AND bom1.calendar_code = :P_CAL_CODE AND bom1.exception_set_id = :P_CAL_EXCEPTION_SET_ID 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 wip.job_quantity > 0 AND wip.compile_designator = req.compile_designator AND org_v.compile_designator = :P_PLAN_NAME AND wip.organization_id = org_v.planned_organization AND par.organization_id = wip.organization_id AND wip.compile_designator = org_v.compile_designator AND DECODE(:P_ORG_TYPE, 1, org_v.planned_organization, org_v.organization_id) = :P_ORG_ID AND wip.status_code IN (3, 6) --AND wip.start_date < :P_ADVANCE_NOTICE_DATE --AND wip.schedule_completion_date >= :P_ADVANCE_NOTICE_DATE AND wip.start_date < :P_ADVANCE_NOTICE_DATE AND wip.schedule_completion_date >= :P_ADVANCE_NOTICE_DATE ORDER BY sys.SEGMENT1 &C_ORDER_BY wip.schedule_completion_date,sys.SEGMENT1, wip.job_quantity, bom2.calendar_date, wip.start_date, wip.schedule_completion_date, wip.wip_entity_id Y MRP MRPRPLOS_XML AR MRP تقرير الطلبات المتأخرة بسلسلة التوريدات (بتنسيق XML) Imported from BI Publisher Description: تقرير طلب تأخير تخطيط سلسلة التوريد Application: الجدولة الرئيسية/MRP Source: تقرير الطلبات المتأخرة بسلسلة التوريدات (بتنسيق XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG D MRP Supply Chain - Überfällige Bestellungen Imported from BI Publisher Description: Supply Chain Planning - Überfällige Bestellungen Application: Materialbedarfsplanung/Produktionsplanung Source: Supply Chain - Überfällige Bestellungen (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG E MRP Pedidos con Demora de la Cadena de Aprovisionamiento Imported from BI Publisher Description: Informe Pedidos de Planificación con Demora de la Cadena de Aprovisionamiento Application: Master Scheduling/MRP Source: Pedidos con Demora de la Cadena de Aprovisionamiento (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG F MRP Etat Ordres en retard - chaîne d'approvisionnement Imported from BI Publisher Description: Etat Ordres en retard - chaîne d'approvisionnement Application: Master Scheduling/MRP Source: Etat Ordres en retard - chaîne d'approvisionnement (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG I MRP Rapporto Ordini in ritardo - Supply Chain Imported from BI Publisher Description: Rapporto Ordini in ritardo - Supply Chain Application: Master Scheduling/MRP Source: Rapporto Ordini in ritardo - Supply Chain (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG JA MRP サプライ・チェーン遅延オーダー・レポート Imported from BI Publisher Description: サプライ・チェーン計画遅延製造オーダー・レポート Application: Master Scheduling/MRP Source: サプライ・チェーン遅延オーダー・レポート(XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG KO MRP 공급망 납기 경과 보고서 Imported from BI Publisher Description: 공급망 계획 지연주문 보고서 Application: Master Scheduling/MRP Source: 공급망 납기 경과 보고서(XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG PTB MRP Relatório da Ordem em Atraso de Planejamento da Cadeia de Suprimento Imported from BI Publisher Description: Relatório da Ordem em Atraso de Planejamento da Cadeia de Suprimento Application: Master Scheduling/MRP Source: Relatório da Ordem em Atraso de Planejamento da Cadeia de Suprimento (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG RU MRP Отчет о просроченных заказах планирования материальных потоков Imported from BI Publisher Description: Отчет о просроченных заказов планирования материальных потоков Application: Основное планирование Source: Отчет о просроченных заказах планирования материальных потоков (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG S MRP Sena order - rapport Imported from BI Publisher Description: Logistikkedjeplanering sena order - rapport Application: Master Scheduling/MRP Source: Logistik: Sena order - rapport (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG TR MRP Tedarik Zinciri Geç Sipariş Raporu Imported from BI Publisher Description: Tedarik Zinciri Planlama Geç Sipariş Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Tedarik Zinciri Geç Sipariş Raporu (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG US MRP Supply Chain Late Order Imported from BI Publisher Description: Supply Chain Planning Late Order Report Application: Master Scheduling/MRP Source: Supply Chain Late Order Report (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG ZHS MRP 供应链延迟订单报表 Imported from BI Publisher Description: 供应链计划延迟订单报表 Application: 主计划/MRP 管理系统 Source: 供应链延迟订单报表 (XML) Short Name: MRPRPLOS_XML DB package: MRP_MRPRPLOR_XMLP_PKG BI Publisher &c_abc_from &c_abc_range &c_abc_where &c_buyer_range &c_category_from &c_category_where &c_order_by &c_planner_range &c_sort_column &p_cat_range &p_item_range :lp_advance_notice_date :p_abc_assgn :p_abc_class :p_advance_notice_date :p_buyer :p_cal_code :p_cal_exception_set_id :p_cat_range :p_cat_set :p_cat_struct :p_cat_struct_num :p_conc_request_id :p_debug :p_flexdata_item :p_high_cat :p_high_item :p_item_order_by :p_item_range :p_low_cat :p_low_item :p_order_by :p_org_id :p_org_type :p_plan_name :p_planner :p_qty_precision :p_sort :p_struct_num 1 -40 :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 -30 :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 -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 数量精确度 数量精确度 4 10 :p_plan_name LOV Oracle MRP_SRS_PLAN_NAME_SCP Y select plan.compile_designator id, plan.compile_designator value, plan.description description from mrp_plans plan,mfg_lookups lu,mrp_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 计划名称 计划名称 5 20 :p_org_type LOV Oracle MRP_SRS_ORG_SELECT_PLAN Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_REPORT_MULTIORG' and ((lookup_code=1 and fnd_profile.value('mfg_organization_id') in (select planned_organization from mrp_plan_organizations_v where planned_organization= fnd_profile.value('mfg_organization_id') and compile_designator= :$flex$.mrp_srs_plan_name_scp)) or (lookup_code=2 and fnd_profile.value('mfg_organization_id') in (select organization_id from mrp_plan_organizations_v where organization_id= fnd_profile.value('mfg_organization_id') and compile_designator= :$flex$.mrp_srs_plan_name_scp and nvl(organization_selection,1)!=1))) order by value,description select distinct meaning from MRP_SRS_ORG_SELECT_PLAN_V where designator=:$flex$.plan_name and ((code=2 and org_id=fnd_profile.value('MFG_ORGANIZATION_ID')) or (code=1 and planned_org=fnd_profile.value('MFG_ORGANIZATION_ID'))) Y AR اختيار التنظيم اختيار التنظيم D Organisationsauswahl Organisationsauswahl E Selección de Organización Selección de Organización F Sélection organisation Sélection organisation I Selezione organizzazione Selezione organizzazione JA 組織選択 組織選択 KO 조직 선택 조직 선택 PTB Seleção da Organização Seleção da Organização RU Выбор организации Выбор организации S Val av organisation Val av organisation TR Organizasyon Seçimi Organizasyon Seçimi US Organization Selection Organization Selection ZHS 选择组织 选择组织 6 30 :p_advance_notice_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(trunc(sysdate) + 1) from dual Y AR تاريخ الإشعار المقدم تاريخ الإشعار المقدم D Datum Vorabmitteilung Datum Vorabmitteilung E Fecha de Notificación Avanzada Fecha de Notificación Avanzada F Date de préavis Date de préavis I Data avviso anticipo Data avviso anticipo JA 事前通知日 事前通知日 KO 사전통보 일자 사전통보 일자 PTB Data de Alteração Adiantada Data de Alteração Adiantada RU Дата предварительного уведомления Дата предварительного уведомления S Datum för avisering i förväg Datum för avisering i förväg TR Önbildirim Tarihi Önbildirim Tarihi US Advance Notice Date Advance Notice Date ZHS 提前通知日期 提前通知日期 7 40 :p_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 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 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 计划员 计划员 9 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 采购员 采购员 10 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 物料自 物料下限 11 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 至 物料上限 12 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 类别集 类别集 13 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 类别自 类别下限 14 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 类别上限 15 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 分配组 16 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 分类 :$flex$.category_set Category Set Category Structure :$flex$.mrp_srs_abc_assignments ABC Assignment Group ABC Class :$flex$.mrp_srs_plan_name_scp Plan Name Organization Selection :$flex$.plan_name Plan Name Organization Selection