ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FA951A9E05362FB09050512Y SELECT pbh.batch_no, ffm.formula_no, ffm.formula_vers, '['||ffm.formula_desc1||']' formula_desc1, frh.routing_no, frh.routing_vers, '['||frh.routing_desc||']' routing_desc, gs.step_id routingstep_id, gs. oprn_id, gs. routing_id, msi.concatenated_segments item_no, '['|| msi.description ||']' item_desc1, gs.revision, mln.lot_number LOT, '['||mln.description||']' lot_desc, fmd.line_type, '['||DECODE(line_type,1,'Product',-1,'Ingredient',2,'By Product')||']' type_desc, gt.test_type, gt.test_code assay_code, gr1.text_code, gt.test_unit qcunit_code, gr1.result_date, decode(gsr.evaluation_ind,'0A','Y','N') accept_anyway, decode(gr1.ad_hoc_print_on_coa_ind, 'Y', decode( gsr.evaluation_ind,'0A','Y','1V','Y','2R','Y', NVL(gst.print_result_ind, 'N'), 'Y', 'N'),'N') final_mark, gs.sample_no , gs.sample_qty, gs.date_drawn sample_date, gs.sample_qty_uom sample_um, gr1.result_value_char text_result, gr1.result_value_num num_result, gr1.result_id qc_result_id, gst.spec_id qc_spec_id, gs.charge charge , nvl(gst.report_precision, gt.report_precision) precision, gst.target_value_char text_spec, gst.target_value_num target_spec, gst.min_value_char min_char, gst.max_value_char max_char, gst.min_value_num min_spec, gst.max_value_num max_spec, gst.test_id qcassy_typ_id , gt.text_code test_text_code , &OprnnoCP ,&RoutstepCP , GMD_QCR03USR_XMLP_PKG.stepcfformula(gs.routing_id, gs.step_id) StepCF, GMD_QCR03USR_XMLP_PKG.oprn_verscfformula0017(gs.oprn_id) Oprn_versCF, GMD_QCR03USR_XMLP_PKG.operationcfformula(gs.oprn_id) OperationCF, GMD_QCR03USR_XMLP_PKG.assay_desccfformula(gt.test_code) assay_descCF, GMD_QCR03USR_XMLP_PKG.assay_displaycfformula(gt.test_code, gst.test_id, :targetCF) assay_displayCF, GMD_QCR03USR_XMLP_PKG.assaymin_dispcfformula(gst.test_id, :min_specCF) assaymin_dispCF, GMD_QCR03USR_XMLP_PKG.assaymax_dispcfformula(gst.test_id, :max_specCF) assaymax_dispCF, GMD_QCR03USR_XMLP_PKG.textcfformula(gst.target_value_char) textCF, GMD_QCR03USR_XMLP_PKG.targetcfformula(gst.target_value_char, gst.target_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision )) targetCF, GMD_QCR03USR_XMLP_PKG.qcunit_codecfformula(gst.spec_id, gt.test_code, gst.test_id) qcunit_codeCF, GMD_QCR03USR_XMLP_PKG.min_speccfformula(gst.min_value_char, gst.min_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision )) min_specCF, GMD_QCR03USR_XMLP_PKG.min_charcfformula(gst.min_value_char) min_charCF, GMD_QCR03USR_XMLP_PKG.max_speccfformula(gst.max_value_char, gst.max_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision )) max_specCF, GMD_QCR03USR_XMLP_PKG.max_charcfformula(gst.max_value_char) max_charCF, GMD_QCR03USR_XMLP_PKG.from_datecfformula(gs.sample_no) from_dateCF, GMD_QCR03USR_XMLP_PKG.to_datecfformula(gs.sample_no) to_dateCF, GMD_QCR03USR_XMLP_PKG.textarraycfformula(:textcodeCF) textarrayCF, GMD_QCR03USR_XMLP_PKG.text_codecfformula(gst.spec_id) textcodeCF, GMD_QCR03USR_XMLP_PKG.assay_typeCP_p assay_typeCP, GMD_QCR03USR_XMLP_PKG.result_numcfformula(gr1.result_value_char, gr1.result_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision )) result_numCF, GMD_QCR03USR_XMLP_PKG.result_dispcfformula(gst.test_id, gr1.result_value_num) result_dispCF, GMD_QCR03USR_XMLP_PKG.accept_cfformula(decode(gsr.evaluation_ind,'0A','Y','N')) Accept_CF, GMD_QCR03USR_XMLP_PKG.Final_cfformula(decode(gr1.ad_hoc_print_on_coa_ind, 'Y', decode( gsr.evaluation_ind,'0A','Y','1V','Y','2R','Y', NVL(gst.print_result_ind, 'N'), 'Y', 'N'),'N')) Final_CF, GMD_QCR03USR_XMLP_PKG.textcodersltcfformula(gr1.result_id, gt.test_code) textcodersltCF, GMD_QCR03USR_XMLP_PKG.textarray2cfformula(gr1.text_code) textarray2CF FROM pm_btch_hdr pbh, fm_form_mst ffm, fm_rout_hdr frh, fm_matl_dtl fmd, mtl_system_items_kfv msi, mtl_lot_Numbers mln, gmd_samples gs, gmd_results gr1, gmd_qc_tests_b gt, gmd_spec_results gsr, gmd_spec_tests_b gst , gmd_sampling_events gse, gmd_event_spec_disp ges &OprntblCP &RoutsteptblCP WHERE gs.inventory_item_id = msi.inventory_item_id AND gs.organization_id = msi.organization_id AND gs.inventory_item_id = mln.inventory_item_id AND gs.organization_id = mln.organization_id AND gs.organization_id = :p_organization_Id AND nvl(gs.lot_number(+),0) = nvl(mln.lot_number,0) AND pbh.batch_id(+) = gs.batch_id AND ffm.formula_id(+) = gs.formula_id AND frh.routing_id(+) = gs.routing_id AND fmd.formula_id(+) = gs.formula_id AND fmd.formulaline_id(+) = gs.formulaline_id AND gs.sample_id = gr1.sample_id AND gs.sample_id = gr1.sample_id AND gse.sampling_event_id = gs.sampling_event_id AND gse.sampling_event_id = ges.sampling_event_id AND ges.spec_used_for_lot_attrib_ind ='Y' AND ges.spec_id(+) = gst.spec_id AND gst.test_id(+) = gt.test_id AND gs.sample_id = gr1.sample_id AND gr1.result_date IS NOT NULL AND gr1.result_id = gsr.result_id AND gr1.test_id = gt.test_id AND ges.event_spec_disp_id = gsr.event_spec_disp_id AND gs.cust_id IS NULL AND ( gs.batch_id IS NOT NULL OR gs.formula_id IS NOT NULL OR gs.routing_id IS NOT NULL OR gs.oprn_id IS NOT NULL ) AND gr1.delete_mark = 0 AND gs.delete_mark = 0 AND gsr.delete_mark =0 AND ges.delete_mark =0 &SampleCP &BatchCP &FormulaCP &Formula_VersCP &RoutingCP &Routing_VersCP &ItemCP &LotnoCP &Date1CP &OprnCP &Rout_StepnoCP &Final1CP /* ORDER BY pbh.batch_no, ffm.formula_no, ffm.formula_vers, frh.routing_no, frh.routing_vers, &OrderCP item_no, LOT , fmd.line_type, gt.test_code, gr1.result_date DESC*/ ORDER BY 1 ASC,2 ASC,3 ASC,4 ASC,5 ASC,6 ASC,7 ASC,10 ASC,9 ASC,13 ASC,11 ASC,12 ASC,33 ASC,8 ASC,16 ASC, 17 ASC,31 ASC,14 ASC,15 ASC,35 ASC,19 ASC,41 ASC,37 ASC,20 ASC,38 ASC,42 ASC , pbh.batch_no , ffm.formula_no , ffm.formula_vers , frh.routing_no , frh.routing_vers , item_no , LOT , fmd.line_type , gt.test_code , gr1.result_date DESC GMD QCR03USR_XML AR GMD تقرير نتائج اختبار الإنتاج (بتنسيق XML) Imported from BI Publisher Description: تقرير نتائج اختبار إنتاج مراقبة جودة OPM Application: تطوير منتجات التصنيع التشغيلي Source: تقرير نتائج اختبار الإنتاج (بتنسيق XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG D GMD Produktion - Testergebnisse Imported from BI Publisher Description: Auswertung "Prüfmethode Produktion - Ergebnisse" in OPM Qualitätskontrolle Application: Process Manufacturing Produktentwicklung Source: Produktion - Testergebnisse (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG E GMD Resultados de Prueba de Producción Imported from BI Publisher Description: Informe Resultados de Ensayos de Producción de OPM QC Application: Process Manufacturing Product Development Source: Resultados de Prueba de Producción (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG F GMD Résultats des tests de production Imported from BI Publisher Description: Etat Résultats des tests de production d'OPM QC Application: Process Manufacturing Product Development Source: Résultats des tests de production (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG I GMD Rapporto Risultati test produzione Imported from BI Publisher Description: Rapporto Risultati analisi produzione (GMQ) Application: Process Manufacturing Product Development Source: Rapporto Risultati test produzione (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG JA GMD 生産テスト結果レポート Imported from BI Publisher Description: OPM QC生産分析結果レポート Application: Process Manufacturing Product Development Source: 生産テスト結果レポート(XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG KO GMD 생산 테스트 결과 보고서 Imported from BI Publisher Description: OPM QC의 생산 검사 항목 결과 보고서 Application: Process Manufacturing Product Development Source: 생산 테스트 결과 보고서(XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG PTB GMD Relatório de Resultados do Teste de Produção Imported from BI Publisher Description: Relatório de Resultados do Ensaio de Produção de CQ do OPM Application: Process Manufacturing Product Development Source: Relatório de Resultados do Teste de Produção (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG RU GMD Отчет о результатах проверки производства Imported from BI Publisher Description: Отчет о результатах проверки тестов по производству КК УНП Application: Разработка продукции УНП Source: Отчет о результатах проверки производства (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG S GMD Produktionstestresultat - rapport Imported from BI Publisher Description: Resultat av produktionsanalys - rapport i OPM GMQ Application: Process Manufacturing Product Development Source: Produktionstestresultat - rapport (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG TR GMD Ürün Test Sonuçları Raporu Imported from BI Publisher Description: OPM Kal. Kont. Ürün Deney Sonuçları Raporu Application: Üretim Prosesi Ürün Geliştirme Source: Ürün Test Sonuçları Raporu (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG US GMD Production Test Results Imported from BI Publisher Description: Production Assay Results Report of OPM QC Application: Process Manufacturing Product Development Source: Production Test Results Report (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG ZHS GMD 生产测试结果报表 Imported from BI Publisher Description: OPM QC 的生产分析结果报表 Application: OPM 产品开发管理系统 Source: 生产测试结果报表 (XML) Short Name: QCR03USR_XML DB package: GMD_QCR03USR_XMLP_PKG BI Publisher &batchcp &date1cp &final1cp &formula_verscp &formulacp &itemcp &lotnocp &oprncp &oprnnocp &oprntblcp &ordercp &rout_stepnocp &routing_verscp &routingcp &routstepcp &routsteptblcp &samplecp :accept_cp :assay_typecp :batchcp :date1cp :final1cp :final_cp :formula_verscp :formulacp :from_batch :from_batchcp :from_formula :from_formula_version :from_formula_versioncp :from_formulacp :from_item :from_itemcp :from_lotno :from_lotnocp :from_operation :from_operationcp :from_result_date :from_routing :from_routing_step_no :from_routing_step_nocp :from_routing_version :from_routing_versioncp :from_routingcp :from_rslt_dtcp :from_sample :from_samplecp :from_sublot :include :itemcp :lotnocp :max_speccf :min_speccf :nonblocksql :oprncp :oprnnocp :oprntblcp :ordercp :orgcp :p_conc_request_id :p_organization_id :p_orgn :print_condition :rout_stepnocp :routing_verscp :routingcp :routstepcp :routsteptblcp :samplecp :sy_all :targetcf :textcodecf :to_batch :to_batchcp :to_formula :to_formula_version :to_formula_versioncp :to_formulacp :to_item :to_itemcp :to_lotno :to_lotnocp :to_operation :to_operationcp :to_result_date :to_routing :to_routing_step_no :to_routing_step_nocp :to_routing_version :to_routing_versioncp :to_routingcp :to_rslt_dtcp :to_sample :to_samplecp :to_sublot 1 -20 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 2 10 :p_organization_id LOV Oracle QM_Org Y select organization_id id, organization_code value, null description from gmd_org_access_vw order by organization_code Y AR التنظيم معرف التنظيم D Organisation Organisationskennung E Organización Identificador de organización F Organisation ID organisation I Organizzazione Id organizzazione JA 組織 組織ID KO 조직 조직 ID PTB Organização ID da Organização RU Организация Идент. организации S Organisation Organisations-id TR Organizasyon Organizasyon No US Organization Organization ID ZHS 组织 组织标识 3 20 :from_sample LOV Oracle GMD_QC_PROD_SAMPLE Y select sample_no id, sample_no value, sample_desc description from gmd_samples where (oprn_id is not null or routing_id is not null or formula_id is not null or batch_id is not null) and delete_mark=0 and organization_id=:$flex$.qm_org order by sample_no AR من عينة من عينة D Von Probe Von Probe E De Muestra De Muestra F Echantillon - De Echantillon - De I Campione - Da Campione - Da JA サンプル:自 サンプル:自 KO 샘플: 부터 샘플: 부터 PTB Amostra - De Amostra - De RU Проба с Проба с S Från prov Från prov TR İlk Numune İlk Numune US From Sample From Sample ZHS 自抽样 自抽样 4 30 :to_sample LOV Oracle GMD_QC_PROD_SAMPLE Y select sample_no id, sample_no value, sample_desc description from gmd_samples where (oprn_id is not null or routing_id is not null or formula_id is not null or batch_id is not null) and delete_mark=0 and organization_id=:$flex$.qm_org order by sample_no AR إلى عينة إلى عينة D Bis Probe Bis Probe E A Muestra A Muestra F Echantillon - A Echantillon - A I Campione - A Campione - A JA サンプル:至 サンプル:至 KO 샘플: 까지 샘플: 까지 PTB Amostra-Até Amostra-Até RU Проба по Проба по S Till prov Till prov TR Son Numune Son Numune US To Sample To Sample ZHS 至样品 至样品 5 40 :from_batch LOV Oracle GMD_QC_BATCH_LIST Y select batch_no id, batch_no value, null description from gme_batch_header where organization_id=:$flex$.qm_org order by batch_no AR من التشغيلة من التشغيلة D Von Produktionsauftrag Von Produktionsauftrag E De Lote De Lote F Batch - De Batch - De I Batch - Da Batch - Da JA バッチ:自 バッチ:自 KO 뱃치: 부터 뱃치: 부터 PTB Ordem Prod. - De Ordem Prod. - De RU Задание с Задание с S Från batch Från batch TR İlk İş Emri İlk İş Emri US From Batch From Batch ZHS 起始批 起始批 6 50 :to_batch LOV Oracle GMD_QC_BATCH_LIST Y select batch_no id, batch_no value, null description from gme_batch_header where organization_id=:$flex$.qm_org order by batch_no AR إلى مجموعة إلى مجموعة D Bis Produktionsauftrag Bis Produktionsauftrag E A Lote A Lote F Batch - A Batch - A I Batch - A Batch - A JA バッチ:至 バッチ:至 KO 뱃치: 까지 뱃치: 까지 PTB OP - Até OP - Até RU Задание по Задание по S Till batch Till batch TR Son İş Emri Son İş Emri US To Batch To Batch ZHS 截止批 截止批 7 60 :from_formula LOV Oracle QC_FORMULA_LIST_V1 Y select formula_no id, formula_no value, null description from fm_form_mst_v1 order by formula_no AR من تركيبة من تركيبة D Von Rezeptur Von Rezeptur E De Fórmula De Fórmula F Formule - De Formule - De I Formula - Da Formula - Da JA フォーミュラ:自 フォーミュラ:自 KO 배합표: 부터 배합표: 부터 PTB Fórmula - De Fórmula - De RU Формула с Формула с S Från formel Från formel TR İlk Formül İlk Formül US From Formula From Formula ZHS 自配方 自配方 8 70 :to_formula LOV Oracle QC_FORMULA_LIST_V1 Y select formula_no id, formula_no value, null description from fm_form_mst_v1 order by formula_no AR إلى تركيبة إلى تركيبة D Bis Rezeptur Bis Rezeptur E A Fórmula A Fórmula F Formule - A Formule - A I Formula - A Formula - A JA フォーミュラ:至 フォーミュラ:至 KO 배합표: 까지 배합표: 까지 PTB Fórmula - Até Fórmula - Até RU Формула по Формула по S Till formel Till formel TR Son Formül Son Formül US To Formula To Formula ZHS 至配方 至配方 9 80 :from_formula_version LOV Oracle QC_FORMULA_VERSION_LIST_V1 Y select formula_vers id, formula_vers value, null description from fm_form_mst_v2 order by formula_vers AR من نسخة التركيبة من نسخة التركيبة D Von Rezepturversion Von Rezepturversion E De Versión de Fórmula De Versión de Fórmula F Version de formule - De Version de formule - De I Versione formula - Da Versione formula - Da JA フォーミュラ・バージョン:自 フォーミュラ・バージョン:自 KO 배합표 버전: 부터 배합표 버전: 부터 PTB Versão da Fórmula - De Versão da Fórmula - De RU Версия формулы с Версия формулы с S Från formelversion Från formelversion TR İlk Formül Sürümü İlk Formül Sürümü US From Formula Version From Formula Version ZHS 自配方版本 自配方版本 10 90 :to_formula_version LOV Oracle QC_FORMULA_VERSION_LIST_V1 Y select formula_vers id, formula_vers value, null description from fm_form_mst_v2 order by formula_vers AR نسخة التركيبة إلى نسخة التركيبة إلى D Bis Rezepturversion Bis Rezepturversion E A Versión de Fórmula A Versión de Fórmula F Version de formule - A Version de formule - A I Versione formula - A Versione formula - A JA フォーミュラ・バージョン:至 フォーミュラ・バージョン:至 KO 배합표 버전: 까지 배합표 버전: 까지 PTB Versão Fórmula - Até Versão Fórmula - Até RU Версия формулы по Версия формулы по S Till formelversion Till formelversion TR Son Formül Sürümü Son Formül Sürümü US To Formula Version To Formula Version ZHS 至配方版本 至配方版本 11 100 :from_routing LOV Oracle QC_ROUTING_LIST_V1 Y select routing_no id, routing_no value, null description from fm_rout_hdr_v1 order by routing_no AR من توجيه من توجيه D Von Verfahren Von Verfahren E De Ruta De Ruta F Gamme - De Gamme - De I Ciclo di produzione - Da Ciclo di produzione - Da JA 工順:自 工順:自 KO 공정순서: 부터 공정순서: 부터 PTB Roteiro - De Roteiro - De RU Техкарта с Техкарта с S Från operationsföljd Från operationsföljd TR İlk Rota İlk Rota US From Routing From Routing ZHS 起始工艺路线 起始工艺路线 12 110 :to_routing LOV Oracle QC_ROUTING_LIST_V1 Y select routing_no id, routing_no value, null description from fm_rout_hdr_v1 order by routing_no AR إلى توجيه إلى توجيه D Bis Verfahren Bis Verfahren E A Ruta A Ruta F Gamme - A Gamme - A I Ciclo di produzione - A Ciclo di produzione - A JA 工順:至 工順:至 KO 공정순서: 까지 공정순서: 까지 PTB Roteiro - Até Roteiro - Até RU Техкарта по Техкарта по S Till operationsföljd Till operationsföljd TR Son Rota Son Rota US To Routing To Routing ZHS 终止工艺路线 终止工艺路线 13 120 :from_routing_version LOV Oracle QC_ROUTING_VERSION_LIST_V1 Y select routing_vers id, routing_vers value, null description from fm_rout_hdr_v2 order by routing_vers AR من نسخة التوجيه من نسخة التوجيه D Von Verfahrensversion Von Verfahrensversion E De Versión de Ruta De Versión de Ruta F Version de gamme - De Version gamme - De I Versione ciclo di produzione - Da Versione ciclo di produzione - Da JA 工順バージョン:自 工順バージョン:自 KO 공정순서 버전: 부터 공정순서 버전: 부터 PTB Versão do Roteiro - De Versão do Roteiro - De RU Версия техкарты с Версия техкарты с S Från operationsföljdsversion Från operationsföljdsversion TR İlk Rota Sürümü İlk Rota Sürümü US From Routing Version From Routing Version ZHS 起始工艺路线版本 起始工艺路线版本 14 130 :to_routing_version LOV Oracle QC_ROUTING_VERSION_LIST_V1 Y select routing_vers id, routing_vers value, null description from fm_rout_hdr_v2 order by routing_vers AR إلى نسخة التوجيه نسخة التوجيه إلى D Bis Verfahrensversion Bis Verfahrensversion E A Versión de Ruta A Versión de Ruta F Version de gamme - A Version gamme - A I Versione ciclo di produzione - A Versione ciclo di produzione - A JA 工順バージョン:至 工順バージョン:至 KO 공정순서 버전: 까지 공정순서 버전: 까지 PTB Versão do Roteiro - Até Versão do Roteiro - Até RU Версия техкарты по Версия техкарты по S Till operationsföljdsversion Till operationsföljdsversion TR Son Rota Sürümü Son Rota Sürümü US To Routing Version To Routing Version ZHS 终止工艺路线版本 终止工艺路线版本 15 140 :from_routing_step_no LOV Oracle QC_ROUTING_STEP_LIST_V1 Y select routingstep_no id, routingstep_no value, null description from fm_rout_dtl_v1 order by routingstep_no AR من رقم خطوة التوجيه من رقم خطوة التوجيه D Von Verfahrensschritt-Nr Von Verfahrensschritt-Nr E De Número de Paso de Ruta De Número de Paso de Ruta F Numéro d'étape de gamme - De Numéro d'étape de gamme - De I Numero fase ciclo di produzione - Da Numero fase ciclo di produzione - Da JA 工順ステップ番号:自 工順ステップ番号:自 KO 공정순서 단계 번호: 부터 공정순서 단계 번호: 부터 PTB Número da Etapa de Roteiro - De Número da Etapa de Roteiro - De RU Номер шага техкарты с Номер шага техкарты с S Stegnr för operationsföljd från Stegnr för operationsföljd från TR İlk Rota Adım No İlk Rota Adım No US From Routing Step Number From Routing Step Number ZHS 工艺路线步骤起始编号 工艺路线步骤起始编号 16 150 :to_routing_step_no LOV Oracle QC_ROUTING_STEP_LIST_V1 Y select routingstep_no id, routingstep_no value, null description from fm_rout_dtl_v1 order by routingstep_no AR إلى رقم خطوة التوجيه إلى رقم خطوة التوجيه D Bis Verfahrensschritt-Nr Bis Verfahrensschritt-Nr E A Número de Paso de Ruta A Número de Paso de Ruta F Numéro d'étape de gamme - A Numéro d'étape de gamme - A I Numero fase ciclo di produzione - Da 2 Numero fase ciclo di produzione - Da JA 工順ステップ番号:至 工順ステップ番号:至 KO To 공정순서 단계 번호 To 공정순서 단계 번호 PTB Número da Etapa de Roteiro - Até Número da Etapa de Roteiro - Até RU Номер шага техкарты по Номер шага техкарты по S Stegnr för operationsföljd till Stegnr för operationsföljd till TR Son Rota Adım No Son Rota Adım No US To Routing Step Number To Routing Step Number ZHS 工艺路线步骤终止编号 工艺路线步骤终止编号 17 160 :from_operation LOV Oracle OPERATION_LIST Y select oprn_no id, oprn_no value, oprn_desc description from fm_oprn_mst where delete_mark=0 order by oprn_no AR من العملية من العملية D Von Arbeitsgang Von Arbeitsgang E De Operación De Operación F Opération - De Opération - De I Operazione - Da Operazione - Da JA 工程:自 工程:自 KO 공정: 부터 공정: 부터 PTB Operação - De Operação - De RU Операция с Операция с S Från operation Från operation TR İlk Operasyon İlk Operasyon US From Operation From Operation ZHS 起始工序 起始工序 18 170 :to_operation LOV Oracle OPERATION_LIST Y select oprn_no id, oprn_no value, oprn_desc description from fm_oprn_mst where delete_mark=0 order by oprn_no AR إلى العملية إلى العملية D Bis Arbeitsgang Bis Arbeitsgang E A Operación A Operación F Opération - A Opération - A I Operazione - A Operazione - A JA 工程:至 工程:至 KO 공정: 까지 공정: 까지 PTB Operação - Até Operação - Até RU Операция по Операция по S Till operation Till operation TR Son Operasyon Son Operasyon US To Operation To Operation ZHS 终止工序 终止工序 19 180 :from_item LOV Oracle QM_Item Y Y select inventory_item_id id, concatenated_segments value, description description from mtl_system_items_kfv where process_quality_enabled_flag='Y' and organization_id=:$flex$.qm_org order by concatenated_segments AR من صنف من صنف D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR İlk Kalem İlk Kalem US From Item From Item ZHS 起始物料 起始物料 20 190 :to_item LOV Oracle QM_Item_To Y select inventory_item_id id, concatenated_segments value, description description from mtl_system_items_kfv where process_quality_enabled_flag='Y' and organization_id=:$flex$.qm_org order by concatenated_segments AR إلى الصنف إلى الصنف D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Son Kalem Son Kalem US To Item To Item ZHS 终止物料 终止物料 21 200 :from_lotno LOV Oracle QM_Lot Y select lot_number id, lot_number value, description description from mtl_lot_numbers where organization_id=:$flex$.qm_org and inventory_item_id>=nvl(:$flex$.qm_item,0) and inventory_item_id<=nvl(:$flex$.qm_item_to,:$flex$.qm_item) order by value,description AR من اللوط من اللوط D Von Charge Von Charge E De Lote 2 De Lote F Lot - De Lot - De I Lotto - Da Lotto - Da JA ロット:自 ロット:自 KO 로트: 부터 로트: 부터 PTB Lote - De Lote - De RU Партия с Партия с S Från parti Från parti TR İlk Lot İlk Lot US From Lot From Lot ZHS 起始批次 起始批次 22 210 :to_lot LOV Oracle QM_Lot Y select lot_number id, lot_number value, description description from mtl_lot_numbers where organization_id=:$flex$.qm_org and inventory_item_id>=nvl(:$flex$.qm_item,0) and inventory_item_id<=nvl(:$flex$.qm_item_to,:$flex$.qm_item) order by value,description AR إلى اللوط إلى اللوط D Bis Charge Bis Charge E A Lote 2 A Lote F Lot - A Lot - A I Lotto - A Lotto - A JA ロット:至 ロット:至 KO 로트: 까지 로트: 까지 PTB Lote - Até Lote - Até RU Партия по Партия по S Till parti Till parti TR Son Lot Son Lot US To Lot To Lot ZHS 终止批次 终止批次 23 220 :from_result_date Date sysdate AR من تاريخ النتيجة من تاريخ النتيجة D Von Ergebnisdatum Von Ergebnisdatum E De Fecha de Resultado De Fecha de Resultado F Date de résultat - Du Date de résultat - Du I Data risultato - Da Data risultato - Da JA 結果日:自 結果日:自 KO 결과 일자: 부터 결과 일자: 부터 PTB Data Resultado-De Data Resultado-De RU Дата результатов с Дата результатов с S Från resultatdatum Från resultatdatum TR İlk Sonuç Tarihi İlk Sonuç Tarihi US From Result Date From Result Date ZHS 结果起始日期 结果起始日期 24 230 :to_result_date Date sysdate AR إلى تاريخ نتيجة إلى تاريخ نتيجة D Bis Ergebnisdatum Bis Ergebnisdatum E A Fecha de Resultado A Fecha de Resultado F Date de résultat - Au Date de résultat - Au I Data risultato - A Data risultato - A JA 結果日:至 結果日:至 KO 결과 일자: 까지 결과 일자: 까지 PTB Data Resultado-Até Data Resultado-Até RU Дата результатов по Дата результатов по S Till resultatdatum Till resultatdatum TR Son Sonuç Tarihi Son Sonuç Tarihi US To Result Date To Result Date ZHS 结果终止日期 结果终止日期 25 240 :include LOV Oracle QC_INCLUDE Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='QC_INCLUDE' order by value,description select meaning from gem_lookups where lookup_type = 'QC_INCLUDE' and lookup_code = 0 AR يتضمن يتضمن D Mit Mit E Incluir Incluir F Inclure Inclure I Includi Includi JA 含む 含む KO 포함 포함 PTB Incluir Incluir RU Включить Включить S Inkludera Inkludera TR Dahil Et Dahil Et US Include Include ZHS 包括 包括 26 250 :print_condition LOV Oracle QC_PRINT Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='QC_PRINT' order by value,description select meaning from gem_lookups where lookup_type = 'QC_PRINT' and lookup_code = 2 AR شرط الطباعة شرط الطباعة D Druckbedingung Druckbedingung E Imprimir Condiciones Imprimir Condiciones F Condition d'impression Condition d'impression I Opzioni di stampa Opzioni di stampa JA 印刷条件 印刷条件 KO 인쇄 조건 인쇄 조건 PTB Condição de Impressão Condição de Impressão RU Условие печати Условие печати S Utskriftsvillkor Utskriftsvillkor TR Yazdırma Koşulu Yazdırma Koşulu US Print Condition Print Condition ZHS 打印条件 打印条件