ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FAA51A9E05362FB09050512Y SELECT msi.concatenated_segments item_no, '['|| msi.description ||']' Item, msi.inventory_item_Id item_id, mln.lot_number Lotno, '['||mln.description||']' Lot, mln.status_id lot_status_id , stat.status_code lot_status, '['||stat.description||']' Status, sub.secondary_inventory_name Subinventory, '[ '||sub.description ||' ]' Sub_Desc, loc.concatenated_segments Location1, '[ '||loc.description ||' ]' Location, loc.inventory_location_id locator_Id, t.test_code assay_code , st.target_value_num target_spec, NVL(TO_CHAR(st.min_value_num), st.min_value_char) min_spec, NVL(TO_CHAR(st.max_value_num),st.max_value_char) max_spec, NVL(st.report_precision, t.report_precision) precision, t.test_unit, st.target_value_char text_spec, st.text_code, t.text_code, t.test_type, s.spec_name, mln.expiration_date, mln.retest_date, mln.expiration_action_code, '[ ' || decode (nvl(mln.expiration_action_code,'0'),'0','',( select description FROM mtl_actions WHERE action_code = mln.expiration_action_code)) || ' ]' Action, mln.expiration_action_date, GMD_QCR05USR_XMLP_PKG.cf_maxformula(NVL(TO_CHAR(st.max_value_num),st.max_value_char), t.test_type, NVL(st.report_precision, t.report_precision)) CF_max, GMD_QCR05USR_XMLP_PKG.cf_minformula(NVL(TO_CHAR(st.min_value_num), st.min_value_char), t.test_type,NVL(st.report_precision, t.report_precision)) CF_min, GMD_QCR05USR_XMLP_PKG.cf_targetformula(st.target_value_num, t.test_type, NVL(st.report_precision, t.report_precision)) CF_target FROM GMD_SPECIFICATIONS_B s, GMD_SPEC_TESTS_B st, GMD_INVENTORY_SPEC_VRS si, GMD_QC_TESTS_B t, MTL_SYSTEM_ITEMS_KFV msi, MTL_LOT_NUMBERS mln, MTL_SECONDARY_INVENTORIES sub, MTL_ITEM_LOCATIONS_KFV loc, MTL_MATERIAL_STATUSES stat, MTL_ONHAND_QUANTITIES_DETAIL moqd WHERE moqd.organization_id = msi.organization_id AND moqd.inventory_item_id = msi.inventory_item_id AND moqd.organization_id = mln.organization_id AND moqd.inventory_item_id = mln.inventory_item_id AND moqd.lot_number = mln.lot_number AND moqd.organization_id = sub.organization_id AND moqd.subinventory_code = sub.secondary_inventory_name AND moqd.organization_id = loc.organization_id AND moqd.locator_id = loc.inventory_location_id AND mln.status_id (+) = stat.status_id AND s.spec_id = st.spec_id AND s.spec_id = si.spec_id AND st.test_id = t.test_id AND t.delete_mark = 0 AND s.delete_mark = 0 AND moqd.primary_transaction_quantity > 0 AND si.spec_vr_id = GMD_SPEC_MATCH_GRP.GET_INV_SPEC_OR_VR_ID( moqd.inventory_item_id ,NULL ,mln.grade_code ,moqd.organization_id ,moqd.subinventory_code , NULL ,moqd.lot_number ,moqd.locator_id ,SYSDATE ,'N' ,NULL ,'SPECVRID' ) &ExpiredCF &Retest_ReqCF &Future_ExpiryCF &FutureRetestCF &Exclusive_TestsCF &lot_statusCF &SubinventoryCF ORDER BY item_no, lotno, Subinventory, location1, assay_code GMD QCR05USR_XML AR GMD تقرير تحليل الصنف/الموقع المطلوب (بتنسيق XML) Imported from BI Publisher Description: تقرير التحليل المطلوب لموقع/صنف مراقبة جودة OPM Application: تطوير منتجات التصنيع التشغيلي Source: تقرير تحليل الصنف/الموقع المطلوب (بتنسيق XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG D GMD Artikel/Lagerplatz - Erforderliche Analyse Imported from BI Publisher Description: Auswertung "Artikel/Lagerplatz - Erforderliche Analyse" in OPM Qualitätskontrolle Application: Process Manufacturing Produktentwicklung Source: Artikel/Lagerplatz - Erforderliche Analyse (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG E GMD Análisis Necesario de Artículo/Ubicación Imported from BI Publisher Description: Informe Análisis de Especificaciones Necesarias de Artículo/Ubicación de OPM QC Application: Process Manufacturing Product Development Source: Análisis Necesario de Artículo/Ubicación (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG F GMD Article/lieu à analyser Imported from BI Publisher Description: Etat Article/lieu à analyser d'OPM QC Application: Process Manufacturing Product Development Source: Article/lieu à analyser (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG I GMD Rapporto Analisi articolo/ubicazione necessaria Imported from BI Publisher Description: Rapporto Analisi obbligatoria articolo/ubicazione (GMQ) Application: Process Manufacturing Product Development Source: Rapporto Analisi articolo/ubicazione necessaria (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG JA GMD 品目/保管場所所要分析レポート Imported from BI Publisher Description: OPM QC品目/保管場所所要分析レポート Application: Process Manufacturing Product Development Source: 品目/保管場所所要分析レポート(XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG KO GMD 품목/위치 필수 분석 보고서 Imported from BI Publisher Description: OPM QC 관리 요구 품목/위치 분석 보고서 Application: Process Manufacturing Product Development Source: 품목/위치 필수 분석 보고서(XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG PTB GMD Relatório de Análise Requerido do Item/Local Imported from BI Publisher Description: Relatório de Análise de Item/Local Necessário de CQ do OPM Application: Process Manufacturing Product Development Source: Relatório de Análise Requerido do Item/Local (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG RU GMD Отчет о необходимости проверки по позиции/расположению Imported from BI Publisher Description: Отчет о необходимости проверки по позиции/расположению КК УНП Application: Разработка продукции УНП Source: Отчет о необходимости проверки по позиции/расположению (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG S GMD Tillsynsrapport över artikel/plats Imported from BI Publisher Description: Obligatorisk analys av artikel/plats - rapport i OPM GMQ Application: Process Manufacturing Product Development Source: Tillsynsrapport över artikel/plats (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG TR GMD Kalem/Depo Adresi Gerekli Analiz Raporu Imported from BI Publisher Description: OPM Kal. Kont. Gerekli Kalem/Depo Adresi Analiz Raporu Application: Üretim Prosesi Ürün Geliştirme Source: Kalem/Depo Adresi Gerekli Analiz Raporu (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG US GMD Item/Location Required Analysis Imported from BI Publisher Description: Item/Location Required Analysis Report of OPM QC Application: Process Manufacturing Product Development Source: Item/Location Required Analysis Report (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG ZHS GMD 要求项目/地点的分析报表 Imported from BI Publisher Description: OPM QC 的要求物料/地点分析报表 Application: OPM 产品开发管理系统 Source: 要求项目/地点的分析报表 (XML) Short Name: QCR05USR_XML DB package: GMD_QCR05USR_XMLP_PKG BI Publisher &exclusive_testscf &expiredcf &future_expirycf &futureretestcf &lot_statuscf &retest_reqcf &subinventorycf :exclusive_test :exclusive_testscp :exclusive_within :expired_items :expiredcp :expiry_within :from_lotstatus :from_lotstatuscp :from_subinventory :from_subinventorycp :from_whse :future_expire :future_expirycp :future_retest :futureretestcp :nonblocksql :orgcp :p_conc_request_id :p_organization_id :retest_items :retest_reqcp :retest_within :sy_all :to_lotstatus :to_lotstatuscp :to_subinventory :to_subinventorycp :to_whse 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_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 起始子库存 起始子库存 4 30 :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 终止子库存 终止子库存 5 40 :from_lotstatus LOV Oracle STATUS_LIST2 Y select status_code id, status_code value, description description from mtl_material_statuses order by status_code AR من الموقف من الموقف D Von Status Von Status E De Estado De Estado F Statut - De Statut - De I Stato - Da Stato - Da JA ステータス:自 ステータス:自 KO 상태: 부터 상태: 부터 PTB Status - De Status - De RU Статус с Статус с S Från status Från status TR İlk Statü İlk Statü US From Status From Status ZHS 起始状态 起始状态 6 50 :to_lotstatus LOV Oracle STATUS_LIST2 Y select status_code id, status_code value, description description from mtl_material_statuses order by status_code AR إلى الموقف إلى الموقف D Neuer Status Neuer Status E A Estado A Estado F Statut d'arrivée Statut d'arrivée I Stato - A Stato - A JA ステータス:至 ステータス:至 KO 상태: 까지 상태: 까지 PTB Status - Até Status - Até RU Статус по Статус по S Till status Till status TR Son Statü Son Statü US To Status To Status ZHS 终止状态 终止状态 7 60 :expired_items LOV Oracle EXPIRED_ITEM_LIST Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108379 order by ffvv.flex_value AR أصناف منتهية الصلاحية أصناف منتهية الصلاحية D Verfallene Artikel Verfallene Artikel E Artículos Vencidos Artículos Vencidos F Articles périmés Articles périmés I Articoli scaduti Articoli scaduti JA 失効済品目 失効済品目 KO 폐기된 품목 폐기된 품목 PTB Itens Expirados Itens Expirados RU Позиции с истекшим сроком годности Позиции с истекшим сроком годности S Utgångna artiklar Utgångna artiklar TR Geçerliliği Biten Kalemler Geçerliliği Biten Kalemler US Expired Items Expired Items ZHS 到期物料 到期物料 8 70 :retest_items LOV Oracle RETEST_ITEM_LIST Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108403 order by ffvv.flex_value AR إعادة اختبار الأصناف إعادة اختبار الأصناف D Artikel neu testen Artikel neu testen E Volver a Probar Artículos Volver a Probar Artículos F Tester les articles Tester les articles I Articoli nuovo test Articoli nuovo test JA 再テスト品目 再テスト品目 KO 재검사 품목 재검사 품목 PTB Itens do Novo Teste Itens do Novo Teste RU Позиции для повторной проверки Позиции для повторной проверки S Omtestn.artiklar Omtestn.artiklar TR Kalemleri Yeniden Test Et Kalemleri Yeniden Test Et US Retest Items Retest Items ZHS 重测物料 重测物料 9 80 :future_expire LOV Oracle FUTURE_EXPIRE_LIST Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108380 order by ffvv.flex_value AR انتهاء آجل انتهاء آجل D Zukünftiges Verfallsdatum Zukünftiges Verfallsdatum E Vencimiento Futuro Vencimiento Futuro F Péremption future Péremption future I Scadenza futura Scadenza futura JA 将来失効 将来失効 KO 미래 폐기 미래 폐기 PTB Expiração Futura Expiração Futura RU Срок годности ограничен Срок годности ограничен S Framt. utgångsdatum Framt. utgångsdatum TR Geçerliliği Gelecekte Bitecek Geçerliliği Gelecekte Bitecek US Future Expire Future Expire ZHS 将来到期 将来到期 10 90 :expiry_within Number AR منتهي الصلاحية في منتهي الصلاحية في D Innerhalb (Tage) Innerhalb (Tage) E Vence Dentro de Vence Dentro de F Péremption avant le Péremption avant le I Scadenza entro Scadenza entro JA 失効内 失効内 KO 만료 이내 만료 이내 PTB Expirar em Expirar em RU Срок годности Срок годности S Går ut inom Går ut inom TR Geçerlilik Sonu Aralığı Geçerlilik Sonu Aralığı US Expire Within Expire Within ZHS 到期范围 到期范围 11 100 :future_retest LOV Oracle FUTURE_RETEST_LIST Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108382 order by ffvv.flex_value AR إعادة اختبار آجل إعادة اختبار آجل D Zukünftiger Neutest Zukünftiger Neutest E Nueva Prueba Futura Nueva Prueba Futura F Test futur Test futur I Nuovo test futuro Nuovo test futuro JA 将来再テスト 将来再テスト KO 미래 재검사 미래 재검사 PTB Novo Teste Futuro Novo Teste Futuro RU Требуется повторная проверка Требуется повторная проверка S Framt. omtest Framt. omtest TR Gelecekte Yeniden Test Edilecek Gelecekte Yeniden Test Edilecek US Future Retest Future Retest ZHS 将来重测 将来重测 12 110 :retest_within Number AR إعادة الاختبار في إعادة الاختبار في D Innerhalb (Tage) 2 Innerhalb (Tage) E Marco para Nueva Prueba Marco para Nueva Prueba F Tester avant le Tester avant le I Nuovo test entro Nuovo test entro JA 再テスト内 再テスト内 KO 재검사 대상 기간 재검사 대상 기간 PTB Novo Teste em Novo Teste em RU Срок повторной проверки Срок повторной проверки S Omtesta inom Omtesta inom TR Yeniden Test Aralığı Yeniden Test Aralığı US Retest Within Retest Within ZHS 重测范围 重测范围 13 120 :exclusive_test LOV Oracle EXCLUSIVE_TEST_LIST Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=108384 order by ffvv.flex_value AR اختبار استثنائي اختبار استثنائي D Vom Test ausschließen Vom Test ausschließen E Prueba de Exclusión Prueba de Exclusión F Test exclusif Test exclusif I Test esclusivo Test esclusivo JA 排他テスト 排他テスト KO 배제 검사 배제 검사 PTB Teste Exclusivo Teste Exclusivo RU Выборочная проверка Выборочная проверка S Exkluderingstest Exkluderingstest TR Özel Test Özel Test US Exclusive Test Exclusive Test ZHS 不测试 不测试 14 130 :exclusive_within Number AR مقصور على مقصور على D Ausschließen innerhalb (Tage) Ausschließen innerhalb (Tage) E Exclusivo En Exclusivo En F Exclusif jusqu'au Exclusif jusqu'au I Esclusivo entro Esclusivo entro JA 排他内 排他内 KO 배제 대상 기간 배제 대상 기간 PTB Exclusivo em Exclusivo em RU Срок выборочной проверки Срок выборочной проверки S Exkluderas inom Exkluderas inom TR Özel Aralığı Özel Aralığı US Exclusive Within Exclusive Within ZHS 不测试范围 不测试范围