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_EQUIPMENT_SHIFTS_D

Line 878: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS

874: MCM.CONTEXTUALIZE_METHOD = 1 AND
875: STG.MTH_ENTITY IS NOT NULL AND
876: STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) ) BUS
877: GROUP BY
878: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
879: WHERE
880: TAG_DATA.GROUP_ID = BUS_CONTEXT.GROUP_ID (+) And
881: TAG_DATA.EQUIPMENT_FK_KEY = BUS_CONTEXT.EQUIPMENT_FK_KEY (+) And
882: TAG_DATA.PLANT_FK_KEY = PLANTS.PLANT_PK_KEY (+) And

Line 1108: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS

1104: MCM.CONTEXTUALIZE_METHOD = 1 AND
1105: STG.MTH_ENTITY IS NOT NULL AND
1106: STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) ) BUS
1107: GROUP BY
1108: BUS.GROUP_ID, BUS.EQUIPMENT_FK_KEY ) BUS_CONTEXT ,MTH_PLANTS_D PLANTS , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS , MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1109: WHERE
1110: TAG_DATA.GROUP_ID = BUS_CONTEXT.GROUP_ID (+) And
1111: TAG_DATA.EQUIPMENT_FK_KEY = BUS_CONTEXT.EQUIPMENT_FK_KEY (+) And
1112: TAG_DATA.PLANT_FK_KEY = PLANTS.PLANT_PK_KEY (+) And

Line 1232: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,

1228: STG.QUALITY_FLAG,
1229: NVL(STG.PROCESSED_FLAG , 0),
1230: EQUIPMENTS.STATUS
1231: FROM MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,
1232: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,
1233: MTH_CONTEXTUALIZATION_REQ MCR
1234: WHERE MCM.CONTEXTUALIZE_METHOD = 2
1235: AND STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1236: -- AND EQP_SHIFTS.FROM_DATE IS NOT NULL

Line 1343: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,

1339: PROD_SCHD.RECIPE_NUM,
1340: PROD_SCHD.RECIPE_VERSION
1341: FROM
1342: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,
1343: MTH_EQUIPMENTS_D EQUIPMENTS, MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,MTH_HOUR_D HOURS ,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD ,
1344: MTH_CONTEXTUALIZATION_REQ MCR
1345: WHERE MCM.CONTEXTUALIZE_METHOD = 2
1346: AND STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1347: AND EQP_SHIFTS.FROM_DATE IS NOT NULL

Line 1462: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,

1458: STG.USER_MEASURE4,
1459: STG.USER_MEASURE5,
1460: STG.QUALITY_FLAG
1461: FROM
1462: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,
1463: MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1464: WHERE
1465: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1466: AND MCM.CONTEXTUALIZE_METHOD = 3

Line 1542: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,

1538: STG.QUALITY_FLAG,
1539: NVL(STG.PROCESSED_FLAG , 0),
1540: EQUIPMENTS.STATUS
1541: FROM
1542: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM , MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS ,MTH_CONTEXTUALIZATION_REQ CONTEXT_REQ,
1543: MTH_HOUR_D HOURS ,MTH_EQUIPMENTS_D EQUIPMENTS
1544: WHERE
1545: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1546: AND MCM.CONTEXTUALIZE_METHOD = 3

Line 1686: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,

1682:
1683: PROCEDURE MTH_GEN_HDL_EQP_DOWN_EVENT IS
1684: v_previous_tag_reading_data VARCHAR2(255) ;
1685: cursor c_readings is select readings.*,eqp_shifts.shift_workday_fk_key
1686: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,
1687: (select MTH_ENTITY, tag_data, equipment_fk_key, reading_time,
1688: tag_code, lag( tag_data)
1689: over (partition by equipment_fk_key, tag_code
1690: order by reading_time ) prev_status

Line 1995: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,

1991:
1992: PROCEDURE MTH_GEN_HDL_EQP_FAULT_EVENT IS
1993: v_previous_tag_reading_data VARCHAR2(255) ;
1994: cursor c_readings is select readings.*
1995: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,
1996: (select MTH_ENTITY, tag_data, equipment_fk_key, reading_time,
1997: tag_code, lag( tag_data)
1998: over (partition by equipment_fk_key, tag_code
1999: order by reading_time ) prev_tag_data

Line 2041: from MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,

2037:
2038: PROCEDURE MTH_GEN_HDL_SCRAP_EVENT IS
2039: cursor c_readings IS
2040: select readings.*
2041: from MTH_EQUIPMENT_SHIFTS_D EQP_SHIFTS,
2042: MTH_TAG_READINGS_STG READINGS
2043: where
2044: READINGS.MTH_ENTITY = 12 And
2045: READINGS.EQUIPMENT_FK_KEY = EQP_SHIFTS.EQUIPMENT_FK_KEY And

Line 2077: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,

2073: cursor c_readings is SELECT Reading.* FROM (select readings.* ,lag( readings.tag_data)
2074: over (partition by readings.equipment_fk_key, readings.tag_code
2075: order by readings.reading_time ) prev_tag_data
2076:
2077: from MTH_EQUIPMENT_SHIFTS_D eqp_shifts,
2078: MTH_TAG_READINGS_STG readings,
2079: MTH_ENTITIES entities
2080: WHERE
2081: READINGS.MTH_ENTITY = 18 And