ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 C6E085D470C351A9E05362FB09050512 select (select ood.organization_name from org_organization_definitions ood where ood.organization_id = org_v.planned_organization ) organization, mrp_mrprppit_xmlp_pkg.c_planned_org_codeformula(org_v.planned_organization) organization_code, plan1.compile_designator plan_name, plan1.description plan_description, plan1.plan_completion_date plan_date, pln_sched.input_designator_name ||' - '||sched.description schedule_name, pln_sched.input_designator_name input_designator, --org_v.planned_organization planned_organization_id, trunc(plan1.cutoff_date) cutoff_date, xxen_util.meaning(:p_periods,'MRP_DISPLAY_PERIODS',700) periods, :p_weeks weeks, mrp_mrprppit_xmlp_pkg.c_cost_typeformula() cost_type, :p_currency_code currency, (select round(mfq.number1,:p_precision) beginning_inventory from mrp_form_query mfq where char2 = pln_sched.input_designator_name and number12 = org_v.planned_organization and query_id = :p_query_id and date2 is not null and rownum=1 ) beginning_inventory, mfq.date1 period, round(mfq.number2,:p_precision) purchase_orders, round(mfq.number3,:p_precision) purchase_reqs, round(mfq.number4,:p_precision) purchase_planned_orders, round(mfq.number5,:p_precision) wip_discrete_jobs, round(mfq.number6,:p_precision) wip_repetitive_schedules, round(mfq.number7,:p_precision) wip_planned_orders, round(mfq.number8,:p_precision) master_schedule, round(mfq.number9,:p_precision) ending_inventory, mfq.number10 period_turns, mfq.number11 cumulative_turns from mrp_plans plan1, mrp_schedule_designators sched, mrp_plan_schedules_v pln_sched, mrp_plan_organizations_v org_v, mrp_form_query mfq where :p_org_code = :p_org_code and :p_cost_type_name = :p_cost_type_name and 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 and mfq.char2 = pln_sched.input_designator_name and mfq.number12 = org_v.planned_organization and mfq.query_id = :p_query_id and mfq.date2 is not null order by plan1.compile_designator, org_v.planned_organization, pln_sched.input_designator_name, pln_sched.input_designator_name, mfq.date1 Y MRP MRPRPPIT_XML AR MRP تقرير التحليل المالي (بتنسيق XML) Imported from BI Publisher Description: تقرير تحليل مالي Application: الجدولة الرئيسية/MRP Source: تقرير التحليل المالي (بتنسيق XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG D MRP Kostenanalyse Imported from BI Publisher Description: Kostenanalyse Application: Materialbedarfsplanung/Produktionsplanung Source: Kostenanalyse (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG E MRP Análisis Financiero Imported from BI Publisher Description: Análisis Financiero Application: Master Scheduling/MRP Source: Análisis Financiero (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG F MRP Etat Analyse financière Imported from BI Publisher Description: Etat Analyse financière Application: Master Scheduling/MRP Source: Etat Analyse financière (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG I MRP Rapporto Analisi finanziaria Imported from BI Publisher Description: Rapporto Analisi finanziaria Application: Master Scheduling/MRP Source: Rapporto Analisi finanziaria (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG JA MRP 会計分析レポート Imported from BI Publisher Description: 会計分析レポート Application: Master Scheduling/MRP Source: 会計分析レポート(XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG KO MRP 재무 분석 보고서 Imported from BI Publisher Description: 재무 분석 보고서 Application: Master Scheduling/MRP Source: 재무 분석 보고서(XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG PTB MRP Relatório de Análise Financeira Imported from BI Publisher Description: Relatório de Análise Financeira Application: Master Scheduling/MRP Source: Relatório de Análise Financeira (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG RU MRP Отчет по финансовому анализу Imported from BI Publisher Description: Отчет по финансовому анализу Application: Основное планирование Source: Отчет по финансовому анализу (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG S MRP Ekonomisk analysrapport Imported from BI Publisher Description: Ekonomisk analysrapport Application: Master Scheduling/MRP Source: Ekonomisk analysrapport (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG TR MRP Finansal Analiz Raporu Imported from BI Publisher Description: Finansal Analiz Raporu Application: Ana Üretim Çizelgeleme/MRP Source: Finansal Analiz Raporu (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG US MRP Financial Analysis Imported from BI Publisher Description: Financial Analysis Report Application: Master Scheduling/MRP Source: Financial Analysis Report (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG ZHS MRP 财务分析报表 Imported from BI Publisher Description: 财务分析报表 Application: 主计划/MRP 管理系统 Source: 财务分析报表 (XML) Short Name: MRPRPPIT_XML DB package: MRP_MRPRPPIT_XMLP_PKG Enginatics R12 only :p_conc_request_id :p_cost_type :p_cost_type_name :p_currency_code :p_currency_desc :p_debug :p_msg_buf :p_org_code :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 -50 :p_periods Char xxen_util.lookup_code(:$flex$.periods,'MRP_DISPLAY_PERIODS',700) US Periods Code 2 -40 :p_org_id Number select mp.organization_id from mtl_parameters mp where mp.organization_code = :$flex$.organization_code 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 组织标识 3 -30 :p_start_date Date select fnd_date.date_to_chardate(NVL(plan_completion_date, SYSDATE)) from mrp_plan_organizations_v where compile_designator = :$flex$.plan_name and planned_organization=:$flex$.mrp_srs_org 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 报表起始日期 4 -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 = :$flex$.mrp_srs_org) 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 -10 :p_cost_type Number SELECT COST_TYPE_ID FROM CST_COST_TYPES WHERE COST_TYPE = :$flex$.cost_type 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 ID Cost Type ZHS 成本类型 成本类型 6 5 :p_org_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Code 7 10 :p_plan_name LOV custom Y select m.compile_designator value, m.description description from mrp_plans m,mrp_plan_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)=:$flex$.mrp_srs_org and decode(m.plan_type,null,m.curr_plan_type, 3,1,m.plan_type)=1 order by value,description 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 计划名称 计划名称 8 20 :p_periods_display LOV custom Y select 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>=:$flex$.mrp_srs_report_start_date_standard) 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 期间 期间 9 30 :p_weeks LOV custom Y select 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$.periods_code*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$.periods_code*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<=:$flex$.mrp_srs_report_start_date_standard group by exception_set_id, calendar_code) and (:$flex$.periods_code*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>= :$flex$.mrp_srs_report_start_date_standard) order by v.seq_num-w.seq_num select 12 * :$flex$.periods_code 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 周数 周数 10 40 :p_cost_type_name LOV custom Y select cct.cost_type value, cct.description description from cst_cost_types cct,mtl_parameters mp where nvl(cct.organization_id,:$flex$.mrp_srs_org)=:$flex$.mrp_srs_org and nvl(cct.disable_date,sysdate+1)>sysdate and mp.organization_id=:$flex$.mrp_srs_org 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 = :$flex$.mrp_srs_org Y US Cost Type :$flex$.cost_type Cost Type Cost Type ID :$flex$.mrp_srs_org MRP_SRS_ORG Cost Type :$flex$.mrp_srs_org MRP_SRS_ORG Currency Code :$flex$.mrp_srs_org MRP_SRS_ORG MRP_SRS_REPORT_START_DATE_STANDARD :$flex$.mrp_srs_org MRP_SRS_ORG Plan Name :$flex$.mrp_srs_org MRP_SRS_ORG 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$.organization_code Organization Code MRP_SRS_ORG :$flex$.periods Periods Periods Code :$flex$.periods_code Periods Code Weeks :$flex$.plan_name Plan Name MRP_SRS_REPORT_START_DATE_STANDARD :$flex$.plan_name Plan Name Periods :$flex$.plan_name Plan Name Weeks