ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4701551A9E05362FB09050512 SELECT msn.serial_number serial_number, &P_ITEM_FLEXDATA item_flexdata, msn.inventory_item_id item_id, msi.description item_desc, msn.revision item_rev, msn.lot_number lot_number, pov.vendor_name vendor_name, msn.vendor_serial_number vendor_serial_num, msn.vendor_lot_number vendor_lot, msn.initialization_date create_date, msn.completion_date assign_date, msn.ship_date ship_date, msn.current_status curr_stat, mlu.meaning curr_stat_name, msn.current_subinventory_code curr_subinv, msn.current_locator_id curr_loc_id, &P_LOC_FLEXDATA loc_flexdata, msn.descriptive_text comments, DECODE (msn.last_txn_source_type_id, 1,poh.segment1, 2,null, 3,null, 5,wip.wip_entity_name, 6,null, 7,porh.segment1, 8,&P_MKTS_FLEXDATA, 9,cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,&P_MKTS_FLEXDATA, 13,msn.last_txn_source_name, msn.last_txn_source_name) txn_source_data, mtst.transaction_source_type_name txn_src_type_name, msn.last_txn_source_type_id txn_source_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_value, DECODE(msn.current_locator_id,null,'',fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_value', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE')) C_loc_value, DECODE(mkts.sales_order_id,null,'',fnd_flex_xml_publisher_apis.process_kff_combination_1('c_txn_source_value', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE')) C_txn_source_value FROM MTL_SERIAL_NUMBERS msn, MTL_SYSTEM_ITEMS msi, MFG_LOOKUPS mlu, MTL_TXN_SOURCE_TYPES mtst, PO_VENDORS pov, MTL_ITEM_LOCATIONS mil, PO_HEADERS_ALL poh, MTL_SALES_ORDERS mkts, GL_CODE_COMBINATIONS glcc, WIP_ENTITIES wip, MTL_GENERIC_DISPOSITIONS mdsp, CST_COST_UPDATES cupd, MTL_CYCLE_COUNT_HEADERS cch, MTL_PHYSICAL_INVENTORIES mpi, PO_REQUISITION_HEADERS_ALL porh WHERE msn.last_txn_source_type_id = mtst.transaction_source_type_id (+) and mlu.lookup_type = 'SERIAL_NUM_STATUS' and mlu.lookup_code = msn.current_status and msn.current_organization_id = mil.organization_id (+) and msn.current_locator_id = mil.inventory_location_id (+) and &P_ITEM_WHERE and msn.inventory_item_id = msi.inventory_item_id and msn.current_organization_id = msi.organization_id and msn.original_unit_vendor_id = pov.vendor_id (+) &C_SERIAL_WHERE &C_VENDOR_WHERE &C_VEND_SERIAL_WHERE &C_UNIT_STATUS_WHERE &C_SOURCE_TYPE_WHERE and msn.current_organization_id = :P_ORG and ( msn.last_txn_source_id = poh.po_header_id (+) and msn.last_txn_source_id = mkts.sales_order_id (+) and msn.last_txn_source_id = glcc.code_combination_id (+) and msn.last_txn_source_id = wip.wip_entity_id (+) and msn.current_organization_id = wip.organization_id (+) and msn.last_txn_source_id = mdsp.disposition_id (+) and msn.last_txn_source_id = porh.requisition_header_id (+) and msn.last_txn_source_id = cch.cycle_count_header_id (+) and msn.current_organization_id = cch.organization_id (+) and msn.last_txn_source_id = mpi.physical_inventory_id (+) and msn.current_organization_id = mpi.organization_id (+) and msn.last_txn_source_id = cupd.cost_update_id (+) and msn.current_organization_id = cupd.organization_id (+) ) Order by msn.serial_number, &P_ITEM_ORDER_BY Y INV INVIRSNO_XML Y AR INV تفاصيل الرقم المسلسل (بتنسيق XML) Imported from BI Publisher Description: تفاصيل الرقم المسلسل Application: المخازن Source: تفاصيل الرقم المسلسل (بتنسيق XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG D INV Seriennummern - Details Imported from BI Publisher Description: Seriennummern - Details Application: Lager Source: Seriennummern - Details (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG E INV Detalle de Números de Serie Imported from BI Publisher Description: Detalle de Números de Serie Application: Inventory Source: Detalle de Números de Serie (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG F INV Détail des numéros de série Imported from BI Publisher Description: Détail des numéros de série Application: Inventory Source: Détail des numéros de série (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG I INV Dettaglio numero di serie Imported from BI Publisher Description: Dettaglio numeri di serie Application: Inventory Source: Dettaglio numero di serie (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG JA INV シリアル番号詳細 Imported from BI Publisher Description: シリアル番号詳細 Application: Inventory Source: シリアル番号詳細(XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG KO INV 일련번호 상세내역 Imported from BI Publisher Description: 일련번호 상세내역 Application: Inventory Source: 일련번호 상세내역(XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG PTB INV Detalhe de número de série Imported from BI Publisher Description: Detalhe de número de série Application: Inventário Source: Detalhe de número de série (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG RU INV Сведения о серийном номере Imported from BI Publisher Description: Сведения о серийном номере Application: Запасы Source: Сведения о серийном номере (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG S INV Serienummerdetalj Imported from BI Publisher Description: Serienummer detalj Application: Inventory Source: Serienummerdetalj (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG TR INV Seri numarası detayı Imported from BI Publisher Description: Seri numarası detayı Application: Stok Yönetimi Source: Seri numarası detayı (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG US INV Serial number detail Imported from BI Publisher Description: Serial number detail Application: Inventory Source: Serial number detail (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG ZHS INV 序列号详细信息 Imported from BI Publisher Description: 序列号明细 Application: 库存管理系统 Source: 序列号详细信息 (XML) Short Name: INVIRSNO_XML DB package: INV_INVIRSNO_XMLP_PKG BI Publisher &c_serial_where &c_source_type_where &c_unit_status_where &c_vend_serial_where &c_vendor_where &p_item_flexdata &p_item_order_by &p_item_where &p_loc_flexdata &p_mkts_flexdata :p_conc_request_id :p_gl_flexdata :p_gl_num :p_item_flexdata :p_item_hi :p_item_lo :p_item_num :p_item_order_by :p_item_where :p_loc_flexdata :p_loc_num :p_mdsp_flexdata :p_mdsp_num :p_mkts_flexdata :p_mkts_num :p_optimizer_code :p_org :p_serial_hi :p_serial_lo :p_source_type :p_trace_flag :p_unit_status :p_vend_serial_hi :p_vend_serial_lo :p_vendor_hi :p_vendor_lo 1 -40 :p_org Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 -30 :p_gl_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('mfg_organization_id') Y AR هيكل الأستاذ العام هيكل الأستاذ العام D Rechnungswesenstruktur Rechnungswesenstruktur E Estructura Contable Estructura Contable F Structure GL Structure GL I Struttura GL Struttura GL JA GL体系 GL体系 KO GL 구조 GL 구조 PTB Estrutura GL Estrutura GL RU Структура ГК Структура ГК S RED-struktur RED-struktur TR GL Yapısı GL Yapısı US GL Structure GL Structure ZHS GL 结构 GL 结构 3 -20 :p_sort_id Number 1 Y AR نوع الفرز فرز D Sortierungsart Sortieren E Tipo de Clasificación Ordenar F Type de tri Trier I Tipo di ordinamento Ordina JA ソート・タイプ ソート KO 정렬 유형 정렬 PTB Tipo de Classificação Classificar RU Тип сортировки Сортировка S Sorteringstyp Sortering TR Sıralama Tipi Sırala US Sort Type Sort ZHS 排序类型 排序 4 10 :p_unit_status LOV Oracle INV_SRS_SERIAL_STATUS Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SERIAL_NUM_STATUS' and enabled_flag= 'Y' order by lookup_code AR موقف الوحدة المسلسلة موقف الوحدة D Einheitenstatus nach Serien-Nr. Status Einheit E Estado del Número de Serie Estado de Unidad F Statut unité en série Statut unité I Stato unità con numeri di serie Stato unità JA シリアル管理単位ステータス 単位ステータス KO 일련번호 지정 단위 상태 단위 상태 PTB Status do Item Serializado Status da Unidade RU Статус единицы с серийным номером Статус единицы S Serienummersatt enhet Enhetsstatus TR Serilenmiş Birim Statüsü Birim Statüsü US Serialized Unit Status Unit Status ZHS 系列化单位状态 单位状态 5 20 :p_source_type LOV Oracle INV_SRS_SOURCE_TYPE Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types order by value,description AR نوع المصدر نوع المصدر D Bezugsart Bezugsart E Tipo de Origen Tipo de Origen F Type d'origine Type d'origine I Tipo di origine Tipo di origine JA ソース・タイプ ソース・タイプ KO 출처 유형 출처 유형 PTB Tipo de Origem Tipo de Origem RU Тип источника Тип источника S Källtyp Källtyp TR Kaynak Tipi Kaynak Tipi US Source Type Source Type ZHS 来源类型 来源类型 6 30 :p_serial_lo LOV Oracle INV_SRS_SERIAL_NUMBERS Y select serial_number id, serial_number value, null description from mtl_serial_numbers where current_organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by serial_number AR أرقام مسلسة من رقم مسلسل إلى D Von Seriennummer Bis Seriennummer E De Número de Serie A Número de Serie F Numéro série - De Numéro de série - A I Numeri di serie - Da Numero di serie massimo JA シリアル番号:自 シリアル番号:上位 KO 일련번호: 부터 일련번호 상한 PTB Números de Série - De Número de Série - Superior RU Серийные номера с Серийный номер по S Från serienummer Till serienummer TR Seri Numarası, İlk Seri Numarası Son: US Serial Numbers From Serial Number High ZHS 序列号自 序列号上限 7 40 :p_serial_hi LOV Oracle INV_SRS_SERIAL_NUMBERS Y select serial_number id, serial_number value, null description from mtl_serial_numbers where current_organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by serial_number AR إلى رقم مسلسل إلى D Bis Bis Seriennummer E A A Número de Serie F A Numéro de série - A I A Numero di serie massimo JA 至 シリアル番号:上位 KO 까지 일련번호 상한 PTB Até Número de Série - Superior RU По Серийный номер по S Till Till serienummer TR Son Seri Numarası Son: US To Serial Number High ZHS 至 序列号上限 8 50 :p_item_lo Char AR الأصناف من صنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Article - De I Articoli - Da Articolo - Minimo JA 品目:自 品目:下位 KO 품목: 부터 품목 하한 PTB Itens - De Item Inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem Alt Değeri US Items From Item Low ZHS 物料自 物料下限 9 60 :p_item_hi Char AR إلى 2 صنف إلى D Bis 2 Bis Artikel E A 2 A Artículo F A 2 Article - A I A 2 Articolo - Massimo JA 至 2 品目:上位 KO 까지 2 품목 상한 PTB Até 2 Item Superior RU По 2 Позиция по S Till 2 Till artikel TR Son 2 Kalem Üst Değeri US To 2 Item High ZHS 至 2 物料上限 10 70 :p_vendor_lo LOV Oracle INV_SRS_PO_VENDOR Y select vendor_id id, vendor_name value, null description from po_vendors where 1=1 order by value,description AR الموردون من مورد من D Von Lieferant Von Lieferant E De Proveedor De Proveedor F Fournisseurs - De Fournisseur - De I Fornitori - Da Fornitore - Da JA 仕入先:自 仕入先:下位 KO 공급자: 부터 공급자 하한 PTB Fornecedores - De Fornecedor - Inferior RU Поставщики с Поставщик с S Från leverantörer Leverantörer från TR Tedarikçiler: İlk Tedarikçi İlk: US Vendors From Vendor Low ZHS 供应商自 供应商下限 11 80 :p_vendor_hi LOV Oracle INV_SRS_PO_VENDOR Y select vendor_id id, vendor_name value, null description from po_vendors where 1=1 order by value,description AR إلى 3 مورد إلى D Bis 3 Von Lieferant E A 3 A Proveedor F A 3 Fournisseur - A I A 3 Fornitore - A JA 至 3 仕入先:上位 KO 까지 3 공급자 상한 PTB Até 3 Fornecedor - Superior RU По 3 Поставщик по S Till 3 Leverantör till TR Son 3 Tedarikçi Son: US To 3 Vendor High ZHS 至 3 供应商上限 12 90 :p_vend_serial_lo LOV Oracle INV_SRS_VEND_SERIAL_NUM Y select vendor_serial_number id, vendor_serial_number value, null description from mtl_serial_numbers where current_organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description AR أرقام المورد المسلسلة من رقم مسلسل مورد من D Von Serien-Nr. Lieferant Von Seriennummer Lieferant E De Número de Serie de Proveedor De Número de Serie de Proveedor F Num. série fourn. - De Numéro série fournisseur - De I Numeri di serie fornitore da Numero di serie fornitore - Da JA 仕入先シリアル番号:自 仕入先シリアル番号:下位 KO 공급자 일련번호: 부터 공급자 일련번호 하한 PTB Números Série Fornecedor - De Número de Série do Fornecedor - Inferior RU Серийные номера поставщика с Серийный номер поставщика с S Leverantörsserienummer från Leverantörsserienummer från TR Tedarikçi Seri Numarası: İlk Tedarikçi Seri Numarası İlk: US Vendor Serial Numbers From Vendor Serial Number Low ZHS 供应商序列号自 供应商序列号下限 13 100 :p_vend_serial_hi LOV Oracle INV_SRS_VEND_SERIAL_NUM Y select vendor_serial_number id, vendor_serial_number value, null description from mtl_serial_numbers where current_organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description AR إلى 4 رقم مسلسل مورد إلى D Bis 4 Bis Seriennummer Lieferant E A 4 A Número de Serie de Proveedor F A 4 Numéro série fournisseur - A I A 4 Numero di serie fornitore - A JA 至 4 仕入先シリアル番号:上位 KO 까지 4 공급자 일련번호 상한 PTB Até 4 Número de Série do Fornecedor - Superior RU По 4 Серийный номер поставщика по S Till 4 Leverantörsserienummer till TR Son 4 Tedraikçi Seri Numarası Son: US To 4 Vendor Serial Number High ZHS 至 4 供应商序列号上限