ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FA851A9E05362FB09050512Y SELECT msi.concatenated_segments ITEM, '['|| msi.description ||']' item_desc1, mln.lot_number LOT, '['||mln.description||']' lot_desc, gs.subinventory , gs.locator_id , gt.test_type, gt.test_code assay_code, gr1.text_code, decode(ges.spec_id,null, gt.test_unit,gst.test_uom) 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.revision, 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, NVL(gst.report_precision, gt.report_precision) precision, gst.spec_id SPEC, 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, nvl( gsr.in_spec_ind,'N') in_spec_ind, GMD_QCR02USR_XMLP_PKG.locator_namecfformula(gs.locator_id) Locator_NameCF, GMD_QCR02USR_XMLP_PKG.assay_desccfformula(gt.test_code) assay_descCF, GMD_QCR02USR_XMLP_PKG.text_codecfformula(gst.spec_id) text_codeCF, GMD_QCR02USR_XMLP_PKG.assay_dispcfformula(gt.test_code, gst.test_id, :targetspecCF) assay_dispCF, GMD_QCR02USR_XMLP_PKG.assaymin_dispcfformula(gst.test_id, :min_specCF) assaymin_dispCF, GMD_QCR02USR_XMLP_PKG.assaymax_dispcfformula(gst.test_id, :max_specCF) assaymax_dispCF, GMD_QCR02USR_XMLP_PKG.qcunit_codecfformula(gst.spec_id, gst.test_id) qcunit_codeCF, GMD_QCR02USR_XMLP_PKG.textcfformula(gst.target_value_char) textspecCF, GMD_QCR02USR_XMLP_PKG.targetspecformula(gst.target_value_num, gt.test_type, NVL ( gst.report_precision , gt.report_precision )) targetspecCF, GMD_QCR02USR_XMLP_PKG.min_vaildcfformula(gt.test_code) min_vaildCF, GMD_QCR02USR_XMLP_PKG.min_speccfformula(gst.min_value_char, gst.min_value_num) min_specCF, GMD_QCR02USR_XMLP_PKG.min_charcfformula(gst.min_value_char) min_charCF, GMD_QCR02USR_XMLP_PKG.minimumcfformula(gst.min_value_num, gt.test_type, NVL ( gst.report_precision , gt.report_precision ), gst.min_value_char) minimumCF, GMD_QCR02USR_XMLP_PKG.max_speccfformula(gst.max_value_char, gst.max_value_num) max_specCF, GMD_QCR02USR_XMLP_PKG.max_charcfformula(gst.max_value_char) max_charCF, GMD_QCR02USR_XMLP_PKG.max_vaildcfformula(gt.test_code) max_vaildCF, GMD_QCR02USR_XMLP_PKG.maximumcfformula(gst.max_value_num, gt.test_type, NVL ( gst.report_precision , gt.report_precision ), gst.max_value_char) maximumCF, GMD_QCR02USR_XMLP_PKG.effectivitycfformula(gs.sample_no) EffectivityCF, GMD_QCR02USR_XMLP_PKG.EFFECTIVITYCFFORMULACHR(gs.sample_no) EffectivityCFCH, GMD_QCR02USR_XMLP_PKG.effectivitycf1formula(gs.sample_no) EffectivityCF1, GMD_QCR02USR_XMLP_PKG.textarraycfformula(:text_codeCF) textarrayCF, GMD_QCR02USR_XMLP_PKG.assay_typeCP_p assay_typeCP, GMD_QCR02USR_XMLP_PKG.result_dispcfformula(gst.test_id, gr1.result_value_num) result_dispCF, GMD_QCR02USR_XMLP_PKG.num_resultcfformula(gr1.result_value_char, gr1.result_value_num, gt.test_type, NVL ( gst.report_precision , gt.report_precision )) num_resultCF, GMD_QCR02USR_XMLP_PKG.resultcfformula(gr1.result_value_char, gr1.result_value_num) ResultCF, GMD_QCR02USR_XMLP_PKG.acceptcfformula(decode ( gsr.evaluation_ind , '0A' , 'Y' , 'N' ), 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' ), nvl ( gsr.in_spec_ind , 'N' )) AcceptCF, GMD_QCR02USR_XMLP_PKG.textarray2cfformula(gr1.text_code) textarray2CF, GMD_QCR02USR_XMLP_PKG.SPEC_CP_p SPEC_CP, GMD_QCR02USR_XMLP_PKG.Accept_CP_p Accept_CP, GMD_QCR02USR_XMLP_PKG.Final_CP_p Final_CP, 'x' dummy, 'y' dummy, 'z' dummy FROM 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 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 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.supplier_id IS NULL AND gs.batch_id IS NULL AND gs.formula_id IS NULL AND gs.routing_id IS NULL AND gs.oprn_id IS NULL AND gr1.delete_mark = 0 AND gs.delete_mark = 0 &SampleCP &ItemCP &LotnoCP &SubinventoryCP &LocatorCP &DateCP &IncludeCP union SELECT distinct msi.concatenated_segments ITEM, '['|| msi.description ||']' item_desc1, mln.lot_number LOT, '['||mln.description||']' lot_desc, gs.subinventory , gs.locator_id , 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', 'N' ), 'N' ) final_mark, gs.revision, 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, NVL (gt.report_precision, gt.report_precision) PRECISION, NULL spec , NULL text_spec, NULL target_spec,NULL min_char, NULL max_char, gt.min_value_num min_spec, gt.max_value_num max_spec, gt.test_id qcassy_typ_id, NVL (gsr.in_spec_ind, 'N') in_spec_ind, GMD_QCR02USR_XMLP_PKG.locator_namecfformula(gs.locator_id) Locator_NameCF, GMD_QCR02USR_XMLP_PKG.assay_desccfformula(gt.test_code) assay_descCF, GMD_QCR02USR_XMLP_PKG.text_codecfformula(NULL) text_codeCF, GMD_QCR02USR_XMLP_PKG.assay_dispcfformula(gt.test_code, gt.test_id, :targetspecCF) assay_dispCF, GMD_QCR02USR_XMLP_PKG.assaymin_dispcfformula(gt.test_id, :min_specCF) assaymin_dispCF, GMD_QCR02USR_XMLP_PKG.assaymax_dispcfformula(gt.test_id, :max_specCF) assaymax_dispCF, GMD_QCR02USR_XMLP_PKG.qcunit_codecfformula(NULL, gt.test_id) qcunit_codeCF, GMD_QCR02USR_XMLP_PKG.textcfformula(NULL) textspecCF, GMD_QCR02USR_XMLP_PKG.targetspecformula(NULL, gt.test_type, NVL (gt.report_precision, gt.report_precision)) targetspecCF, GMD_QCR02USR_XMLP_PKG.min_vaildcfformula(gt.test_code) min_vaildCF, GMD_QCR02USR_XMLP_PKG.min_speccfformula(NULL, gt.min_value_num) min_specCF, GMD_QCR02USR_XMLP_PKG.min_charcfformula(NULL) min_charCF, GMD_QCR02USR_XMLP_PKG.minimumcfformula(gt.min_value_num, gt.test_type, NVL (gt.report_precision, gt.report_precision), NULL) minimumCF, GMD_QCR02USR_XMLP_PKG.max_speccfformula(NULL, gt.max_value_num) max_specCF, GMD_QCR02USR_XMLP_PKG.max_charcfformula(NULL) max_charCF, GMD_QCR02USR_XMLP_PKG.max_vaildcfformula(gt.test_code) max_vaildCF, GMD_QCR02USR_XMLP_PKG.maximumcfformula(gt.max_value_num, gt.test_type,NVL (gt.report_precision, gt.report_precision), NULL) maximumCF, GMD_QCR02USR_XMLP_PKG.effectivitycfformula(gs.sample_no) EffectivityCF, GMD_QCR02USR_XMLP_PKG.EFFECTIVITYCFFORMULACHR(gs.sample_no) EffectivityCFCH, GMD_QCR02USR_XMLP_PKG.effectivitycf1formula(gs.sample_no) EffectivityCF1, GMD_QCR02USR_XMLP_PKG.textarraycfformula(:text_codeCF) textarrayCF, GMD_QCR02USR_XMLP_PKG.assay_typeCP_p assay_typeCP, GMD_QCR02USR_XMLP_PKG.result_dispcfformula(gt.test_id, gr1.result_value_num) result_dispCF, GMD_QCR02USR_XMLP_PKG.num_resultcfformula(gr1.result_value_char, gr1.result_value_num, gt.test_type, NVL (gt.report_precision, gt.report_precision)) num_resultCF, GMD_QCR02USR_XMLP_PKG.resultcfformula(gr1.result_value_char, gr1.result_value_num) ResultCF, GMD_QCR02USR_XMLP_PKG.acceptcfformula(DECODE (gsr.evaluation_ind, '0A', 'Y', 'N'), DECODE (gr1.ad_hoc_print_on_coa_ind, 'Y', DECODE (gsr.evaluation_ind, '0A', 'Y', '1V', 'Y', '2R', 'Y', 'N' ), 'N' ), NVL (gsr.in_spec_ind, 'N')) AcceptCF, GMD_QCR02USR_XMLP_PKG.textarray2cfformula(gr1.text_code) textarray2CF, GMD_QCR02USR_XMLP_PKG.SPEC_CP_p SPEC_CP, GMD_QCR02USR_XMLP_PKG.Accept_CP_p Accept_CP, GMD_QCR02USR_XMLP_PKG.Final_CP_p Final_CP, 'x' dummy, 'y' dummy, 'z' dummy FROM mtl_system_items_kfv msi, mtl_lot_Numbers mln, gmd_samples gs, gmd_results gr1, gmd_qc_tests_b gt, gmd_spec_results gsr 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 gs.sample_id = gr1.sample_id AND gr1.test_id NOT IN (select gst.test_id from gmd_spec_tests_b gst, gmd_sampling_events gse,gmd_event_spec_disp ges where gse.sampling_event_id = gs.sampling_event_id AND gse.sampling_event_id = ges.sampling_event_id AND ges.event_spec_disp_id = gsr.event_spec_disp_id AND ges.spec_used_for_lot_attrib_ind = 'Y' AND ges.spec_id(+) = gst.spec_id) AND gr1.result_date IS NOT NULL AND gr1.result_id = gsr.result_id AND gr1.test_id = gt.test_id AND gs.cust_id IS NULL AND gs.supplier_id IS NULL AND gs.batch_id IS NULL AND gs.formula_id IS NULL AND gs.routing_id IS NULL AND gs.oprn_id IS NULL AND gr1.delete_mark = 0 AND gs.delete_mark = 0 &SampleCP &ItemCP &LotnoCP &SubinventoryCP &LocatorCP &DateCP &IncludeCP /*ORDER BY 1, 3, 5, 6, 9, 11 DESC*/ ORDER BY 1 ASC,2 ASC,14 ASC,6 ASC,5 ASC,3 ASC,4 ASC,22 ASC,8 ASC,29 ASC,27 ASC,25 ASC,26 ASC,28 ASC,24 ASC,7 ASC,21 ASC,23 ASC , 1 , 3 , 5 , 6 , 9 , 11 DESC GMD QCR02USR_XML AR GMD تقرير نتائج اختبار الصنف/الموقع (بتنسيق XML) Imported from BI Publisher Description: تقرير نتائج اختبار موقع/صنف مراقبة جودة OPM Application: تطوير منتجات التصنيع التشغيلي Source: تقرير نتائج اختبار الصنف/الموقع (بتنسيق XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG D GMD Artikel/Lagerplatz - Testergebnisse Imported from BI Publisher Description: Auswertung "Prüfmethode Artikel/Lagerplatz - Ergebnisse" in OPM Qualitätskontrolle Application: Process Manufacturing Produktentwicklung Source: Artikel/Lagerplatz - Testergebnisse (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG E GMD Resultados de Prueba de Artículo/Ubicación Imported from BI Publisher Description: Informe Resultados de Ensayos de Artículo/Ubicación de OPM QC Application: Process Manufacturing Product Development Source: Resultados de Prueba de Artículo/Ubicación (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG F GMD Résultats des tests article/lieu Imported from BI Publisher Description: Etat Résultats des tests article/lieu d'OPM QC Application: Process Manufacturing Product Development Source: Résultats des tests article/lieu (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG I GMD Rapporto Risultati test articolo/ubicazione Imported from BI Publisher Description: Rapporto Risultati analisi articolo/ubicazione (GMQ) Application: Process Manufacturing Product Development Source: Rapporto Risultati test articolo/ubicazione (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG JA GMD 品目/保管場所テスト結果レポート Imported from BI Publisher Description: OPM QC品目/保管場所分析結果レポート Application: Process Manufacturing Product Development Source: 品目/保管場所テスト結果レポート(XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG KO GMD 품목/위치 테스트 결과 보고서 설명 Imported from BI Publisher Description: OPM QC의 품목/위치 검사 항목 결과 보고서 Application: Process Manufacturing Product Development Source: 품목/위치 테스트 결과 보고서 설명(XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG PTB GMD Relatório de Resultados do Teste do Item/Local Imported from BI Publisher Description: Relatório de Resultados do Ensaio de Item/Local de CQ do OPM Application: Process Manufacturing Product Development Source: Relatório de Resultados do Teste do Item/Local (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG RU GMD Отчет о результатах проверки по позиции/расположению Imported from BI Publisher Description: Отчет о результатах проверки тестов по позиции/расположению КК УНП Application: Разработка продукции УНП Source: Отчет о результатах проверки по позиции/расположению (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG S GMD Testresultat för artikel/plats - rapport Imported from BI Publisher Description: Artikel-/platsanalys i OPM KK - resultatrapport Application: Process Manufacturing Product Development Source: Testresultat för artikel/plats - rapport (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG TR GMD Kalem/Yerleşim Test Sonuçları Raporu Imported from BI Publisher Description: OPM Kal. Kont. Kalem/Depo Adresi Deney Sonuçları Raporu Application: Üretim Prosesi Ürün Geliştirme Source: Kalem/Yerleşim Test Sonuçları Raporu (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG US GMD Item/Location Test Results Imported from BI Publisher Description: Item/Location Assay Results Report of OPM QC Application: Process Manufacturing Product Development Source: Item/Location Test Results Report (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG ZHS GMD 项目/地点测试结果报表 Imported from BI Publisher Description: OPM QC 的物料/地点分析结果报表 Application: OPM 产品开发管理系统 Source: 项目/地点测试结果报表 (XML) Short Name: QCR02USR_XML DB package: GMD_QCR02USR_XMLP_PKG BI Publisher &datecp &includecp &itemcp &locatorcp &lotnocp &samplecp &subinventorycp :accept_cp :assay_typecp :datecp :final_cp :from_item :from_itemcp :from_locator :from_locatorcp :from_lotno :from_lotnocp :from_result_date :from_rslt_dtcp :from_sample :from_samplecp :from_subinventory :from_subinventorycp :include :includecp :itemcp :locatorcp :lotnocp :max_speccf :min_speccf :nonblocksql :orgcp :p_conc_request_id :p_organization_id :print_condition :samplecp :spec_cp :subinventorycp :sy_all :targetspeccf :text_codecf :to_item :to_itemcp :to_locator :to_locatorcp :to_lotno :to_lotnocp :to_result_date :to_rslt_dtcp :to_sample :to_samplecp :to_subinventory :to_subinventorycp 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_SAMPLE_NO Y select sample_no id, sample_no value, sample_desc description from gmd_samples where (cust_id is null and supplier_id is null and oprn_id is null and routing_id is null and formula_id is null and batch_id is 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_SAMPLE_NO Y select sample_no id, sample_no value, sample_desc description from gmd_samples where (cust_id is null and supplier_id is null and oprn_id is null and routing_id is null and formula_id is null and batch_id is 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_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 起始物料 起始物料 6 50 :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 终止物料 终止物料 7 60 :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 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 起始批次 起始批次 8 70 :to_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 Bis Charge Bis Charge E A Lote 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 终止批次 终止批次 9 80 :from_subinventory LOV Oracle QM_Subinventory Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.qm_org order by secondary_inventory_name AR من المخزن من المخزن D Von Lager Von Lager E De Subalmacén De Subalmacén F Magasin - De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da JA 保管場所:自 保管場所:自 KO 시작 창고 시작 창고 PTB De Subinventário De Subinventário RU Складское подразделение-отправитель Складское подразделение-отправитель S Från lagerställe Från lagerställe TR İlk Stok Yeri İlk Stok Yeri US From Subinventory From Subinventory ZHS 起始子库存 起始子库存 10 90 :to_subinventory LOV Oracle QM_Subinventory_To Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.qm_org order by secondary_inventory_name AR إلى المخزن إلى المخزن D Bis Lager Bis Lager E A Subalmacén A Subalmacén F Magasin - A Magasin - A I Sottomagazzino - A Sottomagazzino - A JA 保管場所:至 保管場所:至 KO 종료 창고 종료 창고 PTB Para Subinventário Para Subinventário RU Складское подразделение-получатель Складское подразделение-получатель S Till lagerställe Till lagerställe TR Son Stok Yeri Son Stok Yeri US To Subinventory To Subinventory ZHS 终止子库存 终止子库存 11 100 :from_locator LOV Oracle QM_Locator Y select inventory_location_id id, concatenated_segments value, description description from mtl_item_locations_kfv where organization_id=:$flex$.qm_org and subinventory_code>=nvl (:$flex$.qm_subinventory,0) and subinventory_code<=nvl (:$flex$.qm_subinventory_to,:$flex$.qm_subinventory) order by concatenated_segments AR من محدد المواقع من محدد المواقع D Von Lagerplatz Von Lagerplatz E De Ubicación de Stock De Ubicación de Stock F Emplacement - De Emplacement - De I Collocazione - Da Collocazione - Da JA 保管棚:自 保管棚:自 KO 시작 보관처 시작 보관처 PTB Endereço - De Endereço - De RU Складское место-отправитель Складское место-отправитель S Från lagerplats Från lagerplats TR İlk Stok Adresi İlk Stok Adresi US From Locator From Locator ZHS 起始货位 起始货位 12 110 :to_locator LOV Oracle QM_Locator Y select inventory_location_id id, concatenated_segments value, description description from mtl_item_locations_kfv where organization_id=:$flex$.qm_org and subinventory_code>=nvl (:$flex$.qm_subinventory,0) and subinventory_code<=nvl (:$flex$.qm_subinventory_to,:$flex$.qm_subinventory) order by concatenated_segments AR إلى محدد المواقع إلى محدد المواقع D Bis Lagerplatz Bis Lagerplatz E A Ubicación de Stock A Ubicación de Stock F Emplacement - A Emplacement - A I Collocazione - A Collocazione - A JA 保管棚:至 保管棚:至 KO 종료 보관처 종료 보관처 PTB Endereço - Até Endereço - Até RU Складское место-получатель Складское место-получатель S Till lagerplats Till lagerplats TR Son Stok Adresi Son Stok Adresi US To Locator To Locator ZHS 终止货位 终止货位 13 120 :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 结果起始日期 结果起始日期 14 130 :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 结果终止日期 结果终止日期 15 140 :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 包括 包括 16 150 :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 打印条件 打印条件