ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F9B51A9E05362FB09050512 SELECT mmtt.inventory_item_id ,mmtt.revision ,mmtt.subinventory_code fr_subinv ,mmtt.locator_id ,pjm_project.all_proj_idtonum(mrl.project_id) as project_id ,(select task_number from mtl_task_v where task_id=mrl.task_id and rownum=1) as task_id ,mmtt.item_primary_uom_code primary_uom ,mmtt.operation_seq_num ,abs(mmtt.primary_quantity) primary_qty ,milk.concatenated_segments locator ,mrl.request_number ,mrl.line_number ,mrl.created_by ,mrl.date_required ,mrl.line_id ,msik.concatenated_segments item_name ,msik.description item_description ,fnd.user_name requester ,'Allocated' Move_order_Status ,wewov.wip_entity_name ,wro.comments, EAM_EAMMIPCK_XMLP_PKG.cf_refformula() CF_ref, EAM_EAMMIPCK_XMLP_PKG.cf_qty_pickedformula() CF_qty_picked, EAM_EAMMIPCK_XMLP_PKG.cf_reasonformula() CF_reason FROM mtl_material_transactions_temp mmtt ,mtl_txn_request_lines_v mrl ,mtl_item_locations_kfv milk ,fnd_user fnd ,wip_eam_work_orders_v wewov ,mtl_system_items_kfv msik ,wip_requirement_operations wro WHERE mmtt.organization_id = :p_org_id and mmtt.move_order_line_id = mrl.line_id and mmtt.organization_id = milk.organization_id(+) and mmtt.locator_id = milk.inventory_location_id(+) and nvl(mmtt.primary_quantity,0) > 0 and mrl.created_by = fnd.user_id and wewov.wip_entity_id=mmtt.transaction_source_id and wewov.ORGANIZATION_ID = mmtt.ORGANIZATION_ID and wewov.status_type in(3,4,5,6) and mmtt.inventory_item_id = msik.INVENTORY_ITEM_ID and mmtt.organization_id=msik.ORGANIZATION_ID and mmtt.organization_id=wro.organization_id and mmtt.inventory_item_id=wro.inventory_item_id and mmtt.operation_seq_num=wro.operation_seq_num and mmtt.transaction_source_id=wro.wip_entity_id and mrl.move_order_type=5 and mrl.line_status=7 and &p_where_clause order by &p_order_by Y EAM EAMMIRPKL_XML AR EAM تقرير قائمة انتقاء طلب صرف قطع الغيار (بتنسيق XML) Imported from BI Publisher Description: تقرير قائمة انتلقاء طلب صرف قطع الغيار Application: إدارة أصول المؤسسات Source: تقرير قائمة انتقاء طلب صرف قطع الغيار (بتنسيق XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG D EAM Entnahmeschein für Materialentnahmeanforderung Imported from BI Publisher Description: Auswertung "Entnahmeschein für Materialentnahmeanforderung" Application: Enterprise Asset Management Source: Entnahmeschein für Materialentnahmeanforderung (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG E EAM Lista de Acopio de Solicitud de Salida de Material Imported from BI Publisher Description: Informe Lista de Acopio de Solicitud de Salida de Material Application: Enterprise Asset Management Source: Lista de Acopio de Solicitud de Salida de Material (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG F EAM Liste à servir Demande de sortie matières Imported from BI Publisher Description: Etat Liste à servir Demande de sortie matières Application: Enterprise Asset Management Source: Liste à servir Demande de sortie matières (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG I EAM Rapporto Distinta di prelievo richiesta emissione materiale Imported from BI Publisher Description: Rapporto Distinta di prelievo richiesta emissione materiale Application: Enterprise Asset Management Source: Rapporto Distinta di prelievo richiesta emissione materiale (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG JA EAM 資材出庫要求ピック・リスト・レポート Imported from BI Publisher Description: 資材出庫要求ピック・リスト・レポート Application: Enterprise Asset Management Source: 資材出庫要求ピック・リスト・レポート(XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG KO EAM 자재 불출 요청 불출 목록 보고서 Imported from BI Publisher Description: 자재 불출 요청 선택 목록 보고서 Application: Enterprise Asset Management Source: 자재 불출 요청 불출 목록 보고서(XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG PTB EAM Relatório da Lista de Separação da Solicitação de Emissão de Material Imported from BI Publisher Description: Relatório da lista de separação da solicitação de emissão de material Application: Enterprise Asset Management Source: Relatório da Lista de Separação da Solicitação de Emissão de Material (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG RU EAM Отчет по ведомости комплектации запроса на выдачу материала Imported from BI Publisher Description: Отчет по ведомости комплектации запроса на выдачу материала Application: Управление активами предприятия Source: Отчет по ведомости комплектации запроса на выдачу материала (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG S EAM Plocklista för beställning av materialuttag - rapport Imported from BI Publisher Description: Plocklista för materialuttagsjobb - rapport Application: Enterprise Asset Management Source: Plocklista för beställning av materialuttag - rapport (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG TR EAM Malzeme Çıkışı Talebi Toplama Listesi Raporu Imported from BI Publisher Description: Malzeme çıkışı isteği toplama listesi raporu Application: Kurumsal Varlık Yönetimi Source: Malzeme Çıkışı Talebi Toplama Listesi Raporu (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG US EAM Material Issue Request Pick List Imported from BI Publisher Description: Material issue request pick list report Application: Enterprise Asset Management Source: Material Issue Request Pick List Report (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG ZHS EAM 物料发放请求挑库单报表 Imported from BI Publisher Description: 物料发放请求挑库单报表 Application: 企业资产管理系统 Source: 物料发放请求挑库单报表 (XML) Short Name: EAMMIRPKL_XML DB package: EAM_EAMMIPCK_XMLP_PKG BI Publisher &p_order_by &p_where_clause :p_conc_request_id :p_date_required_end :p_date_required_start :p_material :p_material_name :p_order_by :p_order_by_disp :p_order_by_used :p_org_id :p_org_name :p_request_number_end :p_request_number_start :p_requester :p_requester_name :p_source_locator :p_source_locator_name :p_source_subinventory :p_where_clause :p_where_clause1 :p_work_order :p_work_order_name 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y US Org_id 2 10 :p_request_number_start LOV Oracle EAM_SRS_MOVE_ORDER_FROM 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 Anforderungsnummer E De Número de Solicitud F Numéro de demande - De I Numero richiesta - Da JA 要求番号:自 KO 요청 번호: 부터 PTB Número da Solicitação - De RU Номер запроса с S Från beställningsnr TR İlk Talep Numarası US Request Number From ZHS 请求编号自 3 20 :p_request_number_end LOV Oracle EAM_SRS_MOVE_ORDER_TO Y select request_number id, request_number value, null description from mtl_txn_request_headers where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and request_number>=:$flex$.eam_srs_move_order_from order by request_number SELECT request_number FROM MTL_TXN_REQUEST_HEADERS Where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') And request_number >=:$flex$.request_number_from ORDER By request_number AR رقم الطلب إلى D Bis Anforderungsnummer E A Número de Solicitud F Numéro de demande - A I Numero richiesta - A JA 要求番号:至 KO 요청 번호: 까지 PTB Número da Solicitação - Até RU Номер запроса по S Till jobbnummer TR Son Talep Numarası US Request Number To ZHS 请求编号至 4 30 :p_date_required_start LOV Oracle EAM_SRS_START_DATE_STANDARD Y select calendar_date id, calendar_date value, null description from bom_calendar_dates where (calendar_code,exception_set_id) in (select calendar_code,calendar_exception_set_id from mtl_parameters where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) order by calendar_date AR التاريخ المطلوب من D Von Bedarfsdatum E De Fecha de Necesidad F Date requise - Du I Data richiesta - Da JA 要求日:自 KO 요구 일자: 부터 PTB Data Obrigatória - De RU Нужная дата с S Från behovsdatum TR İlk Gereklilik Tarih US Date Required From ZHS 需求日期自 5 40 :p_date_required_end LOV Oracle EAM_SRS_END_DATE_STANDARD Y select calendar_date id, calendar_date value, null description from bom_calendar_dates where (calendar_code,exception_set_id) in (select calendar_code,calendar_exception_set_id from mtl_parameters where organization_id= fnd_profile.value('MFG_ORGANIZATION_ID')) and calendar_date>= fnd_date.canonical_to_date(:$flex$.eam_srs_start_date_standard) order by calendar_date select calendar_date from bom_calendar_dates where (calendar_code, exception_set_id) IN (select calendar_code, calendar_exception_set_id from mtl_parameters where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and calendar_date = fnd_date.canonical_to_date(:$flex$.date_required_from) order by calendar_date AR التاريخ المطلوب إلى D Bis Bedarfsdatum E A Fecha de Necesidad F Date requise - Au I Data richiesta - A JA 要求日:至 KO 요구 일자: 까지 PTB Data Obrigatória - Até RU Нужная дата по S Till behovsdatum TR Son Gereklilik Tarih US Date Required To ZHS 需求日期至 6 50 :p_source_subinventory 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 E Subalmacén de Origen F Magasin d'origine I Sottomagazzino di origine JA ソース保管場所 KO 출처 창고 PTB Subinventário de Origem RU Складское подразделение-отправитель S Källagerställe TR Kaynak Stok Yeri US Source Subinventory ZHS 来源子库存 7 60 :p_source_locator Char AR محدد مواقع المصدر D Bezugslagerplatz E Ubicación Stock Origen F Emplacement d'origine I Collocazione di origine JA ソース保管棚 KO 출처 보관처 PTB Endereço de Origem RU Складское место-отправитель S Källlagerplats TR Kaynak Stok Adresi US Source Locator ZHS 来源货位 8 70 :p_work_order LOV Oracle EAM_SRS_WORK_ORDER_ID Y select wip_entity_id id, wip_entity_name value, null description from wip_eam_work_orders_v where organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') and entity_type=6 and status_type in (3,4,5,6) order by wip_entity_name AR أمر الشغل D Wartungsauftrag E Orden de Trabajo F Ordre de travail I Ordine di lavorazione JA 作業指示 KO 작업 지시 PTB Ordem de Serviço RU Заказ на выполнение работ S Arbetsorder TR İş Emri US Work Order ZHS 工作单 9 80 :p_material 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 قطع الغيار F Matières I Materiale JA 資材 KO 자재 RU Материал TR Malzeme US Material ZHS 物料 10 90 :p_requester LOV Oracle FND_USERS Y select user_id id, user_name value, null description from fnd_user order by user_name AR الطالب D Anforderer E Solicitante F Demandeur I Richiedente JA 依頼元 KO 요청자 PTB Solicitante RU Автор запроса S Beställare TR Talep Eden US Requestor ZHS 申请人 11 100 :p_order_by_used LOV Oracle EAM_SRS_SORT_BY Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='EAM_MATERIAL_ISSUE_SORT_BY' order by value,description Select meaning From mfg_lookups Where lookup_type='EAM_MATERIAL_ISSUE_SORT_BY' and lookup_code=1 AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach E Ordenar por Ordenar por F Tri par Tri par I Ordina per Ordina per JA ソート・キー ソート・キー KO 정렬 기준 정렬 기준 PTB Classificar por Classificar por RU Сортировка Сортировка S Sortera efter Sortera efter TR Sıralama Esası Sıralama Esası US Sort By Sort By ZHS 排序依据 排序依据 :$flex$.date_required_from Date Required From Date Required To :$flex$.eam_srs_move_order_from Request Number From Request Number To :$flex$.eam_srs_start_date_standard Date Required From Date Required To :$flex$.request_number_from Request Number From Request Number To