ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4703251A9E05362FB09050512 SELECT NVL( MTLN.SUPPLIER_LOT_NUMBER , 'None') VENDOR_LOT2, --17153772 NVL( MTLN.LOT_NUMBER, 'None') TXN_LOT_NUM2, null ITEM_FLEX2, MSI.INVENTORY_ITEM_ID ITEM_ID2, MTLN.TRANSACTION_ID TXN_ID2, MMT.REVISION ITEM_REV2, MSI.DESCRIPTION ITEM_DESC2, MTT.TRANSACTION_TYPE_NAME TXN_TYPE_NAME2, MTLN.TRANSACTION_SOURCE_ID TXN_SRC_ID2, MTLN.TRANSACTION_SOURCE_TYPE_ID TXN_SRC_TYPE_ID2, DECODE(MTLN.TRANSACTION_SOURCE_TYPE_ID, 1,POH.SEGMENT1, 2,null, 3,null, 4,NULL, 5,WIP.WIP_ENTITY_NAME, 6,null, 7,PORH.SEGMENT1, 8,&P_MKTS_FLEXDATA, 9,CCH.CYCLE_COUNT_HEADER_NAME, 10,MPI.PHYSICAL_INVENTORY_NAME, 11,CUPD.DESCRIPTION, 12,&P_MKTS_FLEXDATA, 13,MTLN.TRANSACTION_SOURCE_NAME, MTLN.TRANSACTION_SOURCE_NAME) TXN_SOURCE_DATA2, MMT.TRANSACTION_DATE TXN_DATE2, MTLN.ORGANIZATION_ID ORG_ID2, MMT.TRANSACTION_UOM TXN_UOM2, ROUND(NVL(MTLN.PRIMARY_QUANTITY,0), :P_qty_precision) TXN_LOT_QTY2, DECODE(MSI.TRACKING_QUANTITY_IND, 'PS', MMT.SECONDARY_UOM_CODE, NULL) SEC_TXN_UOM2, DECODE(MSI.TRACKING_QUANTITY_IND, 'PS', ROUND(NVL(MTLN.SECONDARY_TRANSACTION_QUANTITY,0),:P_qty_precision), NULL) SEC_TXN_LOT_QTY2, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_item_value2', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_ITEM_VALUE2, decode(MTLN.TRANSACTION_SOURCE_TYPE_ID,2,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source_value2_1', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),3,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source_value2_2', 'SQLGL', 'GL#', GLCC.CHART_OF_ACCOUNTS_ID, NULL, GLCC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'),6,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source_value2_3', 'INV', 'MDSP', 101, MDSP.ORGANIZATION_ID, MDSP.DISPOSITION_ID, 'ALL', 'Y', 'VALUE'),8,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source_value2_1', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),12,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_source_value2_1', 'INV', 'MKTS', 101, NULL, MKTS.SALES_ORDER_ID, 'ALL', 'Y', 'VALUE'),DECODE(MTLN.TRANSACTION_SOURCE_TYPE_ID, 1,POH.SEGMENT1, 2,null, 3,null, 5,WIP.WIP_ENTITY_NAME, 6,null, 7,PORH.SEGMENT1, 8,&P_MKTS_FLEXDATA, 9,CCH.CYCLE_COUNT_HEADER_NAME, 10,MPI.PHYSICAL_INVENTORY_NAME, 11,CUPD.DESCRIPTION, 12,&P_MKTS_FLEXDATA, 13,MTLN.TRANSACTION_SOURCE_NAME, MTLN.TRANSACTION_SOURCE_NAME)) C_SOURCE_VALUE2 --&C_source_value2 C_SOURCE_VALUE2 FROM MTL_SYSTEM_ITEMS MSI, MTL_TRANSACTION_LOT_NUMBERS MTLN, MTL_MATERIAL_TRANSACTIONS MMT, PO_HEADERS_ALL POH, PO_REQUISITION_HEADERS_ALL PORH, MTL_SALES_ORDERS MKTS, GL_CODE_COMBINATIONS GLCC, WIP_ENTITIES WIP, MTL_GENERIC_DISPOSITIONS MDSP, CST_COST_UPDATES CUPD, MTL_CYCLE_COUNT_HEADERS CCH, MTL_TRANSACTION_TYPES MTT, MTL_PHYSICAL_INVENTORIES MPI WHERE MMT.TRANSACTION_TYPE_ID = MTT.TRANSACTION_TYPE_ID (+) AND &P_ITEM_WHERE AND MTLN.ORGANIZATION_ID = :P_ORG AND MTLN.ORGANIZATION_ID = MMT.ORGANIZATION_ID (+) AND MTLN.ORGANIZATION_ID = MSI.ORGANIZATION_ID AND MTLN.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID AND MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID --17153772 &C_LOT_WHERE AND ( :P_VEND_LOT_NUMBER IS NULL OR MTLN.SUPPLIER_LOT_NUMBER = :P_VEND_LOT_NUMBER ) AND trunc(MTLN.TRANSACTION_DATE) >= :P_START_DATE ---17304210 AND trunc(MTLN.TRANSACTION_DATE) <= :P_END_DATE_1 --17304210 AND MTLN.TRANSACTION_SOURCE_ID = POH.PO_HEADER_ID (+) AND MTLN.TRANSACTION_SOURCE_ID = MKTS.SALES_ORDER_ID (+) AND MTLN.TRANSACTION_SOURCE_ID = GLCC.CODE_COMBINATION_ID (+) AND ( MTLN.TRANSACTION_SOURCE_ID = WIP.WIP_ENTITY_ID (+) AND MTLN.ORGANIZATION_ID = WIP.ORGANIZATION_ID (+) ) AND MTLN.TRANSACTION_SOURCE_ID = MDSP.DISPOSITION_ID (+) AND MTLN.TRANSACTION_SOURCE_ID = PORH.REQUISITION_HEADER_ID (+) AND ( MTLN.TRANSACTION_SOURCE_ID = CCH.CYCLE_COUNT_HEADER_ID (+) AND MTLN.ORGANIZATION_ID = CCH.ORGANIZATION_ID (+) ) AND ( MTLN.TRANSACTION_SOURCE_ID = MPI.PHYSICAL_INVENTORY_ID (+) AND MTLN.ORGANIZATION_ID = MPI.ORGANIZATION_ID (+) ) AND ( MTLN.TRANSACTION_SOURCE_ID = CUPD.COST_UPDATE_ID (+) AND MTLN.ORGANIZATION_ID = CUPD.ORGANIZATION_ID (+) ) ORDER BY mtln.supplier_lot_number , mtln.lot_number , &P_ITEM_ORDER_BY, mmt.revision, mtln.transaction_date, mtln.transaction_id Y INV INVTRVLT_XML AR INV تقرير تتبع لوط المورد (بتنسيق XML) Imported from BI Publisher Description: تقرير تتبع لوط المورد Application: المخازن Source: تقرير تتبع لوط المورد (بتنسيق XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG D INV Losverfolgung - Lieferant Imported from BI Publisher Description: Losverfolgung - Lieferant Application: Lager Source: Losverfolgung - Lieferant (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG E INV Rastreo de Lotes de Proveedores Imported from BI Publisher Description: Rastreo de Lotes de Proveedores Application: Inventory Source: Rastreo de Lotes de Proveedores (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG F INV Etat de suivi des lots fournisseur Imported from BI Publisher Description: Etat de suivi des lots fournisseur Application: Inventory Source: Etat de suivi des lots fournisseur (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG I INV Rapporto Individuazione lotto fornitore Imported from BI Publisher Description: Rapporto Individuazione lotto fornitore Application: Inventory Source: Rapporto Individuazione lotto fornitore (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG JA INV 仕入先ロット・トレース・レポート Imported from BI Publisher Description: 仕入先ロット・トレース・レポート Application: Inventory Source: 仕入先ロット・トレース・レポート(XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG KO INV 공급자 로트 추적 보고서 Imported from BI Publisher Description: 공급자 로트 추적 보고서 Application: Inventory Source: 공급자 로트 추적 보고서(XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG PTB INV Relatório de rastreamento do lote do fornecedor Imported from BI Publisher Description: Relatório de rastreamento do lote do fornecedor Application: Inventário Source: Relatório de rastreamento do lote do fornecedor (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG RU INV Отчет об отслеживании партии поставщика Imported from BI Publisher Description: Отчет об отслеживании партии поставщика Application: Запасы Source: Отчет об отслеживании партии поставщика (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG S INV Spåra leverantörsparti - rapport Imported from BI Publisher Description: Leverantör partispårning - rapport Application: Inventory Source: Spåra leverantörsparti - rapport (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG TR INV Tedarikçi lotu izleme raporu Imported from BI Publisher Description: Tedarikçi lotu izleme raporu Application: Stok Yönetimi Source: Tedarikçi lotu izleme raporu (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG US INV Vendor lot trace Imported from BI Publisher Description: Vendor lot trace report Application: Inventory Source: Vendor lot trace report (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG ZHS INV 供应商批次跟踪报表 Imported from BI Publisher Description: 供应商批次跟踪报表 Application: 库存管理系统 Source: 供应商批次跟踪报表 (XML) Short Name: INVTRVLT_XML DB package: INV_INVTRVLT_XMLP_PKG BI Publisher &c_lot_where &c_source_value2 &p_item_order_by &p_item_where &p_mkts_flexdata :cp_end_date :p_conc_request_id :p_end_date :p_end_date_1 :p_gl_flexdata :p_gl_num :p_item_flexdata :p_item_hi :p_item_lo :p_item_num :p_item_order_by :p_item_where :p_lot_number_hi :p_lot_number_lo :p_mdsp_flexdata :p_mdsp_num :p_mkts_flexdata :p_mkts_num :p_optimizer_code :p_org :p_qty_precision :p_sort_id :p_start_date :p_start_date_1 :p_trace_flag :p_vend_lot_number 1 -40 :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 -30 :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 -20 :p_gl_num Number select chart_of_accounts_id from org_organization_definitions where organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') Y AR معرف هيكل الحساب معرف هيكل الحساب D Kennung Kontenstruktur Kennung Kontenstruktur E Id Estructura Contable Id Estructura Contable F ID structure comptable ID structure comptable I ID struttura conto ID struttura conto JA 勘定科目体系ID 勘定科目体系ID KO 계정 구조 Id 계정 구조 Id PTB Id da Estrutura de Conta Id da Estrutura de Conta RU Идентификатор структуры счетов Идентификатор структуры счетов S Kontostruktur-id Kontostruktur-id TR Hesap Yapısı No Hesap Yapısı No US Account Structure Id Account Structure Id ZHS 帐户结构标识 帐户结构标识 4 10 :p_sort_id LOV Oracle INV_SRS_VLT_SORT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='INV_SRS_VLT_SORT' and enabled_flag='Y' order by lookup_code select meaning from mfg_lookups where lookup_type = 'INV_SRS_VLT_SORT' and enabled_flag = 'Y' and lookup_code = 1 Y AR فرز بواسطة خيار الفرز D Sortieren nach Sortieroption E Ordenar por Opción de Ordenación F Tri par Option de tri I Ordina per Opzione di ordinamento JA ソート・キー ソート・オプション KO 정렬 기준 정렬 옵션 PTB Classificar por Opção de Classificação RU Сортировка Параметр сортировки S Sortera efter Sorteringsalternativ TR Sıralama Bazı Sıralama Seçeneği US Sort By Sort Option ZHS 排序依据 排序选项 5 20 :p_start_date Date sysdate Y AR التواريخ من تاريخ من D Datum von Von Datum E De Fecha De Fecha F Dates - Du Date de début I Date - Da Data (min) JA 日付:自 日付:自 KO 일자: 부터 일자 하한 PTB Datas - De Data - Inferior RU Даты с Дата с S Från datum Från datum TR Tarihler: İlk Başlangıç Tarihi US Dates From Date Low ZHS 日期自 日期下限 6 30 :p_end_date Date sysdate Y AR إلى تاريخ إلى D Bis Bis Datum E A A Fecha F Au Date de fin I A Data (max) JA 至 日付:至 KO 까지 일자 상한 PTB Até Data - Superior RU По Дата по S Till Till datum TR Son Bitiş Tarihi US To Date High ZHS 至 日期上限 7 40 :p_lot_number_lo LOV Oracle INV_SRS_LOT_NUMBER1 Y select lot_number id, lot_number value, null description from mtl_lot_numbers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by lot_number AR أرقام اللوطات من رقم لوط من D Von Losnummer Von Losnummer E De Número Lote De Número de Lote F Numéro lot - De Numéro de lot - De I Numeri lotto - Da Numero lotto - Da JA ロット番号:自 ロット番号:下位 KO 로트번호: 부터 로트 번호 하한 PTB Números Lote De Número de Lote - Inferior RU Номера партий с Номер партии с S Från partinummer Partinummer från TR Lot Numaraları, İlk Lot Numarası İlk: US Lot Numbers From Lot Number Low ZHS 批号自 批号下限 8 50 :p_lot_number_hi LOV Oracle INV_SRS_LOT_NUMBER1 Y select lot_number id, lot_number value, null description from mtl_lot_numbers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') order by lot_number AR إلى 2 رقم لوط من D Bis 2 Bis Losnummer E A 2 A Número de Lote F A Numéro de lot - A I A 2 Numero lotto - A JA 至 2 ロット番号:上位 KO 까지 2 로트 번호 상한 PTB Até 2 Número de Lote - Superior RU По 2 Номер партии по S Till 2 Partinummerdetalj till TR Son 2 Lot Numarası Son: US To 2 Lot Number High ZHS 至 2 批号上限 9 60 :p_vend_lot_number Char AR رقم لوط المورد رقم لوط المورد D Losnummer Lieferant Losnummer Lieferant E Número de Lote de Proveedor Número de Lote de Proveedor F Numéro de lot fournisseur Numéro de lot fournisseur I Numero lotto fornitore Numero lotto fornitore JA 仕入先ロット番号 仕入先ロット番号 KO 공급자 로트 번호 공급자 로트 번호 PTB Nr. do Lote do Fornecedor Nr. do Lote do Fornecedor RU Номер партии поставщика Номер партии поставщика S Leverantörens partinummer Leverantörens partinummer TR Tedarikçi Lot Numarası Tedarikçi Lot Numarası US Vendor Lot Number Vendor Lot Number ZHS 供应商批号 供应商批号 10 70 :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 物料自 物料下限 11 80 :p_item_hi Char AR إلى 3 صنف إلى D Bis 3 Bis Artikel E A 3 A Artículo F A 2 Article - A I A 3 Articolo - Massimo JA 至 3 品目:上位 KO 까지 3 품목 상한 PTB Até 3 Item Superior RU По 3 Позиция по S Till 3 Till artikel TR Son 3 Kalem Üst Değeri US To 3 Item High ZHS 至 3 物料上限