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_OUTPUT_PKG dependencies on MTH_ENTITIES

Line 55: mth_entities mte,

51: IF( (p_mode = 'RECAL') AND (p_source = 'TAG') ) THEN
52: SELECT Count(1)
53: INTO v_tag_reading_count
54: FROM mth_tag_readings mtr,
55: mth_entities mte,
56: mth_run_log mrl
57: WHERE mtr.mth_entity = mte.id
58: AND mte.mth_alias IN ('Scrap Quantity',
59: 'Rejected Quantity',

Line 270: MTH_ENTITIES b

266: a.RECIPE_NUM,
267: a.RECIPE_VERSION,
268: a.SEGMENT_FK_KEY
269: FROM MTH_TAG_READINGS a,
270: MTH_ENTITIES b
271: WHERE a.MTH_ENTITY = b.ID
272: AND a.EQUIPMENT_FK_KEY IS NOT NULL
273: AND a.WORKORDER_FK_KEY IS NOT NULL
274: AND a.SEGMENT_FK_KEY IS NOT NULL

Line 297: from mth_entities m

293: set PROCESSED_FLAG = 1,
294: last_update_date=sysdate
295: where exists (
296: select 1
297: from mth_entities m
298: where t.MTH_ENTITY = m.ID
299: AND t.PROCESSED_FLAG = 0
300: AND t.EQUIPMENT_FK_KEY IS NOT NULL
301: AND t.WORKORDER_FK_KEY IS NOT NULL

Line 371: MTH_ENTITIES b

367: a.RECIPE_NUM,
368: a.RECIPE_VERSION,
369: a.SEGMENT_FK_KEY
370: FROM MTH_TAG_READINGS a,
371: MTH_ENTITIES b
372: WHERE a.MTH_ENTITY = b.ID
373: AND a.EQUIPMENT_FK_KEY IS NOT NULL
374: AND a.WORKORDER_FK_KEY IS NOT NULL
375: AND a.SEGMENT_FK_KEY IS NOT NULL

Line 465: from mth_entities m

461: set PROCESSED_FLAG = 1,
462: last_update_date=sysdate
463: where exists (
464: select 1
465: from mth_entities m
466: where t.MTH_ENTITY = m.ID
467: AND t.PROCESSED_FLAG = 0
468: AND t.EQUIPMENT_FK_KEY IS NOT NULL
469: AND t.WORKORDER_FK_KEY IS NOT NULL

Line 568: MTH_ENTITIES b

564: a.RECIPE_NUM,
565: a.RECIPE_VERSION,
566: a.SEGMENT_FK_KEY
567: FROM MTH_TAG_READINGS a,
568: MTH_ENTITIES b
569: WHERE a.MTH_ENTITY = b.ID
570: AND a.EQUIPMENT_FK_KEY IS NOT NULL
571: AND a.WORKORDER_FK_KEY IS NOT NULL
572: AND a.SEGMENT_FK_KEY IS NOT NULL

Line 596: from mth_entities m

592: set PROCESSED_FLAG = 1,
593: last_update_date=sysdate
594: where exists (
595: select 1
596: from mth_entities m
597: where t.MTH_ENTITY = m.ID
598: AND t.PROCESSED_FLAG = 0
599: AND t.EQUIPMENT_FK_KEY IS NOT NULL
600: AND t.WORKORDER_FK_KEY IS NOT NULL