ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4700651A9E05362FB09050512Y SELECT decode(:P_report_option,1,MPI.PHYSICAL_INVENTORY_DATE ,sysdate) PI_DATE, MPA.SUBINVENTORY_NAME SUBINV, ROUND(SUM(MPA.SYSTEM_QUANTITY * nvl(MPA.ACTUAL_COST,0)),:C_std_prec) SYSTEM_VALUE, ROUND(SUM(NVL(MPA.COUNT_QUANTITY,0) * nvl(MPA.ACTUAL_COST,0)),:C_std_prec) COUNT_VALUE, ROUND(SUM((NVL(MPA.COUNT_QUANTITY,0)-MPA.SYSTEM_QUANTITY) * nvl(MPA.ACTUAL_COST,0)),:C_std_prec) ADJMNT_VALUE, ROUND(SUM(ABS(NVL(MPA.COUNT_QUANTITY,0)-SYSTEM_QUANTITY) * nvl(MPA.ACTUAL_COST,0)),:C_std_prec) ABSOLUTE_VARIANCE, 0 NUM_TAGS, COUNT ( DECODE(MPA.ADJUSTMENT_QUANTITY,0,NULL,MPA.ADJUSTMENT_QUANTITY)) NUM_TXNS, INV_INVARPTS_XMLP_PKG.c_adj_pctformula(ROUND ( SUM ( ( NVL ( MPA.COUNT_QUANTITY , 0 ) - MPA.SYSTEM_QUANTITY ) * nvl ( MPA.ACTUAL_COST , 0 ) ) , :C_std_prec ), ROUND ( SUM ( NVL ( MPA.COUNT_QUANTITY , 0 ) * nvl ( MPA.ACTUAL_COST , 0 ) ) , :C_std_prec )) C_adj_pct, INV_INVARPTS_XMLP_PKG.c_var_pctformula(ROUND ( SUM ( ABS ( NVL ( MPA.COUNT_QUANTITY , 0 ) - SYSTEM_QUANTITY ) * nvl ( MPA.ACTUAL_COST , 0 ) ) , :C_std_prec ), ROUND ( SUM ( NVL ( MPA.COUNT_QUANTITY , 0 ) * nvl ( MPA.ACTUAL_COST , 0 ) ) , :C_std_prec )) C_var_pct, INV_INVARPTS_XMLP_PKG.c_num_tagsformula(MPA.SUBINVENTORY_NAME) C_num_tags FROM MTL_PHYSICAL_INVENTORIES MPI, MTL_PHYSICAL_ADJUSTMENTS MPA WHERE MPA.ORGANIZATION_ID + 0 = :P_ORG_ID AND MPI.ORGANIZATION_ID = :P_ORG_ID AND MPA.PHYSICAL_INVENTORY_ID = MPI.PHYSICAL_INVENTORY_ID AND MPI.PHYSICAL_INVENTORY_ID = nvl(:P_PHYS_INV_ID, MPI.PHYSICAL_INVENTORY_ID) &C_where_option GROUP BY decode(:P_report_option,1,MPI.PHYSICAL_INVENTORY_DATE,sysdate), MPA.SUBINVENTORY_NAME ORDER BY decode(:P_report_option,1,MPI.PHYSICAL_INVENTORY_DATE,sysdate), MPA.SUBINVENTORY_NAME INV INVARPTS_XML AR INV تحليل اتجاه وإجمالي المخزون الفعلي (بتنسيق XML) Imported from BI Publisher Description: تحليل اتجاه وإجمالي المخزون الفعلي Application: المخازن Source: تحليل اتجاه وإجمالي المخزون الفعلي (بتنسيق XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG D INV Stichtagsinventur - Trend und Übersicht Imported from BI Publisher Description: Stichtagsinventur - Trend und Übersicht Application: Lager Source: Stichtagsinventur - Trend und Übersicht (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG E INV Análisis de Tendencias y Resumen del Inventario Físico Imported from BI Publisher Description: Análisis de Tendencias y Resumen del Inventario Físico Application: Inventory Source: Análisis de Tendencias y Resumen del Inventario Físico (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG F INV Analyse de tendance et de synthèse de l'inventaire physique Imported from BI Publisher Description: Analyse de tendance et de synthèse de l'inventaire physique Application: Inventory Source: Analyse de tendance et de synthèse de l'inventaire physique (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG I INV Analisi sintetica e andamento inventario fisico Imported from BI Publisher Description: Analisi sintetica e andamento inventario fisico Application: Inventory Source: Analisi sintetica e andamento inventario fisico (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG JA INV 実地棚卸トレンドと要約分析 Imported from BI Publisher Description: 実地棚卸トレンドと要約分析 Application: Inventory Source: 実地棚卸トレンドと要約分析(XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG KO INV 총실사 경향과 요약 분석 Imported from BI Publisher Description: 총실사 경향과 요약 분석 Application: Inventory Source: 총실사 경향과 요약 분석(XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG PTB INV Análise de resumo e tendência do inventário físico Imported from BI Publisher Description: Análise de sumário e tendência de inventário físico Application: Inventário Source: Análise de resumo e tendência do inventário físico (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG RU INV Анализ тренда и сводки общей инвентаризации Imported from BI Publisher Description: Анализ тренда и сводки общей инвентаризации Application: Запасы Source: Анализ тренда и сводки общей инвентаризации (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG S INV Inventering trend- och översiktsanalys Imported from BI Publisher Description: Inventering trend- och översiktsanalys Application: Inventory Source: Inventering trend- och översiktsanalys (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG TR INV Fiziksel sayım eğilim ve özet analizi Imported from BI Publisher Description: Fiziksel sayım eğilim ve özet analizi Application: Stok Yönetimi Source: Fiziksel sayım eğilim ve özet analizi (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG US INV Physical inventory trend and summary analysis Imported from BI Publisher Description: Physical inventory trend and summary analysis Application: Inventory Source: Physical inventory trend and summary analysis (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG ZHS INV 实地盘点趋势和汇总分析 Imported from BI Publisher Description: 实地盘点趋势和汇总分析 Application: 库存管理系统 Source: 实地盘点趋势和汇总分析 (XML) Short Name: INVARPTS_XML DB package: INV_INVARPTS_XMLP_PKG BI Publisher &c_where_option :c_std_prec :p_conc_request_id :p_condition :p_org_id :p_phys_inv_id :p_report_option :p_struct_num :p_subinv_name 1 -20 :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 10 :p_report_option LOV Oracle INV_SRS_PTS_OPTION Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_PTS_OPTION' and enabled_flag='Y' order by value,description 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 20 :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 实地盘点 实地盘点名称