ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FA251A9E05362FB09050512Y select fkp.organization_id, fkp.item_id, &P_ASSY_FLEX C_ITEM_FLEX, fkp.subinventory_code, fkp.locator_id, decode(nvl(fkp.locator_id,-1),-1,NULL,null) C_LOC_FLEX, fkp.type, decode(fkp.type,1,'Kanban Cards Purged',2,'Pull Sequences Purged', 3,'Exceptions in Purge') ttype, fkp.count, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_name', 'INV', 'MSTK', 101, MSI1.ORGANIZATION_ID, MSI1.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_NAME, fnd_flex_xml_publisher_apis.process_kff_combination_1('locator_name', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') LOCATOR_NAME from flm_kanban_purge_temp fkp, mtl_system_items msi1, mtl_item_locations mil where fkp.organization_id = msi1.organization_id and fkp.item_id = msi1.inventory_item_id and fkp.organization_id = mil.organization_id(+) and nvl(fkp.locator_id,-1) = nvl(mil.inventory_location_id(+),-1) and fkp.group_id = :P_CONC_REQUEST_ID order by fkp.type FLM FLMPKB_XML AR FLM شطب كانبان (تنسيق XML) Imported from BI Publisher Description: شطب مسلسلات سحب كانبان Application: تدفق التصنيع Source: شطب كانبان (تنسيق XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG D FLM Kanban löschen Imported from BI Publisher Description: Kanban-Entnahmefolgen löschen Application: Flow Manufacturing Source: Kanban löschen (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG E FLM Depurar Kanban Imported from BI Publisher Description: Depurar Secuencias de Consumo Kanban Application: Flow Manufacturing Source: Depurar Kanban (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG F FLM Purger Kanban Imported from BI Publisher Description: Purger les séquences d'appel Kanban Application: Flow Manufacturing Source: Purger Kanban (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG I FLM Elimina kanban Imported from BI Publisher Description: Sequenze di pull eliminazione kanban Application: Flow Manufacturing Source: Elimina kanban (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG JA FLM カンバンのパージ Imported from BI Publisher Description: カンバン・プル順序のパージ Application: Flow Manufacturing Source: カンバンのパージ(XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG KO FLM 간판 삭제 Imported from BI Publisher Description: 간판 삭제 Pull Sequences Application: Flow Manufacturing Source: 간판 삭제(XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG PTB FLM Expurgar Kanban Imported from BI Publisher Description: Expurgar Sequências de Baixas Automáticas Kanban Application: Flow Manufacturing Source: Expurgar Kanban (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG RU FLM Очистка канбана Imported from BI Publisher Description: Очистка последовательностей выдачи канбана Application: Непрерывное производство Source: Очистка канбана (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG S FLM Rensa Kanban Imported from BI Publisher Description: Rensa påfyllnadssekvenser för Kanban Application: Flow Manufacturing Source: Rensa Kanban (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG TR FLM Kanban Temizle Imported from BI Publisher Description: Kanban Emiş Sıralarını Temizler Application: Akış Üretimi Source: Kanban Temizle (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG US FLM Purge Kanban Imported from BI Publisher Description: Purge Kanban Pull Sequences Application: Flow Manufacturing Source: Purge Kanban (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG ZHS FLM 清除看板 Imported from BI Publisher Description: 清除看板拉式序号 Application: 流式制造管理系统 Source: 清除看板 (XML) Short Name: FLMPKB_XML DB package: FLM_FLMRFPKB_XMLP_PKG BI Publisher &p_assy_flex :p_assy_flex :p_conc_request_id :p_delete_card :p_delete_card_opt :p_item_from :p_item_to :p_line_code :p_line_id :p_loc_flex :p_org_id :p_org_name :p_report_opt :p_report_option :p_retcode :p_source_org_id :p_source_org_name :p_source_subinv :p_source_type :p_source_type_code :p_subinv_from :p_subinv_to :p_supplier_id :p_supplier_name 1 -50 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') US Organization_id Organization_id 2 -40 :p_dummy_lines Number Select 1 from dual where :$flex$.source_type=4 AR FLM_SRS_LINES_ID_DUMMY السطور الافتراضية D FLM_SRS_LINES_ID_DUMMY Dummy-Positionen E FLM_SRS_LINES_ID_DUMMY Líneas Ficticias F FLM_SRS_LINES_ID_DUMMY Lignes fictives I FLM_SRS_LINES_ID_DUMMY Linee fittizie JA FLM_SRS_LINES_ID_DUMMY ダミー・ライン KO FLM_SRS_LINES_ID_DUMMY Dummy 라인 PTB FLM_SRS_LINES_ID_DUMMY Linhas Fictícias RU FLM_SRS_LINES_ID_DUMMY Фиктивные строки S FLM_SRS_LINES_ID_DUMMY Dummy-rader TR FLM_SRS_LINES_ID_DUMMY Sözde Hatlar US FLM_SRS_LINES_ID_DUMMY Dummy Lines ZHS FLM_SRS_LINES_ID_DUMMY 虚拟行 3 -30 :p_dummy_supplier Number Select 1 from dual where :$flex$.source_type=2 AR FLM_KANBAN_SUPPLIER_DUMMY المورد الافتراضي D FLM_KANBAN_SUPPLIER_DUMMY Dummy-Lieferant E FLM_KANBAN_SUPPLIER_DUMMY Proveedor Ficticio F FLM_KANBAN_SUPPLIER_DUMMY Fournisseur fictif I FLM_KANBAN_SUPPLIER_DUMMY Fornitore fittizio JA FLM_KANBAN_SUPPLIER_DUMMY ダミー仕入先 KO FLM_KANBAN_SUPPLIER_DUMMY Dummy 공급자 PTB FLM_KANBAN_SUPPLIER_DUMMY Fornecedor Fictício RU FLM_KANBAN_SUPPLIER_DUMMY Фиктивный поставщик S FLM_KANBAN_SUPPLIER_DUMMY Dummy-leverantör TR FLM_KANBAN_SUPPLIER_DUMMY Sözde Tedarikçi US FLM_KANBAN_SUPPLIER_DUMMY Dummy Supplier ZHS FLM_KANBAN_SUPPLIER_DUMMY 虚拟供应商 4 -20 :p_dummy_organization Number Select :$flex$.source_type from dual where (:$flex$.source_type=1 OR :$flex$.source_type=3) AR FLM_SRS_ORGANIZATION_RANGE_DUMMY التنظيم الافتراضي D FLM_SRS_ORGANIZATION_RANGE_DUMMY Dummy-Organisation E FLM_SRS_ORGANIZATION_RANGE_DUMMY Organización Ficticia F FLM_SRS_ORGANIZATION_RANGE_DUMMY Organisation fictive I FLM_SRS_ORGANIZATION_RANGE_DUMMY Organizzazione fittizia JA FLM_SRS_ORGANIZATION_RANGE_DUMMY ダミー組織 KO FLM_SRS_ORGANIZATION_RANGE_DUMMY Dummy 조직 PTB FLM_SRS_ORGANIZATION_RANGE_DUMMY Organização Fictícia RU FLM_SRS_ORGANIZATION_RANGE_DUMMY Фиктивная организация S FLM_SRS_ORGANIZATION_RANGE_DUMMY Dummy-organisation TR FLM_SRS_ORGANIZATION_RANGE_DUMMY Sözde Organizasyon US FLM_SRS_ORGANIZATION_RANGE_DUMMY Dummy Organization ZHS FLM_SRS_ORGANIZATION_RANGE_DUMMY 虚拟组织 5 10 :p_report_option LOV Oracle FLM_SRS_RPT_LIN_REPORT_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='FLM_RPT_LIN_REPORT_OPT' order by meaning select meaning from mfg_lookups where lookup_type = 'FLM_RPT_LIN_REPORT_OPT' and lookup_code = 1 Y AR النوع نوع التقرير D Art Auswertungsart E Tipo Tipo de Informe F Type Type d'état I Tipo Tipo di rapporto JA タイプ レポート・タイプ KO 유형 보고서 유형 PTB Tipo Tipo de Relatório RU Тип Тип отчета S Typ Rapporttyp TR Tip Rapor Tipi US Type Report Type ZHS 类型 报表类型 6 20 :p_item_from Char AR الصنف من Item_From D Von Artikel Item_From E De Artículo Item_From F Article - De Item_From I Articolo - Da Item_From JA 品目:自 Item_From KO 품목 From Item_From PTB Item - De Item_From RU Позиция с Item_From S Från artikel Item_From TR Kalem, İlk Item_From US Item From Item_From ZHS 物料自 Item_From 7 30 :p_item_to Char AR إلى Item_To D Bis Item_To E A Item_To F A Item_To I A Item_To JA 至 Item_To KO 까지 Item_To PTB Até Item_To RU По Item_To S Till Item_To TR Son Item_To US To Item_To ZHS 至 Item_To 8 40 :p_subinv_from 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 Von Lager Lager E De Subalmacén Almacén F Magasin - De Magasin I Sottomagazzino - Da Sottomagazzino JA 保管場所:自 保管場所 KO 창고: 부터 창고 PTB Subinventário - De Subinventário RU Складское подразделение с Складское подразделение S Från lagerställe Lagerställe TR İlk Stok Yeri Stok Yeri US Subinventory From Sub-Inventory ZHS 子库存自 子库存 9 50 :p_subinv_to 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 إلى 2 المخزن D Bis 2 Lager E A 2 Almacén F A 2 Magasin I A 2 Sottomagazzino JA 至 2 保管場所 KO 까지 2 창고 PTB Até 2 Subinventário RU По 2 Складское подразделение S Till 2 Lagerställe TR Son 2 Stok Yeri US To 2 Sub-Inventory ZHS 至 2 子库存 10 60 :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 select meaning from mfg_lookups where lookup_type ='MTL_KANBAN_SOURCE_TYPE' and lookup_code=2 AR نوع المصدر المصدر D Bezugsart Bezug E Tipo de Origen Origen F Type d'origine Origine I Tipo origine Origine JA ソース・タイプ ソース KO 출처 유형 출처 PTB Tipo de Origem Origem RU Тип источника Источник S Källtyp Källa TR Kaynak Tipi Kaynak US Source Type Source ZHS 来源类型 来源 11 70 :p_line_id LOV Oracle FLM_SRS_LINES_ID Y select wl.line_id id, wl.line_code value, null description from wip_lines wl where wl.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and :$flex$.flm_srs_lines_id_dummy=1 order by wl.line_code AR السطر السطر D Linie Linie E Línea Línea F Ligne Ligne I Linea Linea JA ライン ライン KO 라인 라인 PTB Linha Linha RU Линия Линия S Rad Rad TR Hat Hat US Line Line ZHS 生产线 生产线 12 80 :p_supplier_id LOV Oracle FLM_KANBAN_SUPPLIER Y select vendor_id id, vendor_name value, null description from po_suppliers_val_v where :$flex$.flm_kanban_supplier_dummy=1 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 供应商 供应商 13 90 :p_source_org_id LOV Oracle FLM_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') and :$flex$.flm_srs_organization_range_dummy=1) or (organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and :$flex$.flm_srs_organization_range_dummy=3) order by organization_code Select organization_code from org_organization_definitions where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and :$flex$.source_type=3 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 组织 组织 14 100 :p_source_subinv LOV Oracle FLM_SRS_SOURCE_SUBINV Y select secondary_inventory_name id, secondary_inventory_name value, description description from mtl_secondary_inventories where organization_id=:$flex$.flm_srs_organization_range order by secondary_inventory_name AR المخزن المخزن D Lager Lager E Subalmacén Almacé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 Sub-Inventory ZHS 子库存 子库存 15 110 :p_delete_card LOV Oracle FLM_PURGE_CARD_TYPE Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type like 'FLM_KANBAN_PURGE_CARD' order by lookup_code select meaning from mfg_lookups where lookup_type = 'FLM_KANBAN_PURGE_CARD' and lookup_code = 1 Y AR حذف البطاقات حذف البطاقات D Karten löschen Karten löschen E Suprimir Tarjetas Suprimir Tarjetas F Supprimer des fiches Supprimer des fiches I Schede da eliminare Schede da eliminare JA 削除カード 削除カード KO 카드 삭제 카드 삭제 PTB Excluir Cartões Excluir Cartões RU Удаление карт Удаление карт S Ta bort kort Ta bort kort TR Kartları Sil Kartları Sil US Delete Cards Delete Cards ZHS 删除卡 删除卡