ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702D51A9E05362FB09050512Y SELECT null ITEM_FLEX, MSI.INVENTORY_ITEM_ID ITEM_ID, MOQD.ORGANIZATION_ID ORGANIZATION_ID, nvl(MOQD.REVISION, '-99') ITEM_REV, MSI.DESCRIPTION ITEM_DESC, MSI.PRIMARY_UOM_CODE ITEM_UOM, MLN.EXPIRATION_DATE LOT_EXPIRE_DT, MLN.LOT_NUMBER LOT_NUMBER, MOQD.SUBINVENTORY_CODE SUBINV_CODE, null LOCATOR_FLEX, nvl(MOQD.LOCATOR_ID,-9999) LOCATOR_ID, ROUND(MOQD.PRIMARY_TRANSACTION_QUANTITY , :P_qty_precision) TRAN_QTY, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_loc_value', 'INV', 'MTLL', 101, MIL.ORGANIZATION_ID, MIL.INVENTORY_LOCATION_ID, 'ALL', 'Y', 'VALUE') C_LOC_VALUE FROM MTL_SYSTEM_ITEMS MSI, MTL_ONHAND_QUANTITIES_DETAIL MOQD, MTL_LOT_NUMBERS MLN, MTL_ITEM_LOCATIONS MIL WHERE &P_ITEM_WHERE AND MSI.ORGANIZATION_ID = :P_ORG AND MSI.INVENTORY_ITEM_ID = MOQD.INVENTORY_ITEM_ID AND MOQD.INVENTORY_ITEM_ID = MLN.INVENTORY_ITEM_ID AND MOQD.ORGANIZATION_ID = :P_ORG AND MOQD.LOT_NUMBER = MLN.LOT_NUMBER AND MOQD.ORGANIZATION_ID = MIL.ORGANIZATION_ID (+) AND MOQD.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID (+) AND MLN.ORGANIZATION_ID = :P_ORG AND MLN.EXPIRATION_DATE <= :P_EXPIRE_DATE_1 order by &P_ITEM_ORDER_BY, mln.expiration_date, mln.lot_number INV INVTRELT_XML AR INV تقرير اللوطات منتهية الصلاحية (بتنسيق XML) Imported from BI Publisher Description: تقرير اللوطات المنتهية Application: المخازن Source: تقرير اللوطات منتهية الصلاحية (بتنسيق XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG D INV Lose - abgelaufen Imported from BI Publisher Description: Lose - abgelaufen Application: Lager Source: Lose - abgelaufen (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG E INV Lotes Caducados Imported from BI Publisher Description: Lotes Vencidos Application: Inventory Source: Lotes Caducados (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG F INV Etat des lots périmés Imported from BI Publisher Description: Etat des lots périmés Application: Inventory Source: Etat des lots périmés (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG I INV Rapporto Lotti scaduti Imported from BI Publisher Description: Rapporto Lotti scaduti Application: Inventory Source: Rapporto Lotti scaduti (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG JA INV 失効済ロット・レポート Imported from BI Publisher Description: 失効済ロット・レポート Application: Inventory Source: 失効済ロット・レポート(XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG KO INV 폐기된 로트 보고서 Imported from BI Publisher Description: 폐기된 로트 보고서 Application: Inventory Source: 폐기된 로트 보고서(XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG PTB INV Relatório de lotes expirados Imported from BI Publisher Description: Relatório de lotes expirados Application: Inventário Source: Relatório de lotes expirados (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG RU INV Отчет о просроченных партиях Imported from BI Publisher Description: Отчет о просроченных партиях Application: Запасы Source: Отчет о просроченных партиях (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG S INV Utgångna partier - rapport Imported from BI Publisher Description: Obrukbara partier - rapport Application: Inventory Source: Utgångna partier - rapport (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG TR INV Süresi dolan lotlar raporu Imported from BI Publisher Description: Geciken lotlar raporu Application: Stok Yönetimi Source: Süresi dolan lotlar raporu (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG US INV Expired lots Imported from BI Publisher Description: Expired lots report Application: Inventory Source: Expired lots report (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG ZHS INV 到期批次报表 Imported from BI Publisher Description: 到期批次报表 Application: 库存管理系统 Source: 到期批次报表 (XML) Short Name: INVTRELT_XML DB package: INV_INVTRELT_XMLP_PKG BI Publisher &p_item_order_by &p_item_where :p_conc_request_id :p_expire_date :p_expire_date_1 :p_item_flexdata :p_item_hi :p_item_lo :p_item_num :p_item_order_by :p_item_where :p_locator_flexdata :p_optimizer_code :p_org :p_qty_precision :p_sort_id :p_trace_flag 1 -30 :p_org Number fnd_profile.value('MFG_ORGANIZATION_ID') Y 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 组织 组织 2 -20 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') AR الدقة الدقة D Nachkommastellen Nachkommastellen E Precisión Precisión F Précision Précision I Precisione Precisione JA 精度 精度 KO 소수점 이하 자리수 소수점 이하 자리수 PTB Precisão Precisão RU Точность Точность TR Duyarlılık Duyarlılık US Precision Precision ZHS 精确度 精确度 3 10 :p_expire_date Date sysdate Y AR تاريخ انتهاء الصلاحية تاريخ انتهاء الصلاحية D Verfallsdatum Verfallsdatum E Fecha de Caducidad Fecha de Caducidad F Date d'expiration Date d'expiration I Data scadenza Data scadenza JA 失効日 失効日 KO 만료 일자 만료 일자 PTB Data de Expiração Data Expiração RU Окончание срока хранения Окончание срока хранения S Sista giltighetsdatum Sista giltighetsdatum TR Geçerlilik Bitiş Tarihi Geçerlilik Bitiş Tarihi US Expiration Date Expiration Date ZHS 到期日 到期日 4 20 :p_item_lo Char AR الأصناف من صنف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Article - De I Articoli - Da Articolo - Minimo JA 品目:自 品目:下位 KO 품목: 부터 품목 하한 PTB Itens - De Item Inferior RU Позиции с Позиция с S Från artiklar Från artikel TR Kalemler - İlk Kalem Alt Değeri US Items From Item Low ZHS 物料自 物料下限 5 30 :p_item_hi Char AR إلى صنف إلى D Bis Bis Artikel E A A Artículo F A Article - A I A Articolo - Massimo JA 至 品目:上位 KO 까지 품목 상한 PTB Até Item Superior RU По Позиция по S Till Till artikel TR Son Kalem Üst Değeri US To Item High ZHS 至 物料上限