ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702F51A9E05362FB09050512Y SELECT DECODE(:P_GROUP_BY, 1, &P_CAT_FLEX, 3, MSSV.item_planner_code, 'X') C_GROUP_FLEX ,MSSV.object_type ,MSSV.object_type_meaning ,DECODE(:P_GROUP_BY, 2, 'X', &P_ITEM_FLEX) C_ITEM_FLEX ,DECODE(:P_GROUP_BY, 2, 'X', MSSV.item_description) C_ITEM_DESCRIPTION_POS ,DECODE(:P_GROUP_BY, 2, MSSV.item_description, 'X') C_ITEM_DESCRIPTION_HDR ,DECODE(:P_GROUP_BY, 1, MSSV.item_planner_code, 'X') C_PLANNER_CODE_POS ,DECODE(:P_GROUP_BY, 1, 'X', MSSV.item_planner_code) C_PLANNER_CODE_HDR ,MSSV.uom_code ,DECODE(:P_GROUP_BY, 2, MSSV.uom_code, 'X') C_UOM_CODE_HDR ,MSSV.quantity_open ,MSSV.object_name ,MSSV.object_detail_name ,MP.ORGANIZATION_CODE||' '||HOU.NAME ORG_NAME ,DECODE(:P_GROUP_BY, 2, 0, MSSV.inventory_item_id) C_INVENTORY_ITEM_ID_POS ,DECODE(:P_GROUP_BY, 2, MSSV.inventory_item_id, 0) C_INVENTORY_ITEM_ID_HDR, 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, INV_INVTRSHS_XMLP_PKG.c_net_qty_hdrformula(DECODE ( :P_GROUP_BY , 2 , MSSV.inventory_item_id , 0 )) C_NET_QTY_HDR, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_pad', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_CAT_PAD, null C_HDR_ITEM_PAD, null C_HDR_ITEM_FIELD, INV_INVTRSHS_XMLP_PKG.c_notificationformula(DECODE ( :P_GROUP_BY , 2 , MSSV.inventory_item_id , 0 ), DECODE ( :P_GROUP_BY , 2 , 0 , MSSV.inventory_item_id )) C_NOTIFICATION, INV_INVTRSHS_XMLP_PKG.c_net_qty_posformula(DECODE ( :P_GROUP_BY , 2 , 0 , MSSV.inventory_item_id )) C_NET_QTY_POS, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pos_item_pad', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_POS_ITEM_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pos_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_POS_ITEM_FIELD FROM mtl_short_summary_v MSSV ,hr_organization_units HOU ,mtl_parameters MP ,mtl_system_items MSI ,mtl_item_categories MIC, mtl_categories MC WHERE MSSV.organization_id = :P_ORG_ID AND MSSV.seq_num = :P_SEQ_NUM AND MSI.inventory_item_id = MSSV.inventory_item_id AND MSI.organization_id = :P_ORG_ID AND MSSV.organization_id = MP.organization_id AND MP.organization_id = HOU.organization_id AND &P_ITEM_WHERE AND &P_CAT_WHERE &C_CAT_WHERE &C_ITEMPLANNER_WHERE &C_ONHAND_WHERE and :P_GROUP_BY in (1,3) union SELECT DECODE(:P_GROUP_BY, 2, &P_ITEM_FLEX,'X') C_GROUP_FLEX ,MSSV.object_type ,MSSV.object_type_meaning ,DECODE(:P_GROUP_BY, 2, 'X', &P_ITEM_FLEX) C_ITEM_FLEX ,DECODE(:P_GROUP_BY, 2, 'X', MSSV.item_description) C_ITEM_DESCRIPTION_POS ,DECODE(:P_GROUP_BY, 2, MSSV.item_description, 'X') C_ITEM_DESCRIPTION_HDR ,DECODE(:P_GROUP_BY, 1, MSSV.item_planner_code, 'X') C_PLANNER_CODE_POS ,DECODE(:P_GROUP_BY, 1, 'X', MSSV.item_planner_code) C_PLANNER_CODE_HDR ,MSSV.uom_code ,DECODE(:P_GROUP_BY, 2, MSSV.uom_code, 'X') C_UOM_CODE_HDR ,MSSV.quantity_open ,MSSV.object_name ,MSSV.object_detail_name ,MP.ORGANIZATION_CODE||' '||HOU.NAME ORG_NAME ,DECODE(:P_GROUP_BY, 2, 0, MSSV.inventory_item_id) C_INVENTORY_ITEM_ID_POS ,DECODE(:P_GROUP_BY, 2, MSSV.inventory_item_id, 0) C_INVENTORY_ITEM_ID_HDR, null C_CAT_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, INV_INVTRSHS_XMLP_PKG.c_net_qty_hdrformula(DECODE ( :P_GROUP_BY , 2 , MSSV.inventory_item_id , 0 )) C_NET_QTY_HDR, --fnd_flex_xml_publisher_apis.process_kff_combination_1('c_cat_pad', 'INV', 'MCAT', MC.STRUCTURE_ID, NULL, MC.CATEGORY_ID, 'ALL', 'Y', 'PADDED_VALUE') C_CAT_PAD, null C_CAT_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_hdr_item_pad', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_HDR_ITEM_PAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_hdr_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_HDR_ITEM_FIELD, INV_INVTRSHS_XMLP_PKG.c_notificationformula(DECODE ( :P_GROUP_BY , 2 , MSSV.inventory_item_id , 0 ), DECODE ( :P_GROUP_BY , 2 , 0 , MSSV.inventory_item_id )) C_NOTIFICATION, INV_INVTRSHS_XMLP_PKG.c_net_qty_posformula(DECODE ( :P_GROUP_BY , 2 , 0 , MSSV.inventory_item_id )) C_NET_QTY_POS, null C_POS_ITEM_PAD, null C_POS_ITEM_FIELD -- fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pos_item_pad', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') C_POS_ITEM_PAD, --fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pos_item_field', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_POS_ITEM_FIELD FROM mtl_short_summary_v MSSV ,hr_organization_units HOU ,mtl_parameters MP ,mtl_system_items MSI /* Do not select from category tables.*/ WHERE MSSV.organization_id = :P_ORG_ID AND MSSV.seq_num = :P_SEQ_NUM AND MSI.inventory_item_id = MSSV.inventory_item_id AND MSI.organization_id = :P_ORG_ID AND MSSV.organization_id = MP.organization_id AND MP.organization_id = HOU.organization_id AND &P_ITEM_WHERE AND &P_CAT_WHERE /*&C_CAT_WHERE */ &C_ITEMPLANNER_WHERE &C_ONHAND_WHERE and :P_GROUP_BY=2 &C_ORDER_BY INV INVTRSHS_XML AR INV تقرير إجمالي العجز (بتنسيق XML) Imported from BI Publisher Description: تقرير إجمالي العجز Application: المخازن Source: تقرير إجمالي العجز (بتنسيق XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG D INV Engpässe - Übersicht Imported from BI Publisher Description: Engpässe - Übersicht Application: Lager Source: Engpässe - Übersicht (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG E INV Resumen de Escasez Imported from BI Publisher Description: Informe de resumen de escasez Application: Inventory Source: Resumen de Escasez (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG F INV Synthèse des manquants Imported from BI Publisher Description: Synthèse des manquants Application: Inventory Source: Synthèse des manquants (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG I INV Rapporto Sintetico ammanchi Imported from BI Publisher Description: Rapporto Sintetico carenze Application: Inventory Source: Rapporto Sintetico ammanchi (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG JA INV 在庫不足要約レポート Imported from BI Publisher Description: 在庫不足要約レポート Application: Inventory Source: 在庫不足要約レポート(XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG KO INV 부족 요약 보고서 Imported from BI Publisher Description: 부족 요약 보고서 Application: Inventory Source: 부족 요약 보고서(XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG PTB INV Relatório Resumido de Faltas Imported from BI Publisher Description: Relatório Sumariado de Faltas Application: Inventário Source: Relatório Resumido de Faltas (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG RU INV Сводный отчет о нехватках Imported from BI Publisher Description: Сводный отчет о нехватках Application: Запасы Source: Сводный отчет о нехватках (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG S INV Brister - översiktsrapport Imported from BI Publisher Description: Bristöversikt - rapport Application: Inventory Source: Brister - översiktsrapport (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG TR INV Eksiklikler Özet raporu Imported from BI Publisher Description: Eksiklikler Özet raporu Application: Stok Yönetimi Source: Eksiklikler Özet raporu (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG US INV Shortages Summary Imported from BI Publisher Description: Shortages Summary report Application: Inventory Source: Shortages Summary report (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG ZHS INV 短缺汇总报表 Imported from BI Publisher Description: 短缺汇总报表 Application: 库存管理系统 Source: 短缺汇总报表 (XML) Short Name: INVTRSHS_XML DB package: INV_INVTRSHS_XMLP_PKG BI Publisher &c_cat_where &c_itemplanner_where &c_onhand_where &c_order_by &p_cat_flex &p_cat_where &p_item_flex &p_item_where :p_cat_flex :p_cat_struct_num :p_cat_where :p_category_from :p_category_set :p_category_to :p_conc_request_id :p_g_false :p_g_ret_sts_success :p_g_true :p_group_by :p_inventory_item_id :p_item_flex :p_item_from :p_item_planner :p_item_to :p_item_where :p_onhand_only_yn :p_order_hdr :p_order_item :p_order_pos :p_org_id :p_send_notifications_yn :p_seq_num :p_struct_num 1 -30 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم معرف التنظيم D Organisation Organisationskennung E Organización Id Organización F Organisation ID organisation I Organizzazione ID organizzazione JA 組織 組織ID KO 조직 조직 ID PTB Organização ID da Organização RU Организация Идентификатор организации S Organisation Organisations-id TR Organizasyon Organizasyon No US Organization Organization ID ZHS 组织 组织标识 2 -20 :p_cat_struct_num Number select structure_id from mtl_category_sets where category_set_id = :$flex$.item_category_set Y AR هيكل فئة الصنف هيكل فئة الصنف D Artikelkategorie-Struktur Artikelkategorie-Struktur E Estructura de Categorías de Artículos Estructura de Categorías de Artículos F Structure catégorie article Structure catégorie article I Struttura categoria articolo Struttura categoria articolo JA 品目カテゴリ体系 品目カテゴリ体系 KO 품목 범주 구조 품목 범주 구조 PTB Estrutura da Categoria de Item Estrutura da Categoria de Item RU Структура категорий позиций Структура категорий позиций S Artikelkategoristruktur Artikelkategoristruktur TR Kalem Kategorisi Yapısı Kalem Kategorisi Yapısı US Item Category Structure Item Category Structure ZHS 物料类别结构 物料类别结构 3 10 :p_group_by LOV Oracle INV_SRS_SHORT_SUM_GROUP_BY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_SHORT_SUM_PRINT_GROUP' order by lookup_code select meaning from mfg_lookups where lookup_type = 'MTL_SHORT_SUM_PRINT_GROUP' and lookup_code = 2 Y AR خيار المجموعة خيار المجموعة D Sortieroption Sortieroption E Opción de Grupo Opción de Grupo F Option de regroupement Option de regroupement I Opzione gruppo Opzione gruppo JA グループ・オプション グループ・オプション KO 그룹 옵션 그룹 옵션 PTB Opção de Grupo Opção de Grupo RU Вариант группировки Вариант группировки S Gruppalternativ Gruppalternativ TR Grup Seçeneği Grup Seçeneği US Group Option Group Option ZHS 分组选项 分组选项 4 20 :p_category_set 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 ArtikelkategorieSet ArtikelkategorieSet E Juego de Categorías de Artículos Juego de Categorías de Artículos F Jeu catég. article Jeu catég. article I Serie categorie articolo Serie categorie articolo JA 品目カテゴリ・セット 品目カテゴリ・セット KO 품목 범주 세트 품목 범주 세트 PTB Conjunto de Categorias do Item Conjunto de Categorias do Item RU Набор категорий позиций Набор категорий позиций S Artikelkategoriuppsättning Artikelkategoriuppsättning TR Kalem Kategori Kümesi Kalem Kategori Kümesi US Item Category Set Item Category Set ZHS 物料类别集 物料类别集 5 30 :p_category_from Char AR فئات الصنف من فئات الصنف من D Von Artikelkategorie Von Artikelkategorie E De Categoría de Artículo De Categoría de Artículo F Catégories article - De Catégories article - De I Categorie articolo - Da Categorie articolo - Da JA 品目カテゴリ:自 品目カテゴリ:自 KO 품목 범주: 부터 품목 범주: 부터 PTB Categorias de Item - De Categorias de Item - De RU Категории позиций с Категории позиций с S Från artikelkategori Från artikelkategori TR Kalem Kategorileri, İlk Kalem Kategorileri, İlk US Item Categories From Item Categories From ZHS 物料类别自 物料类别自 6 40 :p_category_to Char AR إلى فئات الصنف من D Bis Bis Artikelkategorie E A A Categoría de Artículo F A Catégories article - A I A Categorie articolo - A JA 至 品目カテゴリ:至 KO 까지 품목 범주: 까지 PTB Até Categorias de Item - Até RU По Категории позиций по S Till Till artikelkategori TR Son Kalem Kategorileri: Son US To Item Categories To ZHS 至 终止物料类别 7 50 :p_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler - İlk Kalemler - İlk US Items From Items From ZHS 物料自 物料自 8 60 :p_item_to Char AR إلى 2 الأصناف إلى D Bis 2 Bis Artikel E A 2 A Artículo F A 2 Articles - A I A 2 Articoli - A JA 至 2 品目:至 KO 까지 2 품목: 까지 PTB Até 2 Itens - Até RU По 2 Позиции по S Till 2 Till artiklar TR Son 2 Kalemler - Son US To 2 Items To ZHS 至 2 物料至 9 70 :p_item_planner LOV Oracle MRP_SRS_PLANNERS Y select planner_code id, planner_code value, description description from mtl_planners where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by value,description AR مخطط الصنف مخطط الصنف D Artikelplaner Artikelplaner E Planificador de Artículos Planificador de Artículos F Gestionnaire article Gestionnaire article I Planner articolo Planner articolo JA 品目計画担当 品目計画担当 KO 품목 계획자 품목 계획자 PTB Planejador de Item Planejador de Item RU Планировщик позиций Планировщик позиций S Artikelplanerare Artikelplanerare TR Kalem Planlayıcı Kalem Planlayıcı US Item Planner Item Planner ZHS 物料计划员 物料计划员 10 80 :p_onhand_only_yn LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR بالكمية المتوافرة فقط بالكمية المتوافرة فقط D Nur mit Bestand Nur mit Bestand E Sólo con Cantidad Física Actual Sólo con Cantidad Física Actual F Avec qté en stock seult Avec qté en stock seult I Solo con quantità esistente Solo con quantità esistente JA 手持数量のみ 手持数量のみ KO 현재고 수량만 현재고 수량만 PTB Com quantidade em estoque somente Com quantidade em estoque somente RU Только с наличным количеством Только с наличным количеством S Endast med lagersaldo Endast med lagersaldo TR Sadece eldeki miktarla Sadece eldeki miktarla US With on-hand quantity only With on-hand quantity only ZHS 仅限于现有量 仅限于现有量 11 90 :p_send_notifications_yn LOV Oracle INV_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by lookup_code select meaning from mfg_lookups where lookup_type = 'SYS_YES_NO' and lookup_code = 2 Y AR إرسال التبليغات إرسال التبليغات D Benachrichtigungen senden Benachrichtigungen senden E Enviar Notificaciones Enviar Notificaciones F Envoyer des notifications Envoyer des notifications I Invia notifiche Invia notifiche JA 通知を送付 通知を送付 KO 통지 발송 통지 발송 PTB Enviar notificações Enviar notificações RU Отправка уведомлений Отправка уведомлений S Skicka meddelanden Skicka meddelanden TR Uyarılar gönder Uyarılar gönder US Send notifications Send notifications ZHS 发送通知 发送通知