ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702951A9E05362FB09050512 SELECT MMT.PICK_SLIP_NUMBER , MTRH.REQUEST_NUMBER , MTRH.MOVE_ORDER_TYPE , MTRL.LINE_NUMBER , MTRL.LINE_ID , MTRL.TRANSACTION_SOURCE_TYPE_ID , MMT.TRANSACTION_ID , TO_NUMBER(NULL) PARENT_LINE_ID , MMT.INVENTORY_ITEM_ID , null C_ITEM_FLEXDAT , MSI.DESCRIPTION ITEM_DESCRIPTION , MMT.REVISION , MMT.SUBINVENTORY_CODE FR_SUBINV , DECODE(MMT.LOCATOR_ID, NULL, '', INV_PROJECT.GET_LOCATOR(MMT.LOCATOR_ID, :P_ORG_ID)) FR_LOCATOR , MMT.TRANSFER_SUBINVENTORY TO_SUBINV , DECODE(MMT.TRANSFER_LOCATOR_ID, NULL, '', INV_PROJECT.GET_LOCATOR(MMT.TRANSFER_LOCATOR_ID, :P_ORG_ID)) TO_LOCATOR , MTRL.PROJECT_ID , MTRL.TASK_ID , DECODE(MMT.DISTRIBUTION_ACCOUNT_ID, '', '', null) C_TO_ACCOUNT_FLEXDAT , FND.USER_NAME REQUESTER , MMT.TRANSACTION_REFERENCE REFERENCE , MMT.TRANSACTION_UOM TRANSACTION_UOM , ABS(MMT.TRANSACTION_QUANTITY) TRANSACTION_QTY , (SELECT LICENSE_PLATE_NUMBER FROM WMS_LICENSE_PLATE_NUMBERS WHERE LPN_ID = NVL(MMT.CONTENT_LPN_ID, MMT.LPN_ID)) PICK_FR_LPN , (SELECT LICENSE_PLATE_NUMBER FROM WMS_LICENSE_PLATE_NUMBERS WHERE LPN_ID = MMT.TRANSFER_LPN_ID) PICK_TO_LPN , 6 TASK_STATUS , (SELECT DROPPING_ORDER FROM MTL_SECONDARY_INVENTORIES WHERE SECONDARY_INVENTORY_NAME = MMT.TRANSFER_SUBINVENTORY AND ORGANIZATION_ID = MMT.ORGANIZATION_ID) SUB_DROPPING_ORDER , (SELECT DROPPING_ORDER FROM MTL_ITEM_LOCATIONS WHERE INVENTORY_LOCATION_ID = MMT.TRANSFER_LOCATOR_ID AND ORGANIZATION_ID = MMT.ORGANIZATION_ID) LOC_DROPPING_ORDER , MMT.SECONDARY_UOM_CODE SEC_UOM , ABS(MMT.SECONDARY_TRANSACTION_QUANTITY) SEC_TRANSACTION_QTY, 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, DECODE(MMT.DISTRIBUTION_ACCOUNT_ID, '', '', fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_to_account', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) CF_TO_ACCOUNT, INV_INVTOPKL_XMLP_PKG.cf_sec_uomformula(MMT.INVENTORY_ITEM_ID, MMT.SECONDARY_UOM_CODE) CF_SEC_UOM, INV_INVTOPKL_XMLP_PKG.cf_sec_qtyformula(MMT.INVENTORY_ITEM_ID, ABS(MMT.SECONDARY_TRANSACTION_QUANTITY)) CF_SEC_QTY, INV_INVTOPKL_XMLP_PKG.cf_task_statusformula(6) CF_TASK_STATUS, INV_INVTOPKL_XMLP_PKG.cf_task_idformula(6, TO_NUMBER(NULL), MMT.TRANSACTION_ID) CF_TASK_ID, INV_INVTOPKL_XMLP_PKG.cf_project_numberformula(MTRL.PROJECT_ID) CF_PROJECT_NUMBER, INV_INVTOPKL_XMLP_PKG.cf_task_numberformula(MTRL.TASK_ID,MTRL.PROJECT_ID) CF_TASK_NUMBER, INV_INVTOPKL_XMLP_PKG.cf_wip_infoformula(LINE_ID, MTRH.MOVE_ORDER_TYPE, MTRL.TRANSACTION_SOURCE_TYPE_ID) CF_WIP_INFO, INV_INVTOPKL_XMLP_PKG.cf_so_infoformula(LINE_ID, MOVE_ORDER_TYPE) CF_SO_INFO, INV_INVTOPKL_XMLP_PKG.CP_SO_ORDER_NUMBER_p CP_SO_ORDER_NUMBER, INV_INVTOPKL_XMLP_PKG.CP_SO_LINE_NUMBER_p CP_SO_LINE_NUMBER, INV_INVTOPKL_XMLP_PKG.CP_SO_DELIVERY_NAME_p CP_SO_DELIVERY_NAME, INV_INVTOPKL_XMLP_PKG.CP_WIP_JOB_p CP_WIP_JOB, INV_INVTOPKL_XMLP_PKG.CP_WIP_DEPARTMENT_p CP_WIP_DEPARTMENT, INV_INVTOPKL_XMLP_PKG.CP_WIP_LINE_p CP_WIP_LINE, INV_INVTOPKL_XMLP_PKG.CP_WIP_ENTITY_TYPE_p CP_WIP_ENTITY_TYPE, INV_INVTOPKL_XMLP_PKG.CP_WIP_START_DATE_p CP_WIP_START_DATE, INV_INVTOPKL_XMLP_PKG.CP_WIP_OPERATION_p CP_WIP_OPERATION FROM MTL_MATERIAL_TRANSACTIONS MMT , MTL_TXN_REQUEST_HEADERS MTRH , MTL_TXN_REQUEST_LINES MTRL , MTL_SYSTEM_ITEMS_VL MSI , GL_CODE_COMBINATIONS GCC , FND_USER FND &P_FROM_MMT WHERE MMT.ORGANIZATION_ID = :P_ORG_ID AND MMT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID AND MTRL.HEADER_ID = MTRH.HEADER_ID AND MSI.ORGANIZATION_ID = MMT.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MMT.INVENTORY_ITEM_ID AND FND.USER_ID = MTRL.CREATED_BY AND GCC.CODE_COMBINATION_ID(+) = MMT.DISTRIBUTION_ACCOUNT_ID AND NVL(MMT.TRANSACTION_QUANTITY, 0) < 0 AND &P_WHERE_MMT UNION ALL SELECT (SELECT PICK_SLIP_NUMBER FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE TRANSACTION_TEMP_ID = NVL(MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID) )PICK_SLIP_NUMBER , MTRH.REQUEST_NUMBER , MTRH.MOVE_ORDER_TYPE , MTRL.LINE_NUMBER , MTRL.LINE_ID , MTRL.TRANSACTION_SOURCE_TYPE_ID , MMTT.TRANSACTION_TEMP_ID TRANSACTION_ID , MMTT.PARENT_LINE_ID , MMTT.INVENTORY_ITEM_ID , null C_ITEM_FLEXDAT , MSI.DESCRIPTION ITEM_DESCRIPTION , MMTT.REVISION , MMTT.SUBINVENTORY_CODE FR_SUBINV , DECODE(MMTT.LOCATOR_ID, NULL, '', INV_PROJECT.GET_LOCATOR(MMTT.LOCATOR_ID, :P_ORG_ID)) FR_LOCATOR , MMTT.TRANSFER_SUBINVENTORY TO_SUBINV , DECODE(MMTT.TRANSFER_TO_LOCATION, NULL, '', INV_PROJECT.GET_LOCATOR(MMTT.TRANSFER_TO_LOCATION, :P_ORG_ID)) TO_LOCATOR , MTRL.PROJECT_ID , MTRL.TASK_ID , DECODE(MMTT.DISTRIBUTION_ACCOUNT_ID, '', '', null) C_TO_ACCOUNT_FLEXDAT , FND.USER_NAME REQUESTER , MMTT.TRANSACTION_REFERENCE REFERENCE , MMTT.TRANSACTION_UOM TRANSACTION_UOM , ABS(MMTT.TRANSACTION_QUANTITY) TRANSACTION_QTY , (SELECT LICENSE_PLATE_NUMBER FROM WMS_LICENSE_PLATE_NUMBERS WHERE LPN_ID = NVL(MMTT.CONTENT_LPN_ID, NVL(MMTT.LPN_ID, MMTT.ALLOCATED_LPN_ID))) , (SELECT LICENSE_PLATE_NUMBER FROM WMS_LICENSE_PLATE_NUMBERS WHERE LPN_ID = NVL(MMTT.TRANSFER_LPN_ID, MMTT.CARTONIZATION_ID)) , NVL((SELECT WDT.STATUS FROM WMS_DISPATCHED_TASKS WDT WHERE TRANSACTION_TEMP_ID = NVL(MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID)), MMTT.WMS_TASK_STATUS) TASK_STATUS , (SELECT DROPPING_ORDER FROM MTL_SECONDARY_INVENTORIES WHERE SECONDARY_INVENTORY_NAME = MMTT.TRANSFER_SUBINVENTORY AND ORGANIZATION_ID = MMTT.ORGANIZATION_ID) SUB_DROPPING_ORDER , (SELECT DROPPING_ORDER FROM MTL_ITEM_LOCATIONS WHERE INVENTORY_LOCATION_ID = MMTT.TRANSFER_TO_LOCATION AND ORGANIZATION_ID = MMTT.ORGANIZATION_ID) LOC_DROPPING_ORDER , MMTT.SECONDARY_UOM_CODE SEC_UOM , ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY) SEC_TRANSACTION_QTY, 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, DECODE(MMTT.DISTRIBUTION_ACCOUNT_ID, '', '', fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_to_account', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) CF_TO_ACCOUNT, INV_INVTOPKL_XMLP_PKG.cf_sec_uomformula(MMTT.INVENTORY_ITEM_ID, MMTT.SECONDARY_UOM_CODE) CF_SEC_UOM, INV_INVTOPKL_XMLP_PKG.cf_sec_qtyformula(MMTT.INVENTORY_ITEM_ID, ABS(MMTT.SECONDARY_TRANSACTION_QUANTITY)) CF_SEC_QTY, INV_INVTOPKL_XMLP_PKG.cf_task_statusformula(NVL((SELECT WDT.STATUS FROM WMS_DISPATCHED_TASKS WDT WHERE TRANSACTION_TEMP_ID = NVL(MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID)), MMTT.WMS_TASK_STATUS)) CF_TASK_STATUS, INV_INVTOPKL_XMLP_PKG.cf_task_idformula(NVL((SELECT WDT.STATUS FROM WMS_DISPATCHED_TASKS WDT WHERE TRANSACTION_TEMP_ID = NVL(MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID)), MMTT.WMS_TASK_STATUS), MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID) CF_TASK_ID, INV_INVTOPKL_XMLP_PKG.cf_project_numberformula(MTRL.PROJECT_ID) CF_PROJECT_NUMBER, INV_INVTOPKL_XMLP_PKG.cf_task_numberformula(MTRL.TASK_ID, MTRL.PROJECT_ID) CF_TASK_NUMBER, INV_INVTOPKL_XMLP_PKG.cf_wip_infoformula(MTRL.LINE_ID, MTRH.MOVE_ORDER_TYPE, MTRL.TRANSACTION_SOURCE_TYPE_ID) CF_WIP_INFO, INV_INVTOPKL_XMLP_PKG.cf_so_infoformula(MTRL.LINE_ID, MTRH.MOVE_ORDER_TYPE) CF_SO_INFO, INV_INVTOPKL_XMLP_PKG.CP_SO_ORDER_NUMBER_p CP_SO_ORDER_NUMBER, INV_INVTOPKL_XMLP_PKG.CP_SO_LINE_NUMBER_p CP_SO_LINE_NUMBER, INV_INVTOPKL_XMLP_PKG.CP_SO_DELIVERY_NAME_p CP_SO_DELIVERY_NAME, INV_INVTOPKL_XMLP_PKG.CP_WIP_JOB_p CP_WIP_JOB, INV_INVTOPKL_XMLP_PKG.CP_WIP_DEPARTMENT_p CP_WIP_DEPARTMENT, INV_INVTOPKL_XMLP_PKG.CP_WIP_LINE_p CP_WIP_LINE, INV_INVTOPKL_XMLP_PKG.CP_WIP_ENTITY_TYPE_p CP_WIP_ENTITY_TYPE, INV_INVTOPKL_XMLP_PKG.CP_WIP_START_DATE_p CP_WIP_START_DATE, INV_INVTOPKL_XMLP_PKG.CP_WIP_OPERATION_p CP_WIP_OPERATION FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT , MTL_TXN_REQUEST_HEADERS MTRH , MTL_TXN_REQUEST_LINES MTRL , MTL_SYSTEM_ITEMS_VL MSI , GL_CODE_COMBINATIONS GCC , FND_USER FND WHERE MMTT.ORGANIZATION_ID = :P_ORG_ID AND MTRL.LINE_ID = MMTT.MOVE_ORDER_LINE_ID AND MTRL.HEADER_ID = MTRH.HEADER_ID AND MSI.INVENTORY_ITEM_ID = MMTT.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MMTT.ORGANIZATION_ID AND GCC.CODE_COMBINATION_ID(+) = MMTT.DISTRIBUTION_ACCOUNT_ID AND FND.USER_ID = MTRL.CREATED_BY AND NVL(MMTT.TRANSACTION_QUANTITY, 0) > 0 AND NOT EXISTS (SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP WHERE PARENT_LINE_ID = MMTT.TRANSACTION_TEMP_ID) AND NVL(MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID) IN (SELECT NVL(MMTT.PARENT_LINE_ID, MMTT.TRANSACTION_TEMP_ID) FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT , MTL_TXN_REQUEST_LINES MTRL , MTL_TXN_REQUEST_HEADERS MTRH &P_FROM_MMTT WHERE MMTT.ORGANIZATION_ID = :P_ORG_ID AND MTRL.LINE_ID = MMTT.MOVE_ORDER_LINE_ID AND MTRH.HEADER_ID = MTRL.HEADER_ID AND &P_WHERE_MMTT ) UNION ALL SELECT MTRL.PICK_SLIP_NUMBER , MTRH.REQUEST_NUMBER , MTRH.MOVE_ORDER_TYPE , MTRL.LINE_NUMBER , MTRL.LINE_ID , MTRL.TRANSACTION_SOURCE_TYPE_ID , -99999 AS TRANSACTION_ID , TO_NUMBER(NULL) PARENT_LINE_ID , MTRL.INVENTORY_ITEM_ID , null C_ITEM_FLEXDAT , MSI.DESCRIPTION , MTRL.REVISION , MTRL.FROM_SUBINVENTORY_CODE FR_SUBINV , DECODE(MTRL.FROM_LOCATOR_ID, NULL, '', INV_PROJECT.GET_LOCATOR(MTRL.FROM_LOCATOR_ID, :P_ORG_ID)) FR_LOCATOR , MTRL.TO_SUBINVENTORY_CODE TO_SUBINV , DECODE(MTRL.TO_LOCATOR_ID, NULL, '', INV_PROJECT.GET_LOCATOR(MTRL.TO_LOCATOR_ID, :P_ORG_ID)) TO_LOCATOR , MTRL.PROJECT_ID , MTRL.TASK_ID , DECODE(MTRL.TO_ACCOUNT_ID, '', '', null) C_TO_ACCOUNT_FLEXDAT , FND.USER_NAME REQUESTER , MTRL.REFERENCE REFERENCE , MTRL.UOM_CODE TRANSACTION_UOM , ABS(NVL(MTRL.QUANTITY, 0) - NVL(MTRL.QUANTITY_DETAILED, 0)) TRANSACTION_QTY , (SELECT LICENSE_PLATE_NUMBER FROM WMS_LICENSE_PLATE_NUMBERS WHERE LPN_ID = MTRL.LPN_ID) , TO_CHAR(NULL) , 0 TASK_STATUS , (SELECT DROPPING_ORDER FROM MTL_SECONDARY_INVENTORIES WHERE SECONDARY_INVENTORY_NAME = MTRL.TO_SUBINVENTORY_CODE AND ORGANIZATION_ID = MTRL.ORGANIZATION_ID) SUB_DROPPING_ORDER , (SELECT DROPPING_ORDER FROM MTL_ITEM_LOCATIONS WHERE INVENTORY_LOCATION_ID = MTRL.TO_LOCATOR_ID AND ORGANIZATION_ID = MTRL.ORGANIZATION_ID) LOC_DROPPING_ORDER , MTRL.SECONDARY_UOM_CODE SEC_UOM , ABS(NVL(MTRL.SECONDARY_QUANTITY, 0) - NVL(MTRL.SECONDARY_QUANTITY_DETAILED, 0)) SEC_TRANSACTION_QTY, 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, DECODE(MTRL.TO_ACCOUNT_ID, '', '', fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_to_account', 'SQLGL', 'GL#', GCC.CHART_OF_ACCOUNTS_ID, NULL, GCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) CF_TO_ACCOUNT, INV_INVTOPKL_XMLP_PKG.cf_sec_uomformula(MTRL.INVENTORY_ITEM_ID, MTRL.SECONDARY_UOM_CODE) CF_SEC_UOM, INV_INVTOPKL_XMLP_PKG.cf_sec_qtyformula(MTRL.INVENTORY_ITEM_ID, ABS(NVL(MTRL.SECONDARY_QUANTITY, 0) - NVL(MTRL.SECONDARY_QUANTITY_DETAILED, 0))) CF_SEC_QTY, INV_INVTOPKL_XMLP_PKG.cf_task_statusformula(0) CF_TASK_STATUS, INV_INVTOPKL_XMLP_PKG.cf_task_idformula(0, TO_NUMBER(NULL), -99999) CF_TASK_ID, INV_INVTOPKL_XMLP_PKG.cf_project_numberformula(MTRL.PROJECT_ID) CF_PROJECT_NUMBER, INV_INVTOPKL_XMLP_PKG.cf_task_numberformula(MTRL.TASK_ID, MTRL.PROJECT_ID) CF_TASK_NUMBER, INV_INVTOPKL_XMLP_PKG.cf_wip_infoformula(LINE_ID, MOVE_ORDER_TYPE, TRANSACTION_SOURCE_TYPE_ID) CF_WIP_INFO, INV_INVTOPKL_XMLP_PKG.cf_so_infoformula(LINE_ID, MOVE_ORDER_TYPE) CF_SO_INFO, INV_INVTOPKL_XMLP_PKG.CP_SO_ORDER_NUMBER_p CP_SO_ORDER_NUMBER, INV_INVTOPKL_XMLP_PKG.CP_SO_LINE_NUMBER_p CP_SO_LINE_NUMBER, INV_INVTOPKL_XMLP_PKG.CP_SO_DELIVERY_NAME_p CP_SO_DELIVERY_NAME, INV_INVTOPKL_XMLP_PKG.CP_WIP_JOB_p CP_WIP_JOB, INV_INVTOPKL_XMLP_PKG.CP_WIP_DEPARTMENT_p CP_WIP_DEPARTMENT, INV_INVTOPKL_XMLP_PKG.CP_WIP_LINE_p CP_WIP_LINE, INV_INVTOPKL_XMLP_PKG.CP_WIP_ENTITY_TYPE_p CP_WIP_ENTITY_TYPE, INV_INVTOPKL_XMLP_PKG.CP_WIP_START_DATE_p CP_WIP_START_DATE, INV_INVTOPKL_XMLP_PKG.CP_WIP_OPERATION_p CP_WIP_OPERATION FROM MTL_TXN_REQUEST_HEADERS MTRH , MTL_TXN_REQUEST_LINES MTRL , MTL_SYSTEM_ITEMS_VL MSI , FND_USER FND , GL_CODE_COMBINATIONS GCC &P_FROM_MTRL WHERE MTRL.ORGANIZATION_ID = :P_ORG_ID AND MTRL.HEADER_ID = MTRH.HEADER_ID AND MSI.INVENTORY_ITEM_ID = MTRL.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MTRL.ORGANIZATION_ID AND MTRL.CREATED_BY = FND.USER_ID AND NVL(MTRL.QUANTITY, 0) > NVL(MTRL.QUANTITY_DETAILED, 0) AND MTRL.LINE_STATUS IN (3, 7) AND MTRL.TO_ACCOUNT_ID = GCC.CODE_COMBINATION_ID(+) AND &P_WHERE_MTRL ORDER BY 1, 8, 29, 30, 27, 28, 2, 3, 4, 5, 6, 7, 9, 31, 11, 12, 13, 14, 15, 16, 17, 18, 32, 20, 21, 22, 23 Y INV INVTOPKL_XML AR INV بطاقة انتقاء طلب النقل (بتنسيق XML) Imported from BI Publisher Description: قائمة انتقاء طلب النقل Application: المخازن Source: بطاقة انتقاء طلب النقل (بتنسيق XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG D INV Transferaufträge - Entnahmeschein Imported from BI Publisher Description: Transferaufträge - Entnahmeschein Application: Lager Source: Transferaufträge - Entnahmeschein (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG E INV Nota de Acopio de Órdenes de Movimiento Imported from BI Publisher Description: Lista de Acopio de Orden de Movimiento Application: Inventory Source: Nota de Acopio de Órdenes de Movimiento (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG F INV Bordereaux de prélèvement d'ordres de transfert Imported from BI Publisher Description: Liste à servir des ordres de transfert Application: Inventory Source: Bordereaux de prélèvement d'ordres de transfert (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG I INV Distinta di prelievo ordine di spostamento Imported from BI Publisher Description: Elenco prelievi ordine di spostamento Application: Inventory Source: Distinta di prelievo ordine di spostamento (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG JA INV 移動オーダー・ピック・スリップ Imported from BI Publisher Description: 移動オーダー・ピック・リスト Application: Inventory Source: 移動オーダー・ピック・スリップ(XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG KO INV 이동 주문 피킹 지시서 Imported from BI Publisher Description: 이동 지시 불출 목록 Application: Inventory Source: 이동 주문 피킹 지시서(XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG PTB INV Lista de Separação da Ordem de Movimentação Imported from BI Publisher Description: Lista de Separações da Ordem de Movimentação Application: Inventário Source: Lista de Separação da Ordem de Movimentação (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG RU INV Товарная накладная к заказу на перемещение Imported from BI Publisher Description: Ведомость комплектации заказа на перемещение Application: Запасы Source: Товарная накладная к заказу на перемещение (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG S INV Plocksedel för transportorder Imported from BI Publisher Description: Plocklista för transportorder Application: Inventory Source: Plocksedel för transportorder (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG TR INV Taşıma Emri Toplama Fişi Imported from BI Publisher Description: Taşıma Emri Toplama Listesi Application: Stok Yönetimi Source: Taşıma Emri Toplama Fişi (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG US INV Move Order Pick Slip Imported from BI Publisher Description: Move Order Pick List Application: Inventory Source: Move Order Pick Slip (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG ZHS INV 物料搬运单挑库单 Imported from BI Publisher Description: 物料搬运挑库单 Application: 库存管理系统 Source: 物料搬运单挑库单 (XML) Short Name: INVTOPKL_XML DB package: INV_INVTOPKL_XMLP_PKG BI Publisher &p_from_mmt &p_from_mmtt &p_from_mtrl &p_where_mmt &p_where_mmtt &p_where_mtrl :cp_chart_of_accounts_num :cp_date_reqd_hi :cp_date_reqd_lo :cp_so_delivery_name :cp_so_line_number :cp_so_order_number :cp_wip_department :cp_wip_entity_type :cp_wip_job :cp_wip_line :cp_wip_operation :cp_wip_start_date :p_allocate_move_order :p_allocate_move_order_meaning :p_cbo_flag :p_conc_request_id :p_const_unallocated :p_customer_id :p_customer_name :p_date_reqd_hi :p_date_reqd_lo :p_dest_locator :p_dest_locator_id :p_dest_subinv :p_freight_code :p_from_mmt :p_from_mmtt :p_from_mtrl :p_item_flexnum :p_item_flexsql :p_move_order_high :p_move_order_low :p_move_order_type :p_move_order_type_meaning :p_org_id :p_org_name :p_pick_slip_group_rule_id :p_pick_slip_group_rule_name :p_pick_slip_number_high :p_pick_slip_number_low :p_plan_tasks :p_plan_tasks_meaning :p_print_option :p_print_option_meaning :p_requested_by :p_requested_by_name :p_sales_order_high :p_sales_order_low :p_ser_child_ls_from :p_ser_child_s_from :p_ser_parent_ls_from :p_ser_parent_s_from :p_set_of_books_id :p_sort_by :p_source_locator :p_source_locator_id :p_source_subinv :p_to_account_flexsql :p_trace_flag :p_transact_move_order :p_transaction_type_id :p_where_mmt :p_where_mmtt :p_where_mtrl :p_wms_install 1 -30 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم معرف التنظيم D Organisation Organisationskennung E Organización Identificador de Organización F Organisation Identifiant de l'organisation I Organizzazione Identificativo organizzazione JA 組織 組織識別子 KO 조직 조직 식별자 PTB Organização Identificador da Organização RU Организация Идентификатор организ. S Organisation Organisations-id TR Organizasyon Organizasyon Tanımlayıcı US Organization Organization Identifier ZHS 组织 组织标识 2 -20 :p_transact_move_order LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE='YES_NO' AND LOOKUP_CODE='N' AR الحركة الآلية السطور المعتمدة للحركة الآلية D Auto-Transaktion Auto-Transaktion - Genehmigte Positionen E Transacción Automática Líneas aprobadas de transacción automática F Traiter automatiquement Traiter automatiquement les lignes approuvées I Transazione automatica Transazione automatica linee approvate JA 自動取引 承認明細の自動取引 KO 자동 처리 자동 처리 승인 라인 PTB Transação Automática Transação Auto Linhas Aprovadas RU Автотранзакция Автотранзакция для утвержденных строк S Autotransaktion Autotransaktion, godkända rader TR Otomatik İşlem Otomatik İşlem Onaylı Satırlar US Auto Transact Auto Transact Approved Lines ZHS 自动处理 自动处理批准行 3 10 :p_move_order_low LOV Oracle INV_MOVE_ORDER Y select request_number id, request_number value, null description from mtl_txn_request_headers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by request_number AR رقم طلب النقل من طلب النقل (من) D Von Transferauftragsnummer Von Transferauftrag E De Número de Orden de Movimiento Orden de Movimiento (De) F Numéro d'ordre de transfert - De Ordre de transfert (De) I Numero ordine di spostamento - Da Ordine di spostamento (da) JA 移動オーダー番号:自 移動オーダー (自) KO 이동 지시 번호: 부터 이동 지시(From) PTB Nr. da Ordem de Movimentação - De Ordem de Movimentação (De) RU Номер заказа на перемещение с Заказ на перемещение (с) S Från transportordernummer Transportorder (från) TR Taşıma Emri Numarası, İlk Taşıma Emri (İlk) US Move Order Number From Move Order (From) ZHS 物料搬运单起始编号 物料搬运单（自） 4 20 :p_move_order_high LOV Oracle INV_MOVE_ORDER Y select request_number id, request_number value, null description from mtl_txn_request_headers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by request_number SELECT :$flex$.move_order_number_from FROM DUAL AR إلى طلب النقل (إلى) D Bis Bis Transferauftrag E A Orden de Movimiento (A) F A Ordre de transfert (A) I A Ordine di spostamento (a) JA 至 移動オーダー (至) KO 까지 이동 지시(To) PTB Até Ordem de Movimentação (Até) RU По Заказ на перемещение (по) S Till Transportorder (till) TR Son Taşıma Emri (Son) US To Move Order (To) ZHS 至 物料搬运单（至） 5 30 :p_pick_slip_number_low LOV Oracle WSH_SRS_PICK_SLIP_NUMBER Y select pick_slip_number id, pick_slip_number value, null description from wsh_srs_pick_slip_v order by pick_slip_number AR رقم بطاقة الانتقاء من رقم بطاقة الانتقاء (من) D Von Entnahmescheinnummer Von Entnahmescheinnummer E De Número de Nota de Acopio Número de Nota de Acopio (De) F Numéro de bordereau de prélèvement - De Numéro de bordereau de prélèvement (De) I Numero distinta di prelievo - Da Numero distinta di prelievo (da) JA ピック・スリップ番号:自 ピック・スリップ番号 (自) KO 출하지시서 번호: 부터 출하 지시서 번호(부터) PTB Nr. do Slip de Separação - De Nr. do Slip de Separação (De) RU Номер товарной накладной с Номер товарной накладной (с) S Från plocksedelnummer Plocksedelnummer (från) TR Toplama Fişi Numarası, İlk Toplama Fişi Numarası (İlk) US Pick Slip Number From Pick Slip Number (From) ZHS 挑库单编号自 挑库单编号（自） 6 40 :p_pick_slip_number_high LOV Oracle WSH_SRS_PICK_SLIP_NUMBER Y select pick_slip_number id, pick_slip_number value, null description from wsh_srs_pick_slip_v order by pick_slip_number SELECT :$flex$.pick_slip_number_from FROM DUAL AR إلى 2 رقم بطاقة الانتقاء (إلى) D Bis 2 Bis Entnahmescheinnummer E A 2 Número de Nota de Acopio (A) F A 2 Numéro de bordereau de prélèvement (A) I A 2 Numero distinta di prelievo (a) JA 至 2 ピック・スリップ番号 (至) KO 까지 2 출하 지시서 번호(까지) PTB Até 2 Nr. do Slip de Separação (Até) RU По 2 Номер товарной накладной (по) S Till 2 Plocksedelnummer (till) TR Son 2 Toplama Fişi Numarası (Son) US To 2 Pick Slip Number (To) ZHS 至 2 挑库单编号（至） 7 50 :p_source_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 Bezugslager Bezugslager E Subalmacén de Origen Subalmacén de Origen F Magasin d'origine Magasin d'origine I Sottomagazzino origine Sottomagazzino origine JA ソース保管場所 ソース保管場所 KO 출처 창고 출처 창고 PTB Subinventário de Origem Subinventário de Origem RU Складское подразделение-отправитель Складское подразделение-отправитель S Källagerställe Källagerställe TR Kaynak Stok Yeri Kaynak Stok Yeri US Source Subinventory Source Subinventory ZHS 来源子库存 来源子库存 8 60 :p_source_locator_id Char AR محدد مواقع مصدر محدد مواقع مصدر D Bezugslagerplatz Bezugslagerplatz E Ubicación de Stock de Origen Ubicación de Stock de Origen F Emplacement d'origine Emplacement d'origine I Collocazione origine Collocazione origine JA ソース保管棚 ソース保管棚 KO 출처 보관처 출처 보관처 PTB Endereço de Origem Endereço de Origem RU Складское место-отправитель Складское место-отправитель S Källlagerplats Källlagerplats TR Kaynak Stok Adresi Kaynak Stok Adresi US Source Locator Source Locator ZHS 来源货位 来源货位 9 70 :p_dest_subinv LOV Oracle INV_DEST_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 Bestimmungslager Bestimmungslager E Subalmacén de Destino Subalmacén de Destino F Magasin de destination Magasin de destination I Sottomagazzino di destinazione Sottomagazzino di destinazione JA 搬送先保管場所 搬送先保管場所 KO 목적지 창고 목적지 창고 PTB Subinventário de Destino Subinventário de Destino RU Складское подразделение-получатель Складское подразделение-получатель S Destinationslagerställe Destinationslagerställe TR Hedef Stok Yeri Hedef Stok Yeri US Destination Subinventory Destination Subinventory ZHS 目标子库存 目标子库存 10 80 :p_dest_locator_id Char AR محدد مواقع الوجهة محدد مواقع الوجهة D Bestimmungslagerplatz Bestimmungslagerplatz E Ubicación de Stock de Destino Ubicación de Stock de Destino F Emplacement de destination Emplacement de destination I Collocazione di destinazione Collocazione di destinazione JA 搬送先保管棚 搬送先保管棚 KO 목적지 보관처 목적지 보관처 PTB Ender. Destino Ender. Destino RU Складское место-получатель Складское место-получатель S Destinationslagerplats Destinationslagerplats TR Hedef Stok Adresi Hedef Stok Adresi US Destination Locator Destination Locator ZHS 目标货位 目标货位 11 90 :p_requested_by LOV Oracle FND_USERS Y select user_id id, user_name value, null description from fnd_user order by user_name AR الطالب مطلوب بواسطة D Anforderer Angefordert von E Solicitante Solicitado por F Demandeur Demandé par I Richiedente Richiesto da JA 依頼者 要求者 KO 요청자 요청자 PTB Solicitante Solicitado por RU Автор запроса Запрошено S Beställare Begärt av TR Talep Eden Talep Eden US Requester Requested By ZHS 申请人 请求者 12 100 :p_date_reqd_lo Date AR تاريخ الطلب من تاريخ الطلب (من) D Von Bedarfsdatum Von Bedarfsdatum E De Fecha de Necesidad Fecha de Necesidad (De) F Date requise - Du Date requise (Du) I Data richiesta - Da Data richiesta (da) JA 要求日:自 要求日 (自) KO 요구 일자: 부터 요구 일자(부터) PTB Data Obrigatória - De Data Obrigatória (De) RU Нужная дата с Нужная дата (с) S Från behovsdatum Behovsdatum (från) TR Gereklilik Tarihi, İlk Gerekli Tarih (İlk) US Date Required From Date Required (From) ZHS 需求日期自 需求日期（自） 13 110 :p_date_reqd_hi Date AR إلى 3 تاريخ الطلب (إلى) D Bis 3 Bis Bedarfsdatum E A 3 Fecha de Necesidad (A) F Au Date requise (Au) I A 3 Data richiesta (a) JA 至 3 要求日 (至) KO 까지 3 요구 일자(까지) PTB Até 3 Data Obrigatória (Até) RU По 3 Нужная дата (по) S Till 3 Behovsdatum (till) TR Son 3 Gerekli Tarih (Son) US To 3 Date Required (To) ZHS 至 3 需求日期（至） 14 120 :p_print_option LOV Oracle INV_SRS_PICK_SLIP_PRINT_OPTIONS Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='INV_PICK_SLIP_PRINT_OPTIONS' and (inv_pick_slip_report.chk_wms_install(fnd_profile.value('MFG_ORGANIZATION_ID'))='TRUE' or lookup_code not in (3,4)) order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'INV_PICK_SLIP_PRINT_OPTIONS' AND LOOKUP_CODE = 99 AR خيار الطباعة موقف تخصيص طلب النقل المطلوب التقيد به D Druckoption Zuteilungsstatus des Transferauftrags, auf den die Auswertung beschränkt werden soll E Opción de Impresión Restringir a Estado de Asignación de Orden de Movimiento F Option d'impression Statut d'affectation d'ordre de transfert à limiter à I Opzione di stampa Stato dell'allocazione dell'ordine di spostamento da limitare a JA 印刷オプション 制約となる移動オーダー割当ステータス KO 인쇄 옵션 다음으로 제한할 이동 지시 할당 상태 PTB Opção de Impressão Status da Alocação da Ordem de Movimentação a ser restrito para RU Режим печати Статус размещения заказов на перемещение, которым следует ограничиться S Utskriftsalternativ Begränsas till denna status för transportorderallokeringar TR Yazdırma Seçeneği Kısıtlanacak Taşıma Emri Paylaştırma Statüsü US Print Option Move Order Allocation Status to be restricted to ZHS 打印选项 受到下列限制的物料搬运单分配状态 15 130 :p_move_order_type LOV Oracle INV_SRS_PICK_SLIP_MO_TYPES Y select lookup_code id, meaning value, description description from mfg_lookups where lookup_type='INV_PICK_SLIP_MO_TYPES' order by lookup_code SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = 'INV_PICK_SLIP_MO_TYPES' AND LOOKUP_CODE = 99 AR أنواع طلبات النقل أنواع طلبات النقل المطلوب التقيد بها D Transferauftragsarten Transferauftragsarten, auf die die Auswertung beschränkt werden soll E Tipos de Orden de Movimiento Restringir a Tipos de Orden De Movimiento F Types d'ordre de transfert Types d'ordre de transfert à limiter à I Tipi di ordine di spostamento Tipi di ordine di spostamento da limitare a JA 移動オーダー・タイプ 制約となる移動オーダー・タイプ KO 이동 지시 유형 다음으로 제한할 이동 지시 유형 PTB Tipos de Ordem de Movimentação Tipos de Ordem de Movimentação a serem restritos para RU Типы заказов на перемещение Типы заказов на перемещения, которыми следует ограничиться S Typer av transportorder Begränsas till dessa transportordertyper TR Taşıma Emri Tipleri Kısıtlanacak Taşıma Emri Tipleri US Move Order Types Move Order Types to be restricted to ZHS 物料搬运单类型 受到下列限制的物料搬运单类型 16 140 :p_sales_order_low LOV Oracle INV_SRS_PICK_SLIP_SALES_ORDERS Y select order_number id, order_number value, null description from oe_order_headers_all where :$flex$.inv_srs_pick_slip_mo_types in (1,99) order by order_number AR أمر المبيعات من أمر المبيعات (من) D Von Kundenauftrag Von Kundenauftrag E De Pedido de Venta Pedido de Venta (De) F Commande client - De Commande client (De) I Ordine di vendita - Da Ordine di vendita (da) JA 受注:自 受注 (自) KO 판매 주문 From 판매 주문(From) PTB Ordem de Venda - De Ordem de Venda (De) RU Заказ на продажу с Заказ на продажу (с) S Från kundorder Kundorder (från) TR Satış Siparişi, İlk Satış Siparişi (İlk) US Sales Order From Sales Order (From) ZHS 销售订单自 销售订单（自） 17 150 :p_sales_order_high LOV Oracle INV_SRS_PICK_SLIP_SALES_ORDERS Y select order_number id, order_number value, null description from oe_order_headers_all where :$flex$.inv_srs_pick_slip_mo_types in (1,99) order by order_number SELECT :$flex$.sales_order_from FROM DUAL AR إلى 4 أمر المبيعات (إلى) D Bis 4 Bis Kundenauftrag E A 4 Pedido de Venta (A) F A 3 Commande client (A) I A 4 Ordine di vendita (a) JA 至 4 受注 (至) KO 까지 4 판매 주문(To) PTB Até 4 Ordem de Venda (Até) RU По 4 Заказ на продажу (по) S Till 4 Kundorder (till) TR Son 4 Satış Siparişi (Son) US To 4 Sales Order (To) ZHS 至 4 销售订单（至） 18 160 :p_freight_code LOV Oracle INV_SRS_PICK_SLIP_FREIGHT_CARRIER Y select lookup_code id, meaning value, description description from fnd_lookup_values_vl where view_application_id=3 and lookup_type='SHIP_METHOD' and :$flex$.inv_srs_pick_slip_mo_types in (1,99) order by lookup_code AR ناقلة الشحن رمز أجر الشحن D Transporteur Transporteur E Transportista Código de Flete F Transporteur Code transport I Vettore Codice vettore JA 運送業者 運送コード KO 운송 회사 운송 코드 PTB Transportadora Código do Frete RU Перевозчик Код фрахта S Speditör Fraktkod TR Taşımacı Navlun Kodu US Freight Carrier Freight Code ZHS 承运人 运费代码 19 170 :p_customer_id LOV Oracle INV_SRS_PICK_SLIP_CUSTOMERS Y select cust_acct.cust_account_id id, substrb(party.party_name,1,50) value, cust_acct.account_number description from hz_parties party,hz_cust_accounts cust_acct where :$flex$.inv_srs_pick_slip_mo_types in (1,99) and party.party_id=cust_acct.party_id order by party.party_name AR العميل معرف العميل D Kunde Kundenkennung E Cliente Id Cliente F Client ID client I Cliente Id cliente JA 顧客 顧客ID KO 고객 고객 ID PTB Cliente ID do Cliente RU Заказчик Идентификатор заказчика S Kund Kund-id TR Müşteri Müşteri No US Customer Customer ID ZHS 客户 客户标识 20 180 :p_allocate_move_order LOV Oracle INV_SRS_PICK_SLIP_AUTO_ALLOCATE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by lookup_code SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE='YES_NO' AND LOOKUP_CODE='N' AR التخصيص الآلي للسطور المعتمدة التخصيص الآلي للسطور المعتمدة D Genehmigte Positionen automatisch zuteilen Genehmigte Positionen automatisch zuteilen E Líneas Aprobadas de Asignación Automática Líneas Aprobadas de Asignación Automática F Affecter automatiquement les lignes approuvées Affecter automatiquement les lignes approuvées I Allocazione automatica linee approvate Allocazione automatica linee approvate JA 承認明細の自動割当 承認明細の自動割当 KO 승인 라인 자동 할당 자동 할당 승인 라인 PTB Alocar Automaticamente as Linhas Aprovadas Alocar Automaticamente as Linhas Aprovadas RU Авторазмещение утвержденных строк Авторазмещение утвержденных строк S Autoallokera godkända rader Autoallokera godkända rader TR Onaylanmış Satırları Otomatik Paylaştır Otomatik Paylaştırma Onaylı Satırlar US Auto Allocate Approved lines Auto Allocate Approved Lines ZHS 自动分配批准行 自动分配批准行 21 190 :p_plan_tasks LOV Oracle INV_SRS_Y_N Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and enabled_flag='Y' order by value,description SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE='YES_NO' AND LOOKUP_CODE='N' AR مهام التخطيط مهام التخطيط D Aufgaben planen Aufgaben planen E Planificar Tareas Planificar Tareas F Tâches de planification Tâches de planification I Task piano Task piano JA 計画タスク 計画タスク KO 계획 태스크 계획 태스크 PTB Tarefas do Plano Tarefas do Plano RU Плановые задачи Плановые задачи S Planaktiviteter Planaktiviteter TR İşleri Planla İşleri Planla US Plan Tasks Plan Tasks ZHS 计划任务 计划任务 22 200 :p_pick_slip_group_rule_id LOV Oracle INV_SRS_PICK_SLIP_GROUP_RULE Y select pick_grouping_rule_id id, name value, description description from wsh_pick_grouping_rules where sysdate between nvl(trunc(start_date_active),sysdate) and nvl(trunc(end_date_active),sysdate)+1 and :$flex$.inv_srs_pick_slip_mo_types in (4,99) and :$flex$.inv_srs_pick_slip_auto_allocate='Y' order by name AR قاعدة تجميع بطاقة الانتقاء قاعدة تجميع بطاقة الانتقاء D Entnahmeschein-Gruppierungsregel Entnahmeschein-Gruppierungsregel E Regla de Agrupación de Notas de Acopio Regla de Agrupación de Notas de Acopio F Règle de regroupement des bordereaux de prélèvement Règle de regroupement des bordereaux de prélèvement I Regola di raggruppamento distinte di prelievo Regola di raggruppamento distinte di prelievo JA ピック・スリップ・グループ化ルール ピック・スリップ・グループ化ルール KO 출하지시서 그룹핑 규칙 출하지시서 그룹핑 규칙 PTB Regra de Agrupamento do Slip de Separação Regra de Agrupamento do Slip de Separação RU Правило группировки товарных накладных Правило группировки товарных накладных S Grupperingsregel för plocksedel Grupperingsregel för plocksedel TR Toplama Fişi Gruplama Kuralı Toplama Fişi Gruplama Kuralı US Pick Slip Grouping Rule Pick Slip Grouping Rule ZHS 挑库单分组规则 挑库单分组规则 :$flex$.inv_srs_pick_slip_auto_allocate Auto Allocate Approved lines Pick Slip Grouping Rule :$flex$.inv_srs_pick_slip_mo_types Move Order Types Customer :$flex$.inv_srs_pick_slip_mo_types Move Order Types Freight Carrier :$flex$.inv_srs_pick_slip_mo_types Move Order Types Pick Slip Grouping Rule :$flex$.inv_srs_pick_slip_mo_types Move Order Types Sales Order From :$flex$.inv_srs_pick_slip_mo_types Move Order Types To 4 :$flex$.move_order_number_from Move Order Number From To :$flex$.pick_slip_number_from Pick Slip Number From To 2 :$flex$.sales_order_from Sales Order From To 4