ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4701D51A9E05362FB09050512Y SELECT mrh.replenishment_count_name , mrl.organization_id , mrh.subinventory_code , mrh.count_date , mrh.supply_cutoff_date , mrh.process_status process_status_code , mrl.inventory_item_id item_id , mrl.locator_id locator_id , mrl.count_type_code , mrl.primary_uom_code UOM , mrl.primary_uom_count_quantity count_qty , mrl.supply_quantity supply_qty , mrl.reorder_quantity reorder_qty , mrl.source_type source_type_code , mrl.source_organization_id source_org_id , mrl.source_subinventory source_subinventory , mrl.expense_account expense_account_id , mrl.error_flag error_code , msi.description item_description , null C_ITEM_FLEXDAT , null C_EXPENSE_ACCT_FLEXDAT , sub.planning_level planning_level , sub.quantity_tracked quantity_tracked, INV_INVRCWSR_XMLP_PKG.cf_process_statusformula(mrh.process_status) CF_PROCESS_STATUS, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_item', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') CF_ITEM, INV_INVRCWSR_XMLP_PKG.cf_locatorformula(mrl.locator_id, mrl.organization_id) CF_LOCATOR, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_expense_account', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_EXPENSE_ACCOUNT, INV_INVRCWSR_XMLP_PKG.cf_par_levelformula(mrl.locator_id, mrl.inventory_item_id) CF_PAR_LEVEL, INV_INVRCWSR_XMLP_PKG.cf_errorformula(mrl.error_flag, mrh.process_status, sub.planning_level, sub.quantity_tracked, mrl.count_type_code, mrl.locator_id, INV_INVRCWSR_XMLP_PKG.cf_par_levelformula(mrl.locator_id, mrl.inventory_item_id)) CF_ERROR, INV_INVRCWSR_XMLP_PKG.cf_count_typeformula(mrl.count_type_code) CF_COUNT_TYPE, INV_INVRCWSR_XMLP_PKG.cf_source_typeformula(mrl.source_type) CF_SOURCE_TYPE, INV_INVRCWSR_XMLP_PKG.cf_source_org_codeformula(mrl.source_organization_id) CF_SOURCE_ORG_CODE FROM mtl_replenish_headers mrh , mtl_replenish_lines mrl , mtl_system_items msi , mtl_item_locations mil , mtl_secondary_inventories sub , gl_code_combinations gcc WHERE mrh.organization_id = :P_ORG_ID AND mrh.replenishment_header_id = :P_HEADER_ID AND mrl.replenishment_header_id = mrh.replenishment_header_id AND msi.organization_id = mrl.organization_id AND msi.inventory_item_id = mrl.inventory_item_id AND mil.organization_id = mrl.organization_id AND mil.inventory_location_id = mrl.locator_id AND sub.organization_id = mrl.organization_id AND sub.secondary_inventory_name = mrh.subinventory_code AND mrl.expense_account = gcc.code_combination_id (+) ORDER BY mil.picking_order, C_ITEM_FLEXDAT INV INVRCWSR_XML AR INV ورقة عمل جرد استعواض PAR (بتنسيق XML) Imported from BI Publisher Description: ورقة عمل جرد استعواض PAR Application: المخازن Source: ورقة عمل جرد استعواض PAR (بتنسيق XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG D INV PAR Arbeitsblatt für Aufnahmen der Bestandsauffüllung Imported from BI Publisher Description: PAR Arbeitsblatt Aufnahmen der Bestandsauffüllung Application: Lager Source: PAR Arbeitsblatt für Aufnahmen der Bestandsauffüllung (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG E INV Hoja de Trabajo de Recuento de Reaprovisionamiento de PAR Imported from BI Publisher Description: Hoja de Trabajo de Recuento de Reaprovisionamiento de PAR Application: Inventory Source: Hoja de Trabajo de Recuento de Reaprovisionamiento de PAR (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG F INV PAR - Feuille de travail de comptage pour réapprovisionnement Imported from BI Publisher Description: PAR - Feuille de travail de comptage pour réapprovisionnement Application: Inventory Source: PAR - Feuille de travail de comptage pour réapprovisionnement (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG I INV Foglio di lavoro inventario per rifornimento PAR Imported from BI Publisher Description: Foglio di lavoro inventario per rifornimento (PAR) Application: Inventory Source: Foglio di lavoro inventario per rifornimento PAR (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG JA INV PAR補充数量計算ワークシート Imported from BI Publisher Description: PAR補充数量計算ワークシート Application: Inventory Source: PAR補充数量計算ワークシート(XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG KO INV PAR 보충 실사 워크시트 Imported from BI Publisher Description: PAR 보충 실사 워크시트 Application: Inventory Source: PAR 보충 실사 워크시트(XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG PTB INV PAR - Planilha da Contagem de Reposição Imported from BI Publisher Description: PAR - Planilha da Contagem de Reposição Application: Inventário Source: PAR - Planilha da Contagem de Reposição (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG RU INV Таблица недостающих количеств ПАП Imported from BI Publisher Description: Таблица недостающих количеств ПАП Application: Запасы Source: Таблица недостающих количеств ПАП (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG S INV Arbetsblad för påfyllnadsinventering Imported from BI Publisher Description: PAR: Arbetsblad för påfyllnadsinventering Application: Inventory Source: PAR: Arbetsblad för påfyllnadsinventering (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG TR INV PAR Stok Yenileme Sayımı Çalışma Sayfası Imported from BI Publisher Description: PAR Stok Yenileme Sayımı Çalışma Sayfası Application: Stok Yönetimi Source: PAR Stok Yenileme Sayımı Çalışma Sayfası (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG US INV PAR Replenishment Count Worksheet Imported from BI Publisher Description: PAR Replenishment Count Worksheet Application: Inventory Source: PAR Replenishment Count Worksheet (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG ZHS INV PAR 补充盘点工作表 Imported from BI Publisher Description: PAR 补充盘点工作表 Application: 库存管理系统 Source: PAR 补充盘点工作表 (XML) Short Name: INVRCWSR_XML DB package: INV_INVRCWSR_XMLP_PKG BI Publisher :order_by_clause :p_actual_start_date :p_application_name :p_conc_request_id :p_count_type_onhand :p_count_type_order :p_count_type_par :p_error :p_expense_acct_flexsql :p_expenseaccount_flexnum :p_header_id :p_item_flexsql :p_item_locator_found :p_locator_flexsql :p_org_code :p_org_id :p_org_name :p_printer :p_qty_precision :p_rc_subinv :p_report_name :p_request_date :p_responsibility_name :p_source_type_inv :p_source_type_sub :p_source_type_supplier :p_status_completed :p_status_error :p_status_hold :p_status_pending :p_status_processing 1 -20 :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 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 10 :p_rc_subinv LOV Oracle INV_SRS_LOC_PLAN_SUBINV 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') and planning_level=1 order by secondary_inventory_name AR المخزن المخزن المخطط على مستوى محدد المواقع D Lager Auf Lagerplatzebene geplantes Lager E Subalmacén Subalmacén Planificado en Nivel de Ubicación F Magasin Magasin planifié de niveau Emplacement I Sottomagazzino Sottomagazzino pianificato a livello collocazione JA 保管場所 保管棚レベル計画保管場所 KO 창고 보관처 레벨 계획 창고 PTB Subinventário Subinventário planejado no nível do endereço RU Складское подразделение Складское подразделение, планируемое на уровне складского места S Lagerställe Lagerställe som har planerats på lagerplatsnivå TR Stok Yeri Stok adresi düzeyinde planlana Stok Yeri US Subinventory Locator level planned Subinventory ZHS 子库存 货位层计划子库存 3 20 :p_header_id LOV Oracle INV_SRS_LOC_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 rch.process_status=2 and rch.subinventory_code= nvl(:$flex$.inv_srs_loc_plan_subinv,rch.subinventory_code) order by rch.count_date desc Y AR اسم الجرد معرف عنوان الجرد المخطط على مستوى محدد المواقع D Aufnahmebezeichnung Auf Lagerplatzebene geplante Bestandsaufnahme - Kopfkennung E Recuento Id Cabecera de Recuento de Planificado en Nivel de Ubicación F Nom comptage ID en-tête de comptage planifié de niveau Emplacement I Nome inventario Id intestazione inventario pianificato a livello collocazione JA 棚卸名 保管棚レベル計画棚卸ヘッダーID KO 실사 명 보관처 레벨 계획 실사 헤더 ID PTB Nome da Contagem Id do Cabeçalho da contagem planejada no nível do endereço RU Имя инвентаризации Идентификатор заголовка подсчета количеств, планируемых на уровне складского места S Inventeringsnamn Rubrik-id för antal som har planerats på lagerplatsnivå TR Sayım Adı Stok adresi düzeyinde planlanan sayım Başlığı No US Count Name Locator level planned count Header Id ZHS 盘点名 货位层计划盘点题头标识