ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 8E2FF36EDEF379D2E0530100007F1FF2 INV Item (master) Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by msiv.concatenated_segments US Any item from item master org, including non costing enabled 9B9627743E84607DE053BB6B635805FB INV Operating Unit Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 AR جميع وحدات التشغيل المرتبطة بمؤسسة مخزون غير رئيسية نشطة D Alle Betriebseinheiten, die mit einer aktiven Nicht-Master-Inventarisierungsorganisation verbunden sind E Todas las unidades operativas relacionadas con una organización de inventario no maestra activa F Toutes les unités opérationnelles liées à un organisme d'inventaire non maître actif I Tutte le unità operative legate a un'organizzazione di inventario non master attiva JA アクティブな非マスターインベントリ組織に関連するすべてのオペレーティング・ユニット KO 활성 비 마스터 재고 조직과 관련된 모든 운영 단위 PTB Todas as unidades operacionais relacionadas a uma organização ativa de inventário não-mestre RU Все операционные единицы, относящиеся к действующей организации, не являющейся ведущим поставщиком инвентарных запасов. S Alla operativa enheter relaterade till en aktiv organisation som inte är huvudlager TR Etkin bir ana envanter organizasyonu ile ilgili tüm işletim birimleri US All operating units related to an active non master inventory organization ZHS 与在用的非总清单组织有关的所有业务单位： 41D6D818F6A4CF9BE06362FB0905CAA3Y select msiv.segment1 item_number, msiv.description description, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', mck.structure_id, null, mck.category_id, 'ALL', 'Y', 'VALUE') category, msiv.primary_uom_code uom, round(sum(ciqt.rollback_qty),:p_qty_precision) quantity, round((nvl(cict.item_cost,0)*:p_exchange_rate1),:p_ext_prec) unit_cost, round((sum(ciqt.rollback_qty*nvl(cict.item_cost,0) )*:p_exchange_rate1)/:round_unit)*:round_unit unit_cost_total, case when mp_from.process_enabled_flag <> mp_to.process_enabled_flag then 0 when ((mmt.transaction_action_id=12 and mmt.transaction_source_type_id=101) or (mmt.transaction_action_id=21 and mmt.transaction_source_type_id=7))then 0 else decode(mip.matl_interorg_transfer_code, 1,round((nvl(rsl.transfer_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), 2,round((nvl(rsl.transfer_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), 3,round((decode(mip.fob_point,2,( nvl(cict.item_cost,0 )*:p_exchange_rate1*rsl.transfer_percentage/100),1,(nvl(mta.rate_or_amount,0)*:p_exchange_rate1))/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), 4,round((decode(mip.fob_point,2,( nvl(cict.item_cost,0 )*:p_exchange_rate1*rsl.transfer_percentage/100),1,(nvl(mta.rate_or_amount,0)*:p_exchange_rate1))/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec) ) end transfer_charges, round((nvl(rsl.transportation_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec) freight_cost, mp_from.organization_code from_org, mp_to.organization_code to_org, ml.meaning fob_point, rsh.shipment_num shipment_number, rsh.shipped_date ship_date, rsh.expected_receipt_date+nvl(msi_to.postprocessing_lead_time,0) arrival_date, rsh.freight_carrier_code freight_carrier, rsh.waybill_airbill_num "Waybill/Airbill", rsh.num_of_containers number_of_containers, bom_cstritvr_xmlp_pkg.item_qtyformula( msiv.primary_uom_code, decode(ciqt.organization_id, ciqt.from_organization_id, msi_from.primary_uom_code, msi_to.primary_uom_code), ciqt.inventory_item_id, round(sum(ciqt.rollback_qty),:p_qty_precision)) item_quantity, bom_cstritvr_xmlp_pkg.tot_costformula( ciqt.organization_id, mp_from.organization_id, msi.primary_uom_code, decode(ciqt.organization_id, ciqt.from_organization_id,msi_from.primary_uom_code, msi_to.primary_uom_code), ciqt.inventory_item_id, round(sum(ciqt.rollback_qty),:p_qty_precision), round((nvl(cict.item_cost,0)* :p_exchange_rate1),:p_ext_prec), round((sum(ciqt.rollback_qty*nvl(cict.item_cost,0) )*:p_exchange_rate1)/:round_unit)*:round_unit ) total_cost, bom_cstritvr_xmlp_pkg.xfer_cost_totalformula( case when mp_from.process_enabled_flag <> mp_to.process_enabled_flag then 0 when ((mmt.transaction_action_id=12 and mmt.transaction_source_type_id=101) or (mmt.transaction_action_id=21 and mmt.transaction_source_type_id=7)) then 0 else decode(mip.matl_interorg_transfer_code, 1,round((nvl(rsl.transfer_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), 2,round((nvl(rsl.transfer_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))), :p_ext_prec), 3,round((decode(mip.fob_point,2,( nvl(cict.item_cost,0)*:p_exchange_rate1*rsl.transfer_percentage/100),1,(nvl(mta.rate_or_amount,0)*:p_exchange_rate1))/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), 4,round((decode(mip.fob_point,2,( nvl(cict.item_cost,0 )*:p_exchange_rate1*rsl.transfer_percentage/100),1,(nvl(mta.rate_or_amount,0)*:p_exchange_rate1))/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))), :p_ext_prec) ) end, round(sum(ciqt.rollback_qty),:p_qty_precision) ) transfer_charges_total, bom_cstritvr_xmlp_pkg.xport_cost_totalformula( round((nvl(rsl.transportation_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), round(sum(ciqt.rollback_qty),:p_qty_precision)) freight_cost_total from cst_inv_qty_temp ciqt, cst_inv_cost_temp cict, rcv_shipment_headers rsh, rcv_shipment_lines rsl, cst_cost_groups ccg, mfg_lookups ml, mtl_parameters mp, mtl_parameters mp_from, mtl_parameters mp_to, mtl_system_items_vl msiv, mtl_system_items msi, mtl_system_items msi_from, mtl_system_items msi_to, mtl_categories_kfv mck, cst_organization_definitions cod, mtl_interorg_parameters mip, mtl_transaction_accounts mta, mtl_material_transactions mmt where 1=1 and msiv.organization_id=:p_org_id and cict.organization_id(+)=ciqt.organization_id and cict.inventory_item_id(+)=ciqt.inventory_item_id and cict.cost_type_id(+)=ciqt.cost_type_id and (mp.primary_cost_method=1 or nvl(cict.cost_group_id,ciqt.cost_group_id)=ciqt.cost_group_id) and rsh.shipment_header_id=rsl.shipment_header_id and rsl.shipment_line_id=ciqt.shipment_line_id and mta.transaction_id(+)=rsl.mmt_transaction_id and mta.accounting_line_type(+)= 11 and mmt.transaction_id(+)=rsl.mmt_transaction_id and ccg.cost_group_id=ciqt.cost_group_id and ml.lookup_type='MTL_FOB_POINT' and ml.lookup_code=decode(ciqt.organization_id,ciqt.to_organization_id,1,2) and mp.organization_id=ciqt.organization_id and mp_from.organization_id=ciqt.from_organization_id and mp_to.organization_id=ciqt.to_organization_id and msiv.inventory_item_id=ciqt.inventory_item_id and msi.organization_id=ciqt.organization_id and msi.inventory_item_id=ciqt.inventory_item_id and msi_from.organization_id=ciqt.from_organization_id and msi_from.inventory_item_id=ciqt.inventory_item_id and msi_to.organization_id=ciqt.to_organization_id and msi_to.inventory_item_id=ciqt.inventory_item_id and mck.category_id=ciqt.category_id and mip.from_organization_id(+)=ciqt.from_organization_id and mip.to_organization_id(+)=ciqt.to_organization_id and cod.organization_id=mp_from.organization_id group by msiv.segment1, fnd_flex_xml_publisher_apis.process_kff_combination_1('category_segment', 'INV', 'MCAT', mck.structure_id, null, mck.category_id, 'ALL', 'Y', 'VALUE'), msiv.description, msiv.primary_uom_code, msi.primary_uom_code, ciqt.organization_id, mp_from.organization_id, mp_from.organization_code, mp_to.organization_code, ml.meaning, rsh.shipment_num, rsh.shipped_date, rsh.expected_receipt_date+nvl(msi_to.postprocessing_lead_time,0), rsh.freight_carrier_code, rsh.waybill_airbill_num, rsh.num_of_containers, ccg.cost_group, decode(ciqt.organization_id, ciqt.from_organization_id, msi_from.primary_uom_code, msi_to.primary_uom_code), round((nvl(cict.item_cost,0)*:p_exchange_rate1),:p_ext_prec), ciqt.inventory_item_id, decode(:p_cost_type_id,cict.cost_type_id,' ','*'), case when mp_from.process_enabled_flag <> mp_to.process_enabled_flag then 0 when ((mmt.transaction_action_id=12 and mmt.transaction_source_type_id=101) or (mmt.transaction_action_id=21 and mmt.transaction_source_type_id=7)) then 0 else decode( mip.matl_interorg_transfer_code, 1,round((nvl(rsl.transfer_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))), :p_ext_prec), 2,round((nvl(rsl.transfer_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))), :p_ext_prec), 3,round( (decode(mip.fob_point, 2,(nvl(cict.item_cost,0)*:p_exchange_rate1*rsl.transfer_percentage/100), 1,(nvl(mta.rate_or_amount,0)*:p_exchange_rate1) )/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec), 4,round( (decode(mip.fob_point, 2,(nvl(cict.item_cost,0)*:p_exchange_rate1*rsl.transfer_percentage/100), 1,(nvl(mta.rate_or_amount,0)*:p_exchange_rate1) )/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec) ) end, round((nvl(rsl.transportation_cost,0)/(gl_currency_api.get_rate(cod.set_of_books_id,:p_currency_code,sysdate,:p_curr_type))),:p_ext_prec) having round(sum(ciqt.rollback_qty),:p_qty_precision) <> 0 BOM CSTRITVR_XML 05227A485EF737D9E06362FB090552B3 US COPY OF: CST Intransit Value (1) Imported from BI Publisher Description: Intransit Value Report Application: Bills of Material Source: Intransit Value Report (XML) Short Name: CSTRITVR_XML DB package: BOM_CSTRITVR_XMLP_PKG BI Publisher 1=1 :ext_precision :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_category_set :p_conc_request_id :p_cost_type :p_cost_type_dummy :p_cost_type_dummy1 :p_cost_type_id :p_curr_type :p_currency_code :p_currency_dsp :p_def_cost_type :p_detail_level :p_exchange_rate :p_exchange_rate1 :p_exchange_rate_char :p_exp_item :p_ext_prec :p_item_from :p_item_revision :p_item_seg :p_item_to :p_org_id :p_org_where :p_organization :p_own :p_qty_precision :p_receipt :p_rpt_option :p_shipment :p_sort_by :p_sort_option :p_title :p_trace :p_view_cost :p_zero_cost :qty_precision :round_unit 1 -40 :p_cost_type_dummy Number select 1 from mtl_parameters where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and primary_cost_method=1 AR CST_SRS_COST_TYPE_DUMMY نوع التكلفة الافتراضي D CST_SRS_COST_TYPE_DUMMY Kostentyp Dummy E CST_SRS_COST_TYPE_DUMMY Tipo de Coste Ficticio F CST_SRS_COST_TYPE_DUMMY Type coût fictif I CST_SRS_COST_TYPE_DUMMY Tipo di costo fittizio JA CST_SRS_COST_TYPE_DUMMY 原価タイプ・ダミー KO CST_SRS_COST_TYPE_DUMMY 원가 유형 dummy PTB CST_SRS_COST_TYPE_DUMMY Tipo do Custo Fictício RU CST_SRS_COST_TYPE_DUMMY Фиктивный тип затрат S CST_SRS_COST_TYPE_DUMMY Dummykostnadstyp TR CST_SRS_COST_TYPE_DUMMY Sözde Maliyet Tipi US CST_SRS_COST_TYPE_DUMMY Cost Type dummy ZHS CST_SRS_COST_TYPE_DUMMY 虚拟成本类型 2 -30 :p_cat_num Number select structure_id from mtl_category_sets where category_set_name = :$flex$.category_set 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 类别结构 类别结构 3 -20 :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 数量精确度 数量精确度 4 -10 :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 Profile Option: View Cost Privilege ZHS 查看成本权限 查看成本权限 5 5 1=1 hou.name=:p_operating_unit LOV INV Operating Unit 9B9627743E84607DE053BB6B635805FB Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit Operating Unit 6 10 :p_org_id LOV Oracle INV_SRS_ORG_ACCESS Y select organization_id id, organization_code value, organization_name description from org_access_view where responsibility_id=to_number(fnd_profile.value('RESP_ID')) and resp_application_id=to_number(fnd_profile.value('RESP_APPL_ID')) order by organization_code fnd_profile.value('MFG_ORGANIZATION_ID') Y AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Organization Code Organization Id ZHS 标题 标题 7 20 :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 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 报表选项 报表选项 8 30 :p_sort_option LOV Oracle CST_SRS_INTRANSIT_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,5,6,7) 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 排序选项 排序选项 9 40 :p_cost_type_id LOV Oracle CST_SRS_AVG_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=2 and mp.primary_cost_method=2) or (cct.cost_type_id!=2)) and ((cct.cost_type_id=1 and mp.primary_cost_method=1) or (cct.cost_type_id!=1)) and :$flex$.cst_srs_cost_type_dummy=1 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 :$flex$.cst_srs_cost_type_dummy=1 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 成本类型 成本类型 10 50 1=1 rsh.shipped_date<=:p_as_of_date Date select fnd_date.date_to_displaydt(sysdate) from dual Y AR اعتبارًا من تاريخ اعتبارًا من تاريخ D Vom Vom E A Fecha A fecha F En date du En date du I In data In data JA 現在日 現在日 KO 기준 일자 기준 일자 PTB Data de Referência Data de Referência RU На дату На дату S Per datum Per datum TR Başlangıç Tarihi Başlangıç Tarihi US As of Date As of Date ZHS 截止日期 截止日期 11 60 :p_item_from LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by 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 物料自 物料自 12 70 :p_item_to LOV INV Item (master) 8E2FF36EDEF379D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv where msiv.organization_id=( select max(mp.master_organization_id) master_organization_id from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or fnd_profile.value('MFG_ORGANIZATION_ID') is null and mp.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) ) order by 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 物料至 物料至 13 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 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 Conjunto de categorias RU Набор категорий Набор категорий S Kategoriuppsättning Kategoriserie TR Kategori Kümesi Kategori kümesi US Category Set Category set ZHS 类别集 类别集 14 90 :p_cat_from LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$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 类别自 类别自 15 100 :p_cat_to LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$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 类别至 类别至 16 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 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 币种 币种 17 120 :p_exchange_rate_char LOV custom 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$.currency and inverse=fnd_profile.value('DISPLAY_INVERSE_RATE') and rate_type=2 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 汇率 汇率 18 130 :p_receipt 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=1 Y AR تضمين إيصالات معلقة تضمين إيصالات معلقة D Mit anstehenden Wareneingängen Mit anstehenden Wareneingängen E Incluir Recepciones Pendientes Incluir Recepciones Pendientes F Inclure les réceptions en attente Inclure les réceptions en attente I Includi ricezioni in sospeso Includi ricezioni in sospeso JA 保留受入を含む 保留受入を含む KO 보류중인 입고 포함 보류중인 입고 포함 PTB Incluir Receitas Pendentes Incluir Receitas Pendentes RU Включить отложенные поступления Включить отложенные поступления S Inkludera avvaktande inleveranser Inkludera avvaktande inleveranser TR Bekleyen Makbuzları Dahil Et Bekleyen Makbuzları Dahil Et US Include Pending Receipts Include Pending Receipts ZHS 包括待定接收 包括待定接收 19 140 :p_shipment 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=1 Y AR تضمين شحنات تضمين شحنات D Mit Lieferungen Mit Lieferungen E Incluir Envíos Incluir Envíos F Inclure les livraisons Inclure les livraisons I Includi spedizioni Include le spedizioni JA 出荷を含む 出荷を含む KO 출하포함 출하포함 PTB Incluir Entregas Incluir Entregas RU Включить поставки Включить поставки S Inkludera leveranser Inkludera leveranser TR Sevkiyatları Dahil Et Sevkiyatları Dahil Et US Include Shipments Include Shipments ZHS 包括发运 包括发运 20 150 :p_own 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=1 Y AR بعرض المخزن الذي تمتلكه فقط بعرض المخزن الذي تمتلكه فقط D Nur eigene Lagerbestände anzeigen Nur eigene Lagerbestände anzeigen E Mostrar Sólo Inventario Propio Mostrar Sólo Inventario Propio F Afficher seulement vos stocks Afficher seulement vos stocks I Visualizza solo magazzini propri Solo visualizzazione magazzino JA 所有在庫のみ表示 所有在庫のみ表示 KO 소유 재고만 표시 소유 재고만 표시 PTB Exibir Apenas Seus Inventários Exibir apenas seu inventário RU Вывод только собственных запасов Вывод только собственных запасов S Visa endast eget lager Visa endast lager som du äger TR Sadece Sahip Olduğunuz Envanteri Görüntüle Sadece sahip olduğunuz envanteri görüntüle US Only Display Inventory You Own Only display inventory you own ZHS 仅显示您拥有的库存 仅显示所拥有的子库存 21 160 :p_item_revision 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 AR الكميات بواسطة المراجعة الكميات بواسطة المراجعة D Mengen nach Version Mengen nach Version E Cantidades por Revisión Cantidades por Revisión F Quantités par version Quantités par version I Quantità per revisione Quantità per revisione JA 改訂別数量 改訂別数量 KO 개정별 수량 개정별 수량 PTB Quantidades por Revisão Quantidades por Revisão RU Количества по версиям Количества по версиям S Kvantiteter per revision Kvantiteter per revision TR Revizyon Bazında Miktarlar Revizyon Bazında Miktarlar US Quantities By Revision Quantities by Revision ZHS 按版本显示数量 按版本列出的数量 22 170 :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 AR عرض التكاليف الصفرية فقط عرض التكلفة الصفرية فقط D Nur Nullkosten anzeigen Nur Nullkosten anzeigen E Mostrar Sólo Costes Cero Mostrar Sólo Costes Cero F Afficher les coûts zéro seulement Afficher coût zéro seulement I Visualizza solo costi zero Visualizza solo costi zero JA ゼロ原価のみ表示 ゼロ原価のみ表示 KO 0 원가만 표시 0 원가만 표시 PTB Exibir Apenas Custos Zero Exibir apenas custo zero RU Вывод только бесплатных позиций Вывод только бесплатных позиций S Visa endast nollkostnader Visa endast nollkostnad TR Sadece Sıfır Maliyetleri Görüntüle Sadece sıfır maliyeti görüntüle US Display Zero Costs Only Display zero cost only ZHS 仅显示零成本 仅显示零成本 23 180 :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 AR تضمين بنود المصروفات تضمين بنود المصروفات D Mit Aufwandsartikeln Mit Aufwandsartikeln E Incluir Conceptos de Gasto Incluir Artículos de Gasto F Inclure les articles passés en charges Inclure les articles passés en charges I Includi articoli di spesa Includi articoli di spesa JA 費用品目を含む 費用品目を含む KO 비용 품목 포함 비용 품목 포함 PTB Incluir Itens de Despesa Incluir itens de despesas RU Включить статьи расхода Включить статьи расхода S Inkludera utgiftsposter Inkludera utgiftsposter TR Gider Kalemlerini Dahil Et Gider kalemlerini dahil et US Include Expense Items Include expense items ZHS 包括低值易耗品 包括低值易耗品