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_CONTEXTUALIZATION_METHOD

Line 417: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR

413: TRE.QUALITY_FLAG,
414: TRE.RECIPE_NUM,
415: TRE.RECIPE_VERSION
416: FROM
417: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR
418: WHERE
419: TRE.RE_PROCESS_FLAG = 'Y' And
420: TRE.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) And
421: TRE.EQUIPMENT_FK_KEY = MCR.EQUIPMENT_FK_KEY (+)

Line 486: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR

482: TRE.QUALITY_FLAG,
483: TRE.PROCESSED_FLAG,
484: SYSDATE - 0.0001
485: FROM
486: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR
487: WHERE
488: TRE.RE_PROCESS_FLAG = 'Y'
489: AND TRE.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
490: AND TRE.EQUIPMENT_FK_KEY = MCR.EQUIPMENT_FK_KEY (+)

Line 579: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR

575: TRE.RECIPE_VERSION,
576: TRE.RECIPE_NUM,
577: TRE.EQUIPMENT_STATUS
578: FROM
579: MTH_TAG_READINGS_ERR TRE, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_CONTEXTUALIZATION_REQ MCR
580: WHERE
581: TRE.RE_PROCESS_FLAG = 'Y' And
582: TRE.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) And
583: TRE.EQUIPMENT_FK_KEY = MCR.EQUIPMENT_FK_KEY (+) AND

Line 678: MTH_TAG_READINGS_STG STG , MTH_CONTEXTUALIZATION_METHOD CM

674: STG.USER_MEASURE5,
675: STG.QUALITY_FLAG,
676: NVL( STG.PROCESSED_FLAG , 0)
677: FROM
678: MTH_TAG_READINGS_STG STG , MTH_CONTEXTUALIZATION_METHOD CM
679: WHERE
680: STG.EQUIPMENT_FK_KEY = CM.EQUIPMENT_FK_KEY (+)
681: AND CM.CONTEXTUALIZE_METHOD NOT IN ( 1 , 2 , 3 )
682: )

Line 841: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM

837: STG.USER_MEASURE4,
838: STG.USER_MEASURE5,
839: STG.QUALITY_FLAG
840: FROM
841: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM
842: WHERE
843: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
844: AND MCM.CONTEXTUALIZE_METHOD = 1 AND
845: ( STG.MTH_ENTITY IS NULL Or STG.MTH_ENTITY IS NOT NULL And NOT STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) )

Line 871: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM

867: STG.ATTRIBUTE_GROUP,
868: STG.ATTRIBUTE,
869: STG.EQUIPMENT_FK_KEY
870: FROM
871: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM
872: WHERE
873: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) AND
874: MCM.CONTEXTUALIZE_METHOD = 1 AND
875: STG.MTH_ENTITY IS NOT NULL AND

Line 1071: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM

1067: STG.USER_MEASURE4,
1068: STG.USER_MEASURE5,
1069: STG.QUALITY_FLAG
1070: FROM
1071: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM
1072: WHERE
1073: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+)
1074: AND MCM.CONTEXTUALIZE_METHOD = 1 AND
1075: ( STG.MTH_ENTITY IS NULL Or STG.MTH_ENTITY IS NOT NULL And NOT STG.MTH_ENTITY IN ( 2 , 3 , 4 , 14 , 15 ) )

Line 1101: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM

1097: STG.ATTRIBUTE_GROUP,
1098: STG.ATTRIBUTE,
1099: STG.EQUIPMENT_FK_KEY
1100: FROM
1101: MTH_TAG_READINGS_STG STG ,MTH_CONTEXTUALIZATION_METHOD MCM
1102: WHERE
1103: STG.EQUIPMENT_FK_KEY = MCM.EQUIPMENT_FK_KEY (+) AND
1104: MCM.CONTEXTUALIZE_METHOD = 1 AND
1105: STG.MTH_ENTITY IS NOT NULL AND

Line 1231: FROM MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,

1227: STG.USER_MEASURE5,
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 (+)

Line 1342: MTH_TAG_READINGS_STG STG, MTH_CONTEXTUALIZATION_METHOD MCM ,MTH_EQUIP_PROD_SCHEDULE_F EQUIP_PROD_SCHEDULE,

1338: STG.QUALITY_FLAG,
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 (+)

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