VIEW: APPS.MTH_ALL_ENTITIES_VIEW_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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