ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4701151A9E05362FB09050512Y select mrh.replenishment_count_name CountName, mrh.subinventory_code , mrh.Count_Date, mfg3.meaning ProcessStatus, mrh.supply_cutoff_date, mrl.inventory_item_id item_id, mfg2.meaning count_type, mrl.primary_uom_code uom, nvl(mrl.primary_uom_count_quantity,0) count_qty, nvl(mrl.supply_quantity,0) supply_qty, nvl(mrl.reorder_quantity,0) reorder_qty, mfg1.meaning source_type, decode(mrl.source_organization_id, null,'',orgs.organization_code) source_organization, mrl.source_subinventory source_subinventory, mfg.meaning error_message, mrl.error_flag error_code, mrl.expense_account ExpenseAccount_Flexid, null ExpenseAccount_Flexdat, &P_ITEM_FLEXSQL C_ITEM_FLEXDAT, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_item_flexval', 'INV', 'MSTK', 101, SYS.ORGANIZATION_ID, SYS.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') F_Item_FlexVal, fnd_flex_xml_publisher_apis.process_kff_combination_1('f_expenseaccount_flex', 'SQLGL', 'GL#', GLC_1.CHART_OF_ACCOUNTS_ID, NULL, GLC_1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') F_ExpenseAccount_Flex from mfg_lookups mfg, mfg_lookups mfg1, mfg_lookups mfg2, mfg_lookups mfg3, org_organization_definitions orgs, mtl_system_items sys, mtl_replenish_lines mrl, gl_code_combinations glc_1, mtl_replenish_headers mrh where sys.organization_id = :P_ORG_ID and mrl.organization_id = :P_ORG_ID and mrl.replenishment_header_id = :P_HeaderID and sys.inventory_item_id = mrl.inventory_item_id and mrl.error_flag = mfg.lookup_code(+) and mfg.lookup_type(+) = 'MTL_REPLENISHMENT_ERROR' and mrl.source_type = mfg1.lookup_code(+) and mfg1.lookup_type(+) = 'MTL_SOURCE_TYPES' and mrl.source_organization_id = orgs.organization_id (+) and mfg2.lookup_type = 'MTL_COUNT_TYPES' and mfg2.lookup_code = mrl.count_type_code and mrl.expense_account = glc_1.code_combination_id (+) and mrh.organization_id = :P_ORG_ID and mrh.replenishment_header_id = :P_HeaderID and mrh.process_status = mfg3.lookup_code and mfg3.lookup_type = 'MTL_COUNT_STATUS' ORDER BY 19 INV INVIRRCR_XML AR INV تقرير جرد استعواض الأصناف (بتنسيق XML) Imported from BI Publisher Description: تقرير جرد استعواض الصنف Application: المخازن Source: تقرير جرد استعواض الأصناف (بتنسيق XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG D INV Bestandsauffüllung - Aufnahmen Imported from BI Publisher Description: Auswertung "Bestandsauffüllung - Aufnahmen" Application: Lager Source: Bestandsauffüllung - Aufnahmen (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG E INV Recuento de Reaprovisionamiento de Artículos Imported from BI Publisher Description: Informe de recuento de reaprovisionamiento de artículos Application: Inventory Source: Recuento de Reaprovisionamiento de Artículos (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG F INV Etat des quantités de réapprovisionnement Imported from BI Publisher Description: Etat des quantités de réapprovisionnement Application: Inventory Source: Etat des quantités de réapprovisionnement (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG I INV Rapporto Inventario per rifornimento articoli Imported from BI Publisher Description: Rapporto Inventario per rifornimento articoli Application: Inventory Source: Rapporto Inventario per rifornimento articoli (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG JA INV 品目補充数量計算レポート Imported from BI Publisher Description: 品目補充数量計算レポート Application: Inventory Source: 品目補充数量計算レポート(XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG KO INV 품목 보충 실사 보고서 Imported from BI Publisher Description: 품목 보충 실사 보고서 Application: Inventory Source: 품목 보충 실사 보고서(XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG PTB INV Relatório de contagem de reposição de item Imported from BI Publisher Description: Relatório de contagem de reposição de item Application: Inventário Source: Relatório de contagem de reposição de item (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG RU INV Отчет о подсчете недостающих количеств для позиций Imported from BI Publisher Description: Отчет о подсчете недостающих количеств для позиций Application: Запасы Source: Отчет о подсчете недостающих количеств для позиций (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG S INV Påfyllnadsinventering av artiklar - rapport Imported from BI Publisher Description: Påfyllnadsinventering av artiklar - rapport Application: Inventory Source: Påfyllnadsinventering av artiklar - rapport (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG TR INV Kalem stok yenileme sayımı raporu Imported from BI Publisher Description: Kalem stok yenileme sayımı raporu Application: Stok Yönetimi Source: Kalem stok yenileme sayımı raporu (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG US INV Item replenishment count Imported from BI Publisher Description: Item replenishment count report Application: Inventory Source: Item replenishment count report (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG ZHS INV 物料补充盘点报表 Imported from BI Publisher Description: 物料补充盘点报表 Application: 库存管理系统 Source: 物料补充盘点报表 (XML) Short Name: INVIRRCR_XML DB package: INV_INVIRRCR_XMLP_PKG BI Publisher &p_item_flexsql :p_cbo_flag :p_conc_request_id :p_expenseaccount_flexnum :p_expenseaccount_flexsql :p_headerid :p_item_flexnum :p_item_flexsql :p_locator_flexsql :p_locator_struc_num :p_org_id :p_qty_precision :p_trace_flag 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_headerid LOV Oracle INV_SRS_SUB_REPLENISH_COUNT_HDR Y select replenishment_header_id id, replenishment_count_name value, null description from mtl_replenish_headers rch where rch.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and (select planning_level from mtl_secondary_inventories sub where sub.organization_id=rch.organization_id and sub.secondary_inventory_name=rch.subinventory_code)=2 order by rch.count_date desc Y AR اسم الجرد اسم الجرد D Aufnahmebezeichnung Aufnahmebezeichnung E Recuento Recuento F Nom comptage Nom comptage I Nome inventario Nome inventario JA 棚卸名 棚卸名 KO 실사 명 실사 명 PTB Nome da Contagem Nome da Contagem RU Имя инвентаризации Имя инвентаризации S Inventeringsnamn Inventeringsnamn TR Sayım Adı Sayım Adı US Count Name Count Name ZHS 盘点名 盘点名