ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FA751A9E05362FB09050512Y SELECT cust.account_number, '['||cust.account_name||']' cust_name , msi.concatenated_segments item_number, '['|| msi.description ||']' item_desc1, mln.lot_number, '['||mln.description||']' lot_desc, gt.test_type, gt.test_code assay_code, gr1.text_code, gt.test_unit qcunit_code, gr1.result_date, 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 qc_spec_id, gst.test_id qcassy_typ_id, 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, decode(gsr.evaluation_ind,'0A','Y','N') accept_anyway, gs.ship_to_site_id, gs.order_id order_header_id, gs.order_line_id , gs.order_line_id order_line , gs.org_id order_org_id, GMD_QCR01USR_XMLP_PKG.operating_unitcfformula(gs.org_id) operating_unitCF, GMD_QCR01USR_XMLP_PKG.ship_to_sitecfformula(gs.ship_to_site_id) ship_to_siteCF, GMD_QCR01USR_XMLP_PKG.order_headercfformula(gs.order_id) order_headerCF, GMD_QCR01USR_XMLP_PKG.order_typeCP_p order_typeCP, GMD_QCR01USR_XMLP_PKG.assay_desccfformula(gt.test_code) assay_descCF, GMD_QCR01USR_XMLP_PKG.cf_minformula(gt.test_type, nvl ( gst.report_precision , gt.report_precision ), gst.min_value_num, gst.min_value_char) CF_min, GMD_QCR01USR_XMLP_PKG.cf_maxformula(gt.test_type, nvl ( gst.report_precision , gt.report_precision ), gst.max_value_num, gst.max_value_char) CF_max, GMD_QCR01USR_XMLP_PKG.textcfformula(gst.target_value_char) textCF, GMD_QCR01USR_XMLP_PKG.targetcfformula(gst.target_value_char, gst.target_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision )) targetCF, GMD_QCR01USR_XMLP_PKG.target_dispcfformula(gt.test_code, gst.test_id,GMD_QCR01USR_XMLP_PKG.targetcfformula(gst.target_value_char, gst.target_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision ))) target_dispCF, GMD_QCR01USR_XMLP_PKG.texttargetformula(GMD_QCR01USR_XMLP_PKG.textcfformula(gst.target_value_char),GMD_QCR01USR_XMLP_PKG.targetcfformula(gst.target_value_char, gst.target_value_num, gt.test_type, nvl ( gst.report_precision , gt.report_precision ))) texttargetCF, GMD_QCR01USR_XMLP_PKG.qcunit_codecfformula(gst.spec_id, gt.test_code, gst.test_id) qcunit_codeCF, GMD_QCR01USR_XMLP_PKG.min_speccfformula(gst.spec_id, gt.test_code, gst.min_value_char, gst.min_value_num) min_specCF, GMD_QCR01USR_XMLP_PKG.min_charcfformula(gst.min_value_char) min_charCF, GMD_QCR01USR_XMLP_PKG.min_dispcfformula(gst.test_id, GMD_QCR01USR_XMLP_PKG.max_specformula(gst.max_value_char, gst.spec_id, gt.test_code, gst.max_value_num)) min_dispCF, GMD_QCR01USR_XMLP_PKG.max_specformula(gst.max_value_char, gst.spec_id, gt.test_code, gst.max_value_num) max_specCF, GMD_QCR01USR_XMLP_PKG.max_charcfformula(gst.max_value_char) max_charCF, GMD_QCR01USR_XMLP_PKG.max_dispcfformula(gst.test_id, GMD_QCR01USR_XMLP_PKG.max_specformula(gst.max_value_char, gst.spec_id, gt.test_code, gst.max_value_num)) max_dispCF, GMD_QCR01USR_XMLP_PKG.from_datecfformula(gs.sample_no) from_dateCF, GMD_QCR01USR_XMLP_PKG.todateformula(gs.sample_no) to_dateCF, GMD_QCR01USR_XMLP_PKG.textarraycfformula(GMD_QCR01USR_XMLP_PKG.textcodecfformula(gst.spec_id)) textarrayCF, GMD_QCR01USR_XMLP_PKG.textcodecfformula(gst.spec_id) TextcodeCF, GMD_QCR01USR_XMLP_PKG.assay_typeCP_p assay_typeCP, GMD_QCR01USR_XMLP_PKG.result1cfformula(gr1.result_value_char, gr1.result_value_num) Result1CF, GMD_QCR01USR_XMLP_PKG.result_dispcfformula(gst.test_id, gr1.result_value_num) result_dispCF, GMD_QCR01USR_XMLP_PKG.accept_finalcfformula(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' )) Accept_FinalCF, GMD_QCR01USR_XMLP_PKG.text_resultcfformula(gr1.result_value_char) text_resultCF, GMD_QCR01USR_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_QCR01USR_XMLP_PKG.textarray2cfformula(gr1.text_code) textarray2CF, GMD_QCR01USR_XMLP_PKG.Accept_CP_p Accept_CP, GMD_QCR01USR_XMLP_PKG.Final_CP_p Final_CP, 'x' dummy,'y' dummy FROM hz_cust_accounts_all cust, 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 cust.cust_account_id = gs.cust_id AND gs.supplier_id IS NULL AND gs.inventory_item_id = msi.inventory_item_id AND gs.organization_id = msi.organization_id AND gs.inventory_item_id = mln.inventory_item_id(+) -- plowe 10122626 AND gs.organization_id = mln.organization_id(+) -- plowe 10122626 AND gs.organization_id = :p_organization_Id AND nvl(gs.lot_number,0) = nvl(mln.lot_number(+),0) -- plowe 10122626 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.batch_id IS NULL AND gs.formula_id IS NULL AND gs.routing_id IS NULL AND gs.oprn_id IS NULL AND cust.status = 'A' AND gr1.delete_mark = 0 AND gs.delete_mark = 0 &Date1CP &Final1CP &Cust_VendCP_1 &ItemCP &LotnoCP &SampleCP ORDER BY cust.account_number, gs.org_id, gs.ship_to_site_id, gs.order_id, gs.order_line_id, item_number, mln.lot_number , gt.test_code, gr1.result_date DESC GMD QCR01USR_XML AR GMD تقرير نتائج اختبار العميل/المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير نتائج اختبار العميل/المورّد في OPM QM Application: تطوير منتجات التصنيع التشغيلي Source: تقرير نتائج اختبار العميل/المورد (بتنسيق XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG D GMD Kunde/Lieferant - Testergebnisse Imported from BI Publisher Description: Auswertung "Prüfmethode Kunde/Lieferant - Ergebnisse" in OPM Qualitätskontrolle Application: Process Manufacturing Produktentwicklung Source: Kunde/Lieferant - Testergebnisse (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG E GMD Resultados de Prueba de Cliente/Proveedor Imported from BI Publisher Description: Informe de Resultados de Ensayo de Cliente/Proveedor de QM de OPM Application: Process Manufacturing Product Development Source: Resultados de Prueba de Cliente/Proveedor (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG F GMD Résultats des tests client/fournisseur Imported from BI Publisher Description: Etat Résultats des tests client/fournisseur d'OPM QM Application: Process Manufacturing Product Development Source: Résultats des tests client/fournisseur (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG I GMD Rapporto Risultati test cliente/fornitore Imported from BI Publisher Description: Rapporto Risultati analisi cliente/fornitore di QM OPM Application: Process Manufacturing Product Development Source: Rapporto Risultati test cliente/fornitore (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG JA GMD 顧客/仕入先テスト結果 - レポート Imported from BI Publisher Description: OPM QM顧客/仕入先分析結果情報 Application: Process Manufacturing Product Development Source: 顧客/仕入先テスト結果 - レポート(XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG KO GMD 고객/공급자 테스트 결과 보고서 Imported from BI Publisher Description: OPM QM 고객/공급자 검사항목 결과 보고서 Application: Process Manufacturing Product Development Source: 고객/공급자 테스트 결과 보고서(XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG PTB GMD Relatório de Resultados do Teste do Cliente/Fornecedor Imported from BI Publisher Description: Relatório de Resultados do Ensaio do Cliente/Fornecedor do OPM QM Application: Process Manufacturing Product Development Source: Relatório de Resultados do Teste do Cliente/Fornecedor (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG RU GMD Отчет о результатах проверки заказчика/поставщика Imported from BI Publisher Description: Отчет УК УНП о результатах тестов по заказчику/поставщику Application: Разработка продукции УНП Source: Отчет о результатах проверки заказчика/поставщика (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG S GMD Kunder/leverantörer: Testresultat - rapport Imported from BI Publisher Description: Analysresultat för kund/leverantör - rapport för kvalitetsstyrning i OPM Application: Process Manufacturing Product Development Source: Kunder/leverantörer: Testresultat - rapport (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG TR GMD Müşteri/Tedarikçi Test Sonuçları Raporu Imported from BI Publisher Description: OPM QM Müşteri/Tedarikçi Deney Sonuçları Raporu Application: Üretim Prosesi Ürün Geliştirme Source: Müşteri/Tedarikçi Test Sonuçları Raporu (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG US GMD Customer/Supplier Test Results Imported from BI Publisher Description: Customer/Supplier Assay Results Report of OPM QM Application: Process Manufacturing Product Development Source: Customer/Supplier Test Results Report (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG ZHS GMD 客户/供应商测试结果报表 Imported from BI Publisher Description: OPM QM 的客户/供应商分析结果报表 Application: OPM 产品开发管理系统 Source: 客户/供应商测试结果报表 (XML) Short Name: QCR01USR_XML DB package: GMD_QCR01USR_XMLP_PKG BI Publisher &cust_vendcp_1 &date1cp &final1cp &itemcp &lotnocp &samplecp :accept1_cp :accept_cp :assay_type1cp :assay_typecp :cust_vendcp :cust_vendcp_1 :date1cp :final1_cp :final1cp :final_cp :from_cust_vend :from_cust_vendcp :from_item :from_itemcp :from_lotno :from_lotnocp :from_result_date :from_rslt_dtcp :from_sample :from_samplecp :include :itemcp :lotnocp :nonblocksql :order_typecp :org_cp :p_conc_request_id :p_organization_id :p_rows :print_condition :report_type :samplecp :sublotnocp :sy_all :to_cust_vend :to_cust_vendcp :to_item :to_itemcp :to_lotno :to_lotnocp :to_result_date :to_rslt_dtcp :to_sample :to_samplecp 1 -20 :sy_all Char fnd_profile.value('SY$ALL') US SY ALL SY ALL 2 10 :report_type LOV Oracle GMD_REPORT_TYPE Y select lookup_code id, meaning value, description description from gem_lookups where lookup_type='GMD_REPORT_TYPE' order by value,description select meaning from gem_lookups where lookup_type = 'GMD_REPORT_TYPE' and lookup_code = 0 Y AR نوع التقرير نوع التقرير D Auswertungsart Auswertungsart E Tipo de Informe Tipo de Informe F Type d'état Type d'état I Tipo di rapporto Tipo di rapporto JA レポート・タイプ レポート・タイプ KO 보고서 유형 보고서 유형 PTB Tipo de Relatório Tipo de Relatório RU Тип отчета Тип отчета S Rapporttyp Rapporttyp TR Rapor Tipi Rapor Tipi US Report Type Report Type ZHS 报表类型 报表类型 3 20 :from_cust_vend LOV Oracle GMD_CUST_VEND_LIST_V2 Y select cust_vend_no id, cust_vend_no value, cust_vend_name description from gmd_cust_vend_mst_v2 where report_type=:$flex$.gmd_report_type order by cust_vend_name AR من العميل/المورد من العميل/المورد D Von Kunde/Lieferant Von Kunde/Lieferant E De Cliente/Proveedor De Cliente/Proveedor F Client/fournisseur - De Client/fournisseur - De I Cliente/fornitore - Da Cliente/fornitore - Da JA 顧客/仕入先:自 顧客/仕入先:自 KO From 고객/공급자 From 고객/공급자 PTB Cliente/Fornecedor - De Cliente/Fornecedor - De RU Заказчик/поставщик с Заказчик/поставщик с S Från kund/leverantör Från kund/leverantör TR İlk Müşteri/Tedarikçi İlk Müşteri/Tedarikçi US From Customer/Supplier From Customer/Supplier ZHS 自客户/供应商 自客户/供应商 4 30 :to_cust_vend LOV Oracle GMD_CUST_VEND_LIST_V2 Y select cust_vend_no id, cust_vend_no value, cust_vend_name description from gmd_cust_vend_mst_v2 where report_type=:$flex$.gmd_report_type order by cust_vend_name AR إلى العميل/المورد إلى العميل/المورد D Bis Kunde/Lieferant Bis Kunde/Lieferant E A Cliente/Proveedor A Cliente/Proveedor F Client/fournisseur - A Client/fournisseur - A I Cliente/fornitore - A Cliente/fornitore - A JA 顧客/仕入先:至 顧客/仕入先:至 KO To 고객/공급자 To 고객/공급자 PTB Cliente/Fornecedor - Até Cliente/Fornecedor - Até RU Заказчик/поставщик по Заказчик/поставщик по S Till kund/leverantör Till kund/leverantör TR Son Müşteri/Tedarikçi Son Müşteri/Tedarikçi US To Customer/Supplier To Customer/Supplier ZHS 至客户/供应商 至客户/供应商 5 40 :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 组织 组织标识 6 50 :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 起始物料 起始物料 7 60 :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 终止物料 终止物料 8 70 :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 起始批次 起始批次 9 80 :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 终止批次 终止批次 10 90 :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 结果起始日期 结果起始日期 11 100 :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 结果终止日期 结果终止日期 12 110 :from_sample LOV Oracle GMD_QC_CUST_VEND_SAMPLE Y select sample_no id, sample_no value, sample_desc description from gmd_samples where ((cust_id is not null and :$flex$.gmd_report_type=0)or (supplier_id is not null and :$flex$.gmd_report_type=1)) 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 自抽样 自抽样 13 120 :to_sample LOV Oracle GMD_QC_CUST_VEND_SAMPLE Y select sample_no id, sample_no value, sample_desc description from gmd_samples where ((cust_id is not null and :$flex$.gmd_report_type=0)or (supplier_id is not null and :$flex$.gmd_report_type=1)) 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 至样品 至样品 14 130 :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 包括 包括 15 140 :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 打印条件 打印条件