ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4A566AD8E05362FB09051F8B select x.* from ( SELECT /*+ leading(eswt) cardinality(eswt 10) push_pred(mtlmt) */ to_char (mtlmt.transaction_source_id || '-' || mtlmt.operation_seq_num || '-' || mtlmt.inventory_item_id) as ECC_SPEC_ID, eswt.WIP_ENTITY_ID, eswt.operation_seq_num, eswt.inventory_item_id, mtlmt.transaction_date as MAT_ISSUE_DATES, ltrim(TO_CHAR(mtlmt.transaction_date,'yyyy-mm'),'0') as MAT_ISSUE_MONTHS, ltrim(TO_CHAR(mtlmt.transaction_date,'yyyy'),'0') as MAT_ISSUE_YEARS FROM mtl_material_transactions mtlmt, EAM_ECC_STORES_WO_TEMP eswt where mtlmt.transaction_source_id = eswt.WIP_ENTITY_ID and mtlmt.operation_seq_num = eswt.operation_seq_num and mtlmt.inventory_item_id = eswt.inventory_item_id and mtlmt.organization_id = eswt.organization_id ) x where 2=2 Y AR ECC إدارة أصول المؤسسات, أوامر شغل المتاجر (الصيانة), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Enterprise Asset Management, Läger - Wartungsaufträge (Instandhaltung), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Enterprise Asset Management, Orden de Trabajo de Tiendas (Mantenimiento), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Enterprise Asset Management, Magasins - Ordre de travail (maintenance), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Enterprise Asset Management, Ordine di lavorazione negozi (manutenzione), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC Enterprise Asset Management, 倉庫作業指示(保守), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC Enterprise Asset Management, 작업 지시 저장(유지보수), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Управление активами предприятия, Заказ на работы для запасов (техобслуж.), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Hantering av företagsanläggningar, Arbetsorder för förråd (underhåll), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Kurumsal Varlık Yönetimi, Mağazalar İş Emri (Bakım), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Enterprise Asset Management, Stores Work Order (Maintenance), SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Enterprise Asset Management, 仓库工作单（维护）, SQL2 Imported from Enterprise Command Center Dataset Key: eam-store-wo Query Procedure: EAM_ECC_STORES_WO_UTIL_PVT.GET_ECC_STORES_WO_DL_INFO Security Procedure: eam_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center