ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4701951A9E05362FB09050512 SELECT MKC.KANBAN_CARD_NUMBER, MFG.MEANING CARD_TYPE, MP.ORGANIZATION_CODE||' '||ORG.NAME DEST_ORG_NAME, &P_ITEM_FLEXDATA ITEM_NUMBER, MKC.KANBAN_SIZE QUANTITY, MSI.PRIMARY_UNIT_OF_MEASURE UOM, MSI.DESCRIPTION ITEM_DESC, MKC.SOURCE_TYPE SOURCE_TYPE_ID, MFG1.MEANING SOURCE_TYPE, PSV.VENDOR_NAME SUPPLIER, MSS.VENDOR_SITE_CODE SUPPLIER_SITE, MP1.ORGANIZATION_CODE||' '||ORG1.NAME SOURCE_ORG_NAME, MKC.SOURCE_SUBINVENTORY, MKC.SUBINVENTORY_NAME DEST_SUBINV, MKC.LOCATOR_ID, /* bug fix 12434306 changed this &P_LOC_FLEXDATA DEST_LOCATOR,*/ /* Bug 22612464 for negative combination id */ nvl2(mil.inventory_location_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_dest_locator_value', 'INV', 'MTLL', 101, mil.ORGANIZATION_ID, mil.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), null) DEST_LOCATOR, MKC.SOURCE_LOCATOR_ID, /* bug fix 12434306 changed this &P_SOURCE_LOC_FLEXDATA SOURCE_LOCATOR,*/ /* Bug 22612464 for negative combination id */ nvl2(mil1.inventory_location_id, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source_locator_value', 'INV', 'MTLL', 101, mil1.ORGANIZATION_ID, mil1.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE'), null) SOURCE_LOCATOR, MKC.WIP_LINE_CODE, MKC.LAST_PRINT_DATE, MKC.CREATION_DATE, SYSDATE PRINT_DATE, /* Newly added effective_date , max_replenishments , replenishment_count , card_status , supply_status columns for the ekanban by javakat */ MKC.DISABLE_DATE , MKC.MAX_REPLENISHMENTS , MKC.REPLENISHMENT_COUNT , MKC.CARD_STATUS_NAME CARD_STATUS, MKC.SUPPLY_STATUS_NAME SUPPLY_STATUS FROM MTL_KANBAN_CARDS_V MKC, MTL_SYSTEM_ITEMS MSI, MTL_ITEM_LOCATIONS MIL, MTL_ITEM_LOCATIONS MIL1, HR_ALL_ORGANIZATION_UNITS ORG, HR_ALL_ORGANIZATION_UNITS ORG1, MTL_PARAMETERS MP, MTL_PARAMETERS MP1, MFG_LOOKUPS MFG, MFG_LOOKUPS MFG1, PO_SUPPLIERS_VAL_V PSV, MTL_SUPPLIER_SITES_V MSS WHERE MKC.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MKC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MKC.ORGANIZATION_ID = MIL.ORGANIZATION_ID(+) AND MKC.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID(+) AND MKC.SOURCE_ORGANIZATION_ID = MIL1.ORGANIZATION_ID(+) AND MKC.SOURCE_LOCATOR_ID = MIL1.INVENTORY_LOCATION_ID(+) AND MKC.ORGANIZATION_ID = ORG.ORGANIZATION_ID(+) AND MKC.SOURCE_ORGANIZATION_ID = ORG1.ORGANIZATION_ID(+) AND MKC.ORGANIZATION_ID = MP.ORGANIZATION_ID(+) AND MKC.SOURCE_ORGANIZATION_ID = MP1.ORGANIZATION_ID(+) AND MFG.LOOKUP_TYPE(+) = 'MTL_KANBAN_CARD_TYPE' AND MFG.LOOKUP_CODE(+) = MKC.KANBAN_CARD_TYPE AND MFG1.LOOKUP_TYPE(+) = 'MTL_KANBAN_SOURCE_TYPE' AND MFG1.LOOKUP_CODE(+) = MKC.SOURCE_TYPE AND MKC.SUPPLIER_ID = PSV.VENDOR_ID(+) AND MKC.SUPPLIER_SITE_ID = MSS.VENDOR_SITE_ID(+) AND MKC.SUPPLIER_ID = MSS.VENDOR_ID(+) AND MKC.ORGANIZATION_ID = MSS.ORGANIZATION_ID(+) AND MKC.CARD_STATUS <> 3 AND &P_CALL_WHERE /* bug 22612464 added item and locator kff condition here and remove it from package */ AND &P_ITEM_WHERE AND &P_LOC_WHERE ORDER BY &P_ORDER_BY Y INV INVKBCPR_XML AR INV طباعة بطاقات كانبان (بتنسيق XML) Imported from BI Publisher Description: طباعة بطاقات كانبان Application: المخازن Source: طباعة بطاقات كانبان (بتنسيق XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG D INV Kanban-Karten drucken Imported from BI Publisher Description: Kanban-Karten drucken Application: Lager Source: Kanban-Karten drucken (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG E INV Imprimir Tarjetas Kanban Imported from BI Publisher Description: Imprimir Tarjetas Kanban Application: Inventory Source: Imprimir Tarjetas Kanban (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG F INV Imprimer des fiches Kanban Imported from BI Publisher Description: Imprimer des fiches Kanban Application: Inventory Source: Imprimer des fiches Kanban (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG I INV Stampa schede Kanban Imported from BI Publisher Description: Stampa schede Kanban Application: Inventory Source: Stampa schede Kanban (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG JA INV カンバンの印刷 Imported from BI Publisher Description: カンバンの印刷 Application: Inventory Source: カンバンの印刷(XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG KO INV 간판 카드 인쇄 Imported from BI Publisher Description: 간판 카드 인쇄 Application: Inventory Source: 간판 카드 인쇄(XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG PTB INV Imprimir Cartões Kanban Imported from BI Publisher Description: Imprimir Cartões Kanban Application: Inventário Source: Imprimir Cartões Kanban (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG RU INV Печать карт канбана Imported from BI Publisher Description: Печать карт канбана Application: Запасы Source: Печать карт канбана (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG S INV Skriv ut Kanban-kort Imported from BI Publisher Description: Skriv ut Kanban-kort Application: Inventory Source: Skriv ut Kanban-kort (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG TR INV Kanban Kartlarını Yazdır Imported from BI Publisher Description: Kanban Kartlarını Yazdır Application: Stok Yönetimi Source: Kanban Kartlarını Yazdır (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG US INV Print Kanban Cards Imported from BI Publisher Description: Print Kanban Cards Application: Inventory Source: Print Kanban Cards (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG ZHS INV 打印看板卡 Imported from BI Publisher Description: 打印看板卡 Application: 库存管理系统 Source: 打印看板卡 (XML) Short Name: INVKBCPR_XML DB package: INV_INVKBCPR_XMLP_PKG BI Publisher &p_call_where &p_item_flexdata &p_item_where &p_loc_flexdata &p_loc_where &p_order_by &p_source_loc_flexdata :p_call_from :p_call_where :p_card_where :p_conc_request_id :p_date_created_high :p_date_created_low :p_item_flexdata :p_item_high :p_item_low :p_item_where :p_kanban_card_id :p_kanban_card_number_high :p_kanban_card_number_low :p_kanban_card_type :p_loc_flexdata :p_loc_where :p_locator_hi :p_locator_low :p_locator_struc_num :p_optimizer_code :p_order_by :p_org_id :p_pull_sequence_id :p_qty_precision :p_report_id :p_reprint_flag :p_sort_by :p_source_loc_flexdata :p_source_loc_id :p_source_loc_where :p_source_org_id :p_source_subinv :p_source_type :p_struct_num :p_subinv :p_supplier_id :p_supplier_site_id :p_trace_flag 1 -30 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') AR التنظيم التنظيم الحالي الذي يطلق التقرير D Organisation Aktuelle Organisation, welche die Auswertung startet E Organización Organización Actual que Lanza el Informe F Organisation L'organisation actuelle qui lance l'état I Organizzazione L'organizzazione corrente che esegue il rapporto JA 組織 レポートを起動する現在の組織 KO 조직 보고서를 착수하는 현재 조직 PTB Organização A organização atual que submete o Relatório RU Организация Текущая организация, запустившая отчет S Organisation Aktuell organisation som startar rapporten TR Organizasyon Raporu başlatan Yürürlükteki organizasyon US Organization The Current organization which launches the Report ZHS 组织 启动报表的当前组织 2 -20 :p_call_from Number 1 AR استدعاء من استدعاء من D Anruf von Anruf von E De Llamada De Llamada F Appel depuis Appel depuis I Richiamato da Richiamato da JA コール元 コール元 KO 요청: 부터 요청: 부터 PTB Chamada de Chamada de RU Переговоры с Переговоры с S Anrop från Anrop från TR Arayan Arayan US Call From Call From ZHS 调用自 调用自 3 10 :p_date_created_low Date sysdate AR تاريخ تكوين من تاريخ تكوين من D Von Erstellungsdatum Von Erstellungsdatum E De Fecha de Creación De Fecha de Creación F Date de création - Du Date de création - Du I Data creazione - Da Data creazione - Da JA 作成日 自 作成日 自 KO 생성 일자: 부터 생성 일자: 부터 PTB Data de Criação - De Data de Criação - de RU Дата создания с Дата создания с S Skapad från Skapad från TR Oluşturma Tarihi İlk: Oluşturma Tarihi İlk: US Date Created From Date Created from ZHS 已创建日期自 已创建日期自 4 20 :p_date_created_high Date sysdate AR إلى تاريخ التكوين إلى D Bis Bis Erstellungsdatum E A A Fecha de Creación F Au Date de création - Au I A Data creazione - A JA 至 作成日 至 KO 까지 생성 일자: 까지 PTB Até Data de Criação - Até RU По Дата создания по S Till Skapad till TR Son Oluşturma Tarihi Son: US To Date Created To ZHS 至 已创建日期至 5 30 :p_kanban_card_number_low Char AR من رقم بطاقة كانبان من رقم بطاقة كانبان D Von Kanban-Kartennummer Von Kanban-Kartennummer E De Número de Tarjeta Kanban De Número de Tarjeta Kanban F Numéro de fiche Kanban - De Numéro de fiche Kanban - De I Numero scheda Kanban - Da Numero scheda Kanban - Da JA カンバン番号 自 カンバン番号 自 KO 간판 카드 번호: 부터 간판 카드 번호: 부터 PTB Número do Cartão Kanban - De Número do cartão kanban - De RU Номер карты канбана с Номер карты канбана с S Kanban-kortnummer från Kanban-kortnummer från TR Kanban Kart Numarası: İlk Kanban kart numarası İlk: US Kanban Card Number From Kanban card number From ZHS 看板卡号自 看板卡号自 6 40 :p_kanban_card_number_high Char AR إلى 2 إلى رقم بطاقة كانبان D Bis 2 Bis Kanban-Kartennummer E A 2 A Número de Tarjeta Kanban F A Numéro de fiche Kanban - A I A 2 Numero scheda Kanban - A JA 至 2 カンバン番号 至 KO 까지 2 간판 카드 번호: 까지 PTB Até 2 Número do cartão kanban - Até RU По 2 Номер карты канбана по S Till 2 kanban-kortnummer till TR Son 2 Kanban kart numarası Son: US To 2 kanban card number To ZHS 至 2 看板卡号至 7 50 :p_item_low Char AR الصنف من الصنف من D Von Artikel Von Artikel E De Artículo De Artículo F Article - De Article - De I Articolo - Da Articolo - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Item - De Item - De RU Позиция с Позиция с S Från artikel Från artikel TR Kalem: İlk Kalem: İlk US Item From Item from ZHS 物料自 物料自 8 60 :p_item_high Char AR إلى 3 الصنف إلى D Bis 3 Bis Artikel E A 3 A Artículo F A 2 Article - A I A 3 Articolo - A JA 至 3 品目:至 KO 까지 3 품목: 까지 PTB Até 3 Item - Até RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Kalem: Son US To 3 Item To ZHS 至 3 物料至 9 70 :p_subinv LOV Oracle INV_SRS_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') order by secondary_inventory_name AR المخزن المخزن D Lager Lager E Subalmacén Subalmacén F Magasin Magasin I Sottomagazzino Sottomagazzino JA 保管場所 保管場所 KO 창고 창고 PTB Subinventário Subinventário RU Складское подразделение Складское подразделение S Lagerställe Lagerställe TR Stok Yeri Stok Yeri US Subinventory Subinventory ZHS 子库存 子库存 10 80 :p_locator_low Char AR محدد موقع من محدد موقع من D Von Lagerplatz Von Lagerplatz E De Ubicación de Stock De Ubicación de Stock F Emplacement - De Emplacement - De I Collocazione - Da Collocazione - Da JA 保管棚 自 保管棚 自 KO 보관처: 부터 보관처: 부터 PTB Endereço - De Endereço - de RU Складское место с Складское место с S Lagerplats från Lagerplats från TR Stok Adresi İlk: Stok Adresi İlk: US Locator From Locator from ZHS 货位自 货位自 11 90 :p_locator_hi Char AR إلى 4 محدد موقع إلى D Bis 4 Bis Lagerplatz E A 4 A Ubicación de Stock F A 3 Emplacement - A I A 4 Collocazione - A JA 至 4 保管棚 至 KO 까지 4 보관처: 까지 PTB Até 4 Endereço - Até RU По 4 Складское место по S Till 4 Lagerplats till TR Son 4 Stok Adresi: Son US To 4 Locator To ZHS 至 4 货位至 12 100 :p_source_type LOV Oracle INV_KANBAN_SOURCE_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_KANBAN_SOURCE_TYPE' and lookup_code in (1,2,3,4) order by lookup_code AR نوع المصدر نوع المصدر D Bezugsart Bezugsart E Tipo de Origen Tipo de Origen F Type d'origine Type d'origine I Tipo di origine Tipo di origine JA ソース・タイプ ソース・タイプ KO 출처 유형 출처 유형 PTB Tipo de Origem Tipo de Origem RU Тип источника Тип источника S Källtyp Källtyp TR Kaynak Tipi Kaynak Tipi US Source Type Source Type ZHS 来源类型 来源类型 13 110 :p_kanban_card_type LOV Oracle INV_KANBAN_CARD_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_KANBAN_CARD_TYPE' order by lookup_code AR نوع البطاقة نوع بطاقة كانبان D Kartenart Kanban-Kartenart E Tipo de Tarjeta Tipo de Tarjeta Kanban F Type fiche Type de fiche Kanban I Tipo carta Tipo di scheda Kanban JA カンバン・タイプ カンバン・タイプ KO 카드 유형 간판 카드 유형 PTB Tipo de Cartão Tipo de cartão kanban RU Тип карты Тип карты канбана S Korttyp Kanban-korttyp TR Kart Tipi Kanban kart Tipi US Card Type Kanban card type ZHS 卡类型 看板卡类型 14 120 :p_supplier_id LOV Oracle INV_KANBAN_SUPPLIER Y select vendor_id id, vendor_name value, null description from po_suppliers_val_v order by value,description AR المُورِّد المُورِّد D Lieferant Lieferant E Proveedor Proveedor F Fournisseur Fournisseur I Fornitore Fornitore JA 仕入先 仕入先 KO 공급자 공급자 PTB Fornecedor Fornecedor RU Поставщик Поставщик S Leverantör Leverantör TR Tedarikçi Tedarikçi US Supplier Supplier ZHS 供应商 供应商 15 130 :p_supplier_site_id LOV Oracle INV_KANBAN_SUPPLIER_SITES Y select vendor_site_id id, vendor_site_code value, null description from mtl_supplier_sites_v where vendor_id=:$flex$.inv_kanban_supplier and organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by vendor_site_code AR موقع المورد موقع المورد D Lieferantenadresse Lieferantenadresse E Sitio de Proveedor Sitio de Proveedor F Site fournisseur Site fournisseur I Sede fornitore Sede fornitore JA 仕入先サイト 仕入先サイト KO 공급자 지점 공급자 지점 PTB Local do Fornecedor Local do Fornecedor RU Отделение поставщика Отделение поставщика S Leverantörsplats Leverantörsplats TR Tedarikçi İşletme Birimi Tedarikçi İşletme Birimi US Supplier Site Supplier Site ZHS 供应商地点 供应商地点 16 140 :p_source_org_id LOV Oracle INV_SRS_ORGANIZATION_RANGE Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where organization_id<>fnd_profile.value('MFG_ORGANIZATION_ID') order by organization_code AR تنظيم المصدر تنظيم المصدر D Bezugsorganisation Bezugsorganisation E Organización de Origen Organización de Origen F Organisation d'origine Organisation d'origine I Organizzazione origine Organizzazione origine JA ソース組織 ソース組織 KO 출처 조직 출처 조직 PTB Organização de Origem Organização de Origem RU Организация-отправитель Организация-отправитель S Källorganisation Källorganisation TR Kaynak Organizasyon Kaynak Organizasyon US Source Organization Source Organization ZHS 来源组织 来源组织 17 150 :p_source_subinv LOV Oracle INV_SRS_SOURCE_SUBINV Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.inv_srs_organization_range order by secondary_inventory_name AR المخزن المصدر مخزن المصدر D Bezugslager Bezugslager E Subalmacén de Origen Almacén de Origen F Magasin d'origine Magasin d'origine I Sottomagazzino origine Sottomagazz. origine JA ソース保管場所 ソース保管場所 KO 출처 창고 출처 창고 PTB Subinventário de Origem Subinv. de Origem RU Складское подразделение-отправитель Складское подразделение-отправитель S Källagerställe Källagerställe TR Kaynak Stok Yeri Kaynak Stok Yeri US Source Subinventory Source Subinv ZHS 来源子库存 来源子库存 18 160 :p_source_loc_id Char AR محدد مواقع مصدر الموقع المصدر D Bezugslagerplatz Bezugslagerplatz E Ubicación de Stock de Origen Ubicación de Origen F Emplacement d'origine Lieu d'origine I Collocazione origine Collocazione origine JA ソース保管棚 ソース事業所 KO 출처 보관처 출처 위치 PTB Endereço de Origem Local de Origem RU Складское место-отправитель Расположение-отправитель S Källlagerplats Källplats TR Kaynak Stok Adresi Kaynak Yerleşim US Source Locator Source Location ZHS 来源货位 来源地点 19 170 :p_sort_by LOV Oracle INV_KANBAN_SORT_BY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='MTL_KANBAN_CARD_PRINT_SORT' order by lookup_code select meaning from mfg_lookups where lookup_type = 'MTL_KANBAN_CARD_PRINT_SORT' and lookup_code = 3 AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Bazı Sıralama Bazı US Sort By Sort By ZHS 排序依据 排序依据 :$flex$.inv_kanban_supplier Supplier Supplier Site :$flex$.inv_srs_organization_range Source Organization Source Subinventory