eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTH_ALL_ENTITIES_V

Source

View Text - Preformatted


SELECT SITE_ID, ENTITY_PK_KEY, ENTITY_NAME, ENTITY_TYPE, PRODUCTION_ENTITY, ENTITY_PK, CREATION_DATE, LAST_UPDATE_DATE, STATUS FROM (SELECT plant_fk_key site_id, entity_pk_key, entity_name, entity_type, production_entity, entity_pk, CREATION_DATE, LAST_UPDATE_DATE, STATUS FROM mth_equip_entities_mst UNION ALL SELECT plant_pk_key site_id, plant_pk_key entity_pk_key, plant_name entity_name, 'SITE' entity_type, production_site production_entity, plant_pk entity_pk, CREATION_DATE, LAST_UPDATE_DATE, CASE WHEN Nvl(To_Date,SYSDATE)>=SYSDATE THEN 'ACTIVE' ELSE 'INACTIVE' END STATUS FROM mth_plants_d UNION ALL SELECT plant_fk_key site_id, resource_pk_key entity_pk_key, resource_name entity_name, 'RESOURCE' entity_type, production_resource production_entity, resource_pk entity_pk, CREATION_DATE, LAST_UPDATE_DATE, STATUS FROM mth_resources_d UNION ALL SELECT plant_fk_key site_id, equipment_pk_key entity_pk_key, equipment_name entity_name, 'EQUIPMENT' entity_type, production_equipment production_entity, EQUIPMENT_PK ENTITY_PK, CREATION_DATE, LAST_UPDATE_DATE, STATUS FROM mth_equipments_d)

View Text - HTML Formatted

SELECT SITE_ID
, ENTITY_PK_KEY
, ENTITY_NAME
, ENTITY_TYPE
, PRODUCTION_ENTITY
, ENTITY_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, STATUS
FROM (SELECT PLANT_FK_KEY SITE_ID
, ENTITY_PK_KEY
, ENTITY_NAME
, ENTITY_TYPE
, PRODUCTION_ENTITY
, ENTITY_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, STATUS
FROM MTH_EQUIP_ENTITIES_MST UNION ALL SELECT PLANT_PK_KEY SITE_ID
, PLANT_PK_KEY ENTITY_PK_KEY
, PLANT_NAME ENTITY_NAME
, 'SITE' ENTITY_TYPE
, PRODUCTION_SITE PRODUCTION_ENTITY
, PLANT_PK ENTITY_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, CASE WHEN NVL(TO_DATE
, SYSDATE)>=SYSDATE THEN 'ACTIVE' ELSE 'INACTIVE' END STATUS
FROM MTH_PLANTS_D UNION ALL SELECT PLANT_FK_KEY SITE_ID
, RESOURCE_PK_KEY ENTITY_PK_KEY
, RESOURCE_NAME ENTITY_NAME
, 'RESOURCE' ENTITY_TYPE
, PRODUCTION_RESOURCE PRODUCTION_ENTITY
, RESOURCE_PK ENTITY_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, STATUS
FROM MTH_RESOURCES_D UNION ALL SELECT PLANT_FK_KEY SITE_ID
, EQUIPMENT_PK_KEY ENTITY_PK_KEY
, EQUIPMENT_NAME ENTITY_NAME
, 'EQUIPMENT' ENTITY_TYPE
, PRODUCTION_EQUIPMENT PRODUCTION_ENTITY
, EQUIPMENT_PK ENTITY_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, STATUS
FROM MTH_EQUIPMENTS_D)