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_PROCESS_UDA_PKG dependencies on MTH_EQUIPMENTS_D

Line 365: (SELECT distinct EQUIPMENT_PK_KEY from MTH_EQUIPMENTS_D

361: DELETE FROM MTH_EQUIPMENTS_EXT_B EQEXT
362: WHERE EQEXT.READ_TIME > p_recal_from_date
363: AND EQEXT.READ_TIME <= p_recal_to_date
364: AND NVL(p_equipment_pk_key,EQEXT.EQUIPMENT_PK_KEY) in
365: (SELECT distinct EQUIPMENT_PK_KEY from MTH_EQUIPMENTS_D
366: WHERE PLANT_FK_KEY = p_plant);
367:
368: INSERT INTO MTH_TAG_READINGS_T_STG
369: (EQUIPMENT_FK_KEY,

Line 396: MTH_EQUIPMENTS_D EQUIP

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

Line 560: OR (P_ENTITY='EQUIPMENTS' AND stg_egv.ATTR_NAME='EQUIPMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT EQUIPMENT_PK_KEY FROM MTH_EQUIPMENTS_D))

556: AND NOT (stg_egv.ATTR_NAME IN ('EQUIPMENT','ITEM','OTHER','WORKORDER','SEGMENT','USER_ENTITY','ENTITY_TYPE'))
557: )
558: OR (stg_egv.ATTR_GROUP_ID IS NULL)
559: OR (eav.REQUIRED_FLAG ='Y' AND stg_egv.ATTR_VALUE IS NULL)
560: OR (P_ENTITY='EQUIPMENTS' AND stg_egv.ATTR_NAME='EQUIPMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT EQUIPMENT_PK_KEY FROM MTH_EQUIPMENTS_D))
561: OR (P_ENTITY='ITEMS' AND stg_egv.ATTR_NAME='ITEM' AND stg_egv.ATTR_VALUE NOT IN (SELECT ITEM_PK_KEY FROM MTH_ITEMS_EXT_B))
562: OR (P_ENTITY='OTHERS' AND stg_egv.ATTR_NAME='OTHER' AND stg_egv.ATTR_VALUE NOT IN (SELECT OTHER_PK_KEY FROM MTH_OTHERS_EXT_B))
563: OR (P_ENTITY='PRODUCTION_SCHEDULES' AND stg_egv.ATTR_NAME='WORKORDER' AND stg_egv.ATTR_VALUE NOT IN (SELECT WORKORDER_PK_KEY FROM MTH_PRODUCTION_SCHEDULES_EXT_B))
564: OR (P_ENTITY='PRODUCTION_SEGMENTS' AND stg_egv.ATTR_NAME='SEGMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT SEGMENT_PK_KEY FROM MTH_PRODUCTION_SEGMENTS_EXT_B))

Line 633: OR (P_ENTITY='EQUIPMENTS' AND stg_egv.ATTR_NAME='EQUIPMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT EQUIPMENT_PK_KEY FROM MTH_EQUIPMENTS_D))

629: AND NOT (stg_egv.ATTR_NAME IN ('EQUIPMENT','ITEM','OTHER','WORKORDER','SEGMENT','USER_ENTITY','ENTITY_TYPE'))
630: )
631: OR (stg_egv.ATTR_GROUP_ID IS NULL)
632: OR (eav.REQUIRED_FLAG ='Y' AND stg_egv.ATTR_VALUE IS NULL)
633: OR (P_ENTITY='EQUIPMENTS' AND stg_egv.ATTR_NAME='EQUIPMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT EQUIPMENT_PK_KEY FROM MTH_EQUIPMENTS_D))
634: OR (P_ENTITY='ITEMS' AND stg_egv.ATTR_NAME='ITEM' AND stg_egv.ATTR_VALUE NOT IN (SELECT ITEM_PK_KEY FROM MTH_ITEMS_EXT_B))
635: OR (P_ENTITY='OTHERS' AND stg_egv.ATTR_NAME='OTHER' AND stg_egv.ATTR_VALUE NOT IN (SELECT OTHER_PK_KEY FROM MTH_OTHERS_EXT_B))
636: OR (P_ENTITY='PRODUCTION_SCHEDULES' AND stg_egv.ATTR_NAME='WORKORDER' AND stg_egv.ATTR_VALUE NOT IN (SELECT WORKORDER_PK_KEY FROM MTH_PRODUCTION_SCHEDULES_EXT_B))
637: OR (P_ENTITY='PRODUCTION_SEGMENTS' AND stg_egv.ATTR_NAME='SEGMENT' AND stg_egv.ATTR_VALUE NOT IN (SELECT SEGMENT_PK_KEY FROM MTH_PRODUCTION_SEGMENTS_EXT_B))