ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations C6E085D46F8A51A9E05362FB09050512 with q_ic_main as ( select cpic.cost_group_id, cpic.pac_period_id period_id, decode(:p_sort_option,2 , mc.concatenated_segments,msi.concatenated_segments) ic_order, ccg.cost_group cost_group, msi.inventory_item_id ic_item_id_p, mc.padded_concatenated_segments ic_cat_pseg, msi.padded_concatenated_segments ic_item_pseg, mc.concatenated_segments ic_category_segment, msi.concatenated_segments ic_item_segment, msi.description ic_description, msi.primary_uom_code ic_uom, round(nvl(cpic.total_layer_quantity,0),:p_qty_precision) ic_qty, round((nvl(cpic.item_cost,0)* :p_exchange_rate),:p_ext_prec) ic_unit_cost, round((nvl(cpic.item_cost,0)* :p_exchange_rate),:p_precision) ic_stdunit_cost, nvl(cpic.item_cost,0)*nvl(cpic.total_layer_quantity,0)*:p_exchange_rate ic_total_cost, round((nvl(cpic.material_cost,0)* :p_exchange_rate),:p_ext_prec) ic_matl_cost, round((nvl(cpic.material_overhead_cost,0)* :p_exchange_rate),:p_ext_prec) ic_mo_cost, round((nvl(cpic.resource_cost,0)* :p_exchange_rate),:p_ext_prec) ic_res_cost, round((nvl(cpic.overhead_cost,0)* :p_exchange_rate),:p_ext_prec) ic_ovhd_cost, round((nvl(cpic.outside_processing_cost,0)* :p_exchange_rate),:p_ext_prec) ic_osp_cost, nvl(cpic.material_cost,0)*nvl(cpic.total_layer_quantity,0)*:p_exchange_rate ic_tot_matl_cost, nvl(cpic.material_overhead_cost,0)*nvl(cpic.total_layer_quantity,0)*:p_exchange_rate ic_tot_mo_cost, nvl(cpic.resource_cost,0)*nvl(cpic.total_layer_quantity,0)*:p_exchange_rate ic_tot_res_cost, nvl(cpic.overhead_cost,0)*nvl(cpic.total_layer_quantity,0)*:p_exchange_rate ic_tot_ovhd_cost, nvl(cpic.outside_processing_cost,0)*nvl(cpic.total_layer_quantity,0)*:p_exchange_rate ic_tot_osp_cost, 1 ic_count, bom_cstrpicr_xmlp_pkg.ic_total_cost_rformula(nvl(cpic.item_cost,0) * nvl(cpic.total_layer_quantity,0) * :p_exchange_rate) ic_total_cost_r, bom_cstrpicr_xmlp_pkg.ic_res_cost_rformula(round((nvl(cpic.resource_cost,0) * :p_exchange_rate) , :p_ext_prec)) ic_res_cost_r, bom_cstrpicr_xmlp_pkg.ic_osp_cost_rformula(round((nvl(cpic.outside_processing_cost,0) * :p_exchange_rate),:p_ext_prec)) ic_osp_cost_r, bom_cstrpicr_xmlp_pkg.ic_ovhd_cost_rformula(round((nvl(cpic.overhead_cost,0) * :p_exchange_rate),:p_ext_prec)) ic_ovhd_cost_r, bom_cstrpicr_xmlp_pkg.ic_tot_osp_cost_rformula(nvl(cpic.outside_processing_cost,0) * nvl(cpic.total_layer_quantity,0) * :p_exchange_rate) ic_tot_osp_cost_r, bom_cstrpicr_xmlp_pkg.ic_tot_ovhd_cost_rformula(nvl(cpic.overhead_cost,0) * nvl(cpic.total_layer_quantity,0) * :p_exchange_rate) ic_tot_ovhd_cost_r, bom_cstrpicr_xmlp_pkg.ic_matl_cost_rformula(round((nvl(cpic.material_cost,0) * :p_exchange_rate ), :p_ext_prec)) ic_matl_cost_r, bom_cstrpicr_xmlp_pkg.ic_tot_res_cost_rformula(nvl(cpic.resource_cost,0) * nvl(cpic.total_layer_quantity,0) * :p_exchange_rate) ic_tot_res_cost_r, bom_cstrpicr_xmlp_pkg.ic_mo_cost_rformula(round((nvl( cpic.material_overhead_cost,0) * :p_exchange_rate ),:p_ext_prec)) ic_mo_cost_r, bom_cstrpicr_xmlp_pkg.ic_tot_matl_cost_rformula(nvl(cpic.material_cost,0) * nvl(cpic.total_layer_quantity,0) * :p_exchange_rate) ic_tot_matl_cost_r, bom_cstrpicr_xmlp_pkg.ic_tot_mo_cost_rformula(nvl(cpic.material_overhead_cost,0) * nvl(cpic.total_layer_quantity,0) * :p_exchange_rate) ic_tot_mo_cost_r from mtl_item_categories mic, mtl_categories_kfv mc, mtl_system_items_vl msi, cst_pac_item_costs cpic, cst_cost_groups ccg where 1=1 and cpic.pac_period_id = :p_period_id and cpic.inventory_item_id = mic.inventory_item_id and mic.organization_id = :p_item_master_org_id and mic.category_set_id = :p_category_set and mc.category_id = mic.category_id and msi.inventory_item_id = mic.inventory_item_id and msi.organization_id = mic.organization_id and cpic.cost_group_id = ccg.cost_group_id ), q_ic_rcv as ( select cprvv.cost_group_id, cpp.pac_period_id period_id, cprvv.rcv_transaction_id ic_txn_id, cpp.pac_period_id ic_pac_period, cpp.cost_type_id ic_cost_type, cpp.period_start_date ic_start_date, cpp.period_end_date ic_end_date, msi.segment1 ic_item_num, mic.category_id ic_category, cprvv.receipt_date ic_receipt_date, cprvv.receipt_num ic_receipt_num, cprvv.shipment_num ic_shipment_num, hr.location_code ic_current_location, hr2.location_code ic_deliver_to_location, cprvv.packing_slip ic_packing_slip, pol.displayed_field ic_document_type, cprvv.source_document ic_document_number, cprvv.document_line_num ic_document_line_num, cstppacq.get_net_undel_qty(cprvv.rcv_transaction_id, (cpp.period_end_date + 1 )) ic_quantity, cprvv.acquisition_cost ic_acquisition_cost, cstppacq.get_net_undel_qty(cprvv.rcv_transaction_id, (cpp.period_end_date +1)) *cprvv.acquisition_cost ic_value, cprvv.txn_unit_of_measure ic_uom_code, cprvv.item_revision ic_revision, cprvv.item_description ic_description, msi.inventory_item_id ic_item_id_c, bom_cstrpicr_xmlp_pkg.ic_value_rformula(cstppacq.get_net_undel_qty ( cprvv.rcv_transaction_id , ( cpp.period_end_date + 1 ) ) * cprvv.acquisition_cost) ic_value_r, bom_cstrpicr_xmlp_pkg.ic_acquisition_cost_rformula(cprvv.acquisition_cost) ic_acquisition_cost_r from cst_pac_receiving_values_v cprvv, mtl_system_items msi, mtl_item_categories mic, mtl_categories mc, hr_locations hr, hr_locations hr2, po_lookup_codes pol, cst_pac_periods cpp, po_vendors pov where 2=2 and cprvv.location_id = hr.location_id (+) and cprvv.deliver_to_location_id = hr2.location_id (+) and mic.organization_id(+) = cprvv.txn_organization_id and mic.inventory_item_id(+) = cprvv.item_id and mc.category_id(+) = mic.category_id and pol.lookup_type = 'DOCUMENT TYPE' and pol.lookup_code = cprvv.source_document_code and pov.vendor_id(+) = cprvv.vendor_id and cpp.legal_entity = cprvv.legal_entity and cprvv.transaction_date >= cpp.period_start_date and cprvv.transaction_date < (cpp.period_end_date + 1 ) and msi.inventory_item_id = cprvv.item_id and msi.organization_id = cprvv.txn_organization_id and cpp.pac_period_id = :p_period_id and mic.category_set_id = :p_category_set ) -- -- Main Query Starts Here -- select :p_legal_entity legal_entity, :p_cost_type cost_type, :p_period_name period, :p_currency_dsp currency, :p_exchange_rate exchange_rate, x.cost_group org_cost_group, x.item, x.description, x.category, x.uom, case when x.row_num = 1 then x.onhand_quantity end onhand_quantity, case when x.row_num = 1 then x.onhand_unit_cost end onhand_unit_cost, case when x.row_num = 1 then x.onhand_value end onhand_value, case when x.row_num = 1 then x.rcv_quantity end rcv_quantity, case when x.row_num = 1 then x.rcv_avg_acquisition_cost end rcv_avg_acquisition_cost, case when x.row_num = 1 then x.rcv_value end rcv_value, case when x.row_num = 1 then x.total_value end total_value, -- case when x.row_num = 1 then x.material_cost end material_cost, case when x.row_num = 1 then x.material_value end material_value, case when x.row_num = 1 then x.material_overhead_cost end material_overhead_cost, case when x.row_num = 1 then x.material_overhead_value end material_overhead_value, case when x.row_num = 1 then x.resource_cost end resource_cost, case when x.row_num = 1 then x.resource_value end resource_value, case when x.row_num = 1 then x.outside_processing_cost end outside_processing_cost, case when x.row_num = 1 then x.outside_processing_value end outside_processing_value, case when x.row_num = 1 then x.overhead_cost end overhead_cost, case when x.row_num = 1 then x.overhead_value end overhead_value, case when x.row_num = 1 then x.cost_elements_total_cost end cost_elements_total_cost, case when x.row_num = 1 then x.cost_elements_total_value end cost_elements_total_value, --q_ic_rcv.* x.receipt_date, x.receipt_number, x.shipment_number, x.current_location, x.deliver_to_location, x.packing_slip, x.document_type, x.document_number, x.document_line_number, x.receipt_qty, x.acquisition_cost, x.value, -- x.ic_txn_id, x.item_id, x.row_num item_seq from ( select /*+ push_pred(q_ic_rcv) */ --q_ic_main.*, q_ic_main.cost_group cost_group, q_ic_main.ic_item_segment item, q_ic_main.ic_description description, q_ic_main.ic_category_segment category, q_ic_main.ic_uom uom, q_ic_main.ic_qty onhand_quantity, q_ic_main.ic_stdunit_cost onhand_unit_cost, q_ic_main.ic_total_cost_r onhand_value, sum(q_ic_rcv.ic_quantity) over (partition by q_ic_main.ic_item_id_p) rcv_quantity, avg(q_ic_rcv.ic_acquisition_cost) over (partition by q_ic_main.ic_item_id_p) rcv_avg_acquisition_cost, case when sum(q_ic_rcv.ic_quantity) over (partition by q_ic_main.ic_item_id_p) is not null and avg(q_ic_rcv.ic_acquisition_cost) over (partition by q_ic_main.ic_item_id_p) is not null then round( ( sum(q_ic_rcv.ic_quantity) over (partition by q_ic_main.ic_item_id_p) * avg(q_ic_rcv.ic_acquisition_cost) over (partition by q_ic_main.ic_item_id_p) ) / :round_unit ) * :round_unit end rcv_value, case when sum(q_ic_rcv.ic_quantity) over (partition by q_ic_main.ic_item_id_p) is not null and avg(q_ic_rcv.ic_acquisition_cost) over (partition by q_ic_main.ic_item_id_p) is not null then round( ( ( sum(q_ic_rcv.ic_quantity) over (partition by q_ic_main.ic_item_id_p) * avg(q_ic_rcv.ic_acquisition_cost) over (partition by q_ic_main.ic_item_id_p) ) + q_ic_main.ic_total_cost_r ) / :round_unit ) * :round_unit else round(q_ic_main.ic_total_cost_r / :round_unit) * :round_unit end total_value, -- q_ic_main.ic_matl_cost material_cost, q_ic_main.ic_tot_matl_cost_r material_value, q_ic_main.ic_mo_cost material_overhead_cost, q_ic_main.ic_tot_mo_cost_r material_overhead_value, q_ic_main.ic_res_cost resource_cost, q_ic_main.ic_tot_res_cost_r resource_value, q_ic_main.ic_osp_cost outside_processing_cost, q_ic_main.ic_osp_cost_r outside_processing_value, q_ic_main.ic_ovhd_cost overhead_cost, q_ic_main.ic_ovhd_cost_r overhead_value, q_ic_main.ic_unit_cost cost_elements_total_cost, q_ic_main.ic_total_cost_r cost_elements_total_value, -- q_ic_main.ic_item_id_p item_id, q_ic_main.ic_order, row_number() over (partition by ic_item_id_p order by q_ic_rcv.ic_txn_id) row_num, --q_ic_rcv.* q_ic_rcv.ic_receipt_date receipt_date, q_ic_rcv.ic_receipt_num receipt_number, q_ic_rcv.ic_shipment_num shipment_number, q_ic_rcv.ic_current_location current_location, q_ic_rcv.ic_deliver_to_location deliver_to_location, q_ic_rcv.ic_packing_slip packing_slip, q_ic_rcv.ic_document_type document_type, q_ic_rcv.ic_document_number document_number, q_ic_rcv.ic_document_line_num document_line_number, q_ic_rcv.ic_quantity receipt_qty, q_ic_rcv.ic_acquisition_cost_r acquisition_cost, q_ic_rcv.ic_value_r value, q_ic_rcv.ic_txn_id, -- q_ic_rcv.ic_pac_period, q_ic_rcv.ic_cost_type, q_ic_rcv.ic_start_date, q_ic_rcv.ic_end_date, q_ic_rcv.ic_item_num, q_ic_rcv.ic_category, q_ic_rcv.ic_uom_code, q_ic_rcv.ic_revision, q_ic_rcv.ic_description, q_ic_rcv.ic_acquisition_cost, q_ic_rcv.ic_value from q_ic_main, q_ic_rcv where q_ic_main.ic_item_id_p = q_ic_rcv.ic_item_id_c (+) and q_ic_main.cost_group_id = q_ic_rcv.cost_group_id (+) and q_ic_main.period_id = q_ic_rcv.period_id (+) ) x order by x.ic_order, x.item, x.row_num, x.ic_txn_id Y BOM CSTRPICR_XML #,##0.00;[Red]-#,##0.00 AR CST تقرير قيمة المخزون الدوري (تنسيق XML) Imported from BI Publisher Description: تقرير قيمة المخزون الدوري Application: شجرة المنتجات Source: تقرير قيمة المخزون الدوري (تنسيق XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG D CST Periodischer Lagerbestand - Wert Imported from BI Publisher Description: Periodischer Lagerbestand - Wert Application: Produktionsdaten Source: Periodischer Lagerbestand - Wert (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG E CST Valor de Inventario Periódico Imported from BI Publisher Description: Informe de valor de inventario periódico Application: Bills of Material Source: Valor de Inventario Periódico (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG F CST Etat des valeurs de stock en fin de période Imported from BI Publisher Description: Etat des valeurs de stock en fin de période Application: Bills of Material Source: Etat des valeurs de stock en fin de période (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG I CST Rapporto Valore scorte periodico Imported from BI Publisher Description: Rapporto periodico Valori magazzino Application: Bills of Material Source: Rapporto Valore scorte periodico (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG JA CST 期間在庫価額レポート Imported from BI Publisher Description: 期間在庫価額レポート Application: Bills of Material Source: 期間在庫価額レポート(XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG KO CST 기간별 재고 금액 보고서 Imported from BI Publisher Description: 기간별 재고 금액 보고서 Application: Bills of Material Source: 기간별 재고 금액 보고서(XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG PTB CST Relatório Periódico de Valor de Inventário Imported from BI Publisher Description: Relatório Periódico de Valor de Inventário Application: Bills of Material Source: Relatório Periódico de Valor de Inventário (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG RU CST Отчет о периодической стоимости запасов Imported from BI Publisher Description: Отчет о периодической стоимости запасов Application: Спецификации Source: Отчет о периодической стоимости запасов (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG S CST Periodiskt lagervärde - rapport Imported from BI Publisher Description: Periodiskt lagervärde - rapport Application: Bills of Material Source: Periodiskt lagervärde - rapport (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG TR CST Dönemsel Envanter Değeri Raporu Imported from BI Publisher Description: Dönemsel Envanter Değer Raporu Application: Ürün Ağacı Source: Dönemsel Envanter Değeri Raporu (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG US CST Periodic Inventory Value Imported from BI Publisher Description: Periodic Inventory Value Report Application: Bills of Material Source: Periodic Inventory Value Report (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG ZHS CST 定期库存值报表 Imported from BI Publisher Description: 定期库存值报表 Application: 物料清单管理系统 Source: 定期库存值报表 (XML) Short Name: CSTRPICR_XML DB package: BOM_CSTRPICR_XMLP_PKG Enginatics R12 only 1=1 2=2 :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_group :p_cost_group_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_ext_prec :p_item_from :p_item_master_org_id :p_item_seg :p_item_to :p_item_where :p_legal_entity :p_legal_entity_id :p_period_id :p_period_name :p_precision :p_qty_precision :p_qty_where :p_report_name :p_rpt_option :p_sessionid :p_sort_by :p_sort_option :p_trace :p_view_cost :round_unit 1 -110 :p_cost_group_id Number select ccg.cost_group_id from cst_cost_groups ccg where xxen_util.contains(:$flex$.cost_group,ccg.cost_group_id) = 'Y' and rownum <= 1 US Dummy Cost Group 2 -100 :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_RPT_DETAIL_OPTION' AND LOOKUP_CODE = 1 Y AR خيار التقرير خيار تفاصيل التقرير D Auswertungsoption Option Auswertungsdetail E Opción de Informe Opción de Detalle del Informe F Option d'édition Option de détail de l'état I Opzione rapporto Opzione dettagli rapporto JA レポート・オプション レポート詳細オプション KO 보고서 옵션 상세내역 옵션 보고 PTB Opção de Relatório Opção Detalhada de Relatório RU Параметр отчета Параметр сведений об отчете S Rapportalternativ Alternativet för information om rapport TR Rapor Seçeneği Rapor Detayı Seçeneği US Report Option Report Detail Option ZHS 报表选项 报表明细选项 3 -90 :round_unit Number US Round Unit 4 -80 :p_set_of_books LOV Oracle CST_SRS_PAC_SOB Y select sob.set_of_books_id id, sob.name value, null description from gl_sets_of_books sob,cst_le_cost_types lct where lct.legal_entity=:$flex$.cst_srs_pac_legal_entity and lct.cost_type_id=:$flex$.cst_srs_pac_cost_type and sob.set_of_books_id=lct.set_of_books_id order by value,description SELECT SOB.NAME FROM GL_SETS_OF_BOOKS SOB, CST_LE_COST_TYPES LCT WHERE LCT.LEGAL_ENTITY = :$flex$.legal_entity AND LCT.COST_TYPE_ID = :$flex$.cost_type AND SOB.SET_OF_BOOKS_ID = LCT.SET_OF_BOOKS_ID Y AR CST_SRS_PAC_SOB دفتر الأستاذ D CST_SRS_PAC_SOB Buch E CST_SRS_PAC_SOB Libro mayor F CST_SRS_PAC_SOB Livre I CST_SRS_PAC_SOB Libro contabile JA CST_SRS_PAC_SOB 元帳 KO CST_SRS_PAC_SOB 원장 PTB CST_SRS_PAC_SOB Razão RU CST_SRS_PAC_SOB Книга S CST_SRS_PAC_SOB Huvudbok TR CST_SRS_PAC_SOB Defter US CST_SRS_PAC_SOB Ledger ZHS CST_SRS_PAC_SOB 分类帐 5 -70 :p_cat_num Number SELECT STRUCTURE_ID FROM MTL_CATEGORY_SETS WHERE CATEGORY_SET_ID = :$flex$.category_set Y AR هيكل الفئة أي رقم D Kategoriestruktur Beliebige Zahl E Estructura de Categoría Cualquier Número F Structure de catégorie Tout numéro I Struttura categoria Qualsiasi numero JA カテゴリ体系 すべての数字 KO 범주 구조 임의 번호 PTB Estrutura da Categoria Qualquer Nr. RU Структура категорий Любое число S Kategoristruktur Valfritt nummer TR Kategori Yapısı Herhangi Bir Sayı US Category Structure Any Number ZHS 类别结构 任何编号 6 -60 :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 显示逆汇率 7 -50 :p_rate_type Number 2 Y AR CST_SRS_RATE_TYPE نوع سعر الصرف D CST_SRS_RATE_TYPE Wechselkursart E CST_SRS_RATE_TYPE Clase de Tipo de Cambio F CST_SRS_RATE_TYPE Type de taux de change I CST_SRS_RATE_TYPE Tipo di tasso di cambio JA CST_SRS_RATE_TYPE 換算レート・タイプ KO CST_SRS_RATE_TYPE 환율 유형 PTB CST_SRS_RATE_TYPE Tipo de Taxa de Câmbio RU CST_SRS_RATE_TYPE Тип обменного курса S CST_SRS_RATE_TYPE Växelkurstyp TR CST_SRS_RATE_TYPE Döviz Kuru Tipi US CST_SRS_RATE_TYPE Exchange Rate Type ZHS CST_SRS_RATE_TYPE 汇率类型 8 -40 :p_qty_precision Number fnd_profile.value('REPORT_QUANTITY_PRECISION') Y 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 数量精确度 数量精确度 9 -30 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') AR امتياز عرض التكاليف امتياز عرض التكاليف D Berechtigung für Kosten anzeigen Berechtigung für Kosten anzeigen E Privilegio de Consultar Costes Privilegio de Consultar Costes F Voir privilège coût Voir privilège coût I Visualizza privilegio costi Visualizza privilegio costi JA 原価権限の表示 原価権限の表示 KO 원가 특권 조회 원가 특권 조회 PTB Verificar Privilégio de Custo Verificar Privilégio de Custo RU Привилегия просмотра затрат Привилегия просмотра затрат S Behörighet att granska kostnader Behörighet att granska kostnader TR Maliyet Ayrıcalığını Görüntüle Maliyet Ayrıcalığını Görüntüle US View Cost Privilege View Cost Privilege ZHS 查看成本权限 查看成本权限 10 -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 跟踪模式 跟踪模式 11 10 :p_legal_entity_id LOV Oracle CST_SRS_PAC_LEGAL_ENTITY Y select legal_entity_id id, name value, null description from xle_firstparty_information_v order by value,description Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Legal Entidad Legal F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa Jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity ZHS 法人主体 法人主体 12 20 :p_cost_type_id LOV Oracle CST_SRS_PAC_COST_TYPE Y select cct.cost_type_id id, cct.cost_type value, cct.description description from cst_cost_types cct,cst_le_cost_types clct where cct.cost_type_id=clct.cost_type_id and clct.legal_entity=:$flex$.cst_srs_pac_legal_entity order by value,description Y 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 成本类型 成本类型 13 30 :p_period_id LOV Oracle CST_SRS_PAC_PERIOD Y select cpp.pac_period_id id, cpp.pac_period_id value, cpp.period_name description from cst_pac_periods cpp where cpp.legal_entity=:$flex$.cst_srs_pac_legal_entity and cpp.cost_type_id=:$flex$.cst_srs_pac_cost_type order by value,description Y AR الفترة الفترة D Periode Periode E Período Período F Période Période I Periodo Periodo JA 期間 期間 KO 기간 기간 PTB Período Período RU Период Период TR Dönem Dönem US Period Period ZHS 期间 期间 14 40 1=1 cpic.cost_group_id =:p_cost_group_id2 LOV Oracle CST_SRS_PAC_COST_GROUP Y select ccg.cost_group_id id, ccg.cost_group value, ccg.description description from cst_cost_groups ccg where ccg.legal_entity=:$flex$.cst_srs_pac_legal_entity and nvl(ccg.cost_group_type,1)=2 and exists (select 'X' from cst_pac_process_phases cppp where cppp.pac_period_id=:$flex$.cst_srs_pac_period and cppp.cost_group_id=ccg.cost_group_id) order by value,description Y AR مجموعة التكاليف مجموعة التكاليف D Kostengruppe Kostengruppe E Grupo de Costes Grupo de Costes F Groupe de coûts Groupe de coûts I Gruppo di costi Gruppo di costi JA 原価グループ 原価グループ KO 원가 그룹 원가 그룹 PTB Grupo de Custos Grupo de Custos RU Группа затрат Группа затрат S Kostnadsgrupp Kostnadsgrupp TR Maliyet Grubu Maliyet Grubu US Cost Group Cost Group ZHS 成本组 成本组 15 2=2 cprvv.cost_group_id =:p_cost_group_id2 US Cost Group 16 50 :p_sort_option LOV Oracle CST_SRS_PAC_INV_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) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE ='CST_ITEM_REPORT_SORT' AND LOOKUP_CODE = 1 Y AR خيار الفرز الصنف/الفئة D Sortieroption Artikel/Kategorie E Opción de Clasificación Artículo/Categoría F Option de tri Article/Catégorie I Opzione di ordinamento Articolo/categoria JA ソート・オプション 品目/カテゴリ KO 정렬 옵션 품목/범주 PTB Opção de Classificação Item/Categoria RU Параметр сортировки Позиция/категория S Sorteringsalternativ Artikel/kategori TR Sıralama Seçeneği Kalem/Kategori US Sort Option Item/Category ZHS 排序选项 物料/类别 17 70 1=1 msi.concatenated_segments >= :p_item_from LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments 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 物料自 物料自 18 80 1=1 msi.concatenated_segments <= :p_item_to LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments 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 物料至 物料至 19 90 :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 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 类别集 类别集 20 100 1=1 mc.concatenated_segments >= :p_cat_from LOV custom Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_id=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs 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 类别自 类别自 21 110 1=1 mc.concatenated_segments >= :p_cat_to LOV custom Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_id=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs 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 类别至 类别至 22 120 :p_item_master_org_id LOV custom Y select mp.organization_id id, mp.organization_code value, null description from mtl_parameters mp,mtl_category_sets mcs,cst_cost_groups ccg,cst_cost_group_assignments cga where mcs.category_set_id=:$flex$.cst_srs_category_set and xxen_util.contains(:$flex$.cost_group,ccg.cost_group_id)='Y' and ((mp.organization_id=ccg.organization_id and ccg.cost_group_type=2 and rownum=1) or (mcs.control_level=2 and cga.cost_group_id=ccg.cost_group_id and cga.organization_id=mp.organization_id and cga.organization_id<>ccg.organization_id)) order by value,description select mp.organization_code from mtl_parameters mp, cst_cost_groups ccg where ccg.cost_group_type = 2 and mp.organization_id = ccg.organization_id and ccg.cost_group_id = :$flex$.cost_group Y AR تنظيم الفئة تنظيم فئة الصنف D Kategorieorganisation Artikelkategorie-Organisation E Organización de Categoría Organización de Categoría de Artículo F Catégorie - Organisation Catégorie d'article - Organisation I Organizzazione categoria Organizzazione categoria articolo JA カテゴリ組織 品目カテゴリ組織 KO 범주 조직 품목 범주 조직 PTB Organização da Categoria Organização da Categoria do Item RU Организация категории Организация категории позиций S Kategoriorganisation Artikelkategoriorganisation TR Kategori Organizasyonu Kalem Kategorisi Organizasyonu US Category Organization Item Category Organization ZHS 类别组织 物料类别组织 23 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 SOB.CURRENCY_CODE FROM GL_SETS_OF_BOOKS SOB WHERE SOB.SET_OF_BOOKS_ID = :$FLEX$.CST_SRS_PAC_SOB Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de Divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Cód. da Moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi Kodu US Currency Currency Code ZHS 币种 币种代码 24 140 :p_exchange_rate_char LOV Oracle CST_SRS_PAC_EXCHANGE_RATE Y select actual_rate id, display_rate value, period description from cst_gl_translation_view where org_id=(select cod.organization_id from cst_organization_definitions cod where cod.set_of_books_id=:$flex$.cst_srs_pac_sob and rownum=1) 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 汇率 汇率 :$FLEX$.CST_SRS_PAC_SOB CST_SRS_PAC_SOB Currency :$flex$.category_set Category Set Category From :$flex$.category_set Category Set Category Structure :$flex$.category_set Category Set Category To :$flex$.cost_group Cost Group Category Organization :$flex$.cost_group Cost Group Dummy Cost Group :$flex$.cost_type Cost Type CST_SRS_PAC_SOB :$flex$.cst_srs_category_set Category Set Category Organization :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_pac_cost_type Cost Type CST_SRS_PAC_SOB :$flex$.cst_srs_pac_cost_type Cost Type Period :$flex$.cst_srs_pac_legal_entity Legal Entity CST_SRS_PAC_SOB :$flex$.cst_srs_pac_legal_entity Legal Entity Cost Group :$flex$.cst_srs_pac_legal_entity Legal Entity Cost Type :$flex$.cst_srs_pac_legal_entity Legal Entity Period :$flex$.cst_srs_pac_period Period Cost Group :$flex$.cst_srs_pac_sob CST_SRS_PAC_SOB Exchange Rate :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate :$flex$.legal_entity Legal Entity CST_SRS_PAC_SOB Detail Detailed Report SYSADMIN 40 ACQUISITION_COST 9 CATEGORY 28 COST_ELEMENTS_TOTAL_COST 29 COST_ELEMENTS_TOTAL_VALUE 2 COST_TYPE 4 CURRENCY 33 CURRENT_LOCATION 34 DELIVER_TO_LOCATION 8 DESCRIPTION 38 DOCUMENT_LINE_NUMBER 37 DOCUMENT_NUMBER 36 DOCUMENT_TYPE 5 EXCHANGE_RATE 42 IC_TXN_ID 7 ITEM 43 ITEM_ID 44 ITEM_SEQ 1 LEGAL_ENTITY 18 MATERIAL_COST 20 MATERIAL_OVERHEAD_COST 21 MATERIAL_OVERHEAD_VALUE 19 MATERIAL_VALUE 11 ONHAND_QUANTITY 12 ONHAND_UNIT_COST 13 ONHAND_VALUE 6 ORG_COST_GROUP 24 OUTSIDE_PROCESSING_COST 25 OUTSIDE_PROCESSING_VALUE 26 OVERHEAD_COST 27 OVERHEAD_VALUE 35 PACKING_SLIP 3 PERIOD 15 RCV_AVG_ACQUISITION_COST 14 RCV_QUANTITY 16 RCV_VALUE 30 RECEIPT_DATE 31 RECEIPT_NUMBER 39 RECEIPT_QTY 22 RESOURCE_COST 23 RESOURCE_VALUE 32 SHIPMENT_NUMBER 17 TOTAL_VALUE 10 UOM 41 VALUE S Site Summary Summary Report SYSADMIN 9 CATEGORY 2 COST_TYPE 4 CURRENCY 8 DESCRIPTION 5 EXCHANGE_RATE 7 ITEM 1 LEGAL_ENTITY 11 ONHAND_QUANTITY 12 ONHAND_UNIT_COST 13 ONHAND_VALUE 6 ORG_COST_GROUP 3 PERIOD 15 RCV_AVG_ACQUISITION_COST 14 RCV_QUANTITY 16 RCV_VALUE 17 TOTAL_VALUE 10 UOM S Site SYSADMIN Summary Detail