EAM Work Order tables

 EAM Related Queries

--------------------------

select * from wip_eam_entities_v where wip_entity_id='375590'

select * from WIP_REQUIREMENT_OPERATIONS_V  where wip_entity_id='375590'

select * from EAM_WORK_ORDERS_V where wip_entity_name ='EN-517074'--wip_entity_id='375590'--order by CREATION_DATE desc

SELECT * FROM EAM_REBUILD_COMPLETION_JOBS_V where wip_entity_id='375590'

select * from EAM_MATERIALS_V where  wip_entity_id='375590'

select * from wip_discrete_jobs where wip_entity_id='375590'

 select * from eam_org_maint_defaults where owning_department_id=15005--ORDER BY CREATION_DATE DESC

 

 select * from mtl_onhand_quantities where update_transaction_id in (4347392,4349395)

 select * from EAM_WO_STATUSES_V

===========cost tables=======================================

SELECT * FROM cst_eam_wo_estimate_details where  organization_id=742--  where organization_id =742 and transaction_id='4349395'

SELECT * FROM WIP_REQ_OPERATION_COST_DETAILS where wip_entity_id='366590'------200/177.42

SELECT * FROM EAM_MATERIALS_V where wip_entity_id='375590'--------0/166.66

---------------------------------------------------------------------------------------------------------------------------

select * from mtl_system_items_b where segment1='Asset Group' and eam_item_type=1;

select * from csi_item_instances;

select * from csi_counters_b;

select * from mtl_system_items_b where segment1='Activty'and eam_item_type=2;