ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4700351A9E05362FB09050512Y select &P_item_flex C_item_flex, pit.revision, &P_cat_flex C_cat_flex, pit.tag_number, pit.subinventory, &P_loc_flex C_loc_flex, loc.inventory_location_id loc_id, nvl(decode(pit.void_flag,1,0,2,pit.TAG_QUANTITY_AT_STANDARD_UOM),0) Quantity, msi.primary_uom_code UOM, round(nvl(pit.item_cost,0) ,:C_ext_prec ) Cost, ppx.last_name Counted_by, decode(pit.item_cost, null, 1, 2) expense_flag, pit.parent_lpn_id parent_lpn_id, pit.outermost_lpn_id outermost_lpn_id, pit.cost_group_id cost_group_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_item_field, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_field', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_cat_field, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_field', 'INV', 'MTLL', 101, LOC.ORGANIZATION_ID, LOC.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_loc_field, INV_INVARPSL_XMLP_PKG.c_total_valueformula(nvl ( decode ( pit.void_flag , 1 , 0 , 2 , pit.TAG_QUANTITY_AT_STANDARD_UOM ) , 0 ), round ( nvl ( pit.item_cost , 0 ) , :C_ext_prec ), :C_std_prec) C_total_value, INV_INVARPSL_XMLP_PKG.cf_outermost_lpnformula(pit.outermost_lpn_id) CF_OUTERMOST_LPN, INV_INVARPSL_XMLP_PKG.cf_parent_lpnformula(pit.parent_lpn_id) CF_parent_lpn, INV_INVARPSL_XMLP_PKG.cf_cost_groupformula(pit.cost_group_id) CF_COST_GROUP from mtl_system_items msi, mtl_categories mc, mtl_item_categories mic, mtl_item_locations loc, per_people_x ppx, mtl_phy_inv_tags_cost_v pit where pit.organization_id = :P_org_id and pit.physical_inventory_id = :P_phys_inv_id and msi.organization_id = pit.organization_id and mic.organization_id = pit.organization_id and loc.organization_id(+) = pit.organization_id and pit.inventory_item_id = msi.inventory_item_id and pit.inventory_item_id = mic.inventory_item_id and mic.category_set_id = :P_category_set_id and mic.category_id = mc.category_id and pit.locator_id = loc.inventory_location_id(+) and pit.counted_by_employee_id = ppx.person_id(+) --order by C_order_by order by MSI.SEGMENT1,MC.SEGMENT1, MC.SEGMENT2,4,5 INV INVARPSL_XML AR INV تقرير جرد المخزون الفعلي (بتنسيق XML) Imported from BI Publisher Description: تقرير جرد المخزون الفعلي Application: المخازن Source: تقرير جرد المخزون الفعلي (بتنسيق XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG D INV Stichtagsinventur - Aufnahmen Imported from BI Publisher Description: Stichtagsinventur - Aufnahmen Application: Lager Source: Stichtagsinventur - Aufnahmen (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG E INV Recuentos del Inventario Físico Imported from BI Publisher Description: Recuentos del Inventario Físico Application: Inventory Source: Recuentos del Inventario Físico (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG F INV Etat Comptages d'inventaire physique Imported from BI Publisher Description: Etat Comptages d'inventaire physique Application: Inventory Source: Etat Comptages d'inventaire physique (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG I INV Rapporto Conteggi inventario fisico Imported from BI Publisher Description: Rapporto Dati inventario fisico Application: Inventory Source: Rapporto Conteggi inventario fisico (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG JA INV 実地棚卸レポート Imported from BI Publisher Description: 実地棚卸レポート Application: Inventory Source: 実地棚卸レポート(XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG KO INV 총실사 횟수 보고서 Imported from BI Publisher Description: 총실사 보고서 Application: Inventory Source: 총실사 횟수 보고서(XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG PTB INV Relatório de contagens de inventário físico Imported from BI Publisher Description: Relatório de contagens de inventário físico Application: Inventário Source: Relatório de contagens de inventário físico (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG RU INV Отчет о количествах общей инвентаризации Imported from BI Publisher Description: Отчет о количествах общей инвентаризации Application: Запасы Source: Отчет о количествах общей инвентаризации (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG S INV Inventeringar - rapport Imported from BI Publisher Description: Inventeringsantal - rapport Application: Inventory Source: Inventeringar - rapport (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG TR INV Fiziksel sayımlar raporu Imported from BI Publisher Description: Fiziksel sayımlar raporu Application: Stok Yönetimi Source: Fiziksel sayımlar raporu (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG US INV Physical inventory counts Imported from BI Publisher Description: Physical inventory counts report Application: Inventory Source: Physical inventory counts report (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG ZHS INV 实地盘点数量报表 Imported from BI Publisher Description: 实地盘点盘点报表 Application: 库存管理系统 Source: 实地盘点数量报表 (XML) Short Name: INVARPSL_XML DB package: INV_INVARPSL_XMLP_PKG BI Publisher &p_cat_flex &p_item_flex &p_loc_flex :c_ext_prec :c_std_prec :p_cat_flex :p_cat_struct_num :p_category_set_id :p_cbo_flag :p_conc_request_id :p_condition :p_item_flex :p_loc_flex :p_order_cat :p_order_item :p_org_id :p_phys_inv_id :p_qty_precision :p_sort_option :p_struct_num :p_trace_flag :p_wms_installed 1 -40 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 -30 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') AR خيار الدقة الديناميكية خيار الدقة الديناميكية D Option Nachkommastellen Option Nachkommastellen E Opción Precisión Dinámica Opción Precisión Dinámica F Option précision dynamique Option précision dynamique I Opzione precisione dinamica Opzione precisione dinamica JA 動的演算精度オプション 動的演算精度オプション KO 동적 소수점자리 옵션 동적 소수점자리 옵션 PTB Opção de Precisão Dinâmica Opção de Precisão Dinâmica RU Динамическая точность Динамическая точность S Alternativ för dynamisk precision Alternativ för dynamisk precision TR Dinamik Duyarlılık Seçeneği Dinamik Duyarlılık Seçeneği US Dynamic Precision Option Dynamic Precision Option ZHS 动态精确度选项 动态精确度选项 3 -20 :p_cat_struct_num Number select structure_id from mtl_category_sets where category_set_id = nvl(:$flex$.category_set,NULL) 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 10 :p_sort_option LOV Oracle INV_SRS_PSL_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_PSL_SORT' and enabled_flag='Y' order by lookup_code Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Ordenación F Tri par Option de tri I Ordina per Opzione di ordinamento JA ソート・キー ソート・オプション KO 정렬 기준 정렬 옵션 PTB Classificar por Opção de Classificação RU Сортировка Параметр сортировки S Sortera efter Sorteringsalternativ TR Sıralama Bazı Sıralama Seçeneği US Sort By Sort Option ZHS 排序依据 排序选项 5 20 :p_category_set_id LOV Oracle INV_SRS_CATEGORY_SET Y select category_set_id id, category_set_name value, description description from mtl_category_sets order by value,description select CATEGORY_SET_NAME from MTL_DEFAULT_SETS_VIEW where FUNCTIONAL_AREA_ID = 1 Y AR مجموعة الفئات اسم مجموعة الفئات D KategorieSet Bezeichnung KategorieSet E Juego de Categorías Nombre de Juego de Categorías F Jeu de catégories Nom du jeu de catégories I Serie di categorie Nome serie categorie JA カテゴリ・セット カテゴリ・セット名 KO 범주 세트 범주 세트명 PTB Conj. Categorias Nome do Conj. Categorias RU Набор катег. Имя набора категорий S Kategoriuppsättning Namn på kategoriuppsättning TR Kategori Kümesi Kategori Kümesi Adı US Category Set Category Set Name ZHS 类别集 类别集名称 6 30 :p_phys_inv_id LOV Oracle INV_SRS_PHYSICAL_INVENTORY Y select physical_inventory_id id, physical_inventory_name value, description description from mtl_physical_inventories where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description Y AR المخزون الفعلي اسم المخزون الفعلي D Stichtagsinventur Bezeichnung Stichtagsinventur E Inventario Físico Nombre de Inventario Físico F Inventaire physique Nom de l'inventaire physique I Inventario fisico Nome inventario fisico JA 実地棚卸 実地棚卸名 KO 총실사 총실사명 PTB Inventário Físico Nome do Inventário Físico RU Общая инвентаризация Имя общей инвентаризации S Lagerinventering Inventering: Namn TR Fiziksel Sayım Fiziksel Sayım Adı US Physical Inventory Physical Inventory Name ZHS 实地盘点 实地盘点名称