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_PRODUCTION_SCHEDULES_F

Line 902: )TAG_DATA1,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD,

898: TAG_DATA.EQUIPMENT_FK_KEY = EQUIPMENTS.EQUIPMENT_PK_KEY (+)
899: --AND EQP_SHIFTS.FROM_DATE IS NOT NULL AND
900: -- EQP_SHIFTS.TO_DATE IS NOT NULL AND
901: -- EQP_SHIFTS.FROM_DATE != EQP_SHIFTS.TO_DATE
902: )TAG_DATA1,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD,
903: MTH_PRODUCTION_SEGMENTS_F PROD_SEG, MTH_ITEMS_D ITEMS , MTH_CONTEXTUALIZATION_REQ MCR
904: WHERE
905: TAG_DATA1.WORKORDER_PK = PROD_SCHD.WORKORDER_PK (+) And
906: TAG_DATA1.SEGMENT_PK = PROD_SEG.SEGMENT_PK (+) And

Line 1126: EQP_SHIFTS.FROM_DATE <> EQP_SHIFTS.TO_DATE )TAG_DATA1,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD,

1122: HOURS.TO_TIME (+)) AND
1123: TAG_DATA.EQUIPMENT_FK_KEY = EQUIPMENTS.EQUIPMENT_PK_KEY (+)
1124: AND EQP_SHIFTS.FROM_DATE IS NOT NULL AND
1125: EQP_SHIFTS.TO_DATE IS NOT NULL AND
1126: EQP_SHIFTS.FROM_DATE <> EQP_SHIFTS.TO_DATE )TAG_DATA1,MTH_PRODUCTION_SCHEDULES_F PROD_SCHD,
1127: MTH_PRODUCTION_SEGMENTS_F PROD_SEG, MTH_ITEMS_D ITEMS , MTH_CONTEXTUALIZATION_REQ MCR
1128: WHERE
1129: TAG_DATA1.WORKORDER_PK = PROD_SCHD.WORKORDER_PK (+) And
1130: TAG_DATA1.SEGMENT_PK = PROD_SEG.SEGMENT_PK (+) 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