ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4A576AD8E05362FB09051F8BY select x.* from ( select * from (select /*+ leading(eswt,EWR) cardinality(eswt 10) */ eswt.ecc_spec_id ECC_SPEC_ID ,msitl.language LANGUAGE ,ewr.WIP_ENTITY_ID WIP_ENTITY_ID ,eswt.wip_entity_name WIP_ENTITY_NAME ,eswt.operation_seq_num OPERATION_SEQ_NUM ,eswt.inventory_item_id INVENTORY_ITEM_ID ,ewr.ORGANIZATION_ID ORGANIZATION_ID ,ewr.REQUISITION_NUMBER PR_NUMBER ,ewr.PO_NUMBER PO_NUMBER ,ewr.PO_STATUS PO_STATUS ,poh.comments PO_DESCRIPTION ,rqh.description PR_DESCRIPTION ,POS_GET.GET_PERSON_NAME_CACHE(poh.AGENT_ID) as BUYER ,pv.vendor_name SUPPLIER_PURCHASE ,msitl.description PO_ITEM_DESCRIPTION ,msi.concatenated_segments PO_ITEM_NAME ,wdj.status_type STATUS_TYPE ,mck.concatenated_segments CATEGORY_NAME from eam_wo_req_po_lite_v ewr, po_headers_all poh, po_requisition_headers_all rqh, mtl_system_items_kfv msi, wip_discrete_jobs wdj, mtl_categories_kfv mck, mtl_system_items_tl msitl, EAM_ECC_STORES_WO_TEMP eswt, po_vendors pv where ewr.po_header_id = poh.po_header_id(+) and ewr.REQUISITION_HEADER_ID = rqh.REQUISITION_HEADER_ID(+) and ewr.item_id = msi.inventory_item_id (+) and ewr.organization_id = msi.organization_id (+) and ewr.wip_entity_id = wdj.wip_entity_id (+) and ewr.CATEGORY_ID = mck.category_id (+) and msi.inventory_item_id = msitl.inventory_item_id and msi.organization_id = msitl.organization_id and ewr.wip_entity_id = eswt.wip_entity_id and ewr.organization_id = eswt.organization_id and ewr.vendor_id = pv.vendor_id(+) and msitl.language in ('US')) PIVOT (max(PO_ITEM_DESCRIPTION) as PO_ITEM_DESCRIPTION for LANGUAGE in ('US' "US")) ) x where 2=2 AR ECC إدارة أصول المؤسسات, أوامر شغل المتاجر (الصيانة), SQL3 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), SQL3 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), SQL3 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), SQL3 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), SQL3 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, 倉庫作業指示(保守), SQL3 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, 작업 지시 저장(유지보수), SQL3 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 Управление активами предприятия, Заказ на работы для запасов (техобслуж.), SQL3 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), SQL3 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), SQL3 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), SQL3 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, 仓库工作单（维护）, SQL3 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