ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8651A9E05362FB09050512Y SELECT null Category , null Item_Number , MSI.description Description , MSI.primary_uom_code Primary_Uom_Code , MSI.invoiceable_item_flag Invoiceable_Item_Flag , MSI.shippable_item_flag Shippable_Item_Flag , decode( :P_CUST_OPT, 1, bill_to_customer_name, 2, sold_to_customer_name, 3, ship_to_customer_name, sold_to_customer_name ) Cust_Name , SOT.name Order_Type , DECODE( :P_sort_option, 4, temp.order_number, NULL ) Order_Num_Sort , DECODE( :P_sort_option, 4, decode( :P_CUST_OPT, 1, bill_to_customer_name, 2, sold_to_customer_name, 3, ship_to_customer_name, sold_to_customer_name ), NULL ) Customer_Sort , temp.order_number Order_Num , temp.parent_line_number Line_Num , decode( temp.origin, 1, 'ORDER', 2, 'RMA', 3, 'CR-MEMO' ) Origin , decode( origin, 2, rma_number, 3, temp. cr_trx_id, NULL ) rma_invoice_number , decode( origin, 2, rma_line_number, 3, temp. cr_trx_line_id, NULL ) Rma_Invoice_Line_Number , NVL( SUM( NVL(temp.invoice_quantity,0) ), 0 ) Invoice_Qty , NVL( SUM( NVL(temp.ship_quantity,0) ), 0 ) Ship_Qty , ROUND( SUM( NVL( temp.invoiced_amount, 0 ) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit Sales_Amount , ROUND( SUM( NVL(&p_sql_select_cost_type,0) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit Cogs_Amount , ((ROUND( SUM( NVL( temp.invoiced_amount, 0 ) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit) - (ROUND( SUM( NVL(&p_sql_select_cost_type,0) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit)) Margin_Amount , decode(SUM( NVL( temp.invoiced_amount, 0 ) ),0,0,ROUND((((SUM( NVL( temp.invoiced_amount, 0 ) )) - (SUM( NVL(&p_sql_select_cost_type,0) ))) / SUM( NVL( temp.invoiced_amount, 0 ) ))* :P_exchange_rate / :P_round_unit ) * :P_round_unit ) ORDER_MARGIN_PCT ,msi2.concatenated_segments config_item, --BOM_CSTROMMA_XMLP_PKG.order_margin_pctformula(:ORDER_SALES, :ORDER_MARGIN) ORDER_MARGIN_PCT, --BOM_CSTROMMA_XMLP_PKG.order_sales1formula(:ORDER_SALES, :ORDER_MARGIN_PCT) ORDER_SALES1, --BOM_CSTROMMA_XMLP_PKG.order_cogs1formula(:ORDER_COGS, :ORDER_MARGIN_PCT) ORDER_COGS1, --BOM_CSTROMMA_XMLP_PKG.order_margin1formula(:ORDER_MARGIN, :ORDER_MARGIN_PCT) ORDER_MARGIN1, --BOM_CSTROMMA_XMLP_PKG.itemcatformula(CATEGORY, :CATEGORY_SEGMENT, :CATEGORY_PSEG) ITEMCAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_pseg', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') CATEGORY_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY_SEGMENT, --BOM_CSTROMMA_XMLP_PKG.cat_margin_pctformula(:CAT_SALES, :CAT_MARGIN) CAT_MARGIN_PCT, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') ITEM_PSEG, 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_SEGMENT --BOM_CSTROMMA_XMLP_PKG.item_sales1formula(:ITEM_SALES, :ITEM_MARGIN_PCT) ITEM_SALES1, --BOM_CSTROMMA_XMLP_PKG.item_cogs1formula(:ITEM_COGS, :ITEM_MARGIN_PCT) ITEM_COGS1, --BOM_CSTROMMA_XMLP_PKG.item_margin1formula(:ITEM_MARGIN, :ITEM_MARGIN_PCT) ITEM_MARGIN1, --BOM_CSTROMMA_XMLP_PKG.item_margin_pctformula(:ITEM_SALES, :ITEM_MARGIN) ITEM_MARGIN_PCT, --BOM_CSTROMMA_XMLP_PKG.avg_unit_priceformula(:ITEM_INVOICE_QTY, :ITEM_SALES) AVG_UNIT_PRICE, --BOM_CSTROMMA_XMLP_PKG.avg_unit_costformula(:ITEM_SHIP_QTY, :ITEM_COGS) AVG_UNIT_COST, --BOM_CSTROMMA_XMLP_PKG.config_item_marginformula(:CONFIG_ITEM_SALES_AMOUNT, :CONFIG_ITEM_COGS_AMOUNT) CONFIG_ITEM_MARGIN, --BOM_CSTROMMA_XMLP_PKG.config_item_margin_pctformula(:CONFIG_ITEM_SALES_AMOUNT, :CONFIG_ITEM_MARGIN) CONFIG_ITEM_MARGIN_PCT, --BOM_CSTROMMA_XMLP_PKG.marginformula(:TOTAL_SALES_AMOUNT, :TOTAL_COGS_AMOUNT) MARGIN, --BOM_CSTROMMA_XMLP_PKG.margin_pctformula(:TOTAL_SALES_AMOUNT, :MARGIN) MARGIN_PCT FROM CST_MARGIN_SUMMARY TEMP &p_sql_from_cost_type , mtl_categories MC , mtl_item_categories MIC , mtl_system_items MSI , mtl_system_items_kfv msi2 , oe_order_lines_all oola , so_order_types_all SOT WHERE oola.item_type_code = 'CONFIG' AND temp.parent_line_id = oola.top_model_line_id AND NVL(temp.parent_ato_flag,'N')='Y' AND :P_CONFIG_ITEM_DETAILS = 1 AND oola.header_id = temp.header_id AND msi2. inventory_item_id = oola.inventory_item_id AND msi2.organization_id = :P_master_org_id AND temp.legal_entity_id >= 0 and &p_sql_where_cost_type and decode(:p_multi_org_flag, 'Y', temp.org_id, 999) = decode(:p_multi_org_flag, 'Y', :p_operating_unit, 999) AND decode(:p_multi_org_flag, 'Y', NVL( SOT.org_id(+), -999 ), 999) = decode(:p_multi_org_flag, 'Y', NVL( :P_Operating_Unit, NVL( sot.org_id(+), -999 ) ), 999) AND SOT.order_type_id( + ) = temp.order_type_id AND MSI.organization_id = :P_master_org_id AND MSI.inventory_item_id = temp.parent_inventory_item_id AND MIC.category_set_id = :P_category_set AND MIC.organization_id = MSI.organization_id AND MIC.inventory_item_id = MSI.inventory_item_id AND MC.category_id = MIC.category_id AND NVL( temp.ORDER_NUMBER, -999 ) = NVL( :P_ORDER_NUMBER, NVL( temp.ORDER_NUMBER, -999 ) ) AND NVL( primary_salesrep_id, -999 ) = NVL( :P_salesrep, NVL( primary_salesrep_id, -999 ) ) AND NVL( temp.customer_id, -999 ) = NVL( :P_customer, NVL( temp.customer_id, -999 ) ) AND NVL( temp.sales_channel_code, -999 ) = NVL( :P_Sales_Channel_Code, NVL( temp.sales_channel_code, -999 ) ) AND NVL( customer_class_code, -999 ) = NVL( :P_Class_Code, NVL( customer_class_code, -999 ) ) AND NVL( temp.territory_id, -999 ) = NVL( :P_Territory_Id, NVL( temp.territory_id, -999 ) ) AND TRUNC(temp.gl_date) between NVL(:lP_date_from ,temp.gl_date-1) and NVL(:lP_date_to,temp.gl_date+1) AND &P_item_where AND &P_cat_where GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('category_pseg', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') , MSI.description , MSI.primary_uom_code , MSI.invoiceable_item_flag , MSI.shippable_item_flag , decode( :P_CUST_OPT, 1, bill_to_customer_name, 2, sold_to_customer_name, 3, ship_to_customer_name, sold_to_customer_name ) , SOT.name , temp.order_number , msi2.concatenated_segments , temp.parent_line_number , temp.origin , decode( origin, 2, rma_number, 3, temp. cr_trx_id, NULL ) , decode( origin, 2, rma_line_number, 3, temp. cr_trx_line_id, NULL ) having &P_RANGE_WHERE UNION SELECT null Category , null Item_Number , MSI.description Description , MSI.primary_uom_code Primary_Uom_Code , MSI.invoiceable_item_flag Invoiceable_Item_Flag , MSI.shippable_item_flag Shippable_Item_Flag , decode( :P_CUST_OPT, 1, bill_to_customer_name, 2, sold_to_customer_name, 3, ship_to_customer_name, sold_to_customer_name ) Cust_Name , SOT.name Order_Type , DECODE( :P_sort_option, 4, temp.order_number, NULL ) Order_Num_Sort , DECODE( :P_sort_option, 4, decode( :P_CUST_OPT, 1, bill_to_customer_name, 2, sold_to_customer_name, 3, ship_to_customer_name, sold_to_customer_name ), NULL ) Customer_Sort , temp.order_number Order_Num , temp.parent_line_number Line_Num , decode( temp.origin, 1, 'ORDER', 2, 'RMA', 3, 'CR-MEMO' ) Origin , decode( origin, 2, rma_number, 3, temp. cr_trx_id, NULL ) rma_invoice_number , decode( origin, 2, rma_line_number, 3, temp. cr_trx_line_id, NULL ) Rma_Invoice_Line_Number , NVL( SUM( NVL(temp.invoice_quantity,0) ), 0 ) Invoice_Qty , NVL( SUM( NVL(temp.ship_quantity ,0)), 0 ) Ship_Qty , ROUND( SUM( NVL( temp.invoiced_amount, 0 ) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit Sales_Amount , ROUND( SUM( NVL(&p_sql_select_cost_type,0) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit Cogs_Amount , ((ROUND( SUM( NVL( temp.invoiced_amount, 0 ) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit) - (ROUND( SUM( NVL(&p_sql_select_cost_type,0) ) * :P_exchange_rate / :P_round_unit ) * :P_round_unit)) Margin_Amount , decode(SUM( NVL( temp.invoiced_amount, 0 ) ),0,0,ROUND((((SUM( NVL( temp.invoiced_amount, 0 ) )) - (SUM( NVL(&p_sql_select_cost_type,0) ))) / SUM( NVL( temp.invoiced_amount, 0 ) ))* :P_exchange_rate / :P_round_unit ) * :P_round_unit ) ORDER_MARGIN_PCT ,NULL config_item, --BOM_CSTROMMA_XMLP_PKG.order_margin_pctformula(:ORDER_SALES, :ORDER_MARGIN) ORDER_MARGIN_PCT, --BOM_CSTROMMA_XMLP_PKG.order_sales1formula(:ORDER_SALES, :ORDER_MARGIN_PCT) ORDER_SALES1, --BOM_CSTROMMA_XMLP_PKG.order_cogs1formula(:ORDER_COGS, :ORDER_MARGIN_PCT) ORDER_COGS1, --BOM_CSTROMMA_XMLP_PKG.order_margin1formula(:ORDER_MARGIN, :ORDER_MARGIN_PCT) ORDER_MARGIN1, --BOM_CSTROMMA_XMLP_PKG.itemcatformula(CATEGORY, :CATEGORY_SEGMENT, :CATEGORY_PSEG) ITEMCAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_pseg', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') CATEGORY_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') CATEGORY_SEGMENT, --BOM_CSTROMMA_XMLP_PKG.cat_margin_pctformula(:CAT_SALES, :CAT_MARGIN) CAT_MARGIN_PCT, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') ITEM_PSEG, 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_SEGMENT --BOM_CSTROMMA_XMLP_PKG.item_sales1formula(:ITEM_SALES, :ITEM_MARGIN_PCT) ITEM_SALES1, --BOM_CSTROMMA_XMLP_PKG.item_cogs1formula(:ITEM_COGS, :ITEM_MARGIN_PCT) ITEM_COGS1, --BOM_CSTROMMA_XMLP_PKG.item_margin1formula(:ITEM_MARGIN, :ITEM_MARGIN_PCT) ITEM_MARGIN1, --BOM_CSTROMMA_XMLP_PKG.item_margin_pctformula(:ITEM_SALES, :ITEM_MARGIN) ITEM_MARGIN_PCT, --BOM_CSTROMMA_XMLP_PKG.avg_unit_priceformula(:ITEM_INVOICE_QTY, :ITEM_SALES) AVG_UNIT_PRICE, --BOM_CSTROMMA_XMLP_PKG.avg_unit_costformula(:ITEM_SHIP_QTY, :ITEM_COGS) AVG_UNIT_COST, --BOM_CSTROMMA_XMLP_PKG.config_item_marginformula(:CONFIG_ITEM_SALES_AMOUNT, :CONFIG_ITEM_COGS_AMOUNT) CONFIG_ITEM_MARGIN, --BOM_CSTROMMA_XMLP_PKG.config_item_margin_pctformula(:CONFIG_ITEM_SALES_AMOUNT, :CONFIG_ITEM_MARGIN) CONFIG_ITEM_MARGIN_PCT, --BOM_CSTROMMA_XMLP_PKG.marginformula(:TOTAL_SALES_AMOUNT, :TOTAL_COGS_AMOUNT) MARGIN, --BOM_CSTROMMA_XMLP_PKG.margin_pctformula(:TOTAL_SALES_AMOUNT, :MARGIN) MARGIN_PCT FROM CST_MARGIN_SUMMARY TEMP &p_sql_from_cost_type , mtl_categories MC , mtl_item_categories MIC , mtl_system_items MSI , so_order_types_all SOT WHERE temp.legal_entity_id >= 0 AND ( ( ( NVL(temp.parent_ato_flag,'N') <> 'Y' OR temp.parent_item_type_code <> 'MODEL' ) AND NVL(:P_CONFIG_ITEM_DETAILS,2)=1 ) OR NVL(:P_CONFIG_ITEM_DETAILS,2)=2 ) and &p_sql_where_cost_type and decode(:p_multi_org_flag, 'Y', temp.org_id, 999) = decode(:p_multi_org_flag, 'Y', :p_operating_unit, 999) AND decode(:p_multi_org_flag, 'Y', NVL( SOT.org_id(+), -999 ), 999) = decode(:p_multi_org_flag, 'Y', NVL( :P_Operating_Unit, NVL( sot.org_id(+), -999 ) ), 999) AND SOT.order_type_id( + ) = temp.order_type_id AND MSI.organization_id = :P_master_org_id AND MSI.inventory_item_id = temp.parent_inventory_item_id AND MIC.category_set_id = :P_category_set AND MIC.organization_id = MSI.organization_id AND MIC.inventory_item_id = MSI.inventory_item_id AND MC.category_id = MIC.category_id AND NVL( temp.ORDER_NUMBER, -999 ) = NVL( :P_ORDER_NUMBER, NVL( temp.ORDER_NUMBER, -999 ) ) AND NVL( primary_salesrep_id, -999 ) = NVL( :P_salesrep, NVL( primary_salesrep_id, -999 ) ) AND NVL( temp.customer_id, -999 ) = NVL( :P_customer, NVL( temp.customer_id, -999 ) ) AND NVL( temp.sales_channel_code, -999 ) = NVL( :P_Sales_Channel_Code, NVL( temp.sales_channel_code, -999 ) ) AND NVL( customer_class_code, -999 ) = NVL( :P_Class_Code, NVL( customer_class_code, -999 ) ) AND NVL( temp.territory_id, -999 ) = NVL( :P_Territory_Id, NVL( temp.territory_id, -999 ) ) AND TRUNC(temp.gl_date) between NVL(:lP_date_from,temp.gl_date-1) and NVL(:lP_date_to,temp.gl_date+1) AND &P_item_where AND &P_cat_where GROUP BY fnd_flex_xml_publisher_apis.process_kff_combination_1('category_pseg', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') , MSI.description , MSI.primary_uom_code , MSI.invoiceable_item_flag , MSI.shippable_item_flag , decode( :P_CUST_OPT, 1, bill_to_customer_name, 2, sold_to_customer_name, 3, ship_to_customer_name, sold_to_customer_name ) , SOT.name , temp.order_number , temp.parent_line_number , temp.origin , decode( origin, 2, rma_number, 3, temp. cr_trx_id, NULL ) , decode( origin, 2, rma_line_number, 3, temp. cr_trx_line_id, NULL ) having &P_RANGE_WHERE BOM CSTROMMA_XML AR CST تقرير تحليل الهامش بإدارة الطلبات (تنسيق XML) Imported from BI Publisher Description: تقرير تحليل الهامش Application: شجرة المنتجات Source: تقرير تحليل الهامش بإدارة الطلبات (تنسيق XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG D CST Bruttoergebnis vom Umsatz in Oracle Order Management Imported from BI Publisher Description: Bruttoergebnis vom Umsatz Application: Produktionsdaten Source: Bruttoergebnis vom Umsatz in Oracle Order Management (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG E CST Análisis de Márgenes con Gestión de Pedidos Imported from BI Publisher Description: Informe de análisis de márgenes Application: Bills of Material Source: Análisis de Márgenes con Gestión de Pedidos (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG F CST Analyse des marges avec gestion des commandes Imported from BI Publisher Description: Etat Analyse des marges Application: Bills of Material Source: Analyse des marges avec gestion des commandes (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG I CST Rapporto Analisi del margine con Order Management Imported from BI Publisher Description: Rapporto Analisi del margine Application: Bills of Material Source: Rapporto Analisi del margine con Order Management (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG JA CST 受注管理マージン分析レポート Imported from BI Publisher Description: マージン分析レポート Application: Bills of Material Source: 受注管理マージン分析レポート(XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG KO CST Order Management를 사용한 마진 분석 보고서 Imported from BI Publisher Description: 마진 분석 보고서 Application: Bills of Material Source: Order Management를 사용한 마진 분석 보고서(XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG PTB CST Relatório de Análise de Margem com Order Management Imported from BI Publisher Description: Relatório de Análise de Margem Application: Bills of Material Source: Relatório de Análise de Margem com Order Management (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG RU CST Отчет об анализе прибыли для Управления заказами Imported from BI Publisher Description: Отчет об анализе прибыли Application: Спецификации Source: Отчет об анализе прибыли для Управления заказами (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG S CST Marginalanalysrapport för Order Management Imported from BI Publisher Description: Marginalanalysrapport Application: Bills of Material Source: Marginalanalysrapport för Order Management (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG TR CST Sipariş Yönetimi'yle Marj Analizi Raporu Imported from BI Publisher Description: Marj Analizi Raporu Application: Ürün Ağacı Source: Sipariş Yönetimi'yle Marj Analizi Raporu (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG US CST Margin Analysis Report with Order Management Imported from BI Publisher Description: Margin Analysis Report Application: Bills of Material Source: Margin Analysis Report with Order Management (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG ZHS CST 具有订单管理的利润分析报表 Imported from BI Publisher Description: 利润分析报表 Application: 物料清单管理系统 Source: 具有订单管理的利润分析报表 (XML) Short Name: CSTROMMA_XML DB package: BOM_CSTROMMA_XMLP_PKG BI Publisher &p_cat_where &p_item_where &p_range_where &p_sql_from_cost_type &p_sql_select_cost_type &p_sql_where_cost_type :lp_currency_code :lp_date_from :lp_date_to :operating_unit :p_cat_from :p_cat_num :p_cat_seg :p_cat_set_name :p_cat_to :p_cat_where :p_category_set :p_class :p_class_code :p_conc_request_id :p_config_item_details :p_config_item_dtls_opts :p_context :p_cost_org_id :p_cost_type :p_cost_type_id :p_currency_code :p_currency_dsp :p_cust_opt :p_cust_opt_dsp :p_customer :p_customer_name :p_date_from :p_date_to :p_def_cost_type :p_detail_dummy :p_exchange_rate :p_ext_prec :p_header_id :p_item_cogs :p_item_cost_column :p_item_cost_table :p_item_cost_where :p_item_from :p_item_seg :p_item_to :p_item_where :p_master_org_id :p_multi_org_flag :p_operating_unit :p_operating_unit_name :p_order_number :p_organization :p_pct_from :p_pct_from_v :p_pct_to :p_pct_to_v :p_profile :p_qty_precision :p_range_where :p_round_unit :p_rpt_opt_dsp :p_rpt_option :p_sales_channel :p_sales_channel_code :p_salesrep :p_salesrep_name :p_sort_by :p_sort_option :p_sql_from_cost_type :p_sql_select_cost_type :p_sql_where_cost_type :p_territory :p_territory_id :p_trace :p_view_cost :qty :qty_v 1 -80 :p_operating_unit LOV Oracle CST_SRS_OPERATING_UNIT_MOAC Y select organization_id id, organization_id value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by value,description select MO_GLOBAL.get_current_org_id from dual Y AR وحدة التشغيل وحدة التشغيل D Betriebseinheit Betriebseinheit E Unidad Operativa Unidad Operativa F Unité opérationnelle Unité opérationnelle I Unità operativa Unità operativa JA 営業単位 営業単位 KO 운영 단위 운영 단위 PTB Unidade Operacional Unidade Operacional RU Операционная единица Операционная единица S Operativ enhet Operativ enhet TR Faaliyet Birimi Faaliyet Birimi US Operating Unit Operating Unit ZHS 业务实体 业务实体 2 -70 :p_detail_dummy Char Select decode(:$flex$.report_option,2,NULL,4) from dual AR CST_RPT_DETAILS_DUMMY خيارات التقرير الافتراضية D CST_RPT_DETAILS_DUMMY Auswertungsoption - Dummy E CST_RPT_DETAILS_DUMMY Opciones de Informes Ficticias F CST_RPT_DETAILS_DUMMY Options d'édition fictives I CST_RPT_DETAILS_DUMMY Opzioni rapporto (fittizio) JA CST_RPT_DETAILS_DUMMY レポート・オプション・ダミー KO CST_RPT_DETAILS_DUMMY 보고서 옵션 Dummy PTB CST_RPT_DETAILS_DUMMY Opções do Relatório - Fictício RU CST_RPT_DETAILS_DUMMY Параметры отчета (фиктивные) S CST_RPT_DETAILS_DUMMY Dummy-rapportalternativ TR CST_RPT_DETAILS_DUMMY Rapor Seçenekleri Sözde Değeri US CST_RPT_DETAILS_DUMMY Report Options Dummy ZHS CST_RPT_DETAILS_DUMMY 报表虚拟选项 3 -60 :p_cat_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set 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 类别结构 类别结构 4 -50 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE عرض السعر العكسي D CST_SRS_INVERSE_RATE Gegenkurs anzeigen E CST_SRS_INVERSE_RATE Visualizar Tipo de Cambio Inverso F CST_SRS_INVERSE_RATE Afficher taux inverse I CST_SRS_INVERSE_RATE Visualizza tasso inverso JA CST_SRS_INVERSE_RATE 逆数レートの表示 KO CST_SRS_INVERSE_RATE 역산율 표시 PTB CST_SRS_INVERSE_RATE Exibir Taxa de Inversão RU CST_SRS_INVERSE_RATE Вывод обратного курса S CST_SRS_INVERSE_RATE Visa inverterad kurs TR CST_SRS_INVERSE_RATE Ters Kuru Görüntüle US CST_SRS_INVERSE_RATE Display Inverse Rate ZHS CST_SRS_INVERSE_RATE 显示逆汇率 5 -40 :p_rate_type Number 2 Y AR CST_SRS_RATE_TYPE نوع السعر D CST_SRS_RATE_TYPE Kursart E CST_SRS_RATE_TYPE Clase de Tipo de Cambio F CST_SRS_RATE_TYPE Type de taux I CST_SRS_RATE_TYPE Tipo di tasso JA CST_SRS_RATE_TYPE レート・タイプ KO CST_SRS_RATE_TYPE 세율 유형 PTB CST_SRS_RATE_TYPE Tipo de Taxa RU CST_SRS_RATE_TYPE Тип курса S CST_SRS_RATE_TYPE Kurstyp TR CST_SRS_RATE_TYPE Kur Tipi US CST_SRS_RATE_TYPE Rate Type ZHS CST_SRS_RATE_TYPE 汇率类型 6 -30 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') AR دقة الكمية دقة الكمية D Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점 이하 자리수 수량 소수점 이하 자리수 PTB Precisão da Quantidade Precisão da Quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar Duyarlılığı US Quantity Precision Quantity Precision ZHS 数量精确度 数量精确度 7 -20 :p_trace Char fnd_profile.value('MRP_TRACE') AR طور التتبع طور التتبع D Trace-Modus Trace-Modus E Modo de Rastreo Modo de rastreo F Mode Trace Mode Trace I Modalità Traccia Modalità Traccia JA トレース・モード トレース・モード KO 추적 모드 추적 모드 PTB Modo de Rastreamento Modo de Rastreamento RU Режим трассировки Режим трассировки S Spårningsläge Spårningsläge TR İzleme Modu İzleme Modu US Trace Mode Trace Mode ZHS 跟踪模式 跟踪模式 8 10 :p_rpt_option LOV Oracle CST_SRS_RPT_DETAIL_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_RPT_DETAIL_OPTION' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_BICR_DETAIL_OPTION' AND LOOKUP_CODE = 2 Y AR خيار التقرير خيار التقرير D Auswertungsoption Auswertungsoption E Opción de Informe Opción de Informe F Option d'édition Option d'édition I Opzione rapporto Opzione rapporto JA レポート・オプション レポート・オプション KO 보고서 옵션 보고서 옵션 PTB Opção de Relatório Opção de Relatório RU Параметр отчета Параметр отчета S Rapportalternativ Rapportalternativ TR Rapor Seçeneği Rapor Seçeneği US Report Option Report Option ZHS 报表选项 报表选项 9 20 :p_config_item_details LOV Oracle CST_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' and :$flex$.cst_rpt_details_dummy is not null order by value,description Select meaning from mfg_lookups where lookup_type='SYS_YES_NO' and lookup_code=2 and :$FLEX$.CST_RPT_DETAILS_DUMMY IS NOT NULL Y AR تفاصيل صنف التركيب تفاصيل صنف التركيب D Details Konfigurationsartikel Details Konfigurationsartikel E Detalles de Artículos de Configuración Detalles de Artículos de Configuración F Détails d'article configuré Détails d'article configuré I Dettagli articolo di configurazione Dettagli articolo di configurazione JA 構成品目詳細 構成品目詳細 KO 사양구성 품목 상세내역 사양구성 품목 상세내역 PTB Detalhes do Item de Configuração Detalhes do Item de Configuração RU Сведения о позиции конфигурации Сведения о позиции конфигурации S Konfigurationsartikeldetaljer Konfigurationsartikeldetaljer TR Konfigürasyon Kalemi Detayları Konfigürasyon Kalemi Detayları US Configuration Item Details Configuration Item Details ZHS 配置项详细信息 配置项详细信息 10 30 :p_sort_option LOV Oracle CST_SRS_MARGIN_RPT_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,4) and not (lookup_code=4 and :$flex$.cst_srs_rpt_detail_option=1 ) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_ITEM_REPORT_SORT' AND LOOKUP_CODE = 1 Y AR خيار الفرز خيار الفرز D Sortieroption Sortieroption E Opción de Clasificación Opción de Clasificación F Option de tri Option de tri I Opzione di ordinamento Opzione di ordinamento JA ソート・オプション ソート・オプション KO 정렬 옵션 정렬 옵션 PTB Opção de Classificação Opção de Classificação RU Параметр сортировки Параметр сортировки S Sorteringsalternativ Sorteringsalternativ TR Sıralama Seçeneği Sıralama Seçeneği US Sort Option Sort Option ZHS 排序选项 排序选项 11 40 :p_header_id LOV Oracle CST_SRS_MARGIN_ORDER_NUM Y Y select header_id id, order_number value, null description from oe_order_headers_all sh where header_id= (select min(sh2.header_id) from oe_order_headers_all sh2 where sh2.order_number=sh.order_number and nvl(sh2.org_id,-999)= nvl(:$flex$.cst_srs_margin_org_id:null,nvl(sh2.org_id,-999)) ) order by value,description AR رقم الطلب رقم الطلب D Auftragsnummer Auftragsnummer E Número de Pedido Número de Pedido F Numéro de commande Numéro de commande I Numero ordine Numero ordine JA 受注番号 受注番号 KO 주문 번호 주문 번호 PTB Nr. da Ordem Nr. da Ordem RU Номер заказа Номер заказа S Ordernummer Ordernummer TR Sipariş Numarası Sipariş Numarası US Order Number Order Number ZHS 订单编号 订单编号 12 50 :p_item_from Char AR الصنف من الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR Kalem, İlk Kalem, İlk US Item From Item From ZHS 物料自 物料自 13 60 :p_item_to Char AR الصنف إلى الصنف إلى D Bis Artikel Bis Artikel E A Artículo A Artículo F Article - A Article - A I Articolo - A Articolo - A JA 品目:至 品目:至 KO 품목: 까지 품목: 까지 PTB Item - Até Item - Até RU Позиция по Позиция по S Till artikel Till artikel TR Kalem, Son Kalem, Son US Item To Item To ZHS 物料至 物料至 14 70 :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.CATEGORY_SET_ID = A.CATEGORY_SET_ID AND B.FUNCTIONAL_AREA_ID = 5 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 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 类别集 类别集 15 80 :p_cat_from Char AR الفئة من الفئة من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégorie - De Catégorie - De I Categoria - Da Categoria - Da JA カテゴリ:自 カテゴリ:自 KO 범주 From 범주 From PTB Categoria - De Categoria - De RU Категория с Категория с S Från kategori Från kategori TR Kategori, İlk Kategori, İlk US Category From Category From ZHS 类别自 类别自 16 90 :p_cat_to Char AR الفئة إلى الفئة إلى D Bis Kategorie Bis Kategorie E A Categoría A Categoría F Catégorie - A Catégorie - A I Categoria - A Categoria - A JA カテゴリ:至 カテゴリ:至 KO 범주 To 범주 To PTB Categoria - Até Categoria - Até RU Категория по Категория по S Till kategori Till kategori TR Kategori, Son Kategori, Son US Category To Category To ZHS 类别至 类别至 17 100 :p_pct_from Number AR النسبة المئوية الهامشية من النسبة المئوية الهامشية من D Prozentsatz Spanne von Prozentsatz Spanne von E De Porcentaje de Margen De Porcentaje de Margen F Pourcentage de marge - De Pourcentage de marge - De I Percentuale margine - Da Percentuale margine - Da JA マージン率:自 マージン率:自 KO 마진 퍼센트 From 마진 퍼센트 From PTB Porcentagem Margem - De Porcentagem Margem - De RU Процент прибыли с Процент прибыли с S Från marginal i procent Från marginal i procent TR Marj Yüzdesi: İlk Marj Yüzdesi: İlk US Margin Percentage From Margin Percentage From ZHS 利润百分比自 利润百分比自 18 110 :p_pct_to Number AR النسبة المئوية الهامشية إلى النسبة المئوية الهامشية إلى D Prozentsatz Spanne bis Prozentsatz Spanne bis E A Porcentaje de Margen A Porcentaje de Margen F Pourcent. marge - A Pourcent. marge - A I Percentuale margine - A Percentuale margine - A JA マージン率:至 マージン率:至 KO 마진 퍼센트 To 마진 퍼센트 To PTB Porcentagem Margem - Até Porcentagem Margem - Até RU Процент прибыли по Процент прибыли по S Marginalprocent till Marginalprocent till TR Marj Yüzdesi: Son Marj Yüzdesi: Son US Margin Percentage To Margin Percentage To ZHS 利润百分比至 利润百分比至 19 120 :p_cost_type_id LOV Oracle CST_SRS_MARGIN_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 AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de Custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet Tipi US Cost Type Cost Type ZHS 成本类型 成本类型 20 130 :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 AR العملة العملة D Währung Währung E Divisa Divisa F Devise Devise I Divisa Divisa JA 通貨 通貨 KO 통화 통화 PTB Moeda Moeda RU Валюта Валюта S Valuta Valuta TR Para Birimi Para Birimi US Currency Currency ZHS 币种 币种 21 140 :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 AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa de Câmbio RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz Kuru US Exchange Rate Exchange Rate ZHS 汇率 汇率 22 150 :p_cust_opt LOV Oracle CST_SRS_RA_CUST_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_RA_CUSTOMER_TYPE' order by meaning SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'CST_RA_CUSTOMER_TYPE' AND LOOKUP_CODE = 2 AR نوع العميل نوع العميل D Kundenart Kundenart E Tipo de Cliente Tipo de Cliente F Type de client Type de client I Tipo cliente Tipo di cliente JA 顧客タイプ 顧客タイプ KO 고객 유형 고객 유형 PTB Tipo de Cliente Tipo de Cliente RU Тип заказчика Тип заказчика S Kundtyp Kundtyp TR Müşteri Tipi Müşteri Tipi US Customer Type Customer Type ZHS 客户类型 客户类型 23 160 :p_customer LOV Oracle CST_SRS_RA_CUSTOMERS_NEW Y select cust_acct.cust_account_id id, party.party_name value, null description from hz_parties party,hz_cust_accounts cust_acct where party.party_id=cust_acct.party_id order by party.party_name AR اسم العميل اسم العميل D Kundenname Kundenname E Nombre de Cliente Nombre de Cliente F Nom du client Nom du client I Nome cliente Nome cliente JA 顧客名 顧客名 KO 고객명 고객명 PTB Nome do Cliente Nome do Cliente RU Имя заказчика Имя заказчика S Kund Kund TR Müşteri Adı Müşteri Adı US Customer Name Customer Name ZHS 客户名称 客户名称 24 170 :p_salesrep LOV Oracle CST_SRS_MARGIN_SALESREPS Y select salesrep_id id, name value, null description from ra_salesreps_all where nvl(org_id,-999)= nvl(:$flex$.cst_srs_margin_org_id:null,nvl(org_id,-999)) order by name AR مندوب المبيعات مندوب المبيعات D Vertriebsmitarbeiter Vertriebsmitarbeiter E Vendedor Vendedor F Vendeur Vendeur I Rappresentante commerciale Rappresentante commerciale JA 営業担当 営業担当 KO 영업사원 영업사원 PTB Representante de Vendas Representante de Vendas RU Продавец Продавец S Säljare Säljare TR Satış Temsilcisi Satış Temsilcisi US Sales Representative Sales Representative ZHS 销售代表 销售代表 25 180 :p_sales_channel_code LOV Oracle CST_SRS_MARGIN_SALES_CHANNEL Y select lookup_code id, meaning value, null description from so_lookups where lookup_type='SALES_CHANNEL' order by value,description AR قناة البيع قناة البيع D Vertriebsweg Vertriebsweg E Canal de Ventas Canal de Ventas F Canal de ventes Canal de ventes I Canale di vendita Canale di vendita JA 販売チャネル 販売チャネル KO 판매 경로 판매 경로 PTB Canal de Venda Canal de Venda RU Канал продаж Канал продаж S Säljkanal Säljkanal TR Satış Kanalı Satış Kanalı US Sales Channel Sales Channel ZHS 销售渠道 销售渠道 26 190 :p_class_code LOV Oracle CST_SRS_MARGIN_INDUSTRY Y select lookup_code id, meaning value, null description from ar_lookups where lookup_type='CUSTOMER CLASS' order by value,description AR الصناعة الصناعة D Branche Branche E Industria Industria F Domaine d'activité Domaine d'activité I Industria Industria JA 産業 産業 KO 산업 산업 PTB Indústria Indústria RU Отрасль Отрасль S Bransch Bransch TR Endüstri Endüstri US Industry Industry ZHS 行业 行业 27 200 :p_territory_id LOV Oracle CST_SRS_MARGIN_SALES_TERRITORY Y select territory_id id, name value, null description from ra_territories order by value,description AR منطقة البيع منطقة البيع D Verkaufsgebiet Verkaufsgebiet E Territorio de Ventas Territorio de Ventas F Territoire de vente Territoire de vente I Area di vendita Area di vendita JA 販売テリトリ 販売テリトリ KO 영업 영역 영업 영역 PTB Território de Vendas Território de Vendas RU Территория сбыта Территория сбыта S Säljdistrikt Säljdistrikt TR Satış Bölgesi Satış Bölgesi US Sales Territory Sales Territory ZHS 销售地区 销售地区 28 210 :p_date_from Date AR من التاريخ من التاريخ D Von Datum Von Datum E De Fecha De Fecha F Date de début Date de début I Data - Da Data - Da JA 日付:自 日付:自 KO 일자: 부터 일자: 부터 PTB Data - De Data - De RU Начальная дата Начальная дата S Från datum Från datum TR Başlangıç Tarihi Başlangıç Tarihi US From Date From Date ZHS 自日期 自日期 29 220 :p_date_to Date sysdate AR إلى التاريخ إلى التاريخ D Bis Datum Bis Datum E A Fecha A Fecha F Date de fin Date de fin I Data - A Data - A JA 日付:至 日付:至 KO 일자: 까지 일자: 까지 PTB Data - Até Data - Até RU Конечная дата Конечная дата S Till datum Till datum TR Bitiş Tarihi Bitiş Tarihi US To Date To Date ZHS 至日期 至日期 :$FLEX$.CST_RPT_DETAILS_DUMMY CST_RPT_DETAILS_DUMMY Configuration Item Details :$flex$.category_set Category Set Category Structure :$flex$.cst_rpt_details_dummy CST_RPT_DETAILS_DUMMY Configuration Item Details :$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 :$flex$.cst_srs_rpt_detail_option Report Option Sort Option :$flex$.report_option Report Option CST_RPT_DETAILS_DUMMY