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_MV#

Source

View Text - Preformatted


Select MTH_ALL_ENTITIES.RRID RRID,MTH_ALL_ENTITIES.SITE_ID SITE_ID,MTH_ALL_ENTITIES.ENTITY_PK_KEY ENTITY_PK_KEY,MTH_ALL_ENTITIES.ENTITY_NAME ENTITY_NAME,MTH_ALL_ENTITIES.ENTITY_TYPE ENTITY_TYPE,MTH_ALL_ENTITIES.PRODUCTION_ENTITY PRODUCTION_ENTITY,MTH_ALL_ENTITIES.ENTITY_PK ENTITY_PK,MTH_ALL_ENTITIES.UMARKER UMARKER FROM (SELECT ROWID rrid,plant_fk_key site_id,entity_pk_key, entity_name,entity_type,
    			production_entity,entity_pk,1 umarker
  				FROM mth_equip_entities_mst UNION ALL SELECT ROWID rrid,
  				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,2 umarker
  				FROM mth_plants_d UNION ALL SELECT ROWID rrid,
  				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,
  				3 umarker FROM mth_resources_d UNION ALL
  				SELECT ROWID rrid,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,
  				4 umarker FROM mth_equipments_d ) MTH_ALL_ENTITIES

View Text - HTML Formatted

SELECT MTH_ALL_ENTITIES.RRID RRID
, MTH_ALL_ENTITIES.SITE_ID SITE_ID
, MTH_ALL_ENTITIES.ENTITY_PK_KEY ENTITY_PK_KEY
, MTH_ALL_ENTITIES.ENTITY_NAME ENTITY_NAME
, MTH_ALL_ENTITIES.ENTITY_TYPE ENTITY_TYPE
, MTH_ALL_ENTITIES.PRODUCTION_ENTITY PRODUCTION_ENTITY
, MTH_ALL_ENTITIES.ENTITY_PK ENTITY_PK
, MTH_ALL_ENTITIES.UMARKER UMARKER
FROM (SELECT ROWID RRID
, PLANT_FK_KEY SITE_ID
, ENTITY_PK_KEY
, ENTITY_NAME
, ENTITY_TYPE
, PRODUCTION_ENTITY
, ENTITY_PK
, 1 UMARKER FROM MTH_EQUIP_ENTITIES_MST UNION ALL SELECT ROWID RRID
, 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
, 2 UMARKER FROM MTH_PLANTS_D UNION ALL SELECT ROWID RRID
, 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
, 3 UMARKER
FROM MTH_RESOURCES_D UNION ALL SELECT ROWID RRID
, 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
, 4 UMARKER
FROM MTH_EQUIPMENTS_D ) MTH_ALL_ENTITIES