ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702E51A9E05362FB09050512 with q_body as ( select msi.inventory_item_id break_item_id, msi.description break_item_desc, mtln.transaction_date txn_date, mtln.lot_number lot_number, mmt.vendor_lot_number vend_lot, mmt.revision rev, mtxt.transaction_type_name txn_type_name, mtln.transaction_source_id txn_source_id, decode(mtln.transaction_source_type_id, 1, poh.segment1, 2, null, 3, null, 5, wipe.wip_entity_name, 6, null, 7, porh.segment1, 8, mkts.concatenated_segments, 9, cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,mkts.concatenated_segments, mtln.transaction_source_name ) txn_source_data, mmt.subinventory_code subinv, sum(decode(:p_rpt_uom, 1, round(nvl(mtln.transaction_quantity,0),:p_qty_precision), 2, round(nvl(mtln.primary_quantity,0),:p_qty_precision), round(nvl(mtln.transaction_quantity,0),:p_qty_precision) ) ) rpt_qty, decode (:p_rpt_uom, 1,mmt.transaction_uom, 2,msi.primary_uom_code, mmt.transaction_uom) uom, sum(round((round(nvl(mmt.actual_cost,0),:c_ext_precision) * round(nvl(mtln.primary_quantity,0),:p_qty_precision)),:c_std_precision)) extd_cost, mcat.category_id catg_id, mtln.transaction_id txn_id, mmt.transaction_set_id txn_set_id, mtln.created_by txn_create_by1, fndu.user_name txn_user_name, trunc(mtln.creation_date) txn_create_dt, mmt.transaction_reference txn_ref, mtr.reason_name reason_name, mmt.locator_id locator_id, mtln.transaction_source_type_id txn_src_type_id, sum(round(nvl(mtln.secondary_transaction_quantity,0), :p_qty_precision)) sec_qty, msi.secondary_uom_code, mtln.grade_code, msi.concatenated_segments c_break_item_value, decode(mtln.transaction_source_type_id, 2, mkts.concatenated_segments, 3, glcc.concatenated_segments, 6, mdsp.concatenated_segments, 8, mkts.concatenated_segments, 12,mkts.concatenated_segments, decode(mtln.transaction_source_type_id, 1, poh.segment1, 2, null, 3, null, 5, wipe.wip_entity_name, 6, null, 7, porh.segment1, 8, mkts.concatenated_segments, 9, cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,mkts.concatenated_segments, mtln.transaction_source_name ) ) c_txn_src_value, inv_invtrlnt_xmlp_pkg.c_secondary_uomformula(msi.inventory_item_id, sum(round(nvl(mtln.secondary_transaction_quantity,0),:p_qty_precision)), msi.secondary_uom_code) c_secondary_uom, inv_invtrlnt_xmlp_pkg.calc_unit_cost (sum(decode(:p_rpt_uom, 1, round(nvl(mtln.transaction_quantity,0),:p_qty_precision), 2, round(nvl(mtln.primary_quantity,0),:p_qty_precision), round(nvl(mtln.transaction_quantity,0),:p_qty_precision) ) ), sum(round((round(nvl(mmt.actual_cost,0),:c_ext_precision) * round(nvl(mtln.primary_quantity,0),:p_qty_precision)),:c_std_precision)), :c_ext_precision ) c_unit_cost, mil.concatenated_segments c_locator_value, mcat.concatenated_segments c_catg_value, inv_invtrlnt_xmlp_pkg.cp_sec_qty_p cp_sec_qty from mtl_transaction_lot_numbers mtln, mtl_system_items_vl msi, mtl_material_transactions mmt, mtl_transaction_types mtxt, mtl_transaction_reasons mtr, mtl_item_categories micat, mtl_item_locations_kfv mil, mtl_categories_kfv mcat, fnd_user fndu, po_headers_all poh, mtl_sales_orders_kfv mkts, gl_code_combinations_kfv glcc, wip_entities wipe, mtl_generic_dispositions_kfv mdsp, cst_cost_updates cupd, mtl_cycle_count_headers cch, mtl_physical_inventories mpi, po_requisition_headers_all porh where 1=1 and mmt.reason_id = mtr.reason_id (+) and mtln.created_by = fndu.user_id (+) and mmt.transaction_type_id = mtxt.transaction_type_id (+) and mmt.locator_id = mil.inventory_location_id (+) and mmt.organization_id = mil.organization_id(+) and mtln.transaction_source_type_id != 11 and mtln.transaction_source_id = poh.po_header_id (+) and mtln.transaction_source_id = mkts.sales_order_id (+) and mtln.transaction_source_id = glcc.code_combination_id (+) and mtln.transaction_source_id = wipe.wip_entity_id (+) and mtln.organization_id = wipe.organization_id (+) and mtln.transaction_source_id = mdsp.disposition_id (+) and mtln.transaction_source_id = porh.requisition_header_id (+) and mtln.transaction_source_id = cch.cycle_count_header_id (+) and mtln.organization_id = cch.organization_id (+) and mtln.transaction_source_id = mpi.physical_inventory_id (+) and mtln.organization_id = mpi.organization_id (+) and mtln.transaction_source_id = cupd.cost_update_id (+) and mtln.organization_id = cupd.organization_id (+) and mtln.inventory_item_id = msi.inventory_item_id and mtln.organization_id = msi.organization_id and micat.category_id = mcat.category_id and mtln.inventory_item_id = micat.inventory_item_id and micat.category_set_id = :p_catg_set_id and mtln.organization_id = micat.organization_id and mtln.transaction_id = mmt.transaction_id and mtln.transaction_date >= :p_txn_date_lo and mtln.transaction_date < :p_txn_date_hi+1 and mtln.organization_id = :p_org group by msi.inventory_item_id, msi.description, mtln.transaction_date, mtln.lot_number, mmt.vendor_lot_number, mmt.revision, mtxt.transaction_type_name, mtln.transaction_source_id, decode(mtln.transaction_source_type_id, 1, poh.segment1, 2, null, 3, null, 5, wipe.wip_entity_name, 6, null, 7, porh.segment1, 8, mkts.concatenated_segments, 9, cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,mkts.concatenated_segments, mtln.transaction_source_name ), mmt.subinventory_code, decode (:p_rpt_uom, 1,mmt.transaction_uom, 2,msi.primary_uom_code, mmt.transaction_uom), mcat.category_id, null, mtln.transaction_id, mmt.transaction_set_id, mtln.created_by, fndu.user_name, trunc(mtln.creation_date), mmt.transaction_reference, mtr.reason_name, mmt.locator_id, mtln.transaction_source_type_id, msi.secondary_uom_code, mtln.grade_code, msi.concatenated_segments, decode(mtln.transaction_source_type_id, 2, mkts.concatenated_segments, 3, glcc.concatenated_segments, 6, mdsp.concatenated_segments, 8, mkts.concatenated_segments, 12,mkts.concatenated_segments, decode(mtln.transaction_source_type_id, 1, poh.segment1, 2, null, 3, null, 5, wipe.wip_entity_name, 6, null, 7, porh.segment1, 8, mkts.concatenated_segments, 9, cch.cycle_count_header_name, 10,mpi.physical_inventory_name, 11,cupd.description, 12,mkts.concatenated_segments, mtln.transaction_source_name ) ), mil.concatenated_segments, mcat.concatenated_segments ), q_serial as ( select mtln.transaction_id mtln_txn_id, mtln.lot_number mtln_lot_number, mut.serial_number serial_number from mtl_transaction_lot_numbers mtln, mtl_unit_transactions mut where mtln.serial_transaction_id = mut.transaction_id(+) and :p_serial_detail = 1 ) -- -- Main Query starts here -- select qb.c_break_item_value item, qb.break_item_desc item_description, qb.lot_number lot_number, qb.vend_lot vendor_lot, qb.txn_date, qb.rev, qb.txn_type_name transaction_type, qb.c_txn_src_value transaction_source, qb.subinv subinventory, case when 1 = row_number() over (partition by qb.break_item_id,qb.lot_number,qb.txn_id order by qs.serial_number) then qb.rpt_qty else null end quantity, case when 1 = row_number() over (partition by qb.break_item_id,qb.lot_number,qb.txn_id order by qs.serial_number) then qb.uom else null end uom, case when 1 = row_number() over (partition by qb.break_item_id,qb.lot_number,qb.txn_id order by qs.serial_number) then qb.cp_sec_qty else null end secondary_quantity, case when 1 = row_number() over (partition by qb.break_item_id,qb.lot_number,qb.txn_id order by qs.serial_number) then qb.c_secondary_uom else null end secondary_uom, case when 1 = row_number() over (partition by qb.break_item_id,qb.lot_number,qb.txn_id order by qs.serial_number) then qb.c_unit_cost else null end unit_cost, case when 1 = row_number() over (partition by qb.break_item_id,qb.lot_number,qb.txn_id order by qs.serial_number) then qb.extd_cost else null end value, -- audit detail qb.txn_set_id, qb.txn_id transaction_number, qb.txn_user_name created_by, qb.txn_create_dt creation_date, -- reason detail qb.txn_ref reference, qb.reason_name reason, -- location detail qb.grade_code grade, qb.c_locator_value locator, -- category (select mcs.category_set_name from mtl_category_sets mcs where mcs.category_set_id = :p_catg_set_id) category_set, qb.c_catg_value category, -- serial_number detail qs.serial_number from q_body qb, q_serial qs where qb.txn_id = qs.mtln_txn_id (+) and qb.lot_number = qs.mtln_lot_number (+) order by qb.c_break_item_value, qb.lot_number, qb.txn_date, qb.txn_id, qs.serial_number Y INV INVTRLNT_XML AR INV مسجل حركة اللوط (بتنسيق XML) Imported from BI Publisher Description: مسجل حركة اللوط Application: المخازن Source: مسجل حركة اللوط (بتنسيق XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG D INV Lostransaktionen - Protokoll Imported from BI Publisher Description: Lostransaktionen - Protokoll Application: Lager Source: Lostransaktionen - Protokoll (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG E INV Registro de Transacciones de Lotes Imported from BI Publisher Description: Registro de Transacciones por Lotes Application: Inventory Source: Registro de Transacciones de Lotes (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG F INV Registre du suivi par lot Imported from BI Publisher Description: Registre du suivi par lot Application: Inventory Source: Registre du suivi par lot (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG I INV Registro transazioni lotto Imported from BI Publisher Description: Registro transazioni lotto Application: Inventory Source: Registro transazioni lotto (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG JA INV ロット取引台帳 Imported from BI Publisher Description: ロット取引台帳 Application: Inventory Source: ロット取引台帳(XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG KO INV 로트 트랜잭션 등록 Imported from BI Publisher Description: 로트 트랜잭션 등록 Application: Inventory Source: 로트 트랜잭션 등록(XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG PTB INV Registro de transação de lote Imported from BI Publisher Description: Registro de transação de lote Application: Inventário Source: Registro de transação de lote (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG RU INV Реестр транзакций с партиями Imported from BI Publisher Description: Реестр транзакций с партиями Application: Запасы Source: Реестр транзакций с партиями (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG S INV Parti - transaktionsregister Imported from BI Publisher Description: Parti - transaktionsregister Application: Inventory Source: Parti - transaktionsregister (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG TR INV Lot hareketi kaydı Imported from BI Publisher Description: Lot hareketi kaydı Application: Stok Yönetimi Source: Lot hareketi kaydı (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG US INV Lot Transaction Register Imported from BI Publisher Description: Lot transaction register Application: Inventory Source: Lot transaction register (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG ZHS INV 批次事务处理登记表 Imported from BI Publisher Description: 批次事务处理登记 Application: 库存管理系统 Source: 批次事务处理登记表 (XML) Short Name: INVTRLNT_XML DB package: INV_INVTRLNT_XMLP_PKG Enginatics R12 only 1=1 :c_ext_precision :c_std_precision :cp_rpt_uom :cp_sec_qty :p_audit_detail :p_break_id :p_category_detail :p_catg_flexdata :p_catg_hi :p_catg_lo :p_catg_order_by :p_catg_set_id :p_catg_struct_num :p_catg_where :p_conc_request_id :p_glcc_flexdata :p_glcc_order_by :p_glcc_struct_num :p_item_flexdata :p_item_hi :p_item_lo :p_item_order_by :p_item_where :p_loc_detail :p_loc_flexdata :p_lot_hi :p_lot_lo :p_mdsp_flexdata :p_mdsp_order_by :p_mkts_flexdata :p_mkts_order_by :p_optimizer_code :p_order_source :p_org :p_qty_precision :p_reason_detail :p_reason_hi :p_reason_lo :p_rpt_qty_type :p_rpt_uom :p_rpt_uom_type :p_serial_detail :p_source_where :p_struct_num :p_subinv_hi :p_subinv_lo :p_trace_flag :p_txn_date_hi :p_txn_date_lo :p_txn_source_hi :p_txn_source_lo :p_txn_source_type_id :p_txn_type_hi :p_txn_type_lo 1 -110 :p_category_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code 1 Y AR تفاصيل الفئة تفاصيل الفئة D Kategoriedetails Kategoriedetails E Detalle de Categoría Detalle de Categoría F Détails catégorie Détails catégorie I Dettagli categoria Dettagli categoria JA カテゴリ詳細 カテゴリ詳細 KO 범주 상세내역 범주 상세내역 PTB Detalhe da Categoria Detalhe da Categoria RU Сведения о категории Сведения о категории S Kategoridetalj Kategoridetalj TR Kategori Detayı Kategori Detayı US Category Detail Category Detail ZHS 类别明细 类别明细 2 -100 :p_loc_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code 1 Y AR تفاصيل الموقع تفاصيل الموقع D Lagerplatzdetails Lagerplatzdetails E Detalle de Ubicación Detalle de Ubicación F Détails lieu Détails lieu I Dettaglio ubicazione Dettaglio ubicazione JA 事業所詳細 事業所詳細 KO 위치 상세내역 위치 상세내역 PTB Detalhe do Local Detalhe do Local RU Сведения о расположении Сведения о расположении S Platsdetalj Platsdetalj TR Yerleşim Detayı Yerleşim Detayı US Location Detail Location Detail ZHS 地点明细 地点明细 3 -90 :p_reason_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code 1 Y AR تفاصيل السبب تفاصيل السبب D Grund-Detail Grund-Detail E Detalle de Motivo Detalle de Motivo F Détails motif Détails motif I Dettaglio motivo Dettaglio motivo JA 事由詳細 事由詳細 KO 사유 상세내역 사유 상세내역 PTB Detalhe do Motivo Detalhe do Motivo RU Сведения об основании Сведения об основании S Orsaksdetalj Orsaksdetalj TR Neden Detayı Neden Detayı US Reason Detail Reason Detail ZHS 原因明细 原因明细 4 -80 :p_audit_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code 1 Y AR تفاصيل التدقيق تفاصيل التدقيق D Protokolldetails Protokolldetails E Detalle de Auditoría Detalle de Auditoría F Détails audit Détails audit I Dettagli audit Dettagli audit JA 監査詳細 監査詳細 KO 감사 상세내역 감사 상세내역 PTB Detalhe da Auditoria Detalhe da Auditoria RU Сведения об аудите Сведения об аудите S Kontrolldetalj Kontrolldetalj TR Denetleme Detayı Denetleme Detayı US Audit Detail Audit Detail ZHS 跟踪明细 跟踪明细 5 -70 :p_break_id Number 3 Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Bazı Sıralama Bazı US Sort By Sort By ZHS 排序依据 排序依据 6 -60 :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 组织 组织 7 -50 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code nvl(fnd_profile.value('REPORT_QUANTITY_PRECISION'),1) Y AR دقة الكمية الدقة D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión F Précision des quantités Précision I Precisione quantità Precisione JA 数量精度 精度 KO 수량 소수점이하 자리수 소수점 이하 자리수 PTB Precisão da Quantidade Precisão RU Точность количества Точность S Kvantitetsprecision Precision TR Miktar Duyarlılığı Duyarlılık US Quantity Precision Precision ZHS 数量精确度 精确度 8 -40 :c_std_precision Number select nvl(fndc.precision,0) from org_organization_definitions ood, gl_sets_of_books gsob, fnd_currencies fndc where ood.organization_id = :$flex$.organization and ood.set_of_books_id = gsob.set_of_books_id and gsob.currency_code = fndc.currency_code US Standard Precision 9 -30 :c_ext_precision Number select nvl(fndc.extended_precision,0) from org_organization_definitions ood, gl_sets_of_books gsob, fnd_currencies fndc where ood.organization_id = :$flex$.organization and ood.set_of_books_id = gsob.set_of_books_id and gsob.currency_code = fndc.currency_code US Extended Precision 10 -20 :p_glcc_struct_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 结构 11 -10 :p_catg_struct_num Number select structure_id from mtl_category_sets where category_set_id = NVL(:$flex$.category_set,NULL) Y AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur E Estructura de Categoría Estructura de Categoría F Structure de catégorie Structure de catégorie I Struttura categoria Struttura categoria JA カテゴリ体系 カテゴリ体系 KO 범주 구조 범주 구조 PTB Estrutura da Categoria Estrutura da Categoria RU Структура категорий Структура категорий S Kategoristruktur Kategoristruktur TR Kategori Yapısı Kategori Yapısı US Category Structure Category Structure ZHS 类别结构 类别结构 12 10 :p_rpt_uom LOV Oracle INV_SRS_REG_UOM Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_REG_UOM' and enabled_flag='Y' order by lookup_code 2 Y AR وحدة القياس وحدة القياس D Maßeinheit Maßeinheit E Unidad de Medida Unidad de Medida F Unité de mesure Unité de mesure I Unità di misura Unità di misura JA 単位 単位 KO UOM UOM PTB Unidade de Medida Unidade de Medida RU ЕИ ЕИ S Måttenhet Måttenhet TR Ölçü Birimi Ölçü Birimi US Unit of Measure Unit of Measure ZHS 单位 单位 13 20 :p_txn_date_lo Date sysdate Y AR تواريخ الحركات من من تاريخ D Von Transaktionsdatum Von Datum E De Fecha de Transacción De Fecha F Dates de mouvement - Du Date - Du I Date transazione - Da Data - Da JA 取引日:自 日付:自 KO 트랜잭션 일자: 부터 일자: 부터 PTB Datas Transação - De Data De RU Даты транзакций с Дата с S Från transaktionsdatum Från datum TR İşlem Tarihleri: İlk Başlangıç Tarihi US Transaction Dates From Date From ZHS 事务处理起始日期 日期自 14 30 :p_txn_date_hi Date last_day(:$flex$.transaction_dates_from) Y AR إلى إلى تاريخ D Bis Bis Datum E A A Fecha F Au Date - Au I A Data - A JA 至 日付:至 KO 까지 일자: 까지 PTB Até Data Até RU По Дата по S Till Till datum TR Son Bitiş Tarihi US Transaction Dates To Date To ZHS 至 日期至 15 40 :p_serial_detail LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code 2 Y AR تفاصيل الرقم المسلسل تفاصيل الرقم المسلسل D Seriennummerndetails Seriennummerndetails E Detalle de Números de Serie Detalle de Números de Serie F Détails numéro série Détails numéro série I Dettaglio numero di serie Dettaglio numero di serie JA シリアル番号詳細 シリアル番号詳細 KO 일련번호 상세내역 일련번호 상세내역 PTB Detalhe de Número de Série Detalhe de Número de Série RU Сведения о серийном номере Сведения о серийном номере S Serienummerdetalj Serienummerdetalj TR Seri Numarası Detayı Seri Numarası Detayı US Serial Number Detail Serial Number Detail ZHS 序列号详细信息 序列号详细信息 16 50 1=1 mtln.lot_number >= :p_lot_lo LOV Oracle INV_SRS_LOT_NUMBER_DISTNT Y select lot_number id, lot_number value, null description from mtl_lot_numbers_srw_v where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by lot_number AR أرقام اللوطات من رقم اللوط من D Von Losnummer Von Losnummer E De Número Lote De Número de Lote F Numéro lot - De Numéro de lot - De I Numeri lotto - Da Numero lotto - Da JA ロット番号:自 ロット番号:自 KO 로트번호: 부터 로트 번호: 부터 PTB Números Lote De Número de Lote - De RU Номера партий с Номер партии с S Från partinummer Partinummer från TR Lot Numaraları, İlk Lot Numarası İlk: US Lot Numbers From Lot Number From ZHS 批号自 批号自 17 60 1=1 mtln.lot_number <= :p_lot_hi LOV Oracle INV_SRS_LOT_NUMBER_DISTNT Y select lot_number id, lot_number value, null description from mtl_lot_numbers_srw_v where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by lot_number AR إلى 2 رقم اللوط إلى D Bis 2 Bis Losnummer E A 2 A Número de Lote F A Numéro de lot - A I A 2 Numero lotto - A JA 至 2 ロット番号:至 KO 까지 2 로트 번호: 까지 PTB Até 2 Número de Lote - Até RU По 2 Номер партии по S Till 2 Partinummer till TR Son 2 Lot Numarası Son: US Lot Numbers To Lot Number To ZHS 至 2 批号至 18 70 1=1 msi.concatenated_segments >= :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 物料自 物料下限 19 80 1=1 msi.concatenated_segments <= :p_item_hi Char AR إلى 3 صنف إلى D Bis 3 Bis Artikel E A 3 A Artículo F A 2 Article - A I A 3 Articolo - Massimo JA 至 3 品目:上位 KO 까지 3 품목 상한 PTB Até 3 Item Superior RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Kalem Üst Değeri US Items To Item High ZHS 至 3 物料上限 20 90 1=1 mtxt.transaction_type_name >= :p_txn_type_lo LOV Oracle INV_SRS_TXN_TYPE_NV Y select transaction_type_name id, transaction_type_name value, description description from mtl_transaction_types order by value,description AR أنواع الحركة من نوع الحركة من D Von Transaktionsart Von Transaktionsart E De Tipo de Transacción De Tipo de Transacción F Type mouvement - De Type de mouvement - De I Tipi di transazione - Da Tipo transazione - Minimo JA 取引タイプ:自 取引タイプ:自 KO 트랜잭션 유형: 부터 트랜잭션 유형 하한 PTB Tipos de Transação - De Tipo de Transação - Inferior RU Типы транзакций с Тип транзакции с S Transaktionstyper från Från transaktionstyp TR İşlem Tipleri: İlk İşlem Tipi Alt Değeri US Transaction Types From Transaction Type Low ZHS 事务处理类型自 事务处理类型下限 21 100 1=1 mtxt.transaction_type_name <= :p_txn_type_hi LOV Oracle INV_SRS_TXN_TYPE_NV Y select transaction_type_name id, transaction_type_name value, description description from mtl_transaction_types order by value,description AR إلى 4 نوع الحركة إلى D Bis 4 Bis Transaktionsart E A 4 A Tipo de Transacción F A 3 Type de mouvement - A I A 4 Tipo transazione - Massimo JA 至 4 取引タイプ:至 KO 까지 4 트랜잭션 유형 상한 PTB Até 4 Tipo de Transação - Superior RU По 4 Тип транзакции по S Till 4 Till transaktionstyp TR Son 4 İşlem Tipi Üst Değeri US Transaction Types To Transaction Type High ZHS 至 4 事务处理类型上限 22 110 1=1 mtr.reason_name >= :p_reason_lo LOV Oracle INV_SRS_TXN_REASON Y select reason_name id, reason_name value, description description from mtl_transaction_reasons order by value,description AR أسباب الحركة من سبب حركة من D Von Transaktionsgrund Von Transaktionsgrund E De Motivo de Transacción De Motivo de Transacción F Motif mouvement - De Motif mouvement - De I Motivi transazione da Motivo transazione - Da JA 取引事由:自 取引事由:下位 KO 트랜잭션 사유: 부터 트랜잭션 사유 하한 PTB Motivos da Transação - De Motivo da Transação - Inferior RU Основания транзакций с Основание транзакции с S Transaktionsorsaker från Transaktionsorsak från TR İşlem Nedenleri: İlk İşlem Nedeni İlk: US Transaction Reasons From Transaction Reason Low ZHS 事务处理原因自 事务处理原因下限 23 120 1=1 mtr.reason_name <= :p_reason_hi LOV Oracle INV_SRS_TXN_REASON Y select reason_name id, reason_name value, description description from mtl_transaction_reasons order by value,description AR إلى 5 سبب حركة إلى D Bis 5 Bis Transaktionsgrund E A 5 A Motivo de Transacción F A 4 Motif mouvement - A I A 5 Motivo transazione - A JA 至 5 取引事由:上位 KO 까지 5 트랜잭션 사유 상한 PTB Até 5 Motivo da Transação - Superior RU По 5 Основание транзакции по S Till 5 Transaktionsorsak till TR Son 5 İşlem Nedeni Son: US Transaction Reasons To Transaction Reason High ZHS 至 5 事务处理原因上限 24 130 1=1 mmt.subinventory_code >= :p_subinv_lo LOV Oracle INV_SRS_SUBINV Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR المخازن من مخزن من D Von Lager Von Lager E De Subalmacén De Subalmacén F Magasins - De Magasin - De I Sottomagazzini - Da Sottomagazzino - Da JA 保管場所:自 保管場所:下位 KO 창고: 부터 창고 하한 PTB Subinventários - De Subinventário - Inferior RU Складские подразделения с Складское подразделение с S Från lagerställen Från lagerställe TR Stok Yerleri, İlk Stok Yeri İlk: US Subinventories From Subinventory Low ZHS 子库存自 子库存下限 25 140 1=1 mmt.subinventory_code <= :p_subinv_hi LOV Oracle INV_SRS_SUBINV Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR إلى 6 مخزن إلى D Bis 6 Bis Lager E A 6 A Subalmacén F A 5 Magasin - A I A 6 Sottomagazzino - A JA 至 6 保管場所:上位 KO 까지 6 창고 상한 PTB Até 6 Subinventário - Superior RU По 6 Складское подразделение по S Till 6 Till lagerställe TR Son 6 Stok Yeri Son: US Subinventories To Subinventory High ZHS 至 6 子库存上限 26 150 :p_catg_set_id LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description select mdsv.category_set_id from mtl_default_sets_view mdsv where mdsv.functional_area_id=1 Y AR مجموعة الفئات مجموعة الفئات D KategorieSet KategorieSet E Juego de Categorías Juego de Categorías F Jeu de catégories Jeu de catégories I Serie di categorie Serie di categorie JA カテゴリ・セット カテゴリ・セット KO 범주 세트 범주 세트 PTB Conj. Categorias Conj. Categorias RU Набор катег. Набор катег. S Kategoriuppsättning Kategoriuppsättning TR Kategori Kümesi Kategori Kümesi US Category Set Category Set ZHS 类别集 类别集 27 160 1=1 mcat.concatenated_segments >= :p_catg_lo Char AR الفئات من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégorie - De I Categorie - Da Categoria (min) JA カテゴリ:自 カテゴリ:下位 KO 범주: 부터 범주 하한 PTB Categorias - De Categoria - Inferior RU Категории с Категория с S Från kategorier Från kategori TR Kategoriler - İlk Kategori Alt Değeri US Categories From Category Low ZHS 类别自 类别下限 28 170 1=1 mcat.concatenated_segments <= :p_catg_hi Char AR إلى 7 الفئة إلى D Bis 7 Bis Kategorie E A 7 Categoría Superior F A 6 Catégorie - A I A 7 Categoria (max) JA 至 7 カテゴリ:上位 KO 까지 7 범주 상한 PTB Até 7 Categoria - Superior RU По 7 Категория по S Till 7 Till kategori TR Son 7 Kategori Üst Değeri US Categories To Category High ZHS 至 7 类别上限 29 180 :p_txn_source_type_id LOV Oracle INV_SRS_SOURCE_TYPE_NC Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types where transaction_source_type_id!=11 order by transaction_source_type_name 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 来源类型 来源类型 30 1=1 mtln.transaction_source_type_id = to_char(:p_txn_source_type_id) US Source Type 31 190 :p_txn_source_lo Char AR مصادر الحركة من مصدر من D Von Transaktionsherkunft Von Herkunft E De Origen de Transacción De Origen F Origine mouvement - De Origine - De I Origini transazione da Origine - Da JA 取引ソース:自 ソース:下位 KO 트랜잭션 출처: 부터 출처 하한 PTB Origens da Transação - De Origem - Inferior RU Источники транзакций с Источник с S Transaktionskällor från Källor från TR İşlem Kaynakları: İlk İlk Kaynak US Transaction Sources From Source Low ZHS 事务处理来源自 来源下限 32 200 :p_txn_source_hi Char AR إلى 8 مصدر إلى D Bis 8 Bis Herkunft E A 8 A Origen F A 7 Origine - A I A 8 Origine - A JA 至 8 ソース:上位 KO 까지 8 출처 상한 PTB Até 8 Origem - Superior RU По 8 Источник по S Till 8 Källor till TR Son 8 Son Kaynak US Transaction Sources To Source High ZHS 至 8 来源上限 :$flex$.category_set Category Set Category Structure :$flex$.organization Organization Extended Precision :$flex$.organization Organization Standard Precision :$flex$.transaction_dates_from Transaction Dates From Y Transaction Dates To Default SYSADMIN 25 CATEGORY 24 CATEGORY_SET 18 CREATED_BY 19 CREATION_DATE 22 GRADE 1 ITEM 2 ITEM_DESCRIPTION 23 LOCATOR 3 LOT_NUMBER 10 QUANTITY 21 REASON 20 REFERENCE 6 REV 12 SECONDARY_QUANTITY 13 SECONDARY_UOM 26 SERIAL_NUMBER 9 SUBINVENTORY 17 TRANSACTION_NUMBER 8 TRANSACTION_SOURCE 7 TRANSACTION_TYPE 5 TXN_DATE 16 TXN_SET_ID 14 UNIT_COST 11 UOM 15 VALUE 4 VENDOR_LOT INV Lot Transaction Register - Default Template.xlsx US UEsDBBQAAAAIAGBhllyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAGBhlly1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAGBhllwWzEZxpgEAAHADAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TTW/bMAyG7wP2HwzdG7nNUAyBrGJoN3RAtwWLm505mY6FypIhMkGyXz/ZRhJn7Wk3funVQ1JSd/vWZTuMZIMvxPUsFxl6EyrrN4V4Lr9cfRQZMfgKXPBYiAOSuNPv36llDB1GtkhZkvBUiIa5W0hJpsEWaJbSPmXqEFvg5MaNDHVtDT4Es23Rs7zJ81uJe0ZfYXXVnQTFqLjY8f+KVsH0fLQuD10C1qoMDK60LepcybOjPnWdswY4da+/WRMDhZqzz3uDTslpUiXqFZpttHzoNaauWhlweJ8u1DU4QiXPAfWI0A9zCTaSVjte7NBwiBnZP2mcNyL7DYQ9ZiF2EC14Trh92egMtuuIo/4V4gs1iExKnoKDOa2d2vaDng8FybgsHE4NIClxiVhadkg/6iVEfoN4PiUewEbekfHr93X2FDgrI3gC0881+4kbS4xxSn0+wNgOJ1bbtoV4eLMooUCLSeJ158ce/qF+sv6FnrsyPADjcSuXQbVqIGKVFnna2imgHtNCoutF7hvwG6yONa8T/Rtajx9IX9/O8nmensckpuT5q+i/UEsDBBQAAAAIAGBhllxMtXi0NQEAAFECAAARAAAAZG9jUHJvcHMvY29yZS54bWyNks1qwzAQhO+FvoPR3ZbkpD8I24G25NRAoSkpvQlpk4haspDUOnn7ynbiJJBDj7sz+2l2UTHb6Tr5BedVY0pEM4ISMKKRymxK9LGcp48o8YEbyevGQIn24NGsur0phGWicfDmGgsuKPBJJBnPhC3RNgTLMPZiC5r7LDpMFNeN0zzE0m2w5eKbbwDnhNxjDYFLHjjugKkdieiAlGJE2h9X9wApMNSgwQSPaUbxyRvAaX91oFfOnFqFvY07HeKes6UYxNG982o0tm2btZM+RsxP8efi9b1fNVWmu5UAVBVSMOGAh8ZVRUx7KuLhau7DIt54rUA+7aN+pSdFH3eYA5nEAGyIe1RWk+eX5RxVOcmnKblLyWRJKCMPLJ9+dU9ezHeBhoY+PPxvYk4ZpWfEI2DIffkJqj9QSwMEFAAAAAgAYGGWXE1B1tIaAQAAewQAABoAAAB4bC9fcmVscy93b3JrYm9vay54bWwucmVsc72UwUrEMBCG74LvEOZu03Z1Fdl0Dy7CXnV9gNBO27BtEjJxtW9vrNBaWOoeipfAzCT//zHMZLP9bBt2QkfKaAFJFANDnZtC6UrA2+H55gEYeakL2RiNAjok2GbXV5sXbKQPj6hWllhQ0SSg9t4+ck55ja2kyFjUoVIa10ofQldxK/OjrJCncbzm7rcGZBNNti8EuH2xAnbobHD+W9uUpcpxZ/L3FrU/Y8E/jDtSjeiDqHQVegFDinhfWUWBGPh5mPslYaiWDotX70KvaQSapOdg0iVhLuhMOgeT/DNMMgezXhKGfNeEoR8G5iees79b0t6HVcLRvQ95f8624HZJBqtOxj/JsNU7LJVW33s/Io1Vfu7igMknX0b2BVBLAwQUAAAACABgYZZc4it/e7sAAAAzAQAAMgAAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzhY/BasMwEETvhf6D2HstO4dQiuUcEgK5BucDFmlti9haoVVC/PfRMaGFHodh3sy0u8cyqzsl8RwMNFUNioJl58No4NIfv75BScbgcOZABlYS2HWfH+2ZZswlJJOPogoliIEp5/ijtdiJFpSKI4XiDJwWzEWmUUe0VxxJb+p6q9MrA7o3pjo5A+nkGlD9Gkvz/2weBm/pwPa2UMh/VOjo75z3WOadyXJyUuCYRsoGfllNVaaD7lr9drV7AlBLAwQUAAAACABgYZZc/UFB160DAACrEAAAJwAAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbNVYW4/aOBR+X6n/wcp7JhcCAwiouAwVEp1qB2beTWLAmtiObIcFrfrf9zgGmlmYQgX0IiEgtvnOxd/5jk3r45qlaEWkooK3neDOdxDhsUgoX7Sd5+nQrTtIacwTnApO2s6GKOdj58NfrYyuhO7jeEkGZE451QCAAIyrtrPUOmt6noJJhtWdyAiHmbmQDGt4lAtPZZLgRC0J0Sz1Qt+veQxT7liEpjwHQ8znNCYDEeeMcG1BJEmx8UQtaaZ2aCw+B45h+ZpnbixYBhAzmlK9KUAdxOLmaMGFxLMUUrCWO+D1oZ+MxlIoMdd3AORZFw+iDSJwdEVNzh0kmzRpO3KUBPCdzCVRyy98LDAMfhshSW/Tdrq5Xgqwvl1GkgHW4FBUjYLqXbVa8+/rlWotgi1jVCnYwpEmTI0po7rtwM7GkHRNkpfddsPCPVR5kFH+ZD0xEe9nKmZ5LGTSFzkHRHBvLZu5cf/fYaXRDbtR6Hbve0M3qkVVt1EbhG6lV6+EfqPSDaPaV6fTig1jJiKXMUF6k4H3/wj5WhABZvfftys4ZrDCPkCs2PE6La8EscUbUpImCsXWrbC2s1OMIwtiUuEgnrMh0yPw2IdFEJ8kSZGk3Y8DM4xWbefR6xbWSmt2tgvYsumSCTQgKpY0MyS8sbmx0OgxZzMCjLhpXC+EJ0IisPd9Q1xDCatHwS0tDeGEHZtoWQhKaaiXYv5qOLTf0vfSOl1zZBDLxoNa9WD/tqYIo5/pmiRTYBdoUcnkMc+sq8DkI65CGdhpUAHf9QN4TX2/aV7wA4bX78+eDOqJrH5NMiXmCseFWpsM3Zg605I5W8bfMXgyaZN8RvkKxF7IzSU4f+eYa5D3MkZ0KAgnCXWE1rYg3zBqxDVZbMeAUi84zW11AIP2Dydjf/7y+ZKQJyDc0MTlBh0L/r3Yr17L39x4Fifk+EZq8gxHFdQX6o2WBTXTM962g99q9wue/El0NaI9IRqNknNkbvK+aP/MGiur1Tmd9beiSN8e7lDvImksUExzOOy40Y+XyBU7rtXL/3XccNeP/dPHCDjREgl3mzPPEVeXvieC1akz4Y0075PEyYlOfyPLYxFj6NbnaMDVE96HcljAScHo0CWtc4dzCcaESIrTs47r19kJe0uyF6NOi6z1WOniE+WSwn3tPqx2H8Lug9uIGoEb1WfE7YW9yI0eeo37aNiv+PXo6/6eG0QHN+izLrp+w2vYi32ntQ6i5rE/DczJB/yy74WX3rFlnf8AUEsDBBQAAAAIAGBhllxfpU4VMgEAAKICAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1sjZLdagMhEIXvC30H8T7RLaWUZXdD6Q/0phclfQDjzmalqyNqls3bd0xIE0hTAgqjZ+bzzGC1mOzARgjRoKt5MZecgdPYGreu+dfybfbIWUzKtWpABzXfQuSL5vam8mbE9Kx0D5+gMbSREcnFmvcp+VKISIpVcY4eHCkdBqsSHcNaRB9AtbEHSHYQd1I+CKuM43tCGa5hYNcZDS+oNxZc2kMCDCpRH7E3Ph5oVl+Dsyp8b/xMo/WEWJnBpO0OypnV5fvaYVCrgfqfwgE8nfu0RgeM2KU5gcTe4lm3xT0ZHU0eOGcaNy7R3HlThaaa2FhzycXfkaX7NmeQLzmTBa2llGVeRa7J+pEQc+aHeMrKaex+39jdvqpDaS4/iv9Hp8ALlnZtZObpvmQq5wgagDj7Vc0PUEsDBBQAAAAIAGBhllwKQQzqvQAAAEcBAAApAAAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHOFj8EKwjAMhu+C71Byt908iMg6D4rgVfQBQpdtxS0tbRV9e+ttA8FjyJ/vz1ftX+MgnhSidayhlAUIYuMay52G2/W02oKICbnBwTFpeFOEfb1cVBcaMOWj2FsfRaZw1NCn5HdKRdPTiFE6T5w3rQsjpjyGTnk0d+xIrYtio8KUAfWMKc6NhnBuShDXt8/N/9muba2hozOPkTj9qFDePl06YH7vSK1l+xXIfAwdJQ1STgI/s6XMOqDqSs306w9QSwMEFAAAAAgAYGGWXHSznb5xBAAAOxEAAB4AAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWztWFtv2zYUfh+w/yDwXZHlyI5tWC7ki9AA3Ro0afdMS5RNlBeBohIZxf77DilblmwXyLwM6IY+JLaOpO9850LyO56+qzhznokqqBQh8m96yCEikSkVmxB9fordEXIKjUWKmRQkRDtSoHezX3+Z5vRZ6ie8ZmRJMiqoBgAHwEQRoq3W+cTzimRLOC5uZE4E3Mmk4ljDpdp4Ra4ITostIZozr9/rDT2OqUA1woQnrwHhWH0tczeRPMearimjemexkMOTyf1GSGX4hahSB+BKnQFzmihZyEzfAJAns4wm5IyfH3iKPFOTJYBSk5KmIfoWzIPFKO5FbjSMF24wWgVu1O9DzqLx3XLej+Pb3vhP5AjMgcRDkzAfOQmG3NwDhh8gB+c52/1e8jVRcZ2jEEEdrHkuVXrBHEuhz559wFoTJc7sEaMbwcmFN/6gqd6+J3SzPaIBuxRrvMC5KWmIvmBWQtGdMgczSb8cegUag1PxiWSKFFuT5+bOLbTMVr4sFWXMRlIWJCq1rIlp21rghWrCHxQV+olqRiBmkxdoixMnVKRA3eLYSied70ugau/xkmmaMxJTwtKYMsiETeNsymQC7QHdqUgWosifrAbIyagq9HvoQaI+yRfr25oM3plhISGOAHmzuuutiwLYlIZXfwg+jnYHVxQcm/+A0+UsS82oWUXA12Qo2ueHioIoPWdYfN37nk1Ndo4+wIUxOJV5F3jYC3CekgxD4Mbk2Tfg88jln/Laoz+Way01trU8IeafEvtvsGg30veKciH4TgN0ulGUPObaLughdNebYF4NckUH/guVfvMcX52PNpNjoQJYhG8C+T8DabcynKRXR2cOEbtT1ht7a+v+WYN6L33ddgIC4eoa/Jhr8Gc4dl101sTfy0nrjIcTX8mXriQJ4FTOrIuDXmiufNN1zVW/czW0MqJBs8D3bRlicOlsWsFj7T8PbLStRurbjXlthA282jFuFAwVLaPxa53NpolkHbdWZBjAw43ZtNlcGolkHmqse8n9WHJHZo5VsKDv7FYEy2mNi1omhgg2OHNl3IGSA6neOsfvbDqOniBvtTpvlJ9JszU5aZXZw9+wsPorAiFrdfRHwXZW8LUrbAvwIAs7NdWyCsQpUTB6kU5EjRXUqSUMHPe6EyDPTm1bXZhUDlAHNWjYwPea7Blp4/7HJ71nD/1xHD0f9Y6Re5HJ9oxljb+RlJZ8XOtsENW11K+HDGMCSX9qgqcetaK5GUX2Ah2eOjV9wIUGc8nNuGzSTSr9oYCkwqdTKgpj4XjYX8WDpe8OFlHfDZLxrTtaxYG7nMeDRW8Q3I6XfRgL61G38oPrRtLe2BvXQzOsLD+YXBzItzQl9QB3GGr2XqHdT6b0i3MwqRLSns9Ne0Gg7Wjvgrto6A8D1x8NIjfoLRcw/0YDN+75A78/8HvLQXCMNk/h6HuN59NfCPxhvente57hHSwoEzogXozdHzorYebS9DC/FPBLhZmWbHkb40fxJPPWnSZEE6itbO345LeO2V9QSwMEFAAAAAgAYGGWXELAUlzYAwAA/w0AAA0AAAB4bC9zdHlsZXMueG1s7Vfbjts2EH0v0H8gtK+VdbHkWK7lIL4ICJAGRXcLFKiLgpYomwgvAkVv5Rb59wwp2ZY3u9lLU6AP0YNNDskzh5yZI2r6uuEM3RJVUylSJxj4DiIilwUV29T59SZzxw6qNRYFZlKQ1DmQ2nk9+/67aa0PjFzvCNEIIESdOjutq4nn1fmOcFwPZEUEjJRScayhq7ZeXSmCi9os4swLfX/kcUyF0yJMeP4UEI7Vh33l5pJXWNMNZVQfLJaDeD55uxVS4Q0Dqk0Q4Rw1wUiFqFFHJ9b6mR9OcyVrWeoB4HqyLGlOPqebeImH8zMSIL8MKYg9P7zYe6NeiBR5itxSEz5nNhV7nnFdo1zuhU6d6GRC7cjbAmI8ihzURmUhCzinolgPOF8PDgfHO0JczI8fmr9Gu92E80ldP7ASYtL3dPXD1ZU/8M3z4++/kOKPtdszPYDx6n6MP9FdiDUyCF53BrNpKcX5KEKImon85IOQf4nMDMFRwPmYWbNp/Te6xQwsvsHIJZMKachjOJ7A8sKctDMWmNGNosZYYk7ZoTWHxmBTv5vHKSSiJdR6aH83ZtZ/7su6rMEnZeyUDEOzWTDMplA3miiRQQd17ZtDBVsVUOItZTvvkdlbhQ9BGD99QS0ZLQyL7cIesNpuUifLVm9WWWZhNt0AFQVpCOQqpKqh0yN8Imc5wh43UhUgX8eUNyFtTbMpI6WG5Ypud+Zfy8r4kFpDic+mBcVbKTAzDo4rugbA5oSxayNxv5UX2E3ZKw0QS3PSpqpMEwh1zRav7Rj8PlqL3YMdA+Xnw6KmPOE/tDo4k4L875M6rUa4qtjB1IPJ9K4HG+ny/gK5U47HNnwH+/2eb4jKrODcj2r15aujWu35yqjRkyL+zAN4JmZFb6We7yGLzQvbpNedIFnB/Pcbt0kLadqrhYtKOOU0MuKYOu9NhBnIbJeXaLOnTFNxTxUAZtH06iqECgDDo4pzFJCjTnQKDe8z8APJ5Q/iBJ7hOBmFyTjwo3GrTvfqh3XYej1Jc6fVXm/sy4r5jdG3qD0tj/5POWbyG2pQm3uyfcmdChu0qCAl3jN9cxpMnXP7J1LQPYeXSTfrZyNGFiJ1zu12VmJqjzT6XQ0XH/hHe0VT55/V/FWyXGWhO/bnYzcakthN4vnSjaPFfLnMEj/0Fx97t/WX3Yt9c1e3Hxegj0E0qRnc6FW32Y789dmWOr3OO3NhsMrqAe0+9yQc+W/iwHezoR+40QiP3fFoGLtZHITLUTRfxVnc4x6/jHvge0FwJh9PNOWEUXGM1TFCfSsECbpf2ITZio2Ed/5ym30CUEsDBBQAAAAIAGBhllzCh9vyUQYAANcbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZT2/bNhS/D9h3IHRvYye2Ewd1itixm61NGyRuhx5pmZbYUKJA0kl9G9rjgAHDumGXAbvtMGwr0AK7dJ8mW4etA/oV9khKthgzjdOm2L/mEIvUj+//e3ykrly9nzB0SISkPG0F1cuVAJE05EOaRq3gdr93aS1AUuF0iBlPSSuYEBlc3Xj/vSt4XcUkIQjWp3Idt4JYqWx9aUmGMI3lZZ6RFN6NuEiwgqGIloYCHwHdhC0tVyqNpQTTNEApToDsrdGIhgT1DUl4u4ouwU+1EmwUjLoMXqVK6omQiX3NhrirT64bHlQ1Wk5khwl0iFkrAP5DftQn91WAGJYKXrSCivkLljauLOH1fBFTp6wtreuZv3xdvmB4sGx4imgwZVrt1ZqrW1P6BsDUPK7b7Xa61Sk9A8BhCFpbWco0a721arugWQLZx3nanUq9UnPxJforc/Sb7Xa73sxlsUQNyD7W5vBrlUZtc9nBG5DF1+flb292Og0Hb0AW35jD91abjZqLN6CY0fRgDq39OfXMFDLibNsLXwP4WhEAMxREwzTSNIsRT9UicZfge1z0AGwcjRVNkZpkZIRDiPQOTgaCYq05Xie49MZOhXJuSvNFMhQ0U63gwwxD1szovXz2/ctnT9DLZ4+PHzw9fvDT8cOHxw9+tLSchds4jcoLX3z72Z9ff4z+ePLNi0df+PGyjP/1h09++flzPxCyaSbR8y8f//b08fOvPv39u0ce+KbAgzK8TxMi0U1yhPZ4Arp5JCcDcb4V/RhTZwWOgbaHdFfFDvDmBDMfrk1c490RUEh8wGvje46s+7EYK+rhfD1OHOAO56zNhdcA1zWvkoX74zTyMxfjMm4P40Mf7w5OHdd2xxlU0yIonajpxMQRc5fhVOGIpEQh/Y4fEOLR7i6ljl13aCi45COF7lLUxtRrkj4dOIE0W7RNE/DLxKczuNqxzc4d1ObMp/UWOXSRkBCYeYTvE+aY8RoeK5z4SPZxwsoGv4FV7BNyfyLCMq4rFXg6Ioyj7pBI6VtzS4C+Jadfx1C7vG7fYZPERQpFD3w0b2DOy8gtftCJcZJ5ZaZpXMZ+IA8gRDHa5coH3+Fuhugx+AGnp7r7DiWOu88uBLdp5Ig0CxD9Ziw8vrxGuJuPEzbCxFQZKO9OpU5o+qqyzSjU7Xdlu9jHNmET8yXP9olifRruX1iit/A43SWQFfNb1LsK/a5CB//5Cn1aLl98XZ6VYqjSs77bNLXJQk34iDK2ryaM3JCmD5ewGQ17MGkG5vQ4PaBlMTzmW4KDiwQ2a5Dg6iOq4v0YZ9DDV82xNJI56UiijEs4R5ppL21zjKXQxptTaL04bwIaqx0+tNMr5XPolIzZqCJz7i0YrWgCizJbWc0Pt6/JrGqlWlC1qhHNFEhHtanKoMy8akbD3JrQ5SDojcDKDTjQa2pw9sGMDLXd7bZduMXY5CJdJGM8JLmPtN7zilSNk4pYKcLI4yN9pjzDaiVuTU32Dbgt4qQyu9op7ArvvYmXCuvMvKRz+EQ6srScnCxFR62gWV+uByjEWSsYwbEZHpMMvC51Y4lZBPdToRI2EM9MZoOaebPpD8sq3Iqc4k2HRSak2sIytqFhXhXXNKk55Bv5l+tg1otSwEb6a0ixsgbB8LdJATK7riWjEQlV2dmlGXMHYgB58vOxImI/Hh6hARuLPQzu16EK+gyphNsPUxH0AK7ttLXNyC3OedKVL8sMzs5jlsU4L7c6RYtMtnBj86kMZlQSbzoy2sxkPzFcVBWT8hekSjmM/2eq6P0EriNWhub2DG6TBUY6X1sBFyrmUIWymIY9AZdoJgIgWuDqF16D8eFO2/wKcqh/bc5ZGiat4VSp9miEBIX9SMWCkF0oSyb6ziBWzfcuS7IgZHN6Jq7MrNgDckhYX9eQht7bAxQX1SQvAwZ3Mv7ccR52g0g3LP/Uzscm83nbg1nnY9cv2IvUSkW/tBU030yEc261tmLNabxcX3irzeBSCel/sP9RETJi9Ncbap/vQelE044SQVRfso0H0gXSPg2gcbKTNpg0qbfbRs063Snft9h8lrb5aXPmsnNy8dXd5/mMnVvYsXW50/WYGhxwMkV1e1QcaoxjzJe18gcvPrgHjt6CTwhjpqT9dHAfrhBhy7IfJCD5rXPN0o2/AFBLAwQUAAAACABgYZZcKXUZ8yEDAABJBwAADwAAAHhsL3dvcmtib29rLnhtbKVVbW/aMBD+Pmn/IbOQtkoLiZMUWESoaCEaUteiQVtpX5BJDFhN4shxIKjqf985EF7KtKEuQIJ99nPPPXe+tK+KONKWVGSMJx7CdRNpNAl4yJK5hx7Gvt5CWiZJEpKIJ9RDa5qhq87HD+0VF89Tzp81AEgyDy2kTF3DyIIFjUlW5ylNwDLjIiYShmJuZKmgJMwWlMo4MizTbBgxYQnaILjiHAw+m7GA9niQxzSRGxBBIyKBfrZgaVahxcE5cDERz3mqBzxOAWLKIibXJSjS4sAdzBMuyDSCsAt8qRUCvg34YRNuVuUJTCeuYhYInvGZrAO0sSF9Ej82DYyPJChONTgPyQERlkzlcMdKNN7JSgm6wQIVNqlRIf83GobSquCsd6Jd7rhZqNOesYg+bkpXI2l6R2KVqQhpEclkP2SShh5qwpCv6H7CQZrI0+ucRWC1mo51iYzOrpyHQgNYScVQsCUJ1nAmkLZgIR2yJZc+o1F4yzJZTod0RvJIjqHiKx4wbzmW1VCQhXArJYdSaPB/0LsFZiOyBJ6gRrgt4wEQwfYkCYSLJy+2afutPvZ12286utO/buld3OrpZsNu3jRx65vf7b2ClKLhBpzkcrGVQEF7yIF4T0w/SFFZsOnmLNzTeDG3l66eb26V7VWFow77I6OrbC+WGmrFE0tCvvKQji0Ian08XJXGJxbKhYfsVsOBJZu575TNF8DYAsVgkgSSLemYTEtp4Xwpnh464gciKJI+XOXtiJ9xQLBsMkC0fGpJWRiDu0ftlkttLEiSKW9QNT/pHJJJBfQ4tbJMBJSHqzyLQYhV3EcYksYlyCiPoXesD/bZB/ust/uGRAAHcAT9aecJOsjOk612GBVtKCyW0FAVNARxMNqGMimiJK5P/LJQe0SSKcmoqvOARKMqENAU6jakqq2jzue/hf/5U61bw27tVw23jQN3f/I94rmADgxOUefe90f98ZczsL+a8Lm5f7gbd/+93K11L85dDKzxxcUb1ocxgICgSgDnWj3KDFuWhcvUpupM3xB4ZcGq/QBWwlS5VDWLqhqcMkdHe4zqLdj5DVBLAwQUAAAACABgYZZcyKG4+rgAAAA0AQAAIwAAAHhsL3dvcmtzaGVldHMvX3JlbHMvc2hlZXQyLnhtbC5yZWxzhY/BCsIwEETvgv8Q9m7SehCRpr2I4FXqB6zptg22SchG0b83xwqCt9kd9s1O1bzmSTwpsvVOQykLEOSM76wbNFzb02YPghO6DifvSMObGJp6vaouNGHKRzzawCJTHGsYUwoHpdiMNCNLH8hlp/dxxpTHOKiA5o4DqW1R7FRcMqD+YopzpyGeuxJE+w45+T/b9701dPTmMZNLPyJUsE+fWrxNlKkYB0oapFyseaFLmX8HVVfqq2v9AVBLAwQUAAAACABgYZZcPYFbnakDAABZDAAAGAAAAHhsL3dvcmtzaGVldHMvc2hlZXQxLnhtbKVXXW/bNhR9L7D/IPBhb5FE2Yo/arsYEhgN0A7FsnVA32iJsolIokrS+Sr233dIiVKKrIXlBYl4JUqH5957yHuzevdYlcE9V1rIek1oGJOA15nMRb1fk7/+3F7MSaANq3NWypqvyRPX5N3mlzerB6nu9IFzEwCh1mtyMKZZRpHODrxiOpQNrzFTSFUxg1u1j3SjOMvdR1UZJXF8GVVM1KRFWKpTMGRRiIxfy+xY8dq0IIqXzIC/PohGe7QqOwWuYuru2FxksmoAsROlME8OlARVtrzZ11KxXQm/H+mUZcGjwm+Cv4lfxj1/tVIlMiW1LEwI5Kjl/Nr9RbSIWNYjvfb/JBg6RQDuhU3gAJWcR4mmPVYygE3OBLOZaYnZcKnlUeRr8i3ufi4wUnuJh4uf+4dsVrlAhu3HgeLFmvxGl18SEm1WTj+fBX/QL+zAynEn5Z2duMEyMRAaVvPg6bZBUiFtEhjZfOCFueJlCTw4yDIj7vknvLYmO2mMrOy8E7zBo0LJZ167NXnJ8S64WMzvX25BBlD9teXryEY925e2Z751m+OTCnJesGNprmT5t8jNAWxpOE3S2ZwmKfGzf8iH91zsD9aZJJxhwolvmT9dc51hN8Dr0K2ayRJL4BpUwu5qiJk9uvGhhZ+H6SyeOPAd12bbBSg7asTAU+iQWgxEy2Fg7DAmNKTT+HIEBlTgMDB2GPBjLJFpB4LRg9BwnqbTy7kNyYnu4E1HBaNHSUdTsYeEBcHYgcA6kcCs+xZj920SjyaAs9kRwOhBLsNkntJ0TFoWHQpGH4tJOKPxYjIioBSFoxUZDA8D88Rw0F6jg0hn412hXqbW8Czm4+VBvVStcb5AqBerNfqgnEHHy5UOej3HKy9YOijWBv7UHHnN0kG0dHFGkrxs6aBbnHej9zD1wrWGj+507KGUeOFaYzhRRu+ixCvYGv0xO9qppD9oBwXPxscm8QK2xv9g4wWcvBDwZHzKbZFoy8eLAxfZP1F5iReuNYZMDxXy5zhRWw9dKb5mhvlS3NrsaORWlIarodFACv+zX1n8sF9B1W3Ynn9kai9qHZToI2w5xk5Rbcl2NjoQZ9lC5foNf3dAY8zRAMYh8lVICTbtTYd7y82xQfPRcHUrntGBQPJSCRR91/muSYkWXWeYJ8EBE88SM+V1I2wnZPt7I7L+Hpjtelu30GYl8/y9e7D5lVXN26ub3z8HH6QJjGK1tv2Na8L2QuPtVTS8vYq+x4n6fwo2/wJQSwMEFAAAAAgAYGGWXI0sZ+z9AgAAWggAABgAAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWydltdu2zAUhu8L9B0I3lvLkhcsB44HGqAFgqbjmqYom4gkqiS9WvTde0hZSmwjqRLAsQZ/ffzP0HHGN4c8QzsmFRdFjH3Hw4gVVCS8WMf4+7dlZ4CR0qRISCYKFuMjU/hm8vHDeC/ko9owphEQChXjjdblyHUV3bCcKEeUrICVVMicaLiUa1eVkpHEPpRnbuB5PTcnvMAVYSTbMESacsrmgm5zVugKIllGNPhXG16qmpbTNricyMdt2aEiLwGx4hnXRwvFKKeju3UhJFllEPfBDwlFBwmfAP669Tb2/tVOOadSKJFqB8hu5fk6/KE7dAltSNfxt8L4ISRgx00Bn1DB+yz5UcMKnmDdd8JMZSpjJl1ytOVJjP/M+uEsmk27nSgYzjthGPid27kfdLxoOJsOe8vF4nbwF0/GCYcKm4eRZGmMp/5oEWF3Mrb984OzvXp2jjRZPbCMUc1gDx8j054rIR6N8A5ueUAsScHQ8aGEIluNFuVnluoZyzLgQ8CEar5j9yCL8UpoLXKzbl8ADbdSKX6zwnqwWxlvhnkuriBPUPWr8h+YB93G/fPzOpKlfVnuJUpYSraZ/ir2nxhfb4zdwOlHkEXTbqPkOGeKQv9DXI7lUpEBBL5Rzs17DO1LDlUieKI3cOY5YRD1B34AlBVTenlKAt0qiPPnSXViVRTIiKXA8UTpdp1gEPlR7w0UqL2lwLH2EjhR3+u+xUp4gsCxhvQcP/TeYgQCt0bgWDP81uG4VYZt+eZEk8lYij2CVxZSrKAJYAD6o5cKBJUx0qnRxhhmCxROQUPuJt7Y3UEn0JPi9lrhnytm14rgXDG/VnTPFQvT+7WDsFlzIaImLKh567BA2+Cii4BeWZu9sjZ/ZW1hvMW4f5HAM/vQbK3tg7ax37vIlOH8ZytoybZbLYzW4MwkeJ5taJy2jCloG7v9C7uG85LdavRUvVuSNftC5JoXCmUw4swc6WMkq1ljz2E42jMzLuworK828BvOoJs9B5KTCqHrCxNU81/B5B9QSwECFAAUAAAACABgYZZckO8c1poBAABtBwAAEwAAAAAAAAAAACAAtoEAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIUABQAAAAIAGBhlly1VTAj7gAAAEwCAAALAAAAAAAAAAAAIAC2gcsBAABfcmVscy8ucmVsc1BLAQIUABQAAAAIAGBhllwWzEZxpgEAAHADAAAQAAAAAAAAAAAAIAC2geICAABkb2NQcm9wcy9hcHAueG1sUEsBAhQAFAAAAAgAYGGWXEy1eLQ1AQAAUQIAABEAAAAAAAAAAAAgALaBtgQAAGRvY1Byb3BzL2NvcmUueG1sUEsBAhQAFAAAAAgAYGGWXE1B1tIaAQAAewQAABoAAAAAAAAAAAAgALaBGgYAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzUEsBAhQAFAAAAAgAYGGWXOIrf3u7AAAAMwEAADIAAAAAAAAAAAAgALaBbAcAAHhsL3Bpdm90Q2FjaGUvX3JlbHMvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbC5yZWxzUEsBAhQAFAAAAAgAYGGWXP1BQdetAwAAqxAAACcAAAAAAAAAAAAgALaBdwgAAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZURlZmluaXRpb24xLnhtbFBLAQIUABQAAAAIAGBhllxfpU4VMgEAAKICAAAkAAAAAAAAAAAAIAC2gWkMAAB4bC9waXZvdENhY2hlL3Bpdm90Q2FjaGVSZWNvcmRzMS54bWxQSwECFAAUAAAACABgYZZcCkEM6r0AAABHAQAAKQAAAAAAAAAAACAAtoHdDQAAeGwvcGl2b3RUYWJsZXMvX3JlbHMvcGl2b3RUYWJsZTEueG1sLnJlbHNQSwECFAAUAAAACABgYZZcdLOdvnEEAAA7EQAAHgAAAAAAAAAAACAAtoHhDgAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1sUEsBAhQAFAAAAAgAYGGWXELAUlzYAwAA/w0AAA0AAAAAAAAAAAAgALaBjhMAAHhsL3N0eWxlcy54bWxQSwECFAAUAAAACABgYZZcwofb8lEGAADXGwAAEwAAAAAAAAAAACAAtoGRFwAAeGwvdGhlbWUvdGhlbWUxLnhtbFBLAQIUABQAAAAIAGBhllwpdRnzIQMAAEkHAAAPAAAAAAAAAAAAIAC2gRMeAAB4bC93b3JrYm9vay54bWxQSwECFAAUAAAACABgYZZcyKG4+rgAAAA0AQAAIwAAAAAAAAAAACAAtoFhIQAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHNQSwECFAAUAAAACABgYZZcPYFbnakDAABZDAAAGAAAAAAAAAAAACAAtoFaIgAAeGwvd29ya3NoZWV0cy9zaGVldDEueG1sUEsBAhQAFAAAAAgAYGGWXI0sZ+z9AgAAWggAABgAAAAAAAAAAAAgALaBOSYAAHhsL3dvcmtzaGVldHMvc2hlZXQyLnhtbFBLBQYAAAAAEAAQAH8EAABsKQAAAAA= xl/worksheets/sheet1.xml xl/worksheets/sheet3.xml 1 0 Item 1 Item Description 2 Lot Number 3 Transaction Type 4 Sum of Value 5 N/A 6 N/A Total 7 Grand Total data A1 1 data B1 1 data C1 1 data D1 1 data E 3 data E1 1 data F1 1 data G1 1 data H1 1 data I1 1 data J 5 data J1 1 data K1 1 data L1 1 data M1 1 data N 4 data N1 1 data O 5 data O1 1 data P1 1 data Q1 1 data R1 1 data S 2 data S1 1 data T 3 data T1 1 data U1 1 data V1 1 data W1 1 data X1 1 data Y1 1 data Z1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A13 1 parameter A14 1 parameter A15 1 parameter A16 1 parameter A17 1 parameter A18 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A8 1 parameter B3 3 S Site SYSADMIN Default ANDY.HAACK Default PIYUSH.KHANDELWAL Default