APPS.MTH_PROCESS_UDA_PKG dependencies on EGO_ATTRS_V

Line 209: EGO_ATTRS_V EGO,

205: EGO.DATABASE_COLUMN,
206: TAG.ATTRIBUTE_GROUP
207: FROM MTH_TAG_READINGS TAG,
208: MTH_RUN_LOG RUN_LOG,
209: EGO_ATTRS_V EGO,
210: EGO_ATTR_GROUPS_V EGO_ATTR_GRP
211: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'
212: AND TAG.creation_date >= RUN_LOG.from_date
213: AND TAG.creation_date <= Nvl(RUN_LOG.To_Date,SYSDATE)

Line 304: EGO_ATTRS_V EGO,

300: EGO.DATABASE_COLUMN,
301: TAG.GROUP_ID
302: FROM MTH_TAG_READINGS TAG,
303: MTH_RUN_LOG RUN_LOG,
304: EGO_ATTRS_V EGO,
305: EGO_ATTR_GROUPS_V EGO_ATTR_GRP
306: WHERE RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENTS_EXT_B'
307: AND TAG.EQUIPMENT_FK_KEY = NVL(p_equipment_pk_key, TAG.EQUIPMENT_FK_KEY)
308: AND TAG.CREATION_DATE >= RUN_LOG.FROM_DATE

Line 394: EGO_ATTRS_V EGO,

390: TAG.TAG_DATA,
391: EGO.DATABASE_COLUMN,
392: TAG.ATTRIBUTE_GROUP
393: FROM MTH_TAG_READINGS TAG,
394: EGO_ATTRS_V EGO,
395: EGO_ATTR_GROUPS_V EGO_ATTR_GRP,
396: MTH_EQUIPMENTS_D EQUIP
397: WHERE TAG.CREATION_DATE <= p_recal_to_date
398: AND EGO.ATTR_GROUP_TYPE = 'MTH_EQUIPMENTS_GROUP'

Line 527: FROM ego_attrs_v eav,

523: 'MTH_USER_ENTITIES_GROUP',stg_egv.ATTR_NAME,
524: eav.ATTR_NAME),stg_egv.ATTR_NAME) attr_name,
525: stg_egv.attr_value,
526: stg_egv.group_id
527: FROM ego_attrs_v eav,
528: (
529: SELECT stg.*,
530: egv.attr_group_name,
531: egv.attr_group_id,

Line 599: FROM ego_attrs_v eav,

595: stg_egv.attr_value,
596: stg_egv.group_id,
597: eav.database_column,
598: eav.unique_key_flag
599: FROM ego_attrs_v eav,
600: (
601: SELECT stg.*,
602: egv.attr_group_name,
603: egv.attr_group_id,