ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41DA3A35C8B8CFB7E06362FB0905E8D8 SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NUMBER, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY, decode(:P_SORT_OPTION,1,fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE')), MSI.description DESCRIPTION, MSI.primary_uom_code UOM_CODE, ROUND(SUM(CIQT.rollback_qty),:P_Qty_Precision) STK_QTY, 0 INT_QTY, 0 RCV_QTY, ROUND( SUM(CIQT.rollback_qty) * DECODE(SUB.asset_inventory,1,CICT.item_cost,0) * :P_Exchange_Rate / :Round_Unit ) * :Round_Unit STK_VALUE, 0 INT_VALUE, 0 RCV_VALUE, ROUND( SUM(CIQT.rollback_qty) * DECODE(SUB.asset_inventory,1,CICT.item_cost,0) * :P_Exchange_Rate / :Round_Unit ) * :Round_Unit IT_VALUE, ROUND(SUM(CIQT.rollback_qty),:P_Qty_Precision) IT_QTY FROM cst_inv_qty_temp CIQT, cst_inv_cost_temp CICT, mtl_parameters MP, mtl_system_items_vl MSI, mtl_categories MC, mtl_secondary_inventories SUB WHERE CIQT.qty_source in (3,4,5) AND CICT.cost_source in (1,2) AND CICT.organization_id = CIQT.organization_id AND CICT.inventory_item_id = CIQT.inventory_item_id AND ( MP.primary_cost_method = 1 OR CICT.cost_group_id = CIQT.cost_group_id) AND MP.organization_id = CIQT.organization_id AND SUB.organization_id = CIQT.organization_id AND SUB.secondary_inventory_name = CIQT.subinventory_code AND MSI.organization_id = CIQT.organization_id AND MSI.inventory_item_id = CIQT.inventory_item_id AND MC.category_id = CIQT.category_id GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), MSI.description, MSI.primary_uom_code, DECODE(SUB.asset_inventory,1,CICT.item_cost,0) HAVING SUM(CIQT.rollback_qty) <> 0 UNION ALL SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NUMBER, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY, decode(:P_SORT_OPTION,1,fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE')), MSI.description DESCRIPTION, MSI.primary_uom_code UOM_CODE, 0 STK_QTY, ROUND(SUM(CIQT.rollback_qty),:P_Qty_Precision) INT_QTY, 0 RCV_QTY, 0 STK_VALUE, ROUND( SUM(CIQT.rollback_qty) * CICT.item_cost * :P_Exchange_Rate / :Round_Unit ) * :Round_Unit INT_VALUE, 0 RCV_VALUE, ROUND( SUM(CIQT.rollback_qty) * CICT.item_cost * :P_Exchange_Rate / :Round_Unit ) * :Round_Unit IT_VALUE, ROUND(SUM(CIQT.rollback_qty),:P_Qty_Precision) IT_QTY FROM cst_inv_qty_temp CIQT, cst_inv_cost_temp CICT, mtl_parameters MP, mtl_system_items_vl MSI, mtl_categories MC WHERE CIQT.qty_source in (6,7,8) AND CICT.organization_id = :P_ORG_ID AND CICT.cost_source in (1,2) AND CICT.organization_id = CIQT.organization_id AND CICT.inventory_item_id = CIQT.inventory_item_id AND ( MP.primary_cost_method = 1 OR CICT.cost_group_id = CIQT.cost_group_id) AND MP.organization_id = CIQT.organization_id AND MSI.organization_id = CIQT.organization_id AND MSI.inventory_item_id = CIQT.inventory_item_id AND MC.category_id = CIQT.category_id GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), MSI.description, MSI.primary_uom_code, CICT.item_cost HAVING SUM(CIQT.rollback_qty) <> 0 UNION ALL SELECT fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NUMBER, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY, decode(:P_SORT_OPTION,1,fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'),fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE')), MSI.description DESCRIPTION, MSI.primary_uom_code UOM_CODE, 0 STK_QTY, 0 INT_QTY, ROUND(SUM(CIQT.rollback_qty),:P_Qty_Precision) RCV_QTY, 0 STK_VALUE, 0 INT_VALUE, ROUND( SUM(CIQT.rollback_qty)* CICT.item_cost * :P_Exchange_Rate / :Round_Unit ) * :Round_Unit RCV_VALUE, ROUND( SUM(CIQT.rollback_qty)* CICT.item_cost * :P_Exchange_Rate / :Round_Unit ) * :Round_Unit IT_VALUE, ROUND(SUM(CIQT.rollback_qty),:P_Qty_Precision) IT_QTY FROM cst_inv_qty_temp CIQT, cst_inv_cost_temp CICT, mtl_system_items_vl MSI, mtl_categories MC WHERE CIQT.qty_source in (9,10) AND CICT.cost_source in (3,4) AND CICT.organization_id = CIQT.organization_id AND CICT.inventory_item_id = CIQT.inventory_item_id AND CICT.rcv_transaction_id = CIQT.rcv_transaction_id AND MSI.organization_id = CIQT.organization_id AND MSI.inventory_item_id = CIQT.inventory_item_id AND MC.category_id = CIQT.category_id GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE'), MSI.description, MSI.primary_uom_code, CICT.item_cost HAVING SUM(CIQT.rollback_qty) <> 0 order by 3,1 Y BOM CSTRAIVR_XML AR CST تقرير قيمة كل المخازن (تنسيق XML) Imported from BI Publisher Description: تقرير قيمة كل المخازن Application: شجرة المنتجات Source: تقرير قيمة كل المخازن (تنسيق XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG D CST Lagerbestandsbewertung Imported from BI Publisher Description: Lagerbestandsbewertung Application: Produktionsdaten Source: Lagerbestandsbewertung (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG E CST Valor de Todos los Inventarios Imported from BI Publisher Description: Informe de valor de todos los inventarios Application: Bills of Material Source: Valor de Todos los Inventarios (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG F CST Etat des stocks valorisés par type de coût Imported from BI Publisher Description: Etat des stocks valorisés par type de coût Application: Bills of Material Source: Etat des stocks valorisés par type de coût (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG I CST Rapporto Valore di tutti i magazzini Imported from BI Publisher Description: Rapporto Valore tutti i magazzini Application: Bills of Material Source: Rapporto Valore di tutti i magazzini (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG JA CST 全在庫価額レポート Imported from BI Publisher Description: 全在庫品評価額レポート Application: Bills of Material Source: 全在庫価額レポート(XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG KO CST 모든 재고 금액 보고서 Imported from BI Publisher Description: 모든 재고 금액 보고서 Application: Bills of Material Source: 모든 재고 금액 보고서(XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG PTB CST Relatório de Valor de Todos os Inventários Imported from BI Publisher Description: Relatório de Valor de Todos os Inventários Application: Bills of Material Source: Relatório de Valor de Todos os Inventários (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG RU CST Отчет о стоимости всех запасов Imported from BI Publisher Description: Отчет о стоимости всех запасов Application: Спецификации Source: Отчет о стоимости всех запасов (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG S CST Rapport över värde för alla lager Imported from BI Publisher Description: Rapport över värde för alla lager Application: Bills of Material Source: Rapport över värde för alla lager (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG TR CST Tüm Envanterler Değer Raporu Imported from BI Publisher Description: Tüm Envanterler Değer Raporu Application: Ürün Ağacı Source: Tüm Envanterler Değer Raporu (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG US CST All Inventories Value Imported from BI Publisher Description: All Inventories Value Report Application: Bills of Material Source: All Inventories Value Report (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG ZHS CST 所有库存值报表 Imported from BI Publisher Description: 所有库存值报表 Application: 物料清单管理系统 Source: 所有库存值报表 (XML) Short Name: CSTRAIVR_XML DB package: BOM_CSTRAIVR_XMLP_PKG BI Publisher 1=1 :p_as_of_date :p_as_of_date1 :p_cat_from :p_cat_num :p_cat_seg :p_cat_set_name :p_cat_to :p_cat_where :p_category_set :p_conc_request_id :p_cost_org_id :p_cost_type :p_cost_type_id :p_currency_code :p_currency_dsp :p_def_cost_type :p_detail_level :p_exchange_rate :p_exchange_rate_char :p_exp_item :p_exp_subinv :p_ext_prec :p_gl_num :p_item_from :p_item_seg :p_item_to :p_item_where :p_neg_qty :p_org_id :p_organization :p_qty_precision :p_qty_where :p_rpt_mode :p_sort_by :p_sort_option :p_title :p_trace :p_view_cost :p_zero_cost :round_unit 1 -90 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y US Organization Id Organization Id 2 -80 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') Y US Chart of Accounts Id Chart of Accounts Id 3 -70 :p_cat_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set Y US Category Structure Category Structure 4 -60 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y US CST_SRS_INVERSE_RATE Display Inverse Rate 5 -50 :p_rate_type Number 2 Y US CST_SRS_RATE_TYPE Exchange Rate Type 6 -40 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') US Quantity Precision Quantity Precision 7 -30 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') US View Cost Privilege View Cost Privilege 8 -20 :p_trace Char fnd_profile.value('MRP_TRACE') US Trace Mode Trace Mode 9 -10 :debugflag Char N US DebugFlag DebugFlag 10 10 :p_title Char US Title Title 11 20 :p_cost_type_id LOV Oracle CST_SRS_INV_COST_TYPE Y select cct.cost_type_id id, cct.cost_type value, cct.description description from cst_cost_types cct,mtl_parameters mp where nvl(cct.organization_id,fnd_profile.value('MFG_ORGANIZATION_ID'))= fnd_profile.value('MFG_ORGANIZATION_ID') and nvl(cct.disable_date,sysdate+1)>sysdate and mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and ((cct.cost_type_id=mp.primary_cost_method) or (cct.cost_type_id) not in (1,2,5,6)) order by cost_type SELECT COST_TYPE FROM CST_COST_TYPES WHERE COST_TYPE_ID = (SELECT PRIMARY_COST_METHOD FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID')) and cost_type_id <> 2 Y US Cost Type Cost Type 12 30 :p_sort_option LOV Oracle CST_SRS_ITEMCAT_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_ITEM_REPORT_SORT' and lookup_code in (1,2) order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT' AND LOOKUP_CODE = 1 Y US Sort Option Sort Option 13 40 :p_rpt_mode LOV Oracle CST_SRS_AIVR_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_AIVR_OPTION' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_AIVR_OPTION' AND LOOKUP_CODE = 1 Y US Report Option Report Option 14 50 :p_as_of_date DateTime select fnd_date.date_to_displaydt(sysdate) from dual Y US As of Date As of Date 15 60 :p_item_from Char US Item From Item from 16 70 :p_item_to Char US Item To Item to 17 80 :p_category_set LOV Oracle CST_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets where mult_item_cat_assign_flag='N' order by value,description SELECT CATEGORY_SET_NAME FROM MTL_CATEGORY_SETS A, MTL_DEFAULT_CATEGORY_SETS B WHERE B.FUNCTIONAL_AREA_ID = 5 AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID Y US Category Set Category set 18 90 :p_cat_from Char US Category From Category From 19 100 :p_cat_to Char US Category To Category To 20 110 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT CURRENCY_CODE FROM GL_SETS_OF_BOOKS SOB, ORG_ORGANIZATION_DEFINITIONS OOD WHERE OOD.ORGANIZATION_ID = fnd_profile.value('MFG_ORGANIZATION_ID') AND SOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID Y US Currency Currency 21 120 :p_exchange_rate_char LOV Oracle CST_SRS_EXCHANGE_RATE_C Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=fnd_profile.value('MFG_ORGANIZATION_ID') and code=:$flex$.cst_srs_currency_code and inverse=:$flex$.cst_srs_inverse_rate and rate_type=:$flex$.cst_srs_rate_type order by period_year desc,period_num desc Y US Exchange Rate Exchange Rate 22 130 :p_zero_cost LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=2 Y US Display Zero Costs Only Display zero cost only 23 140 :p_exp_item LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='SYS_YES_NO' AND LOOKUP_CODE=2 Y US Include Expense Items Include expense items 24 150 :p_exp_subinv LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'SYS_YES_NO' AND LOOKUP_CODE = 2 Y US Include Expense Subinventories Include Expense Subinventories :$flex$.category_set Category Set Category Structure :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate