DBA Data[Home] [Help]

APPS.MTH_LOAD_TAG_READINGS_PKG dependencies on MTH_TAG_DESTINATION_MAP

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(+)