ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CFD51DC4A2F5BBC6E05362FB0905069AY SELECT 1 AC_SOURCE_TYPE , CQL.COST_GROUP_ID AC_CQL_CG_ID /*, &P_ITEM_SEG AC_ITEM*/ , MSI.DESCRIPTION AC_ITEM_DESC , MSI.PRIMARY_UOM_CODE AC_UOM , DECODE(:P_ITEM_REVISION, 1, MOH.REVISION, NULL) AC_REVISION /*, &P_CAT_SEG AC_CATEGORY*/ , LU.MEANING AC_INV_ASSET , MOH.SUBINVENTORY_CODE AC_SUBINV , SEC.DESCRIPTION AC_SUBINV_DESC /*, &P_LOC_SEG AC_LOC_SEG*/ , MIL.PHYSICAL_LOCATION_CODE AC_LOC , MIL.DESCRIPTION AC_LOC_DESC , MOH.TRANSACTION_QUANTITY AC_QUANTITY , ROUND(MOH.TRANSACTION_QUANTITY * NVL(CQL.MATERIAL_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, 1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT AC_MATL_COST , ROUND(MOH.TRANSACTION_QUANTITY * NVL(CQL.MATERIAL_OVERHEAD_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, 1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT AC_MOVH_COST , ROUND(MOH.TRANSACTION_QUANTITY * NVL(CQL.RESOURCE_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, 1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT AC_RES_COST , ROUND(MOH.TRANSACTION_QUANTITY * NVL(CQL.OUTSIDE_PROCESSING_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, 1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT AC_OSP_COST , ROUND(MOH.TRANSACTION_QUANTITY * NVL(CQL.OVERHEAD_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, 1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT AC_OVHD_COST , ROUND(MOH.TRANSACTION_QUANTITY * NVL(CQL.ITEM_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, 1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT AC_TOTAL_COST ,BOM_CSTRISLR_XMLP_PKG.ac_i_rowcountformula(:AC_I_QUANTITY) AC_I_ROWCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_loc_pseg', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'PADDED_VALUE') AC_LOC_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_loc_segment', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') AC_LOC_SEGMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') AC_ITEM_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') AC_CATEGORY_SEGMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_cat_pseg', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') AC_CAT_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') AC_ITEM_SEGMENT FROM CST_QUANTITY_LAYERS CQL , MTL_CATEGORIES MC , MTL_ITEM_CATEGORIES MIC , MTL_SYSTEM_ITEMS_VL MSI , MTL_PARAMETERS MP , MTL_SECONDARY_INVENTORIES SEC , MTL_ONHAND_QUANTITIES MOH , MTL_ITEM_LOCATIONS MIL , MRP_PROJECT_PARAMETERS MPP , MFG_LOOKUPS LU WHERE MOH.ORGANIZATION_ID = :P_ORG_ID AND MOH.SUBINVENTORY_CODE BETWEEN NVL(:P_SUBINV_FROM, MOH.SUBINVENTORY_CODE) AND NVL(:P_SUBINV_TO, MOH.SUBINVENTORY_CODE) AND SEC.ORGANIZATION_ID = MOH.ORGANIZATION_ID AND SEC.SECONDARY_INVENTORY_NAME = MOH.SUBINVENTORY_CODE AND SEC.ASSET_INVENTORY = 1 AND MSI.ORGANIZATION_ID = MOH.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MOH.INVENTORY_ITEM_ID AND MSI.INVENTORY_ASSET_FLAG = DECODE(:P_EXP_ITEM, 1, MSI.INVENTORY_ASSET_FLAG , 'Y') AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.CATEGORY_SET_ID = :P_CATEGORY_SET AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND MIL.ORGANIZATION_ID (+) = MOH.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID (+) = MOH.LOCATOR_ID AND MPP.ORGANIZATION_ID (+) = MIL.ORGANIZATION_ID AND MPP.PROJECT_ID (+) = MIL.PROJECT_ID AND MP.ORGANIZATION_ID = MOH.ORGANIZATION_ID AND CQL.ORGANIZATION_ID = MOH.ORGANIZATION_ID AND CQL.INVENTORY_ITEM_ID = MOH.INVENTORY_ITEM_ID AND CQL.COST_GROUP_ID = NVL(MPP.COSTING_GROUP_ID, MP.DEFAULT_COST_GROUP_ID) AND LU.LOOKUP_TYPE = 'SYS_YES_NO' AND LU.LOOKUP_CODE = DECODE(MSI.INVENTORY_ASSET_FLAG,'Y',1,2) AND &P_ITEM_WHERE AND &P_CAT_WHERE and CQL.COST_GROUP_ID = :AC_CG_ID UNION ALL SELECT 2 , CQL.COST_GROUP_ID /*, null*/ , MSI.DESCRIPTION , MSI.PRIMARY_UOM_CODE , DECODE(:P_ITEM_REVISION, 1, MMT.REVISION, NULL) /*, null*/ , LU.MEANING , SEC.SECONDARY_INVENTORY_NAME , SEC.DESCRIPTION /*, null AC_LOC_SEG*/ , MIL.PHYSICAL_LOCATION_CODE , MIL.DESCRIPTION , (-1)*MMT.PRIMARY_QUANTITY , ROUND(MMT.PRIMARY_QUANTITY * NVL(CQL.MATERIAL_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, -1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT , ROUND(MMT.PRIMARY_QUANTITY * NVL(CQL.MATERIAL_OVERHEAD_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, -1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT , ROUND(MMT.PRIMARY_QUANTITY * NVL(CQL.RESOURCE_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, -1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT , ROUND(MMT.PRIMARY_QUANTITY * NVL(CQL.OUTSIDE_PROCESSING_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, -1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT , ROUND(MMT.PRIMARY_QUANTITY * NVL(CQL.OVERHEAD_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, -1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT , ROUND(MMT.PRIMARY_QUANTITY * NVL(CQL.ITEM_COST,0) * DECODE(SEC.ASSET_INVENTORY, 1, -1, 0) * :P_EXCHANGE_RATE / :ROUND_UNIT) * :ROUND_UNIT, BOM_CSTRISLR_XMLP_PKG.ac_i_rowcountformula(:AC_I_QUANTITY) AC_I_ROWCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_loc_pseg', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'PADDED_VALUE') AC_LOC_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_loc_segment', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') AC_LOC_SEGMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') AC_ITEM_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_category_segment', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') AC_CATEGORY_SEGMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_cat_pseg', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') AC_CAT_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('ac_item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') AC_ITEM_SEGMENT FROM CST_QUANTITY_LAYERS CQL , MTL_CATEGORIES MC , MTL_ITEM_CATEGORIES MIC , MTL_SYSTEM_ITEMS_VL MSI , MTL_PARAMETERS MP , MTL_SECONDARY_INVENTORIES SEC , MTL_ITEM_LOCATIONS MIL , MRP_PROJECT_PARAMETERS MPP , MTL_MATERIAL_TRANSACTIONS MMT , MFG_LOOKUPS LU WHERE MMT.COSTED_FLAG >= 'A' AND MMT.COSTED_FLAG <= 'Z' AND MMT.ORGANIZATION_ID + 0 = :P_ORG_ID AND MMT.ORGANIZATION_ID = NVL(MMT.OWNING_ORGANIZATION_ID,MMT.ORGANIZATION_ID) AND NVL(MMT.OWNING_TP_TYPE,2)=2 AND NVL(MMT.LOGICAL_TRANSACTION, 2) <> 1 AND SEC.ORGANIZATION_ID = MMT.ORGANIZATION_ID + 0 AND SEC.SECONDARY_INVENTORY_NAME = NVL(MMT.SUBINVENTORY_CODE, NULL) AND SEC.ASSET_INVENTORY = 1 AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID + 0 AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID + 0 AND MSI.INVENTORY_ASSET_FLAG = DECODE(:P_EXP_ITEM, 1, MSI.INVENTORY_ASSET_FLAG, 1) AND MIC.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MIC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MIC.CATEGORY_SET_ID = :P_CATEGORY_SET AND MC.CATEGORY_ID = MIC.CATEGORY_ID AND MIL.ORGANIZATION_ID (+) = MMT.ORGANIZATION_ID AND MIL.INVENTORY_LOCATION_ID (+) = MMT.LOCATOR_ID AND MPP.ORGANIZATION_ID (+) = MIL.ORGANIZATION_ID AND MPP.PROJECT_ID (+) = MIL.PROJECT_ID AND MP.ORGANIZATION_ID = MMT.ORGANIZATION_ID AND CQL.ORGANIZATION_ID = MMT.ORGANIZATION_ID AND CQL.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID AND CQL.COST_GROUP_ID = NVL(MPP.COSTING_GROUP_ID, MP.DEFAULT_COST_GROUP_ID) AND LU.LOOKUP_TYPE = 'SYS_YES_NO' AND LU.LOOKUP_CODE = DECODE(MSI.INVENTORY_ASSET_FLAG,'Y',1,2) AND &P_ITEM_WHERE AND &P_CAT_WHERE and CQL.COST_GROUP_ID = :AC_CG_ID BOM CSTRISLR_XML AR CST تقرير الأستاذ الفرعي للمخزون (تنسيق XML) Imported from BI Publisher Description: تقرير الأستاذ الفرعي للمخزون Application: شجرة المنتجات Source: تقرير الأستاذ الفرعي للمخزون (تنسيق XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG D CST Nebenbuch - Lager Imported from BI Publisher Description: Nebenbuch - Lager Application: Produktionsdaten Source: Nebenbuch - Lager (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG E CST Contabilidad Auxiliar de Inventario Imported from BI Publisher Description: Informe de contabilidad auxiliar de inventario Application: Bills of Material Source: Contabilidad Auxiliar de Inventario (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG F CST Etat Auxiliaires des stocks Imported from BI Publisher Description: Etat Auxiliaires des stocks Application: Bills of Material Source: Etat Auxiliaires des stocks (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG I CST Rapporto Sezionale di magazzino Imported from BI Publisher Description: Rapporto Dettagli sezionali magazzino Application: Bills of Material Source: Rapporto Sezionale di magazzino (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG JA CST 在庫補助元帳レポート Imported from BI Publisher Description: 在庫補助元帳レポート Application: Bills of Material Source: 在庫補助元帳レポート(XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG KO CST 재고 보조 원장 보고서 Imported from BI Publisher Description: 재고 보조 원장 보고서 Application: Bills of Material Source: 재고 보조 원장 보고서(XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG PTB CST Relatório de Sub-razão do Inventário Imported from BI Publisher Description: Relatório de Sub-razão do Inventário Application: Bills of Material Source: Relatório de Sub-razão do Inventário (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG RU CST Отчет по субкниге запасов Imported from BI Publisher Description: Отчет по субкниге запасов Application: Спецификации Source: Отчет по субкниге запасов (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG S CST Lagerreskontra - rapport Imported from BI Publisher Description: Lagerreskontra - rapport Application: Bills of Material Source: Lagerreskontra - rapport (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG TR CST Envanter Cari Hesap Raporu Imported from BI Publisher Description: Envanter Cari Hesap Raporu Application: Ürün Ağacı Source: Envanter Cari Hesap Raporu (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG US CST Inventory Subledger Imported from BI Publisher Description: Inventory Subledger Report Application: Bills of Material Source: Inventory Subledger Report (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG ZHS CST 库存子分类帐报表 Imported from BI Publisher Description: 库存子分类帐报表 Application: 物料清单管理系统 Source: 库存子分类帐报表 (XML) Short Name: CSTRISLR_XML DB package: BOM_CSTRISLR_XMLP_PKG BI Publisher &p_cat_seg &p_cat_where &p_item_seg &p_item_where &p_loc_seg :ac_cg_id :ac_i_quantity :lp_qty_precision :p_acct_seg1 :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_currency_code :p_currency_dsp :p_exchange_rate :p_exchange_rate_char :p_exp_item :p_ext_prec :p_inverse_rate :p_item_from :p_item_revision :p_item_seg :p_item_to :p_item_where :p_loc_seg :p_neg_qty :p_org_id :p_organization :p_qty_precision :p_rate_type :p_subinv_from :p_subinv_to :p_trace :p_view_cost :p_zero_qty :round_unit 1 -80 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف التنظيم معرف التنظيم D Organisationskennung Organisationskennung E Id Organización Id Organización F ID organisation ID organisation I Id organizzazione Id dell'organizzazione JA 組織ID 組織ID KO 조직 ID 조직 ID PTB Id da Organização Id da Organização RU Идентификатор организации Идентификатор организации S Organisations-id Organisations-id TR Organizasyon No Organizasyon No US Organization Id Organization Id ZHS 组织标识 组织标识 2 -70 :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 类别结构 类别结构 3 -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 显示逆汇率 4 -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 汇率类型 5 -40 :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 数量精确度 数量精确度 6 -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 查看成本权限 查看成本权限 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 :debugflag Char N AR علامة معالجة الأخطاء علامة معالجة الأخطاء D DebugFlag Debug-Kennzeichen E Depurar Depuración F Indicateur Diagnostic Indicateur Diagnostic I Flag Debug Flag Debug JA デバッグ・フラグ デバッグ・フラグ KO 디버그 플래그 디버그 플래그 PTB DebugFlag Indicador de Depuração RU DebugFlag Флаг отладки S DebugFlag Felsökningsflagga TR Hata Ayıklama İşareti Hata Ayıklama İşareti US DebugFlag Debug Flag ZHS 调试标志 调试标志 9 10 :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 物料自 物料自 10 20 :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 物料至 物料至 11 30 :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 类别集 类别集 12 40 :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 类别自 类别自 13 50 :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 类别至 类别至 14 60 :p_subinv_from LOV Oracle CST_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR مخزن من مخزن من D Von Lager Von Lager E De Subalmacén De Subalmacén F Magasin - De Magasin - De I Sottomagazzino - Da Sottomagazzino - Da JA 保管場所:自 保管場所:自 KO 창고: 부터 창고: 부터 PTB Subinventário - De Subinventário - De RU Складское подразделение с Складское подразделение с S Från lagerställe Från lagerställe TR Stok Yeri: İlk Stok Yeri: İlk US Subinventory From Subinventory From ZHS 子库存自 子库存自 15 70 :p_subinv_to LOV Oracle CST_SRS_SUBINVENTORY Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by secondary_inventory_name AR مخزن إلى مخزن إلى D Bis Lager Bis Lager E A Subalmacén A Subalmacén F Magasin - A Magasin - A I Sottomagazzino - A Sottomagazzino - A JA 保管場所:至 保管場所:至 KO 창고: 까지 창고: 까지 PTB Subinventário - Até Subinventário - Até RU Складское подразделение по Складское подразделение по S Till lagerställe Till lagerställe TR Stok Yeri: Son Stok Yeri: Son US Subinventory To Subinventory To ZHS 子库存至 子库存至 16 80 :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 90 :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 汇率 汇率 18 100 :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 按版本列出的数量 按版本列出的数量 19 110 :p_neg_qty 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 negative Mengen Nur negative Mengen E Sólo Cantidades Negativas Sólo Cantidades Negativas F Quantités négatives seulement Quantités négatives seulement I Solo quantità negative Solo quantità negative JA マイナスの数量のみ マイナスの数量のみ KO 음의 수량만 음의 수량만 PTB Apenas Quantidades Negativas Apenas Quantidades Negativas RU Только отрицательные количества Только отрицательные количества S Endast negativa kvantiteter Endast negativa kvantiteter TR Sadece Negatif Miktarlar Sadece Negatif Miktarlar US Negative Quantities Only Negative Quantities Only ZHS 仅限于负数量 仅限于负数量 20 120 :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 Conceptos 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 Despesa RU Включить статьи расхода Включить статьи расхода S Inkludera utgiftsposter Inkludera utgiftsposter TR Gider Kalemlerini Dahil Et Gider Kalemlerini Dahil Et US Include Expense Items Include Expense Items ZHS 包括低值易耗品 包括低值易耗品 21 130 :p_zero_qty 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 Nullmengen Mit Nullmengen E Incluir Cantidades Cero Incluir Cantidades Cero F Inclure les quantités zéro Inclure les quantités zéro I Includi quantità zero Include le quantità zero JA ゼロ数量を含む ゼロ数量を含む KO 영(0) 수량 포함 영(0) 수량 포함 PTB Incluir Quantidades Zero Incluir Quantidades Zero RU Включить нулевые количества Включить нулевые количества S Inkludera nollkvantiteter Inkludera nollkvantiteter TR Sıfır Miktarları Dahil Et Sıfır Miktarları Dahil Et US Include Zero Quantities Include Zero Quantities ZHS 包括零数量 包括零数量