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.

APPS.MTH_LOAD_TAG_READINGS_PKG dependencies on MTH_TAG_MASTER

Line 206: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP

202: FROM
203:
204: MTH_TAG_READINGS_RAW_PROCESSED RP
205: GROUP BY
206: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP
207: WHERE
208: RAW_DATA.TAG_CODE = TM.TAG_CODE
209: AND TM.TAG_CODE = TDM.TAG_CODE (+)
210: AND TDM.EQUIPMENT_FK_KEY = EQP.EQUIPMENT_PK_KEY(+)

Line 301: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP

297: FROM
298: MTH_TAG_READINGS_RAW_PROCESSED RP
299: --WHERE (r.CREATION_DATE >= v_log_from_date and r.CREATION_DATE < v_log_to_date )
300: GROUP BY
301: RP.READING_TIME , RP.TAG_CODE ) RAW_DATA ,MTH_TAG_MASTER TM ,MTH_TAG_DESTINATION_MAP TDM ,MTH_EQUIPMENTS_D EQP
302: WHERE
303: RAW_DATA.TAG_CODE = TM.TAG_CODE
304: AND TM.TAG_CODE = TDM.TAG_CODE (+)
305: AND TDM.EQUIPMENT_FK_KEY = EQP.EQUIPMENT_PK_KEY(+)

Line 1770: JOIN MTH_TAG_MASTER tag_mstr ON ( --(( stg.EQUIPMENT_FK_KEY = tag_mstr.EQUIPMENT_FK_KEY ))

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 ))
1769: AND (( stg.ATTRIBUTE = eattrs.ATTR_ID )) )
1770: JOIN MTH_TAG_MASTER tag_mstr ON ( --(( stg.EQUIPMENT_FK_KEY = tag_mstr.EQUIPMENT_FK_KEY ))
1771: --AND
1772: (( stg.TAG_CODE = tag_mstr.TAG_CODE )) )
1773: WHERE
1774: ( eagrps.APPLICATION_ID = 9001 ) AND

Line 1857: JOIN MTH_TAG_MASTER tag_mstr ON (-- (( stg.EQUIPMENT_FK_KEY = tag_mstr.EQUIPMENT_FK_KEY ))

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 ))
1856: AND (( stg.ATTRIBUTE = eattrs.ATTR_ID )) )
1857: JOIN MTH_TAG_MASTER tag_mstr ON (-- (( stg.EQUIPMENT_FK_KEY = tag_mstr.EQUIPMENT_FK_KEY ))
1858: -- AND
1859: (( stg.TAG_CODE = tag_mstr.TAG_CODE )) )
1860: WHERE
1861: ( eagrps.APPLICATION_ID = 9001 ) AND

Line 1918: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM

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

Line 1938: FROM EGO_ATTR_GROUPS_V EAGV ,EGO_ATTRS_V EAV, MTH_TAG_READINGS_STG TRS , MTH_TAG_MASTER TM

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