ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4700251A9E05362FB09050512 select pit.tag_number, pit.subinventory, &P_item_flex C_item_flex, pit.revision, &P_loc_flex C_loc_flex, loc.inventory_location_id loc_id, pit.lot_number , pit.serial_num Serial_number, pit.tag_quantity quantity, pit.tag_uom uom, v.last_name Counted_by, pit.inventory_item_Id item_id, pit.outermost_lpn_id, pit.parent_lpn_id , pit.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_loc_field', 'INV', 'MTLL', 101, LOC.ORGANIZATION_ID, LOC.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_loc_field, INV_INVARPMT_XMLP_PKG.cf_outermost_lpnformula(pit.outermost_lpn_id) CF_OUTERMOST_LPN, INV_INVARPMT_XMLP_PKG.cf_parent_lpnformula(pit.parent_lpn_id) CF_PARENT_LPN, INV_INVARPMT_XMLP_PKG.cf_cost_groupformula(pit.cost_group_id) CF_COST_GROUP from mtl_system_items msi, mtl_item_locations loc , mtl_employees_view v, mtl_physical_inventory_tags pit where pit.organization_id = :P_org_id and msi.organization_id(+) = :P_org_id and loc.organization_id(+) = :P_org_id and pit.inventory_item_id = msi.inventory_item_id(+) and pit.locator_id = loc.inventory_location_id(+) and pit.physical_inventory_id = :P_phys_inv_id &C_where and pit.counted_by_employee_id = v.employee_id(+) and v.organization_id(+) = :P_org_id -- P_condition this does not do any thing order by 1 Y INV INVARPMT_XML AR INV قائمة بطاقات المخزون الفعلي غير الموجودة (بتنسيق XML) Imported from BI Publisher Description: قائمة بطاقات المخزون الفعلي المفقودة Application: المخازن Source: قائمة بطاقات المخزون الفعلي غير الموجودة (بتنسيق XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG D INV Stichtagsinventur - fehlende Belege Imported from BI Publisher Description: Stichtagsinventur - fehlende Belege Application: Lager Source: Stichtagsinventur - fehlende Belege (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG E INV Listado de Etiquetas Perdidas del Inventario Físico Imported from BI Publisher Description: Listado de Etiquetas No Contadas del Inventario Físico Application: Inventory Source: Listado de Etiquetas Perdidas del Inventario Físico (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG F INV Liste des fiches manquantes dans l'inventaire physique Imported from BI Publisher Description: Liste des fiches manquantes dans l'inventaire physique Application: Inventory Source: Liste des fiches manquantes dans l'inventaire physique (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG I INV Elenco cartellini mancanti in inventario fisico Imported from BI Publisher Description: Elenco cartellini mancanti in inventario fisico Application: Inventory Source: Elenco cartellini mancanti in inventario fisico (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG JA INV 実地棚卸不明現品票リスト Imported from BI Publisher Description: 実地棚卸不明現品票リスト Application: Inventory Source: 実地棚卸不明現品票リスト(XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG KO INV 총실사 누락 태그 목록 Imported from BI Publisher Description: 총실사 누락 태그 목록 Application: Inventory Source: 총실사 누락 태그 목록(XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG PTB INV Lista de etiquetas ausentes de inventário físico Imported from BI Publisher Description: Lista de etiqueta ausente de inventário físico Application: Inventário Source: Lista de etiquetas ausentes de inventário físico (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG RU INV Список недостающих инвентарных ярлыков Imported from BI Publisher Description: Список недостающих инвентарных ярлыков Application: Запасы Source: Список недостающих инвентарных ярлыков (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG S INV Lista över saknade kort Imported from BI Publisher Description: Inventering saknade kort - lista Application: Inventory Source: Inventering: Lista över saknade kort (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG TR INV Fiziksel sayım eksik etiket listesi Imported from BI Publisher Description: Fiziksel sayım eksik etiket listesi Application: Stok Yönetimi Source: Fiziksel sayım eksik etiket listesi (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG US INV Physical inventory missing tag listing Imported from BI Publisher Description: Physical inventory missing tag listing Application: Inventory Source: Physical inventory missing tag listing (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG ZHS INV 实地盘点遗漏货签列表 Imported from BI Publisher Description: 实地盘点丢失货签列表 Application: 库存管理系统 Source: 实地盘点遗漏货签列表 (XML) Short Name: INVARPMT_XML DB package: INV_INVARPMT_XMLP_PKG BI Publisher &c_where &p_item_flex &p_loc_flex :p_conc_request_id :p_condition :p_item_flex :p_loc_flex :p_org_id :p_phys_inv_id :p_qty_precision :p_report_id :p_struct_num :p_wms_installed 1 -30 :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 -20 :p_report_id Number 2 Y AR خيار التقرير خيار التقرير D Auswertungsoption Auswertungsoption E Opción de Informe Opción de Informe F Option d'état Option d'état 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 报表选项 报表选项 3 10 :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 实地盘点 实地盘点名称