ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470C951A9E05362FB09050512 SELECT NVL(SUM(NVL(NVL(dates.schedule_quantity, dates.repetitive_daily_rate), 0)), 0) C_sched FROM bom_calendar_dates cal, mrp_schedule_dates dates WHERE cal.calendar_date BETWEEN GREATEST(NVL(dates.schedule_workdate, trunc(:C_period_start)), trunc(:C_period_start)) AND LEAST(NVL (NVL(dates.rate_end_date, dates.schedule_workdate), trunc(:C_period_start)), trunc(:C_period_end) - 1) AND ( dates.rate_end_date IS NULL OR cal.seq_num IS NOT NULL) AND cal.calendar_code = :P_CAL_CODE AND cal.exception_set_id = :P_CAL_EXCEPTION_SET_ID AND NVL(dates.rate_end_date(+), dates.schedule_workdate(+)) >= :C_period_start AND dates.schedule_workdate(+) < :C_period_end AND dates.supply_demand_type(+) = DECODE(:P_SCHED_TYPE, 1, 1, 2) AND dates.schedule_level(+) = :P_SCHED_VERSION AND dates.schedule_designator(+) = :P_SCHED_NAME AND dates.organization_id(+) = :C_PLANNED_ORG AND dates.inventory_item_id(+) = :C_item_id_master Y MRP MRPRPSSS_XML AR MRP تقرير موقف جدول سلسلة التوريدات (بتنسيق XML) Imported from BI Publisher Description: تقرير موقف جدول سلسلة التوريدات Application: الجدولة الرئيسية/MRP Source: تقرير موقف جدول سلسلة التوريدات (بتنسيق XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG D MRP Supply Chain - Planstatus Imported from BI Publisher Description: Supply Chain - Planstatus Application: Materialbedarfsplanung/Produktionsplanung Source: Supply Chain - Planstatus (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG E MRP Estado de Programación de la Cadena de Aprovisionamiento Imported from BI Publisher Description: Estado de Programación de la Cadena de Aprovisionamiento Application: Master Scheduling/MRP Source: Estado de Programación de la Cadena de Aprovisionamiento (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG F MRP Etat Statut du programme d'expédition Imported from BI Publisher Description: Etat Statut du programme d'expédition Application: Master Scheduling/MRP Source: Etat Statut du programme d'expédition (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG I MRP Rapporto Stato programma - Supply Chain Imported from BI Publisher Description: Rapporto Stato programma - Supply Chain Application: Master Scheduling/MRP Source: Rapporto Stato programma - Supply Chain (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG JA MRP サプライ・チェーン・スケジュール・ステータス・レポート Imported from BI Publisher Description: サプライ・チェーン・スケジュール・ステータス・レポート Application: Master Scheduling/MRP Source: サプライ・チェーン・スケジュール・ステータス・レポート(XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG KO MRP 공급망 스케줄 상태 보고서 Imported from BI Publisher Description: 공급망 스케줄 상태 보고서 Application: Master Scheduling/MRP Source: 공급망 스케줄 상태 보고서(XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG PTB MRP Relatório de Status da Programação da Cadeia de Suprimento Imported from BI Publisher Description: Relatório de Status da Programação da Cadeia de Suprimento Application: Master Scheduling/MRP Source: Relatório de Status da Programação da Cadeia de Suprimento (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG RU MRP Отчет о статусе графика материальных потоков Imported from BI Publisher Description: Отчет о статусе графика материальных потоков Application: Основное планирование Source: Отчет о статусе графика материальных потоков (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG S MRP Planläggningstatus - rapport Imported from BI Publisher Description: Logistik: Planläggningstatus - rapport Application: Master Scheduling/MRP Source: Logistik: Planläggningstatus - rapport (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG TR MRP Tedarik Zinciri Çizelge Statüsü Raporu Imported from BI Publisher Description: Tedarik Zinciri Çizelge Statüsü Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Tedarik Zinciri Çizelge Statüsü Raporu (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG US MRP Supply Chain Schedule Status Imported from BI Publisher Description: Supply Chain Schedule Status Report Application: Master Scheduling/MRP Source: Supply Chain Schedule Status Report (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG ZHS MRP 供应链计划状态报表 Imported from BI Publisher Description: 供应链计划状态报表 Application: 主计划/MRP 管理系统 Source: 供应链计划状态报表 (XML) Short Name: MRPRPSSS_XML DB package: MRP_MRPRPSST_XMLP_PKG BI Publisher :c_item_id_master :c_period_end :c_period_start :c_planned_org :format_string :lp_start_date :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_currency_code :p_currency_desc :p_debug :p_flexdata_item :p_high_cat :p_high_item :p_item_range :p_low_cat :p_low_item :p_order_by :p_org_id :p_periods :p_periods_actual :p_precision :p_qty_precision :p_query_id :p_report_multiorg :p_sched_name :p_sched_type :p_sched_type_desc :p_sched_version :p_sched_version_desc :p_sort :p_start_date :p_struct_num :p_weeks 1 -60 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR MRP_SRS_ORG معرف التنظيم D MRP_SRS_ORG Org.-Kennung E MRP_SRS_ORG Id Organización F MRP_SRS_ORG ID org. I MRP_SRS_ORG ID org. JA MRP_SRS_ORG 組織ID KO MRP_SRS_ORG 조직 ID PTB MRP_SRS_ORG Id da Org. RU MRP_SRS_ORG Идентификатор организации S MRP_SRS_ORG Org.-id TR MRP_SRS_ORG Org no US MRP_SRS_ORG Org id ZHS MRP_SRS_ORG 组织标识 2 -50 :p_sched_type Number select schedule_type from mrp_schedule_designators_v where schedule_designator = :$flex$.schedule_name and organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR نوع الجدول نوع الجدول D Planart Planart E Tipo de Programa Tipo de Programa F Type de programme Type de programme I Tipo di programma Tipo di programma JA 計画タイプ 計画タイプ KO 스케줄 유형 스케줄 유형 PTB Tipo de Programação Tipo de Programação RU Тип графика Тип графика S Plantyp Plantyp TR Çizelge Tipi Çizelge Tipi US Schedule Type Schedule Type ZHS 计划类型 计划类型 3 -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 类别结构 类别结构 4 -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 币种代码 币种代码 5 -20 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية الدقة المستخدمة للكميات D Nachkommastellen Nachkommastellen für Mengen E Precisión de Cantidad Precisión a utilizar para cantidad 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 quantitie ZHS 数量精确度 数量所用精确度 6 10 :p_sched_name LOV Oracle MRP_SRS_SCHEDULE_NAME Y select schedule_designator id, schedule_designator value, sched.description description from mrp_schedule_designators sched,mfg_lookups lu,mrp_organizations_v v where sched.schedule_designator=v.compile_designator(+) and sched.organization_id=v.organization_id(+) and nvl(v.planned_organization,sched.organization_id)= fnd_profile.value('MFG_ORGANIZATION_ID') and lookup_type='MRP_SCHEDULE_TYPE' and lookup_code=sched.schedule_type order by value,description Y AR اسم الجدول اسم الجدول D Plan Plan E Nombre de Programa Nombre de Programa F Nom du programme Nom du programme I Nome programma Nome programma JA 計画名 計画名 KO 스케줄명 스케줄명 PTB Nome da Programação Nome da Programação RU Имя графика Имя графика S Plan Plan TR Çizelge Adı Çizelge Adı US Schedule Name Schedule Name ZHS 计划名称 计划名称 7 20 :p_sched_version LOV Oracle MRP_SRS_SCHEDULE_VERSION Y select lookup_code id, meaning value, null description from mfg_lookups where decode(to_char(lookup_code),to_char(1), 'Y',fnd_profile.value('MRP_ORIGINAL_SCHEDULE_VERSION'))= fnd_profile.value('MRP_ORIGINAL_SCHEDULE_VERSION') and lookup_type='MRP_SCHEDULE_LEVEL' order by value,description select meaning from mfg_lookups where LOOKUP_TYPE = 'MRP_SCHEDULE_LEVEL' and lookup_code = 2 Y AR نسخة الجدول نسخة الجدول D Planversion Planversion E Versión del Programa Versión del Programa F Version du programme Version du programme I Versione programma Versione del programma JA 製造オーダー・バージョン 製造オーダー・バージョン KO 스케줄 버전 스케줄 버전 PTB Versão da Programação Versão da Programação RU Версия графика Версия графика S Planversion Planversion TR Çizelge Sürümü Çizelge Sürümü US Schedule Version Schedule Version ZHS 计划版本 计划版本 8 30 :p_report_multiorg LOV Oracle MRP_SRS_ORG_SELECT_SCHED Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_REPORT_MULTIORG' and (lookup_code=1 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_schedule_name and nvl(organization_selection,1)!=1))) order by value,description select distinct meaning from MRP_SRS_ORG_SELECT_SCHED_V where designator=:$flex$.schedule_name and ((code=2 and p_org_id=fnd_profile.value('MFG_ORGANIZATION_ID')) or (code=1 and NVL(planned_org,s_org_id)=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 选择组织 选择组织 9 40 :p_start_date Date sysdate Y AR MRP_SRS_REPORT_START_DATE_STANDARD تاريخ البداية D MRP_SRS_REPORT_START_DATE_STANDARD Startdatum E MRP_SRS_REPORT_START_DATE_STANDARD Fecha de Inicio F MRP_SRS_REPORT_START_DATE_STANDARD Date de début I MRP_SRS_REPORT_START_DATE_STANDARD Data di inizio JA MRP_SRS_REPORT_START_DATE_STANDARD 開始日 KO MRP_SRS_REPORT_START_DATE_STANDARD 시작 일자 PTB MRP_SRS_REPORT_START_DATE_STANDARD Data Inicial RU MRP_SRS_REPORT_START_DATE_STANDARD Начальная дата S MRP_SRS_REPORT_START_DATE_STANDARD Startdatum TR MRP_SRS_REPORT_START_DATE_STANDARD Başlangıç Tarihi US MRP_SRS_REPORT_START_DATE_STANDARD Start Date ZHS MRP_SRS_REPORT_START_DATE_STANDARD 起始日期 10 50 :p_periods LOV Oracle MRP_SRS_PERIODS_PDR Y select lookup_code id, meaning value, null description from mfg_lookups lu where lookup_type='MRP_DISPLAY_PERIODS' and lookup_code<=(select count(*)/12 from bom_cal_week_start_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')) and week_start_date>= to_date(:$flex$.mrp_srs_report_start_date_standard, 'YYYY/MM/DD HH24:MI:SS')) order by value,description select meaning from mfg_lookups where lookup_code = 1 and lookup_type = 'MRP_DISPLAY_PERIODS' and :$flex$.schedule_name is not null Y AR الفترات الفترات D Perioden Perioden E Períodos Períodos F Périodes Périodes I Periodi Periodi JA 期間 期間 KO 기간 기간 PTB Períodos Períodos RU Периоды Периоды S Perioder Perioder TR Dönemler Dönemler US Periods Periods ZHS 期间 期间 11 60 :p_weeks LOV Oracle MRP_SRS_WEEKS_PDR2 Y select v.seq_num-w.seq_num id, v.seq_num-w.seq_num value, null description from bom_cal_week_start_dates v,bom_cal_week_start_dates w where v.calendar_code=w.calendar_code and v.exception_set_id=w.exception_set_id and v.seq_num<=w.seq_num+ :$flex$.mrp_srs_periods_pdr*12 and v.week_start_date>=w.week_start_date and (exists (select null from bom_period_start_dates where calendar_code=v.calendar_code and exception_set_id= v.exception_set_id and period_start_date= v.week_start_date) or v.seq_num=w.seq_num+ :$flex$.mrp_srs_periods_pdr*12 or v.seq_num=w.seq_num) and (w.week_start_date, w.exception_set_id, w.calendar_code)= (select max(week_start_date), exception_set_id, calendar_code from bom_cal_week_start_dates where (calendar_code,exception_set_id) in (select calendar_code, calendar_exception_set_id from mtl_parameters where organization_id= :$flex$.mrp_srs_org) and week_start_date<=to_date(:$flex$.mrp_srs_report_start_date_standard, 'YYYY/MM/DD HH24:MI:SS') group by exception_set_id,calendar_code ) and (:$flex$.mrp_srs_periods_pdr*12- (v.seq_num-w.seq_num))<=(select count(*) from bom_period_start_dates p where p.calendar_code=v.calendar_code and p.exception_set_id=v.exception_set_id and period_start_date>= to_date(:$flex$.mrp_srs_report_start_date_standard, 'YYYY/MM/DD HH24:MI:SS')) order by v.seq_num-w.seq_num select 12 * :$flex$.periods from DUAL where :$flex$.schedule_name is not null Y AR أسابيع أسابيع D Wochen Wochen E Semanas Semanas F Semaines Semaines I Settimane Settimane JA 週 週 KO 주 주 PTB Semanas Semanas RU Недели Недели S Veckor Veckor TR Haftalar Haftalar US Weeks Weeks ZHS 周数 周数 12 70 :p_sort LOV Oracle MRP_SRS_STATUS_REP_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MRP_SCHEDULE_STATUS_SORT' order by value,description select meaning from mfg_lookups where lookup_type = 'MRP_SCHEDULE_STATUS_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 排序 排序 13 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 物料自 物料下限 14 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 至 物料上限 15 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 类别集 类别集 16 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 类别自 类别下限 17 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 类别上限 :$flex$.category_set Category Set Category Structure :$flex$.mrp_srs_org MRP_SRS_ORG Weeks :$flex$.mrp_srs_periods_pdr Periods Weeks :$flex$.mrp_srs_report_start_date_standard MRP_SRS_REPORT_START_DATE_STANDARD Y Periods :$flex$.mrp_srs_report_start_date_standard MRP_SRS_REPORT_START_DATE_STANDARD Y Weeks :$flex$.mrp_srs_schedule_name Schedule Name Organization Selection :$flex$.periods Periods Weeks :$flex$.schedule_name Schedule Name Organization Selection :$flex$.schedule_name Schedule Name Periods :$flex$.schedule_name Schedule Name Schedule Type :$flex$.schedule_name Schedule Name Weeks