ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D470C251A9E05362FB09050512Y SELECT plan1.compile_designator ||' - '||plan1.description C_plan_name , to_char(plan1.plan_completion_date,'DD-MON-YYYY HH24:MI') C_plan_date, org_v.planned_organization C_planned_organization, pln_sched.INPUT_DESIGNATOR_NAME ||' - '||sched.description C_schedule_name, pln_sched.INPUT_DESIGNATOR_NAME C_input_designator_name, to_char(plan1.cutoff_date,'DD-MON-YYYY') C_cutoff_date, MRP_MRPRPPIT_XMLP_PKG.c_planned_org_codeformula(org_v.planned_organization) C_planned_org_code, MRP_MRPRPPIT_XMLP_PKG.c_cost_typeformula() C_cost_type FROM mrp_plans plan1 , mrp_schedule_designators sched , mrp_plan_schedules_v pln_sched , mrp_plan_organizations_v org_v WHERE sched.organization_id = pln_sched.INPUT_ORGANIZATION_ID AND sched.schedule_designator = pln_sched.INPUT_DESIGNATOR_NAME AND pln_sched.INPUT_ORGANIZATION_ID = org_v.PLANNED_ORGANIZATION AND pln_sched.compile_designator = org_v.compile_designator AND plan1.organization_id = org_v.organization_id AND plan1.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 MRP MRPRPPIS_XML AR MRP تقرير التحليل المالي لسلسلة التوريدات (بتنسيق XML) Imported from BI Publisher Description: تقرير التحليل المالي لسلسلة التوريدات Application: الجدولة الرئيسية/MRP Source: تقرير التحليل المالي لسلسلة التوريدات (بتنسيق XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG D MRP Supply Chain - Kostenanalyse Imported from BI Publisher Description: Supply Chain - Kostenanalyse Application: Materialbedarfsplanung/Produktionsplanung Source: Supply Chain - Kostenanalyse (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG E MRP Análisis Financiero de la Cadena de Aprovisionamiento Imported from BI Publisher Description: Análisis Financiero de la Cadena de Aprovisionamiento Application: Master Scheduling/MRP Source: Análisis Financiero de la Cadena de Aprovisionamiento (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG F MRP Etat Analyse financière - chaîne d'approvisionnement Imported from BI Publisher Description: Etat Analyse financière - chaîne d'approvisionnement Application: Master Scheduling/MRP Source: Etat Analyse financière - chaîne d'approvisionnement (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG I MRP Rapporto Analisi finanziaria - Supply Chain Imported from BI Publisher Description: Rapporto Analisi finanziaria - Supply Chain Application: Master Scheduling/MRP Source: Rapporto Analisi finanziaria - Supply Chain (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG JA MRP サプライ・チェーン財務分析レポート Imported from BI Publisher Description: サプライ・チェーン財務分析レポート Application: Master Scheduling/MRP Source: サプライ・チェーン財務分析レポート(XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG KO MRP 공급망 재무 분석 보고서 Imported from BI Publisher Description: 공급망 재무 분석 보고서 Application: Master Scheduling/MRP Source: 공급망 재무 분석 보고서(XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG PTB MRP Relatório de Análise Financeira da Cadeia de Suprimento Imported from BI Publisher Description: Relatório de Análise Financeira da Cadeia de Suprimento Application: Master Scheduling/MRP Source: Relatório de Análise Financeira da Cadeia de Suprimento (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG RU MRP Отчет о финансовом анализе материальных потоков Imported from BI Publisher Description: Отчет о финансовом анализе материальных потоков Application: Основное планирование Source: Отчет о финансовом анализе материальных потоков (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG S MRP Ekonomisk analys - rapport Imported from BI Publisher Description: Logistik: Ekonomisk analys - rapport Application: Master Scheduling/MRP Source: Logistik: Ekonomisk analys - rapport (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG TR MRP Tedarik Zinciri Finansal Analiz Raporu Imported from BI Publisher Description: Tedarik Zinciri Finansal Analiz Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Tedarik Zinciri Finansal Analiz Raporu (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG US MRP Supply Chain Financial Analysis Imported from BI Publisher Description: Supply Chain Financial Analysis Report Application: Master Scheduling/MRP Source: Supply Chain Financial Analysis Report (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG ZHS MRP 供应链财务分析报表 Imported from BI Publisher Description: 供应链财务分析报表 Application: 主计划/MRP 管理系统 Source: 供应链财务分析报表 (XML) Short Name: MRPRPPIS_XML DB package: MRP_MRPRPPIT_XMLP_PKG BI Publisher :p_conc_request_id :p_cost_type :p_currency_code :p_currency_desc :p_debug :p_msg_buf :p_org_id :p_org_type :p_periods :p_periods_actual :p_plan_name :p_precision :p_query_id :p_start_date :p_weeks 1 -40 :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 -30 :p_start_date Date select fnd_date.date_to_chardate(NVL(plan_completion_date, SYSDATE)) from mrp_organizations_v where compile_designator = :$flex$.plan_name and planned_organization=fnd_profile.value('MFG_ORGANIZATION_ID') Y AR MRP_SRS_REPORT_START_DATE_STANDARD تاريخ بداية التقرير D MRP_SRS_REPORT_START_DATE_STANDARD Startdatum Auswertung E MRP_SRS_REPORT_START_DATE_STANDARD Fecha de Inicio del Informe F MRP_SRS_REPORT_START_DATE_STANDARD Date de début de l'état I MRP_SRS_REPORT_START_DATE_STANDARD Data inizio rapporto JA MRP_SRS_REPORT_START_DATE_STANDARD レポート開始日 KO MRP_SRS_REPORT_START_DATE_STANDARD 보고서 시작일자 PTB MRP_SRS_REPORT_START_DATE_STANDARD Data Inicial do Relatório RU MRP_SRS_REPORT_START_DATE_STANDARD Начальная дата отчета S MRP_SRS_REPORT_START_DATE_STANDARD Startdatum för rapport TR MRP_SRS_REPORT_START_DATE_STANDARD Rapor Başlangıç Tarihi US MRP_SRS_REPORT_START_DATE_STANDARD Report Start Date ZHS MRP_SRS_REPORT_START_DATE_STANDARD 报表起始日期 3 -20 :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 10 :p_plan_name LOV Oracle MRP_SRS_MRP_DRP_NAME_SCP Y select m.compile_designator id, m.compile_designator value, m.description description from mrp_plans m,mrp_organizations_v v where m.compile_designator=v.compile_designator(+) and m.organization_id=v.organization_id(+) and nvl(v.planned_organization,m.organization_id)= fnd_profile.value('MFG_ORGANIZATION_ID') and decode(m.plan_type,null,m.curr_plan_type, 3,1,m.plan_type)=1 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_MRP_DRP 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_mrp_drp_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_mrp_drp_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_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$.plan_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 期间 期间 7 40 :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$.plan_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 周数 周数 8 50 :p_cost_type LOV Oracle MRP_SRS_COST_TYPE Y select cct.cost_type_id id, cct.cost_type value, cct.description description from cst_cost_types cct,mtl_parameters mp where nvl(cct.organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))= fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(cct.disable_date,sysdate+1)>sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and ((cct.cost_type_id=2 and mp.primary_cost_method=2) or (cct.cost_type_id!=2) ) and ((cct.cost_type_id=1 and mp.primary_cost_method=1) or (cct.cost_type_id!=1) ) order by cost_type SELECT COST_TYPE FROM CST_COST_TYPES CCT, MTL_PARAMETERS MP WHERE CCT.COST_TYPE_ID = MP.PRIMARY_COST_METHOD AND MP.ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de Custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet Tipi US Cost Type Cost Type ZHS 成本类型 成本类型