ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFF79D2E0530100007F1FF2 INV Category (org id dependent) Y select mcbk.concatenated_segments value, mct.description from mtl_category_sets_b mcsb, mtl_categories_b_kfv mcbk, mtl_categories_tl mct where mcsb.category_set_id=:$flex$.category_set and mcsb.structure_id=mcbk.structure_id and (mcsb.category_set_id, mcbk.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=:$flex$.organization_code) and mcbk.category_id=mct.category_id and mct.language=userenv('lang') order by mcbk.concatenated_segments AR فئة عنصر المخزون ، مقيدة بمجموعة الفئة المحددة السابقة والفئات التي تحتوي على عنصر واحد على الأقل تم تعيينه في رمز المؤسسة المحدد D Kategorie des Inventarartikels, eingeschränkt auf den zuvor ausgewählten Kategoriensatz und auf Kategorien, denen mindestens ein Artikel im ausgewählten Organisationscode zugeordnet ist E Categoría de artículo de inventario, restringida al conjunto de categorías seleccionadas anteriormente y a las categorías que tienen al menos un artículo asignado en el código de organización seleccionado F Catégorie d'article d'inventaire, limitée à l'ensemble des catégories sélectionnées précédemment et aux catégories auxquelles au moins un article est attribué dans le code de l'organisation sélectionnée I Categoria di articoli dell'inventario, limitata al precedente set di categorie selezionato e alle categorie che hanno almeno un articolo assegnato nel codice di organizzazione selezionato JA インベントリ項目のカテゴリは、前に選択したカテゴリセットに制限され、選択した組織コードで割り当てられた少なくとも1つの項目を持っているカテゴリに KO 재고 품목 범주, 이전에 선택한 범주 세트 및 선택한 조직 코드에 지정된 품목이 하나 이상있는 범주로 제한됨 PTB Categoria do item de estoque, restrita ao conjunto de categorias selecionadas anteriormente e às categorias que tenham pelo menos um item atribuído no código de organização selecionado RU Категория инвентаризационных единиц, ограниченная ранее выбранной категорией и категориями, которым в выбранном коде организации присвоен хотя бы один инвентаризационный единичный элемент. S Lagerartikelkategori, begränsad till tidigare vald kategorisats och till kategorier som har åtminstone ett objekt tilldelat i den valda organisationskoden TR Envanter öğesi kategorisi, önceki seçilen kategori grubu ve seçilen organizasyon kodunda en az bir öğenin atanmış olduğu kategorilerle sınırlıdır US Inventory item category, restricted to previous selected category set and to categories which have at least one item assigned in the selected organization code ZHS 库存项目类别，限于以前选定的类别集和在选定的组织代码中至少有一个项目的类别； 8E2FF36EDEFC79D2E0530100007F1FF2 INV Item (org id dependent) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where (msiv.organization_id=:$flex$.organization_code or :$flex$.organization_code is null) order by msiv.concatenated_segments US Required for certain reports matching :$flex$.organization_code to organization_id instead of organization_code, as these reports return the org_id instead of the code from the LOV 8E2FF36EDF0179D2E0530100007F1FF2 INV Subinventory (org id dependent) Y select msi.secondary_inventory_name value, msi.description from mtl_secondary_inventories msi where msi.organization_id=:$flex$.organization_code order by msi.secondary_inventory_name US C2FC853CD3DD36E7E0530100007F396A select :p_org_code organization, x.subinventory "Subinventory/Cost Group", x.asset_inventory, x.category, x.item, x.item_description, x.user_item_type, x.uom, -- :p_hist_date rollback_date, :p_selection_dsp report_type, case :p_selection when '1' then inv_invtrhan_xmlp_pkg.c_target_qty_valformula (:c_cost_type, x.ass_inv, x.target_quantity, x.current_quantity_value_old, inv_invtrhan_xmlp_pkg.cur_qty_valformula(x.ass_inv,x.current_quantity_value_old,x.source_type1,x.source_type2,x.source_type3,x.source_type4,x.other_type), x.source_type1, x.source_type2, x.source_type3, x.source_type4, x.source_type5, x.other_type, x.inventory_item_id, x.subinventory, :c_std_prec ) else x.target_quantity end "Rollback Date Quantity", case :p_selection when '1' then x.current_quantity_value_old else x.current_quantity end "Current Quantity", x.change_quantity, -- &lp_template_dummy_columns &lp_source_columns -- inv_invtrhan_xmlp_pkg.c_othersformula (x.other_type, :c_cost_type, x.inventory_item_id, x.subinventory, x.target_quantity, x.source_type1, x.source_type2, x.source_type3, x.source_type4, :c_std_prec, inv_invtrhan_xmlp_pkg.cur_qty_valformula(x.ass_inv,x.current_quantity_value_old,x.source_type1,x.source_type2,x.source_type3,x.source_type4,x.other_type) ) other_types, -- case when :p_selection in ('2','3') then inv_invtrhan_xmlp_pkg.c_target_qty_valformula (:c_cost_type, x.ass_inv, x.target_quantity, x.current_quantity_value_old, inv_invtrhan_xmlp_pkg.cur_qty_valformula(x.ass_inv,x.current_quantity_value_old,x.source_type1,x.source_type2,x.source_type3,x.source_type4,x.other_type), x.source_type1, x.source_type2, x.source_type3, x.source_type4, x.source_type5, x.other_type, x.inventory_item_id, x.subinventory, :c_std_prec ) end "Rollback Date Value", -- case when :p_selection in ('2','3') then inv_invtrhan_xmlp_pkg.cur_qty_valformula(x.ass_inv,x.current_quantity_value_old,x.source_type1,x.source_type2,x.source_type3,x.source_type4,x.other_type) end "Current Value", -- inv_invtrhan_xmlp_pkg.c_change_valformula (inv_invtrhan_xmlp_pkg.c_target_qty_valformula (:c_cost_type, x.ass_inv, x.target_quantity, x.current_quantity_value_old, inv_invtrhan_xmlp_pkg.cur_qty_valformula(x.ass_inv,x.current_quantity_value_old,x.source_type1,x.source_type2,x.source_type3,x.source_type4,x.other_type), x.source_type1, x.source_type2, x.source_type3, x.source_type4, x.source_type5, x.other_type, x.inventory_item_id, x.subinventory, :c_std_prec ), inv_invtrhan_xmlp_pkg.cur_qty_valformula(x.ass_inv,x.current_quantity_value_old,x.source_type1,x.source_type2,x.source_type3,x.source_type4,x.other_type) ) "Change Value", -- case :p_sort_id when '1' then x.subinventory -- subinventory when '2' then x.subinventory -- item when '3' then x.category -- category when '4' then x.subinventory -- costgroup end pivot_key1, case :p_sort_id when '1' then x.category -- subinventory when '2' then x.category -- item when '3' then x.subinventory -- category when '4' then x.category -- costgroup end pivot_key2 from (select v.subinv subinventory, msub.asset_inventory ass_inv, xxen_util.meaning(msub.asset_inventory,'SYS_YES_NO',700) asset_inventory, mck.concatenated_segments category, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, msiv.primary_uom_code uom, msiv.inventory_item_id, -- sum(nvl(target_qty,0)) target_quantity, sum(nvl(cur_qty,0)) current_quantity, inv_invtrhan_xmlp_pkg.c_change_qtyformula(sum(nvl(cur_qty,0)),sum(nvl(target_qty,0))) change_quantity, decode(:p_selection,1,sum(nvl(cur_qty_val,0)),round(sum(nvl(cur_qty_val,0)),:c_std_prec)) current_quantity_value_old, -- decode(:p_selection, 2,decode(:c_cost_type,2,round(sum(nvl(source_type1,0))*v.item_cost,:c_std_prec),round(sum(nvl(source_type1,0)),:c_std_prec)), 3,round(sum(nvl(source_type1,0)),:c_std_prec), sum(nvl(source_type1,0)) ) source_type1, decode(:p_selection, 2,decode(:c_cost_type,2,round(sum(nvl(source_type2,0))*v.item_cost,:c_std_prec),round(sum(nvl(source_type2,0)),:c_std_prec)), 3,round(sum(nvl(source_type2,0)),:c_std_prec), sum(nvl(source_type2,0)) ) source_type2, decode(:p_selection, 2,decode(:c_cost_type,2,round(sum(nvl(source_type3,0))*v.item_cost,:c_std_prec),round(sum(nvl(source_type3,0)),:c_std_prec)), 3,round(sum(nvl(source_type3,0)),:c_std_prec), sum(nvl(source_type3,0)) ) source_type3, decode(:p_selection, 2,decode(:c_cost_type,2,round(sum(nvl(source_type4,0))*v.item_cost,:c_std_prec),round(sum(nvl(source_type4,0)),:c_std_prec)), 3,round(sum(nvl(source_type4,0)),:c_std_prec), sum(nvl(source_type4,0)) ) source_type4, decode(:p_selection, 2,decode(:c_cost_type,2,round(sum(nvl(source_type5,0))*v.item_cost,:c_std_prec),round(sum(nvl(source_type5,0)),:c_std_prec)), 3,round(sum(nvl(source_type5,0)),:c_std_prec), sum(nvl(source_type5,0)) ) source_type5, decode(:p_selection, 2,decode(:c_cost_type,2,round(sum(nvl(other,0))*v.item_cost,:c_std_prec),round(sum(nvl(other,0)),:c_std_prec)), 3,round(sum(nvl(other,0)),:c_std_prec), sum(nvl(other,0)) ) other_type from mtl_secondary_inventories msub, mtl_system_items_vl msiv, mtl_item_categories mic, mtl_categories_kfv mck, ( select moqd.subinventory_code subinv, moqd.inventory_item_id item_id, 0 item_cost, 0 source_type1,0 source_type2,0 source_type3,0 source_type4,0 source_type5,0 other, sum(moqd.primary_transaction_quantity) cur_qty_val, sum(moqd.primary_transaction_quantity) cur_qty, sum(moqd.primary_transaction_quantity) target_qty from mtl_onhand_quantities_detail moqd where :p_selection='1' and moqd.organization_id=:p_org_id and moqd.owning_tp_type=decode(:p_consigned,2,2,moqd.owning_tp_type) group by moqd.subinventory_code,moqd.inventory_item_id union all select mmt.subinventory_code, mmt.inventory_item_id, 0, sum(decode(mtst.transaction_source_type_id,:p_stype1,mmt.primary_quantity)), sum(decode(mtst.transaction_source_type_id,:p_stype2,mmt.primary_quantity)), sum(decode(mtst.transaction_source_type_id,:p_stype3,mmt.primary_quantity)), sum(decode(mtst.transaction_source_type_id,:p_stype4,mmt.primary_quantity)), 0, sum(decode(mtst.transaction_source_type_id,:p_stype1,0,:p_stype2,0,:p_stype3,0,:p_stype4,0,mmt.primary_quantity)), 0,0, -sum(mmt.primary_quantity) from mtl_material_transactions mmt, mtl_txn_source_types mtst, mtl_parameters mp where :p_selection='1' and mmt.organization_id=:p_org_id and mp.organization_id=:p_org_id and mmt.transaction_date>=:p_hist_date+1 and nvl(mmt.owning_tp_type,2)=decode(:p_consigned,2,2,nvl(mmt.owning_tp_type,2)) and mmt.transaction_source_type_id=mtst.transaction_source_type_id and nvl(mmt.logical_transaction,2)<>1 group by mmt.subinventory_code,mmt.inventory_item_id,mp.primary_cost_method union all select moqv.subinventory_code, moqv.inventory_item_id, round(moqv.item_cost,15), 0,0,0,0,0,0, decode(:p_selection,1,sum(moqv.transaction_quantity),sum(moqv.transaction_quantity*nvl(moqv.item_cost,0))), sum(moqv.transaction_quantity), sum(moqv.transaction_quantity) from mtl_onhand_qty_cost_v moqv where :p_selection<>'1' and moqv.organization_id=:p_org_id group by moqv.subinventory_code,moqv.inventory_item_id,moqv.item_cost union all select mmt.subinventory_code, mmt.inventory_item_id, round(cst.item_cost,15), sum(decode(mtst.transaction_source_type_id,:p_stype1,decode(:p_selection,1,mmt.primary_quantity,decode(mp.primary_cost_method,2,mmt.primary_quantity,decode(:p_stype1,11,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),13,decode(mmt.transaction_action_id,24,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),mmt.primary_quantity*mmt.actual_cost),mmt.primary_quantity*mmt.actual_cost))),0)), sum(decode(mtst.transaction_source_type_id,:p_stype2,decode(:p_selection,1,mmt.primary_quantity,decode(mp.primary_cost_method,2,mmt.primary_quantity,decode(:p_stype2,11,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),13,decode(mmt.transaction_action_id,24,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),mmt.primary_quantity*mmt.actual_cost),mmt.primary_quantity*mmt.actual_cost))),0)), sum(decode(mtst.transaction_source_type_id,:p_stype3,decode(:p_selection,1,mmt.primary_quantity,decode(mp.primary_cost_method,2,mmt.primary_quantity,decode(:p_stype3,11,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),13,decode(mmt.transaction_action_id,24,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),mmt.primary_quantity*mmt.actual_cost),mmt.primary_quantity*mmt.actual_cost))),0)), sum(decode(mtst.transaction_source_type_id,:p_stype4,decode(:p_selection,1,mmt.primary_quantity,decode(mp.primary_cost_method,2,mmt.primary_quantity,decode(mp.primary_cost_method,2,mmt.primary_quantity,decode(:p_stype4,11,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),13,decode(mmt.transaction_action_id,24,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),mmt.primary_quantity*mmt.actual_cost),mmt.primary_quantity*mmt.actual_cost)))),0)), 0, sum(decode(mtst.transaction_source_type_id,:p_stype1,0,:p_stype2,0,:p_stype3,0,:p_stype4,0,decode(:p_selection,1,mmt.primary_quantity,decode(mp.primary_cost_method,2,mmt.primary_quantity,decode(mtst.transaction_source_type_id,11,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),13,decode(mmt.transaction_action_id,24,mmt.quantity_adjusted*(mmt.new_cost-mmt.prior_cost),mmt.primary_quantity*mmt.actual_cost),mmt.primary_quantity*mmt.actual_cost))))), 0,0, -sum(mmt.primary_quantity) from mtl_material_transactions mmt, mtl_txn_source_types mtst, mtl_parameters mp, cst_item_costs_for_gl_view cst where :p_selection<>'1' and mmt.organization_id=:p_org_id and mp.organization_id=:p_org_id and cst.organization_id=:p_org_id and cst.inventory_item_id=mmt.inventory_item_id and mmt.transaction_date>=:p_hist_date+1 and nvl(mmt.owning_tp_type,2)=2 and mmt.transaction_source_type_id=mtst.transaction_source_type_id and nvl(mmt.logical_transaction,2)<>1 group by mmt.subinventory_code,mmt.inventory_item_id,cst.item_cost,mp.primary_cost_method &lp_template_dummy_view) v where v.item_id=msiv.inventory_item_id and msub.organization_id=:p_org_id and msub.secondary_inventory_name=v.subinv and msub.asset_inventory in (1,2) and msub.quantity_tracked=1 and (:p_selection=1 or :p_selection<>1 and msub.asset_inventory=1) and msiv.inventory_item_id = mic.inventory_item_id and mic.category_id = mck.category_id and mic.organization_id = to_char(:p_org_id) and mic.category_set_id = to_char(:p_cat_set_id) and msiv.organization_id=:p_org_id and decode(:p_selection ,1 ,'N' ,:p_wms_pjm_enabled)='N' and 1=1 group by v.subinv, mck.concatenated_segments, msiv.concatenated_segments, v.item_cost, msiv.description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3), msiv.primary_uom_code, msub.asset_inventory, xxen_util.meaning(msub.asset_inventory,'SYS_YES_NO',700), msiv.inventory_item_id union select ccg.cost_group subinventory, 0 ass_inv, null asset_inventory, mck.concatenated_segments category, msiv.concatenated_segments item, msiv.description item_description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3) user_item_type, msiv.primary_uom_code uom, msiv.inventory_item_id item_id, -- sum(ciqt.rollback_qty ) target_quantity, sum(decode(ciqt.qty_source,3,ciqt.rollback_qty,4,ciqt.rollback_qty,6,ciqt.rollback_qty,7,ciqt.rollback_qty,0)) current_quantity, inv_invtrhan_xmlp_pkg.c_change_qtyformula (sum(decode(ciqt.qty_source,3,ciqt.rollback_qty,4,ciqt.rollback_qty,6,ciqt.rollback_qty,7,ciqt.rollback_qty,0)), sum(ciqt.rollback_qty) ) change_quantity, round(sum(ciqt.rollback_qty) * past_cost.item_cost,:c_std_prec) current_quantity_value_old, -- round(sum(decode(ciqt.txn_source_type_id,:p_stype1,nvl(ciqt.rollback_value,0),0)),:c_std_prec) source_type1, round(sum(decode(ciqt.txn_source_type_id,:p_stype2,nvl(ciqt.rollback_value,0),0)),:c_std_prec) source_type2, round(sum(decode(ciqt.txn_source_type_id,:p_stype3,nvl(ciqt.rollback_value,0),0)),:c_std_prec) source_type3, round(sum(decode(ciqt.txn_source_type_id,:p_stype4,nvl(ciqt.rollback_value,0),0)),:c_std_prec) source_type4, 0 source_type5, round(sum(decode(ciqt.qty_source,3 ,ciqt.rollback_qty ,4 ,ciqt.rollback_qty ,6 ,ciqt.rollback_qty ,7 ,ciqt.rollback_qty ,0 ) * current_cost.item_cost),:c_std_prec) - round(sum(ciqt.rollback_qty) * past_cost.item_cost,:c_std_prec) - round(sum(decode(ciqt.txn_source_type_id,:p_stype1,nvl(ciqt.rollback_value,0),0)),:c_std_prec) - round(sum(decode(ciqt.txn_source_type_id,:p_stype2,nvl(ciqt.rollback_value,0),0)),:c_std_prec) - round(sum(decode(ciqt.txn_source_type_id,:p_stype3,nvl(ciqt.rollback_value,0),0)),:c_std_prec ) - round(sum(decode(ciqt.txn_source_type_id,:p_stype4,nvl(ciqt.rollback_value,0),0)),:c_std_prec) other_type from cst_inv_qty_temp ciqt, cst_inv_cost_temp current_cost, cst_inv_cost_temp past_cost, mtl_system_items_vl msiv, mtl_categories_kfv mck, cst_cost_groups ccg where current_cost.organization_id=ciqt.organization_id and current_cost.inventory_item_id=ciqt.inventory_item_id and current_cost.cost_source=1 and past_cost.organization_id=ciqt.organization_id and past_cost.inventory_item_id=ciqt.inventory_item_id and past_cost.cost_source= 2 and msiv.organization_id=ciqt.organization_id and msiv.inventory_item_id=ciqt.inventory_item_id and mck.category_id=ciqt.category_id and ccg.cost_group_id=ciqt.cost_group_id and decode(:p_selection ,1 ,'N' ,:p_wms_pjm_enabled)='Y' and 2=2 group by ccg.cost_group, mck.concatenated_segments, msiv.concatenated_segments, msiv.description, xxen_util.meaning(msiv.item_type,'ITEM_TYPE',3), msiv.primary_uom_code, msiv.inventory_item_id, past_cost.item_cost ) x order by case :p_sort_id when '1' then x.subinventory -- subinventory when '2' then null -- item when '3' then x.category -- category when '4' then x.subinventory -- costgroup end, case :p_sort_id when '1' then x.category -- subinventory when '2' then null -- item when '3' then x.subinventory -- category when '4' then x.category -- costgroup end, x.item Inline the txn_analysis_view subquery directly into SQL instead of relying on dynamic view creation by inv_invtrhan_xmlp_pkg.afterpform. The old engine called afterpform to CREATE VIEW before the main SQL; the new engine does not, causing ORA-00942. Y INV INVTRHAN_XML #,##0.00;[Red]-#,##0.00 AR INV إجمالي تاريخي للحركة (بتنسيق XML) Imported from BI Publisher Description: إجمالي تاريخي للحركة Application: المخازن Source: إجمالي تاريخي للحركة (بتنسيق XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG D INV Historische Transaktionen - Übersicht Imported from BI Publisher Description: Historische Transaktionen - Übersicht Application: Lager Source: Historische Transaktionen - Übersicht (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG E INV Resumen de Historial de Transacciones Imported from BI Publisher Description: Resumen del Historial de Transacciones Application: Inventory Source: Resumen de Historial de Transacciones (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG F INV Synthèse de l'historique des mouvements Imported from BI Publisher Description: Synthèse historique des mouvements Application: Inventory Source: Synthèse de l'historique des mouvements (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG I INV Sintetico cronologia transazioni (XNL) Imported from BI Publisher Description: Sintetico cronologia transazioni Application: Inventory Source: Sintetico cronologia transazioni (XNL) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG JA INV 取引履歴要約 Imported from BI Publisher Description: 取引履歴要約 Application: Inventory Source: 取引履歴要約(XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG KO INV 트랜잭션 내역 요약 Imported from BI Publisher Description: 트랜잭션 내역 요약 Application: Inventory Source: 트랜잭션 내역 요약(XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG PTB INV Resumo do histórico de transações Imported from BI Publisher Description: Sumário do histórico de transações Application: Inventário Source: Resumo do histórico de transações (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG RU INV Историческая сводка транзакций Imported from BI Publisher Description: Историческая сводка транзакций Application: Запасы Source: Историческая сводка транзакций (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG S INV Transaktioner - historisk översikt Imported from BI Publisher Description: Transaktionshistorik totalt Application: Inventory Source: Transaktioner - historisk översikt (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG TR INV İşlem tarihçe özeti Imported from BI Publisher Description: İşlem tarihçe özeti Application: Stok Yönetimi Source: İşlem tarihçe özeti (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG US INV Transaction Historical Summary Application: Inventory Description: Transaction Historical Summary Report This report provides equivalent functionality to the Oracle standard Transaction historical summary (XML) report. Templates Quantity/Value Template – for use with the Quantity and Value Selection Option Balance Template – for use with the Balance Selection Option The templates provide a summary pivot based on the selected sort option parameter with drill down to the detail data. Sort Option Category: Pivot by Category, Subinventory/Cost Group All Others: Pivot by Subinventory/Cost Group, Category Source: Transaction historical summary (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG ZHS INV 事务处理历史汇总 Imported from BI Publisher Description: 事务处理历史记录汇总 Application: 库存管理系统 Source: 事务处理历史汇总 (XML) Short Name: INVTRHAN_XML DB package: INV_INVTRHAN_XMLP_PKG Enginatics R12 only &lp_source_columns &lp_template_dummy_columns &lp_template_dummy_view 1=1 2=2 :c_cost_type :c_std_prec :p_cat_flex :p_cat_hi :p_cat_lo :p_cat_set_id :p_cat_sort :p_cat_struct_num :p_cg_hi :p_cg_lo :p_conc_request_id :p_consigned :p_cost_group_id :p_hist_date :p_hist_date_1 :p_item_flex :p_item_hi :p_item_lo :p_item_order :p_optimizer_flag :p_org_code :p_org_id :p_pjm_enabled :p_qty_precision :p_selection :p_selection_dsp :p_sort_id :p_struct_num :p_stype1 :p_stype1_1 :p_stype2 :p_stype2_1 :p_stype3 :p_stype3_1 :p_stype4 :p_stype4_1 :p_stype5 :p_subinv_hi :p_subinv_lo :p_trace_flag :p_where_cat :p_where_item :p_wms_enabled :p_wms_pjm_enabled 1 -90 &lp_source_columns select x.col from ( select 'x.source_type1 "' || mtst.transaction_source_type_name || '",' col from mtl_txn_source_types mtst where :p_source_cols = 'Y' and :run_id is not null and mtst.transaction_source_type_id=:p_stype1 union select 'x.source_type2 "' || mtst.transaction_source_type_name || '",' from mtl_txn_source_types mtst where :p_source_cols = 'Y' and :run_id is not null and mtst.transaction_source_type_id=:p_stype2 union select 'x.source_type3 "' || mtst.transaction_source_type_name || '",' from mtl_txn_source_types mtst where :p_source_cols = 'Y' and :run_id is not null and mtst.transaction_source_type_id=:p_stype3 union select 'x.source_type4 "' || mtst.transaction_source_type_name || '",' from mtl_txn_source_types mtst where :p_source_cols = 'Y' and :run_id is not null and mtst.transaction_source_type_id=:p_stype4 union select null from dual where :p_source_cols = 'Y' and :run_id is not null ) x Char select nvl( (select 'Y' from dual where :$flex$.Source_Type_for_Column_One is not null or :$flex$.Source_Type_for_Column_Two is not null or :$flex$.Source_Type_for_Column_Three is not null or :$flex$.Source_Type_for_Column_Four is not null ), 'N') from dual F Colonnes de la source US Source Columns 2 -80 :p_org_code Char select mp.organization_code from mtl_parameters mp where mp.organization_id=:$flex$.organization_code Y AR التنظيم التنظيم D Organisation Organisation F Code de l'organisation Disp Organisation I Organizzazione Organizzazione US Organization Code Disp Organization ZHS 组织 组织 3 -70 :c_cost_type Number select mp.primary_cost_method from mtl_parameters mp where mp.organization_id = :$flex$.organization_code F Type de coût US Cost Type 4 -60 :c_std_prec Number select nvl(c.precision,2) from org_organization_definitions o, gl_sets_of_books g, fnd_currencies c where o.organization_id = :$flex$.organization_code and o.set_of_books_id = g.set_of_books_id and g.currency_code = c.currency_code (+) AR خيار الدقة الديناميكية خيار الدقة الديناميكية D Option Nachkommastellen Option Nachkommastellen F Option de précision dynamique Option précision dynamique I Opzione precisione dinamica Opzione precisione dinamica US Dynamic Precision Option Dynamic Precision Option ZHS 动态精确度选项 动态精确度选项 5 -50 :p_wms_enabled Char select wms_enabled_flag from mtl_parameters where organization_id = :$flex$.organization_code Y AR علامة فعالية WMS علامة فعالية WMS D Für WMS aktiviert Für WMS aktiviert F Drapeau WMS activé Indicateur WMS activé I Flag WMS abilitato Flag WMS abilitato US WMS Enabled Flag WMS Enabled Flag ZHS WMS 启用标志 WMS 启用标志 6 -40 :p_pjm_enabled Char select DECODE(project_reference_enabled, 1, 'Y','N') from mtl_parameters where organization_id = :$flex$.organization_code AR علامة فعالية PJM علامة فعالية PJM D Für PJM aktiviert Für PJM aktiviert F Drapeau PJM activé Indicateur PJM activé I Flag PJM abilitato Flag PJM abilitato US PJM Enabled Flag PJM Enabled Flag ZHS PJM 启用标志 PJM 启用标志 7 -30 :p_selection Char select lookup_code from mfg_lookups where lookup_type='INV_SRS_HAN_SEL' and meaning=:$flex$.Selection_Option US INV_SRS_HAN_SELECTION 8 -20 :p_wms_pjm_enabled Char select DECODE(project_reference_enabled, 1, 'Y',wms_enabled_flag) from mtl_parameters where organization_id = :$flex$.organization_code AR INV_SRS_CHARACTER علامة تمكين WMS أو PJM D INV_SRS_CHARACTER Für WMS oder PJM aktiviert F INV_SRS_CARACTÈRE Indicateur WMS ou PJM activé I INV_SRS_CHARACTER Flag WMS o PJM abilitato US INV_SRS_CHARACTER WMS or PJM Enabled Flag ZHS INV_SRS_CHARACTER WMS 或 PJM 启用标志 9 -10 :p_cg_dummy Number select 1 from dual where :$flex$.inv_srs_han_selection IN ( 2 , 3 ) AND :$flex$.inv_srs_character='Y' AR INV_SRS_CG_SELECTION_DUMMY اختيار مجموعة تكاليف افتراضي D INV_SRS_CG_SELECTION_DUMMY Dummy für Kostengruppenauswahl F INV_SRS_CG_SELECTION_DUMMY Sélection de groupe de coûts - Fictif I INV_SRS_CG_SELECTION_DUMMY Selezione di gruppo di costi fittizia US INV_SRS_CG_SELECTION_DUMMY Cost Group Selection Dummy ZHS INV_SRS_CG_SELECTION_DUMMY 成本组选择虚拟 10 10 :p_org_id LOV Oracle INV_SRS_ORGANIZATION_ID Y select organization_id id, organization_code value, organization_name description from org_access_view where responsibility_id=fnd_profile.value('RESP_ID') order by 1 select nvl(fnd_profile.value('MFG_ORGANIZATION_ID'),(select min(oav.organization_id) from org_access_view oav where oav.responsibility_id=fnd_global.resp_id and oav.resp_application_id=fnd_global.resp_appl_id)) from dual Y F Code de l'organisation US Organization Code 11 20 :p_selection_dsp LOV custom Y select meaning value, null description from mfg_lookups where lookup_type='INV_SRS_HAN_SEL' and enabled_flag='Y' and ((lookup_code!=2) and exists (select organization_id from mtl_parameters where organization_id=:$flex$.organization_code and primary_cost_method=2) or exists (select organization_id from mtl_parameters where organization_id=:$flex$.organization_code and primary_cost_method!=2)) order by value,description Quantity Y AR خيار الاختيار خيار الاختيار D Auswahloption Auswahloption F Option de sélection Option de sélection I Opzione di selezione Opzione di selezione US Selection Option Selection Option ZHS 选择选项 选择选项 12 &lp_template_dummy_columns select '0 "' || transaction_source_type_name || '",' from mtl_txn_source_types where :run_id is null order by transaction_source_type_name F Option de sélection US Selection Option 13 &lp_template_dummy_view select 'union all select null subinv,0 item_id,0 item_cost,0 source_type1,0 source_type2,0 source_type3,0 source_type4,0 source_type5,0 other,0 cur_qty_val,0 cur_qty,0 target_qty from dual' from dual where :run_id is null F Option de sélection US Selection Option 14 30 :p_sort_id LOV Oracle INV_SRS_TRHAN_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_HAN_SORT' and enabled_flag='Y' and lookup_code not in decode (:$flex$.inv_srs_character,'Y',decode(:$flex$.inv_srs_han_selection,2,1,3,1,1,4,-999),'N',4,-999) order by lookup_code decode(:$flex$.inv_srs_character,'N', 1, 'Y' , decode(:$flex$.inv_srs_han_selection, 2, 4, 3, 4, 1 ) , 1 ) Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption F Trier par Option de tri I Ordina per Opzione di ordinamento US Sort By Sort Option ZHS 排序依据 排序选项 15 40 :p_cg_lo LOV custom Y select cg.cost_group value, cg.description description from cst_cost_groups cg where :$flex$.inv_srs_cg_selection_dummy=1 and nvl(cg.organization_id,:$flex$.organization_code)=:$flex$.organization_code and nvl(cg.disable_date,sysdate+1)>sysdate and cg.cost_group_type=3 order by cost_group AR مجموعات التكاليف من مجموعة التكاليف من D Von Kostengruppen Von Kostengruppe F Groupes de coûts De Groupe de coûts - Inf. I Gruppi di costi - Da Gruppo di costi - min US Cost Groups From Cost Group Low ZHS 成本组自 成本组下限 16 2=2 ccg.cost_group>=:p_cg_lo F Groupes de coûts De US Cost Groups From 17 50 :p_cg_hi LOV custom Y select cg.cost_group value, cg.description description from cst_cost_groups cg where :$flex$.inv_srs_cg_selection_dummy=1 and nvl(cg.organization_id,:$flex$.organization_code)=:$flex$.organization_code and nvl(cg.disable_date,sysdate+1)>sysdate and cg.cost_group_type=3 order by cost_group AR إلى مجموعة التكاليف إلى D Bis Bis Kostengruppe F Groupes de coûts à Groupe de coûts - Sup. I A Gruppo di costi - max US Cost Groups To Cost Group High ZHS 至 成本组上限 18 2=2 ccg.cost_group<=:p_cg_hi F Groupes de coûts à US Cost Groups To 19 60 :p_consigned LOV Oracle INV_SRS_TRN_HIST_CONSIGN_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=decode(:$flex$.inv_srs_han_selection,1,lookup_code,2) order by lookup_code 2 Y AR تضمين الإيداع تضمين الإيداع D Mit Konsignation Mit Konsignation F Inclure les consignés Inclure le stock de consignation I Comprendi scorte in deposito Comprendi scorte in deposito US Include Consigned Include Consigned ZHS 包括寄销 包括寄销 20 70 :p_hist_date Date Y AR إلغاء التعديلات لتاريخه إلغاء تعديلات القيمة/الكمية لتاريخه D Rollback bis zu diesem Datum Wert/Menge rückwärts verrechnen bis F Retour à cette date Remonter valeur/quantité à cette date I Da questa data Valore rollback/qtà a data corrente US Rollback to this Date Rollback Value/Qty to this Date ZHS 回滚至日期 将值/数量回滚至此日期 21 80 :p_cat_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 category_set_id from mtl_default_sets_view where functional_area_id = 1 Y AR مجموعة الفئات اسم مجموعة الفئات D KategorieSet Bezeichnung KategorieSet F Ensemble de la catégorie Nom du jeu de catégories I Serie di categorie Nome serie categorie US Category Set Category Set Name ZHS 类别集 类别集名称 22 90 :p_cat_lo LOV INV Category (org id dependent) 8E2FF36EDEFF79D2E0530100007F1FF2 Y select mcbk.concatenated_segments value, mct.description from mtl_category_sets_b mcsb, mtl_categories_b_kfv mcbk, mtl_categories_tl mct where mcsb.category_set_id=:$flex$.category_set and mcsb.structure_id=mcbk.structure_id and (mcsb.category_set_id, mcbk.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=:$flex$.organization_code) and mcbk.category_id=mct.category_id and mct.language=userenv('lang') order by mcbk.concatenated_segments AR الفئات من الفئة من D Von Kategorie Von Kategorie F Catégories de Catégorie - De I Categorie - Da Categoria (min) US Categories From Category Low ZHS 类别自 类别下限 23 1=1 mck.concatenated_segments>=:p_cat_lo F Catégories de US Categories From 24 2=2 mck.concatenated_segments>=:p_cat_lo F Catégories de US Categories From 25 100 :p_cat_hi LOV INV Category (org id dependent) 8E2FF36EDEFF79D2E0530100007F1FF2 Y select mcbk.concatenated_segments value, mct.description from mtl_category_sets_b mcsb, mtl_categories_b_kfv mcbk, mtl_categories_tl mct where mcsb.category_set_id=:$flex$.category_set and mcsb.structure_id=mcbk.structure_id and (mcsb.category_set_id, mcbk.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=:$flex$.organization_code) and mcbk.category_id=mct.category_id and mct.language=userenv('lang') order by mcbk.concatenated_segments AR إلى 2 الفئة إلى D Bis 2 Bis Kategorie F Catégories à Catégorie - A I A 2 Categoria (max) US Categories To Category High ZHS 至 2 类别上限 26 1=1 mck.concatenated_segments<=:p_cat_hi F Catégories à US Categories To 27 2=2 mck.concatenated_segments<=:p_cat_hi F Catégories à US Categories To 28 110 :p_item_lo LOV INV Item (org id dependent) 8E2FF36EDEFC79D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where (msiv.organization_id=:$flex$.organization_code or :$flex$.organization_code is null) order by msiv.concatenated_segments AR الأصناف من صنف من D Von Artikel Von Artikel F Articles de Article - De I Articoli - Da Articolo - Minimo US Items From Item Low ZHS 物料自 物料下限 29 1=1 msiv.concatenated_segments>=:p_item_lo F Articles de US Items From 30 2=2 msiv.concatenated_segments>=:p_item_lo F Articles de US Items From 31 120 :p_item_hi LOV INV Item (org id dependent) 8E2FF36EDEFC79D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where (msiv.organization_id=:$flex$.organization_code or :$flex$.organization_code is null) order by msiv.concatenated_segments AR إلى 3 صنف إلى D Bis 3 Bis Artikel F Articles à Article - A I A 3 Articolo - Massimo US Items To Item High ZHS 至 3 物料上限 32 1=1 msiv.concatenated_segments<=:p_item_hi F Articles à US Items To 33 2=2 msiv.concatenated_segments<=:p_item_hi F Articles à US Items To 34 130 :p_subinv_lo LOV INV Subinventory (org id dependent) 8E2FF36EDF0179D2E0530100007F1FF2 Y select msi.secondary_inventory_name value, msi.description from mtl_secondary_inventories msi where msi.organization_id=:$flex$.organization_code order by msi.secondary_inventory_name AR المخازن من مخزن من D Von Lager Von Lager F Sous-stocks De Magasin - De I Sottomagazzini - Da Sottomagazzino - Da US Subinventories From Subinventory Low ZHS 子库存自 子库存下限 35 1=1 v.subinv>=:p_subinv_lo F Sous-stocks De US Subinventories From 36 140 :p_subinv_hi LOV INV Subinventory (org id dependent) 8E2FF36EDF0179D2E0530100007F1FF2 Y select msi.secondary_inventory_name value, msi.description from mtl_secondary_inventories msi where msi.organization_id=:$flex$.organization_code order by msi.secondary_inventory_name AR إلى 4 مخزن إلى D Bis 4 Bis Lager F Sous-inventaires Au Magasin - A I A 4 Sottomagazzino - A US Subinventories To Subinventory High ZHS 至 4 子库存上限 37 1=1 v.subinv<=:p_subinv_hi F Sous-inventaires Au US Subinventories To 38 150 :p_stype1 LOV Oracle INV_SRS_TRN_HIST_SOURCE_TYPES Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types where :$flex$.inv_srs_han_selection<>3 order by value,description select transaction_source_type_id from mtl_txn_source_types where transaction_source_type_id = 1 and :$flex$.inv_srs_han_selection <> 3 AR نوع المصدر للعمود 1 نوع المصدر الأول D Herkunftsart für Spalte eins Herkunftsart 1 F Type de source pour la première colonne Type d'origine - Un I Tipo di origine per colonna uno Tipo di origine per colonna uno US Source Type for Column One Source Type One ZHS 列 1 的来源类型 来源类型 1 39 160 :p_stype2 LOV Oracle INV_SRS_TRN_HIST_SOURCE_TYPES Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types where :$flex$.inv_srs_han_selection<>3 order by value,description select transaction_source_type_id from mtl_txn_source_types where transaction_source_type_id = 3 and :$flex$.inv_srs_han_selection <> 3 AR نوع المصدر للعمود 2 نوع المصدر الثاني D Herkunftsart für Spalte zwei Herkunftsart 2 F Type de source pour la deuxième colonne Type d'origine - Deux I Tipo di origine per colonna due Tipo di origine per colonna due US Source Type for Column Two Source Type Two ZHS 列 2 的来源类型 来源类型 2 40 170 :p_stype3 LOV Oracle INV_SRS_TRN_HIST_SOURCE_TYPES Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types where :$flex$.inv_srs_han_selection<>3 order by value,description select transaction_source_type_id from mtl_txn_source_types where transaction_source_type_id = 6 and :$flex$.inv_srs_han_selection <> 3 AR نوع المصدر للعمود 3 نوع المصدر الثالث D Herkunftsart für Spalte drei Herkunftsart 3 F Type de source pour la troisième colonne Type d'origine - Trois I Tipo di origine per colonna tre Tipo di origine per colonna tre US Source Type for Column Three Source Type Three ZHS 列 3 的来源类型 来源类型 3 41 180 :p_stype4 LOV Oracle INV_SRS_TRN_HIST_SOURCE_TYPES Y select transaction_source_type_id id, transaction_source_type_name value, description description from mtl_txn_source_types where :$flex$.inv_srs_han_selection<>3 order by value,description select transaction_source_type_id from mtl_txn_source_types where transaction_source_type_id = 5 and :$flex$.inv_srs_han_selection <> 3 AR نوع المصدر للعمود 4 نوع المصدر الرابع D Herkunftsart für Spalte vier Herkunftsart 4 F Type de source pour la quatrième colonne Type d'origine - Quatre I Tipo di origine per colonna quattro Tipo di origine per colonna quattro US Source Type for Column Four Source Type Four ZHS 列 4 的来源类型 来源类型 4 :$flex$.Selection_Option Selection Option INV_SRS_HAN_SELECTION :$flex$.Source_Type_for_Column_Four Source Type for Column Four Source Columns :$flex$.Source_Type_for_Column_One Source Type for Column One Source Columns :$flex$.Source_Type_for_Column_Three Source Type for Column Three Source Columns :$flex$.Source_Type_for_Column_Two Source Type for Column Two Source Columns :$flex$.category_set Category Set Categories From :$flex$.category_set Category Set Categories To :$flex$.inv_srs_cg_selection_dummy INV_SRS_CG_SELECTION_DUMMY Cost Groups From :$flex$.inv_srs_cg_selection_dummy INV_SRS_CG_SELECTION_DUMMY Cost Groups To :$flex$.inv_srs_character INV_SRS_CHARACTER INV_SRS_CG_SELECTION_DUMMY :$flex$.inv_srs_character INV_SRS_CHARACTER Sort By :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION INV_SRS_CG_SELECTION_DUMMY :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION Include Consigned :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION Sort By :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION Source Type for Column Four :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION Source Type for Column One :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION Source Type for Column Three :$flex$.inv_srs_han_selection INV_SRS_HAN_SELECTION Source Type for Column Two :$flex$.organization_code Organization Code Categories From :$flex$.organization_code Organization Code Categories To :$flex$.organization_code Organization Code Cost Groups From :$flex$.organization_code Organization Code Cost Groups To :$flex$.organization_code Organization Code Cost Type :$flex$.organization_code Organization Code Dynamic Precision Option :$flex$.organization_code Organization Code INV_SRS_CHARACTER :$flex$.organization_code Organization Code Items From :$flex$.organization_code Organization Code Items To :$flex$.organization_code Organization Code Organization Code Disp :$flex$.organization_code Organization Code PJM Enabled Flag :$flex$.organization_code Organization Code Selection Option :$flex$.organization_code Organization Code Subinventories From :$flex$.organization_code Organization Code Subinventories To :$flex$.organization_code Organization Code WMS Enabled Flag Balance Template Y Default Balance Template SYSADMIN 3 ASSET_INVENTORY 4 CATEGORY 12 CHANGE_QUANTITY 15 Change Value 11 Current Quantity 14 Current Value 5 ITEM 6 ITEM_DESCRIPTION 1 ORGANIZATION 16 PIVOT_KEY1 17 PIVOT_KEY2 9 REPORT_TYPE 8 ROLLBACK_DATE 10 Rollback Date Quantity 13 Rollback Date Value 2 Subinventory/Cost Group 7 UOM CHANGE_QUANTITY VALUE 3 SUM Change Value VALUE 6 SUM Current Quantity VALUE 2 SUM Current Value VALUE 5 SUM ORGANIZATION FILTER 1 PIVOT_KEY1 ROW 1 PIVOT_KEY2 ROW 2 REPORT_TYPE FILTER 3 ROLLBACK_DATE FILTER 2 Rollback Date Quantity VALUE 1 SUM Rollback Date Value VALUE 4 SUM S Site Quantity/Value Template Y Default Quantity/Value Template SYSADMIN 3 ASSET_INVENTORY 12 Account 13 Account alias 4 CATEGORY 46 CHANGE_QUANTITY 45 Change Value 14 Consignment 43 Current Quantity 44 Current Value 15 Cycle Count 16 External Requisition 5 ITEM 6 ITEM_DESCRIPTION 17 Internal order 18 Internal requisition 19 Inventory 20 Job or Schedule 21 Layer Cost Update 22 Mobile Field Service 23 Move order 1 ORGANIZATION 42 OTHER_TYPES 24 PICK 47 PIVOT_KEY1 48 PIVOT_KEY2 25 Periodic Cost Update 26 Physical Inventory 27 Project Contract 28 Purchase order 29 PutAway 9 REPORT_TYPE 30 RMA 8 ROLLBACK_DATE 10 Rollback Date Quantity 11 Rollback Date Value 31 Sales order 32 Spares Management 33 Standard cost update 2 Subinventory/Cost Group 7 UOM 34 {Found *'******'* *'******'* } 35 {INCR_TEST1 *'******'* *'****} 36 {LIFO-Transaction *'******'* } 37 {LIFO_TEST1 *'******'* *'****} 38 {NL Issue to Project *'******} 39 {Order Capture *'******'* *'*} 40 {Temp-Test *'******'* *'*****} 41 {test *'******'* *'******'* *} Account VALUE 3 SUM Account alias VALUE 4 SUM CHANGE_QUANTITY VALUE 35 SUM Change Value VALUE 37 SUM Consignment VALUE 5 SUM Current Quantity VALUE 34 SUM Current Value VALUE 36 SUM Cycle Count VALUE 6 SUM External Requisition VALUE 7 SUM Internal order VALUE 8 SUM Internal requisition VALUE 9 SUM Inventory VALUE 10 SUM Job or Schedule VALUE 11 SUM Layer Cost Update VALUE 12 SUM Mobile Field Service VALUE 13 SUM Move order VALUE 14 SUM ORGANIZATION FILTER 1 OTHER_TYPES VALUE 33 SUM PICK VALUE 15 SUM PIVOT_KEY1 ROW 1 PIVOT_KEY2 ROW 2 Periodic Cost Update VALUE 16 SUM Physical Inventory VALUE 17 SUM Project Contract VALUE 18 SUM Purchase order VALUE 19 SUM PutAway VALUE 20 SUM REPORT_TYPE FILTER 3 RMA VALUE 21 SUM ROLLBACK_DATE FILTER 2 Rollback Date Quantity VALUE 1 SUM Rollback Date Value VALUE 2 SUM Sales order VALUE 22 SUM Spares Management VALUE 23 SUM Standard cost update VALUE 24 SUM {Found *'******'* *'******'* } VALUE 25 SUM {INCR_TEST1 *'******'* *'****} VALUE 26 SUM {LIFO-Transaction *'******'* } VALUE 27 SUM {LIFO_TEST1 *'******'* *'****} VALUE 28 SUM {NL Issue to Project *'******} VALUE 29 SUM {Order Capture *'******'* *'*} VALUE 30 SUM {Temp-Test *'******'* *'*****} VALUE 31 SUM {test *'******'* *'******'* *} VALUE 32 SUM S Site SYSADMIN Balance Template ENGINATICS Balance Template Quantity/Value Template