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_WORKDAY_SHIFTS_D

Line 800: FROM mth_workday_shifts_d mds,

796: UPDATE mth_equip_output_stg stg
797: SET stg.err_code = stg.err_code || 'WDS '
798: WHERE stg.shift_workday_fk IS NOT NULL
799: AND NOT EXISTS ( SELECT * FROM ( SELECT mds.shift_workday_pk
800: FROM mth_workday_shifts_d mds,
801: mth_equip_output_stg stg
802: WHERE stg.shift_workday_fk = mds.shift_workday_pk(+)
803: AND stg.shift_workday_fk IS NOT NULL) wds
804: WHERE wds.shift_workday_pk = stg.shift_workday_fk

Line 913: FROM mth_workday_shifts_d mds,

909: -- Validation for ITR
910: UPDATE mth_equip_output_stg stg
911: SET stg.err_code = stg.err_code || 'ITR '
912: WHERE NOT EXISTS ( SELECT * FROM ( SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.to_date
913: FROM mth_workday_shifts_d mds,
914: mth_equip_output_stg stg,
915: mth_equipment_shifts_d mes,
916: mth_equipments_d med
917: WHERE stg.shift_workday_fk = mds.shift_workday_pk

Line 938: mth_workday_shifts_d wds

934: WHERE EXISTS (SELECT * FROM (SELECT meo.reading_time,med.equipment_pk,wds.shift_workday_pk
935: FROM mth_equip_output meo,
936: mth_equip_output_stg stg,
937: mth_equipments_d med,
938: mth_workday_shifts_d wds
939: WHERE med.equipment_pk_key = meo.equipment_fk_key
940: AND wds.shift_workday_pk_key = meo.shift_workday_fk_key
941: AND med.equipment_pk = stg.equipment_fk
942: AND wds.shift_workday_pk = stg.shift_workday_fk

Line 1104: mth_workday_shifts_d wds,

1100: null,
1101: mhd.hour_pk_key
1102: FROM mth_equip_output_stg stg,
1103: mth_equipments_d med,
1104: mth_workday_shifts_d wds,
1105: mth_items_d mid,
1106: mth_production_segments_f msf,
1107: mth_production_schedules_f mps,
1108: mth_systems_setup mss,

Line 1360: FROM mth_workday_shifts_d mds,

1356: UPDATE mth_equip_output_stg stg
1357: SET stg.err_code = stg.err_code || 'WDS '
1358: WHERE stg.shift_workday_fk IS NOT NULL
1359: AND NOT EXISTS ( SELECT * FROM ( SELECT mds.shift_workday_pk
1360: FROM mth_workday_shifts_d mds,
1361: mth_equip_output_stg stg
1362: WHERE stg.shift_workday_fk = mds.shift_workday_pk(+)
1363: AND stg.shift_workday_fk IS NOT NULL) wds
1364: WHERE wds.shift_workday_pk = stg.shift_workday_fk

Line 1473: FROM mth_workday_shifts_d mds,

1469: -- Validation for ITR
1470: UPDATE mth_equip_output_stg stg
1471: SET stg.err_code = stg.err_code || 'ITR '
1472: WHERE NOT EXISTS ( SELECT * FROM ( SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.to_date
1473: FROM mth_workday_shifts_d mds,
1474: mth_equip_output_stg stg,
1475: mth_equipment_shifts_d mes,
1476: mth_equipments_d med
1477: WHERE stg.shift_workday_fk = mds.shift_workday_pk

Line 1498: mth_workday_shifts_d wds

1494: WHERE EXISTS (SELECT * FROM (SELECT meo.reading_time,med.equipment_pk,wds.shift_workday_pk
1495: FROM mth_equip_output meo,
1496: mth_equip_output_stg stg,
1497: mth_equipments_d med,
1498: mth_workday_shifts_d wds
1499: WHERE med.equipment_pk_key = meo.equipment_fk_key
1500: AND wds.shift_workday_pk_key = meo.shift_workday_fk_key
1501: AND med.equipment_pk = stg.equipment_fk
1502: AND wds.shift_workday_pk = stg.shift_workday_fk

Line 1667: mth_workday_shifts_d wds,

1663: null,
1664: mhd.hour_pk_key
1665: FROM mth_equip_output_stg stg,
1666: mth_equipments_d med,
1667: mth_workday_shifts_d wds,
1668: mth_items_d mid,
1669: mth_production_segments_f msf,
1670: mth_production_schedules_f mps,
1671: mth_systems_setup mss,

Line 1976: FROM mth_workday_shifts_d mds,

1972: UPDATE mth_equip_output_stg stg
1973: SET stg.err_code = stg.err_code || 'WDS '
1974: WHERE stg.shift_workday_fk IS NOT NULL
1975: AND NOT EXISTS ( SELECT * FROM ( SELECT mds.shift_workday_pk
1976: FROM mth_workday_shifts_d mds,
1977: mth_equip_output_stg stg
1978: WHERE stg.shift_workday_fk = mds.shift_workday_pk(+)
1979: AND stg.shift_workday_fk IS NOT NULL) wds
1980: WHERE wds.shift_workday_pk = stg.shift_workday_fk);

Line 2080: FROM mth_workday_shifts_d mds,

2076: -- Validation for ITR
2077: UPDATE mth_equip_output_stg stg
2078: SET stg.err_code = stg.err_code || 'ITR '
2079: WHERE NOT EXISTS ( SELECT * FROM ( SELECT mds.shift_workday_pk,med.equipment_pk,mes.from_date,mes.to_date
2080: FROM mth_workday_shifts_d mds,
2081: mth_equip_output_stg stg,
2082: mth_equipment_shifts_d mes,
2083: mth_equipments_d med
2084: WHERE stg.shift_workday_fk = mds.shift_workday_pk

Line 2104: mth_workday_shifts_d wds

2100: WHERE EXISTS (SELECT * FROM (SELECT meo.reading_time,med.equipment_pk,wds.shift_workday_pk
2101: FROM mth_equip_output meo,
2102: mth_equip_output_stg stg,
2103: mth_equipments_d med,
2104: mth_workday_shifts_d wds
2105: WHERE med.equipment_pk_key = meo.equipment_fk_key
2106: AND wds.shift_workday_pk_key = meo.shift_workday_fk_key
2107: AND med.equipment_pk = stg.equipment_fk
2108: AND wds.shift_workday_pk = stg.shift_workday_fk

Line 2226: mth_workday_shifts_d wds,

2222: null,
2223: mhd.hour_pk_key
2224: FROM mth_equip_output_stg stg,
2225: mth_equipments_d med,
2226: mth_workday_shifts_d wds,
2227: mth_items_d mid,
2228: mth_production_segments_f msf,
2229: mth_production_schedules_f mps,
2230: mth_systems_setup mss,

Line 2480: mth_workday_shifts_d msg,

2476: Min(med.level9_level_key) level9_level_key,
2477: Min(mrc.cost) resource_cost
2478: FROM mth_item_cost_mv mic,
2479: mth_resource_cost_mv mrc,
2480: mth_workday_shifts_d msg,
2481: mth_equipment_denorm_d med,
2482: mth_equip_standard_rates_f srf,
2483: mth_equip_output meo
2484: WHERE med.equipment_hierarchy_key = -2

Line 2787: mth_workday_shifts_d msg,

2783: Min(med.level9_level_key) sq_level9_level_key,
2784: Min(mrc.cost) sq_resource_cost
2785: FROM mth_item_cost_mv mic,
2786: mth_resource_cost_mv mrc,
2787: mth_workday_shifts_d msg,
2788: mth_equipment_denorm_d med,
2789: mth_equip_standard_rates_f srf,
2790: mth_equip_output meo
2791: WHERE med.equipment_hierarchy_key = -2

Line 3122: mth_workday_shifts_d msg,

3118: Min(med.level9_level_key) level9_level_key,
3119: Min(mrc.cost) resource_cost
3120: FROM mth_item_cost_mv mic,
3121: mth_resource_cost_mv mrc,
3122: mth_workday_shifts_d msg,
3123: mth_equipment_denorm_d med,
3124: mth_equip_standard_rates_f srf,
3125: mth_equip_output meo
3126: WHERE med.equipment_hierarchy_key = -2