APPS.MTH_PROCESS_UDA_PKG dependencies on EGO_ATTR_GROUPS_V

Line 210: EGO_ATTR_GROUPS_V EGO_ATTR_GRP

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)
214: AND TAG.MTH_ENTITY IS NULL

Line 305: EGO_ATTR_GROUPS_V EGO_ATTR_GRP

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
309: AND TAG.CREATION_DATE < RUN_LOG.TO_DATE

Line 395: EGO_ATTR_GROUPS_V EGO_ATTR_GRP,

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'
399: AND EGO_ATTR_GRP.ATTR_GROUP_ID = TAG.ATTRIBUTE_GROUP

Line 533: FROM ego_attr_groups_v egv,

529: SELECT stg.*,
530: egv.attr_group_name,
531: egv.attr_group_id,
532: egv.attr_group_type
533: FROM ego_attr_groups_v egv,
534: mth_ext_attr_i_stg stg
535: WHERE egv.APPLICATION_ID(+) = 9001
536: AND egv.ATTR_GROUP_TYPE(+) = Decode(P_ENTITY,
537: 'EQUIPMENTS','MTH_EQUIPMENTS_GROUP',

Line 605: FROM ego_attr_groups_v egv,

601: SELECT stg.*,
602: egv.attr_group_name,
603: egv.attr_group_id,
604: egv.attr_group_type
605: FROM ego_attr_groups_v egv,
606: mth_ext_attr_i_stg stg
607: WHERE egv.APPLICATION_ID(+) = 9001
608: AND egv.ATTR_GROUP_TYPE(+) = Decode(P_ENTITY,
609: 'EQUIPMENTS','MTH_EQUIPMENTS_GROUP',

Line 669: ego_attr_groups_v egv,

665: stg.ATTR_NAME,
666: stg.ATTR_VALUE,
667: stg.attr_group_id
668: FROM
669: ego_attr_groups_v egv,
670: MTH_EXT_ATTR_ERR err,
671: MTH_EXT_ATTR_T_STG stg
672: WHERE
673: ( stg.ATTR_GROUP_ID = egv.ATTR_GROUP_ID) AND

Line 692: ego_attr_groups_v egv,

688: err.ATTR_NAME,
689: err.ATTR_VALUE,
690: err.GROUP_ID
691: FROM
692: ego_attr_groups_v egv,
693: MTH_EXT_ATTR_ERR err
694: WHERE
695: (egv.APPLICATION_ID = 9001 ) AND
696: (egv.ATTR_GROUP_TYPE = Decode(P_ENTITY,'EQUIPMENTS','MTH_EQUIPMENTS_GROUP','ITEMS','MTH_ITEMS_GROUP','OTHERS','MTH_OTHERS_GROUP',