[Home] [Help]
1760: tag_mstr.TAG_CODE "TAG_CODE_1",
1761: tag_mstr.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY_1",
1762: tag_mstr.UOM
1763: FROM
1764: EGO_ATTR_GROUPS_V eagrps
1765: JOIN EGO_ATTRS_V eattrs ON ( (( eagrps.ATTR_GROUP_TYPE = eattrs.ATTR_GROUP_TYPE ))
1766: AND (( eagrps.APPLICATION_ID = eattrs.APPLICATION_ID ))
1767: AND (( eattrs.ATTR_GROUP_NAME = eagrps.ATTR_GROUP_NAME )) )
1768: JOIN MTH_TAG_READINGS_STG stg ON ( (( eagrps.ATTR_GROUP_ID = stg.ATTRIBUTE_GROUP ))
1847: tag_mstr.TAG_CODE "TAG_CODE_1",
1848: tag_mstr.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY_1",
1849: tag_mstr.UOM
1850: FROM
1851: EGO_ATTR_GROUPS_V eagrps
1852: JOIN EGO_ATTRS_V eattrs ON ( (( eagrps.ATTR_GROUP_TYPE = eattrs.ATTR_GROUP_TYPE ))
1853: AND (( eagrps.APPLICATION_ID = eattrs.APPLICATION_ID ))
1854: AND (( eattrs.ATTR_GROUP_NAME = eagrps.ATTR_GROUP_NAME )) )
1855: JOIN MTH_TAG_READINGS_STG stg ON ( (( eagrps.ATTR_GROUP_ID = stg.ATTRIBUTE_GROUP ))
1914: TRS.ATTRIBUTE ATTRIBUTE,
1915: TRS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY ,
1916: TM.UOM ,
1917: TRS.READING_TIME
1918: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM
1919: WHERE EAGV.ATTR_GROUP_TYPE = EAV.ATTR_GROUP_TYPE
1920: AND EAGV.APPLICATION_ID = EAV.APPLICATION_ID
1921: AND EAV.ATTR_GROUP_NAME = EAGV.ATTR_GROUP_NAME
1922: AND EAGV.ATTR_GROUP_ID = TRS.ATTRIBUTE_GROUP
1934: TRS.ATTRIBUTE,
1935: TRS.EQUIPMENT_FK_KEY EQUIPMENT_FK_KEY,
1936: TM.UOM ,
1937: TRS.READING_TIME
1938: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM
1939: WHERE EAGV.ATTR_GROUP_TYPE = EAV.ATTR_GROUP_TYPE
1940: AND EAGV.APPLICATION_ID = EAV.APPLICATION_ID
1941: AND EAV.ATTR_GROUP_NAME = EAGV.ATTR_GROUP_NAME
1942: AND EAGV.ATTR_GROUP_ID = TRS.ATTRIBUTE_GROUP