ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4700951A9E05362FB09050512 select MSI.SEGMENT1 ITEM, MMT.SUBINVENTORY_CODE SUBINV, mil.concatenated_segments LOCATOR, pv.VENDOR_NAME VENDOR_NAME, MMT.TRANSACTION_QUANTITY TRANSACTION_QUANTITY, MMT.TRANSACTION_UOM TRANSACTION_UOM, to_char(MMT.TRANSACTION_DATE, 'DD-MON-YYYY HH:MI:SS AM') TRANSACTION_DATE, to_char(trunc(PHA.CREATION_DATE), 'DD-MON-YYYY') BILLING_PERIOD_END_DATE, PHA1.SEGMENT1 PO_NUMBER, PHA.SEGMENT1 RELEASE_NUMBER, fu.user_name USER_NAME from MTL_CONSUMPTION_TRANSACTIONS MCT, MTL_CONSUMPTION_TRANSACTIONS PMCT, MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_B MSI, mtl_item_locations_kfv mil, PO_VENDOR_SITES_ALL PS, PO_VENDORS PV, PO_HEADERS_ALL PHA, PO_HEADERS_ALL PHA1, fnd_user fu where MCT.TRANSACTION_ID = MMT.TRANSACTION_ID and MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID and MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID and nvl(MMT.LOCATOR_ID, -999) = mil.inventory_location_id(+) and PV.VENDOR_ID = PS.VENDOR_ID and PS.VENDOR_SITE_ID = mmt.XFR_OWNING_ORGANIZATION_ID and mmt.transaction_action_id = 6 and MMT.TRANSACTION_SOURCE_TYPE_ID = 13 and mmt.created_by = fu.user_id and MCT.PARENT_TRANSACTION_ID = PMCT.TRANSACTION_ID and PMCT.CONSUMPTION_PO_HEADER_ID is not null and PMCT.CONSUMPTION_PROCESSED_FLAG = 'Y' and PMCT.CONSUMPTION_PO_HEADER_ID = PHA.PO_HEADER_ID and PMCT.TRANSACTION_SOURCE_ID = PHA1.PO_HEADER_ID and MMT.ORGANIZATION_ID = :P_ORG_ID and MMT.transaction_date between trunc(:P_DATE_FROM) and trunc(:P_DATE_TO) and &P_WHERE union select MSI.SEGMENT1 ITEM, MMT.SUBINVENTORY_CODE SUBINV, mil.concatenated_segments LOCATOR, pv.VENDOR_NAME VENDOR_NAME, MMT.TRANSACTION_QUANTITY TRANSACTION_QUANTITY, MMT.TRANSACTION_UOM TRANSACTION_UOM, to_char(MMT.TRANSACTION_DATE, 'DD-MON-YYYY HH:MI:SS AM') TRANSACTION_DATE, to_char(trunc(PHA.CREATION_DATE), 'DD-MON-YYYY') BILLING_PERIOD_END_DATE, PHA.SEGMENT1 PO_NUMBER, to_Char(PRA.RELEASE_NUM) RELEASE_NUMBER, fu.user_name USER_NAME from MTL_CONSUMPTION_TRANSACTIONS MCT, MTL_CONSUMPTION_TRANSACTIONS PMCT, MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_B MSI, mtl_item_locations_kfv mil, PO_VENDOR_SITES_ALL PS, PO_VENDORS PV, PO_HEADERS_ALL PHA, PO_RELEASES_ALL PRA, fnd_user fu where MCT.TRANSACTION_ID = MMT.TRANSACTION_ID and MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID and MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID and nvl(MMT.LOCATOR_ID, -999) = mil.inventory_location_id(+) and PV.VENDOR_ID = PS.VENDOR_ID and PS.VENDOR_SITE_ID = mmt.XFR_OWNING_ORGANIZATION_ID and mmt.transaction_action_id = 6 and MMT.TRANSACTION_SOURCE_TYPE_ID = 13 and mmt.created_by = fu.user_id and MCT.PARENT_TRANSACTION_ID = PMCT.TRANSACTION_ID and PMCT.CONSUMPTION_PROCESSED_FLAG = 'Y' and PMCT.CONSUMPTION_RELEASE_ID is not null and PMCT.TRANSACTION_SOURCE_ID = PHA.PO_HEADER_ID and PMCT.CONSUMPTION_RELEASE_ID = PRA.PO_RELEASE_ID and MMT.ORGANIZATION_ID = :P_ORG_ID and MMT.transaction_date between trunc(:P_DATE_FROM) and trunc(:P_DATE_TO) and &P_WHERE union select MSI.SEGMENT1 ITEM, MMT.SUBINVENTORY_CODE SUBINV, mil.concatenated_segments LOCATOR, pv.VENDOR_NAME VENDOR_NAME, MMT.TRANSACTION_QUANTITY TRANSACTION_QUANTITY, MMT.TRANSACTION_UOM TRANSACTION_UOM, to_char(MMT.TRANSACTION_DATE, 'DD-MON-YYYY HH:MI:SS AM') TRANSACTION_DATE, null BILLING_PERIOD_END_DATE, PHA.SEGMENT1 PO_NUMBER, null RELEASE_NUMBER, fu.user_name USER_NAME from MTL_CONSUMPTION_TRANSACTIONS MCT, MTL_CONSUMPTION_TRANSACTIONS PMCT, MTL_MATERIAL_TRANSACTIONS MMT, MTL_SYSTEM_ITEMS_B MSI, mtl_item_locations_kfv mil, PO_VENDOR_SITES_ALL PS, PO_VENDORS PV, PO_HEADERS_ALL PHA, PO_LINES_ALL PLA, fnd_user fu where MCT.TRANSACTION_ID = MMT.TRANSACTION_ID and MMT.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID and MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID and nvl(MMT.LOCATOR_ID, -999) = mil.inventory_location_id(+) and PV.VENDOR_ID = PS.VENDOR_ID and PS.VENDOR_SITE_ID = mmt.XFR_OWNING_ORGANIZATION_ID and mmt.transaction_action_id = 6 and MMT.TRANSACTION_SOURCE_TYPE_ID = 13 and mmt.created_by = fu.user_id and MCT.PARENT_TRANSACTION_ID = PMCT.TRANSACTION_ID and PMCT.CONSUMPTION_PROCESSED_FLAG = 'N' and PMCT.PO_LINE_ID = PLA.PO_LINE_ID and PHA.PO_HEADER_ID = PLA.PO_HEADER_ID and MMT.ORGANIZATION_ID = :P_ORG_ID and MMT.transaction_date between trunc(:P_DATE_FROM) and trunc(:P_DATE_TO) and &P_WHERE order by ITEM, BILLING_PERIOD_END_DATE Y INV INVCONRT_XML AR INV تقرير حركات إعادة المودع Imported from BI Publisher Description: تقرير حركات إعادة المخزون المودع Application: المخازن Source: تقرير حركات إعادة المودع (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG D INV Rücksendungstransaktionen aus Konsignationsbestand Imported from BI Publisher Description: Auswertung "Rücksendungstransaktionen aus Konsignationsbestand" Application: Lager Source: Rücksendungstransaktionen aus Konsignationsbestand (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG E INV Informe Transacciones de Devolución Consignadas Imported from BI Publisher Description: Informe Transacciones de Devolución Consignadas de Inventario Application: Inventory Source: Informe Transacciones de Devolución Consignadas (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG F INV Etat des mouvements de retour consigné Imported from BI Publisher Description: Etat des mouvements de retour consigné dans le stock Application: Inventory Source: Etat des mouvements de retour consigné (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG I INV Report Transazioni restituzione in conto deposito Imported from BI Publisher Description: Report Transazioni restituzione in conto deposito magazzino Application: Inventory Source: Report Transazioni restituzione in conto deposito (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG JA INV 預託返品取引レポート Imported from BI Publisher Description: 在庫預託返品取引レポート Application: Inventory Source: 預託返品取引レポート(XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG KO INV 위탁 반품 트랜잭션 보고서 Imported from BI Publisher Description: 재고 위탁 반품 트랜잭션 보고서 Application: Inventory Source: 위탁 반품 트랜잭션 보고서(XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG PTB INV Relatório de Transações de Devolução Consignada Imported from BI Publisher Description: Relatório de Transações de Devolução Consignada de Inventário Application: Inventário Source: Relatório de Transações de Devolução Consignada (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG RU INV Отчет о транзакциях возврата с консигнацией Imported from BI Publisher Description: Отчет о транзакциях возврата запасов с консигнацией Application: Запасы Source: Отчет о транзакциях возврата с консигнацией (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG S INV Rapport över konsignerade returtransaktioner Imported from BI Publisher Description: Lager: Rapport över konsignerade returtransaktioner Application: Inventory Source: Rapport över konsignerade returtransaktioner (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG TR INV Konsinye İade İşlemleri Raporu Imported from BI Publisher Description: Envanter Konsinye İade İşlemleri Raporu Application: Stok Yönetimi Source: Konsinye İade İşlemleri Raporu (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG US INV Consigned Return Transactions Imported from BI Publisher Description: Inventory Consigned Return Transactions Report Application: Inventory Source: Consigned Return Transactions Report (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG ZHS INV 寄销退货事务处理报表 Imported from BI Publisher Description: 库存寄销退货事务处理报表 Application: 库存管理系统 Source: 寄销退货事务处理报表 (XML) Short Name: INVCONRT_XML DB package: INV_INVCONRT_XMLP_PKG BI Publisher &p_where :cp_date_hi :cp_date_lo :p_conc_request_id :p_date_from :p_date_to :p_item :p_item_id :p_locator :p_locator_id :p_org_id :p_org_name :p_owning_organization_id :p_subinv :p_vendor_name :p_where 1 -10 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR ORGANIZATION معرف التنظيم D ORGANIZATION Organisationskennung E ORGANIZATION Identificador de Organización F ORGANIZATION Identifiant de l'organisation I ORGANIZATION Identificativo organizzazione JA ORGANIZATION 組織識別子 KO ORGANIZATION 조직 식별자 PTB ORGANIZATION Identificador da Organização RU ORGANIZATION Идентификатор организ. S ORGANIZATION Organisations-id TR ORGANIZATION Organizasyon Tanımlayıcı US ORGANIZATION Organization Identifier ZHS ORGANIZATION 组织标识 2 10 :p_date_from Date Y 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 需求日期自 需求日期（自） 3 20 :p_date_to Date Y AR التاريخ المطلوب إلى تاريخ الطلب (إلى) D Bis Bedarfsdatum Bis Bedarfsdatum E A Fecha de Necesidad Fecha de Necesidad (A) F Date requise - Au Date requise (Au) I Data richiesta - A Data richiesta (a) JA 要求日:至 要求日 (至) KO 요구 일자: 까지 요구 일자(까지) PTB Data Necessária - até Data Obrigatória (Até) RU Нужная дата по Нужная дата (по) S Till behovsdatum Behovsdatum (till) TR Gerekli Tarih: Son Gerekli Tarih (Son) US Date Required To Date Required (To) ZHS 需求日期至 需求日期（至） 4 30 :p_item_id LOV Oracle INV_SRS_ITEM_ID Y select inventory_item_id id, concatenated_segments value, description description from mtl_system_items_kfv where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by concatenated_segments AR الصنف الصنف D Artikel Artikel E Artículo Artículo F Article Article I Articolo Articolo JA 品目 品目 KO 품목 품목 RU Позиция Позиция S Artikel Artikel TR Kalem Kalem US Item Item ZHS 物料 物料 5 40 :p_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 Lager Bezugslager E Subalmacén Subalmacén de Origen F Magasin Magasin d'origine I Sottomagazzino Sottomagazzino origine JA 保管場所 ソース保管場所 KO 창고 출처 창고 PTB Subinventário Subinventário de Origem RU Складское подразделение Складское подразделение-отправитель S Lagerställe Källagerställe TR Stok Yeri Kaynak Stok Yeri US Subinventory Source Subinventory ZHS 子库存 来源子库存 6 50 :p_locator_id Char AR مُحدد المواقع محدد مواقع مصدر D Lagerplatz Bezugslagerplatz E Ubicación de Stock Ubicación de Stock de Origen F Emplacement Emplacement d'origine I Collocazione Collocazione origine JA 保管棚 ソース保管棚 KO 보관처 출처 보관처 PTB Endereço Endereço de Origem RU Складское место Складское место-отправитель S Lagerplats Källlagerplats TR Stok Adresi Kaynak Stok Adresi US Locator Source Locator ZHS 货位 来源货位 7 60 :p_owning_organization_id LOV Oracle INV_CONS_VENDORS Y Y select vendor_id id, vendor_name value, null description from po_vendors order by value,description AR التنظيم المالك معرف التنظيم المالك D Verantwortliche Organisation Kennung Verantwortliche Organisation E Organización Propietaria Id Organización Propietaria F Organisation propriétaire ID organisation propriétaire I Organizzazione proprietaria ID organizzazione proprietaria JA 所有組織 所有組織ID KO 소유 조직 소유 조직 ID PTB Organização Responsável ID da Organização Responsável RU Организация-владелец Идентификатор организации-владельца S Ägande organisation Id för ägande organisation TR Sahip Olan Organizasyon Sahip Olan Organizasyon No US Owning Organization Owning Organization ID ZHS 拥有组织 拥有组织标识