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 STANDARD

Line 2449: STANDARD_RATE_1,

2445: LAST_UPDATED_BY,
2446: RECIPE_NUM,
2447: RECIPE_VERSION,
2448: SEGMENT_FK_KEY,
2449: STANDARD_RATE_1,
2450: ITEM_COST,
2451: RESOURCE_FK_KEY,
2452: RESOURCE_COST )
2453: ( SELECT meo.equipment_fk_key,

Line 2474: Min(srf.standard_rate_1) standard_rate_1,

2470: v_ua_val,
2471: Nvl(meo.recipe_num,v_ua_val) recipe_num,
2472: Nvl(meo.recipe_version,v_ua_val) recipe_version,
2473: meo.segment_fk_key segment_fk_key,
2474: Min(srf.standard_rate_1) standard_rate_1,
2475: Min(mic.cost) item_cost,
2476: Min(med.level9_level_key) level9_level_key,
2477: Min(mrc.cost) resource_cost
2478: FROM mth_item_cost_mv mic,

Line 2482: mth_equip_standard_rates_f srf,

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
2485: AND med.equipment_fk_key is not null
2486: AND msg.from_date between med.equipment_effective_date

Line 2525: end / meos.standard_rate_1) required_time,

2521: nvl(meos.qty_rework,0) + nvl(meos.qty_scrap,0)
2522: else meos.qty_rejected
2523: end
2524: else meos.qty_output
2525: end / meos.standard_rate_1) required_time,
2526: count(*) wo_item_count,
2527: meos.hour_fk_key,
2528: v_log_date last_update_date,
2529: v_ua_val last_update_system_id,

Line 2533: WHERE meos.standard_rate_1 is NOT NULL

2529: v_ua_val last_update_system_id,
2530: v_ua_val last_update_login,
2531: v_ua_val last_updated_by
2532: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
2533: WHERE meos.standard_rate_1 is NOT NULL
2534: AND meos.standard_rate_1 <> 0
2535: GROUP BY meos.equipment_fk_key,
2536: meos.shift_workday_fk_key,
2537: meos.hour_fk_key) statrec

Line 2534: AND meos.standard_rate_1 <> 0

2530: v_ua_val last_update_login,
2531: v_ua_val last_updated_by
2532: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
2533: WHERE meos.standard_rate_1 is NOT NULL
2534: AND meos.standard_rate_1 <> 0
2535: GROUP BY meos.equipment_fk_key,
2536: meos.shift_workday_fk_key,
2537: meos.hour_fk_key) statrec
2538: WHERE mes.EQUIPMENT_FK_KEY = statrec.EQUIPMENT_FK_KEY AND

Line 2551: end / meos.standard_rate_1) required_time,

2547: nvl(meos.qty_rework,0) + nvl(meos.qty_scrap,0)
2548: else meos.qty_rejected
2549: end
2550: else meos.qty_output
2551: end / meos.standard_rate_1) required_time,
2552: count(*) wo_item_count,
2553: meos.hour_fk_key,
2554: v_log_date last_update_date,
2555: v_ua_val last_update_system_id,

Line 2559: WHERE meos.standard_rate_1 is NOT NULL

2555: v_ua_val last_update_system_id,
2556: v_ua_val last_update_login,
2557: v_ua_val last_updated_by
2558: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
2559: WHERE meos.standard_rate_1 is NOT NULL
2560: AND meos.standard_rate_1 <> 0
2561: GROUP BY meos.equipment_fk_key,
2562: meos.shift_workday_fk_key,
2563: meos.hour_fk_key) meos

Line 2560: AND meos.standard_rate_1 <> 0

2556: v_ua_val last_update_login,
2557: v_ua_val last_updated_by
2558: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
2559: WHERE meos.standard_rate_1 is NOT NULL
2560: AND meos.standard_rate_1 <> 0
2561: GROUP BY meos.equipment_fk_key,
2562: meos.shift_workday_fk_key,
2563: meos.hour_fk_key) meos
2564: WHERE mes.EQUIPMENT_FK_KEY = meos.EQUIPMENT_FK_KEY

Line 2631: Sum((case when srf.standard_rate_1 is not null then

2627: v_ua_val last_update_system_id,
2628: null,
2629: v_ua_val last_update_login,
2630: v_ua_val last_updated_by,
2631: Sum((case when srf.standard_rate_1 is not null then
2632: case when nvl(aggr.qty_output,0) = 0 then
2633: nvl(aggr.qty_completed,0) +
2634: case when nvl((aggr.qty_rejected),0) = 0 then
2635: nvl(aggr.qty_rework,0) + nvl(aggr.qty_scrap,0)

Line 2639: end / srf.standard_rate_1

2635: nvl(aggr.qty_rework,0) + nvl(aggr.qty_scrap,0)
2636: else aggr.qty_rejected
2637: end
2638: else aggr.qty_output
2639: end / srf.standard_rate_1
2640: end) ) required_time,
2641: Sum((CASE WHEN eos.equipment_fk_key IS NULL THEN 1 ELSE 0 END)) wo_item_count,
2642: null,
2643: null

Line 2645: mth_equip_standard_rates_f srf,

2641: Sum((CASE WHEN eos.equipment_fk_key IS NULL THEN 1 ELSE 0 END)) wo_item_count,
2642: null,
2643: null
2644: FROM mth_equip_output_summary eos,
2645: mth_equip_standard_rates_f srf,
2646: (SELECT meo.equipment_fk_key,
2647: meo.item_fk_key,
2648: Nvl(meo.workorder_fk_key,v_ua_val) workorder_fk_key,
2649: Sum(meo.qty_completed) qty_completed,

Line 2680: AND srf.standard_rate_1 IS NOT NULL

2676: AND aggr.hour_fk_key = eos.hour_fk_key(+)
2677: AND aggr.equipment_fk_key = srf.equipment_fk_key(+)
2678: AND aggr.item_fk_key = srf.item_fk_key(+)
2679: AND aggr.shift_workday_fk_key = srf.shift_workday_fk_key(+)
2680: AND srf.standard_rate_1 IS NOT NULL
2681: AND srf.standard_rate_1 <> 0
2682: GROUP BY aggr.equipment_fk_key,
2683: aggr.shift_workday_fk_key,
2684: aggr.hour_fk_key) statrec

Line 2681: AND srf.standard_rate_1 <> 0

2677: AND aggr.equipment_fk_key = srf.equipment_fk_key(+)
2678: AND aggr.item_fk_key = srf.item_fk_key(+)
2679: AND aggr.shift_workday_fk_key = srf.shift_workday_fk_key(+)
2680: AND srf.standard_rate_1 IS NOT NULL
2681: AND srf.standard_rate_1 <> 0
2682: GROUP BY aggr.equipment_fk_key,
2683: aggr.shift_workday_fk_key,
2684: aggr.hour_fk_key) statrec
2685: WHERE mes.equipment_fk_key = statrec.equipment_fk_key

Line 2699: Sum((case when srf.standard_rate_1 is not null then

2695: v_ua_val last_update_system_id,
2696: null,
2697: v_ua_val last_update_login,
2698: v_ua_val last_updated_by,
2699: Sum((case when srf.standard_rate_1 is not null then
2700: case when nvl(aggr.qty_output,0) = 0 then
2701: nvl(aggr.qty_completed,0) +
2702: case when nvl((aggr.qty_rejected),0) = 0 then
2703: nvl(aggr.qty_rework,0) + nvl(aggr.qty_scrap,0)

Line 2707: end / srf.standard_rate_1

2703: nvl(aggr.qty_rework,0) + nvl(aggr.qty_scrap,0)
2704: else aggr.qty_rejected
2705: end
2706: else aggr.qty_output
2707: end / srf.standard_rate_1
2708: end) ) required_time,
2709: Sum((case when eos.equipment_fk_key is null then 1 else 0 end)) wo_item_count,
2710: null,
2711: null

Line 2713: mth_equip_standard_rates_f srf,

2709: Sum((case when eos.equipment_fk_key is null then 1 else 0 end)) wo_item_count,
2710: null,
2711: null
2712: FROM mth_equip_output_summary eos,
2713: mth_equip_standard_rates_f srf,
2714: (SELECT meo.equipment_fk_key,
2715: meo.item_fk_key,
2716: Nvl(meo.workorder_fk_key,v_ua_val) workorder_fk_key,
2717: Sum(meo.qty_completed) qty_completed,

Line 2748: AND srf.standard_rate_1 IS NOT NULL

2744: AND aggr.hour_fk_key = eos.hour_fk_key(+)
2745: AND aggr.equipment_fk_key = srf.equipment_fk_key(+)
2746: AND aggr.item_fk_key = srf.item_fk_key(+)
2747: AND aggr.shift_workday_fk_key = srf.shift_workday_fk_key(+)
2748: AND srf.standard_rate_1 IS NOT NULL
2749: AND srf.standard_rate_1 <> 0
2750: GROUP BY aggr.equipment_fk_key,
2751: aggr.shift_workday_fk_key,
2752: aggr.hour_fk_key) meos

Line 2749: AND srf.standard_rate_1 <> 0

2745: AND aggr.equipment_fk_key = srf.equipment_fk_key(+)
2746: AND aggr.item_fk_key = srf.item_fk_key(+)
2747: AND aggr.shift_workday_fk_key = srf.shift_workday_fk_key(+)
2748: AND srf.standard_rate_1 IS NOT NULL
2749: AND srf.standard_rate_1 <> 0
2750: GROUP BY aggr.equipment_fk_key,
2751: aggr.shift_workday_fk_key,
2752: aggr.hour_fk_key) meos
2753: WHERE mes.EQUIPMENT_FK_KEY = meos.EQUIPMENT_FK_KEY

Line 2781: Min(srf.standard_rate_1) sq_standard_rate_1,

2777: v_log_date sq_log_date,
2778: Nvl(meo.recipe_num,v_ua_val) sq_recipe_num,
2779: Nvl(meo.recipe_version,v_ua_val) sq_recipe_version,
2780: meo.segment_fk_key segment,
2781: Min(srf.standard_rate_1) sq_standard_rate_1,
2782: Min(mic.cost) sq_item_cost,
2783: Min(med.level9_level_key) sq_level9_level_key,
2784: Min(mrc.cost) sq_resource_cost
2785: FROM mth_item_cost_mv mic,

Line 2789: mth_equip_standard_rates_f srf,

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
2792: AND med.equipment_fk_key is not null
2793: AND msg.from_date between med.equipment_effective_date

Line 2839: standard_rate_1 = subquery.sq_standard_rate_1,

2835: last_update_date = subquery.sq_log_date,
2836: last_update_system_id = subquery.sq_system_fk_key,
2837: last_update_login = subquery.sq_system_fk_key,
2838: last_updated_by = subquery.sq_system_fk_key,
2839: standard_rate_1 = subquery.sq_standard_rate_1,
2840: item_cost = subquery.sq_item_cost,
2841: resource_fk_key = subquery.sq_level9_level_key,
2842: resource_cost = subquery.sq_resource_cost
2843:

Line 2867: mth_equip_output_summary.standard_rate_1,

2863: mth_equip_output_summary.last_updated_by,
2864: mth_equip_output_summary.recipe_num,
2865: mth_equip_output_summary.recipe_version,
2866: mth_equip_output_summary.segment_fk_key,
2867: mth_equip_output_summary.standard_rate_1,
2868: mth_equip_output_summary.item_cost,
2869: mth_equip_output_summary.resource_fk_key,
2870: mth_equip_output_summary.resource_cost)
2871: VALUES

Line 2893: subquery.sq_standard_rate_1,

2889: subquery.sq_system_fk_key,
2890: subquery.sq_recipe_num,
2891: subquery.sq_recipe_version,
2892: subquery.segment,
2893: subquery.sq_standard_rate_1,
2894: subquery.sq_item_cost,
2895: subquery.sq_level9_level_key,
2896: subquery.sq_resource_cost);
2897:

Line 3091: STANDARD_RATE_1,

3087: LAST_UPDATED_BY,
3088: RECIPE_NUM,
3089: RECIPE_VERSION,
3090: SEGMENT_FK_KEY,
3091: STANDARD_RATE_1,
3092: ITEM_COST,
3093: RESOURCE_FK_KEY,
3094: RESOURCE_COST )
3095: ( SELECT meo.equipment_fk_key,

Line 3116: Min(srf.standard_rate_1) standard_rate_1,

3112: v_ua_val,
3113: Nvl(meo.recipe_num,v_ua_val) recipe_num,
3114: Nvl(meo.recipe_version,v_ua_val) recipe_version,
3115: meo.segment_fk_key segment_fk_key,
3116: Min(srf.standard_rate_1) standard_rate_1,
3117: Min(mic.cost) item_cost,
3118: Min(med.level9_level_key) level9_level_key,
3119: Min(mrc.cost) resource_cost
3120: FROM mth_item_cost_mv mic,

Line 3124: mth_equip_standard_rates_f srf,

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
3127: AND med.equipment_fk_key is not null
3128: AND msg.from_date between med.equipment_effective_date

Line 3174: end / meos.standard_rate_1) required_time,

3170: nvl(meos.qty_rework,0) + nvl(meos.qty_scrap,0)
3171: else meos.qty_rejected
3172: end
3173: else meos.qty_output
3174: end / meos.standard_rate_1) required_time,
3175: count(*) wo_item_count,
3176: meos.hour_fk_key ,
3177: v_log_date last_update_date,
3178: v_ua_val last_update_system_id,

Line 3182: WHERE meos.standard_rate_1 is NOT NULL

3178: v_ua_val last_update_system_id,
3179: v_ua_val last_update_login,
3180: v_ua_val last_updated_by
3181: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
3182: WHERE meos.standard_rate_1 is NOT NULL
3183: AND meos.standard_rate_1 <> 0
3184: AND meos.hour_fk_key IN (SELECT hour_pk_key
3185: FROM mth_hour_d
3186: WHERE from_time >= p_n_recalc_from_date

Line 3183: AND meos.standard_rate_1 <> 0

3179: v_ua_val last_update_login,
3180: v_ua_val last_updated_by
3181: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
3182: WHERE meos.standard_rate_1 is NOT NULL
3183: AND meos.standard_rate_1 <> 0
3184: AND meos.hour_fk_key IN (SELECT hour_pk_key
3185: FROM mth_hour_d
3186: WHERE from_time >= p_n_recalc_from_date
3187: AND to_time <= p_n_recalc_to_date)

Line 3208: end / meos.standard_rate_1) required_time,

3204: nvl(meos.qty_rework,0) + nvl(meos.qty_scrap,0)
3205: else meos.qty_rejected
3206: end
3207: else meos.qty_output
3208: end / meos.standard_rate_1) required_time,
3209: count(*) wo_item_count,
3210: meos.hour_fk_key ,
3211: v_log_date last_update_date,
3212: v_ua_val last_update_system_id,

Line 3216: WHERE meos.standard_rate_1 is NOT NULL

3212: v_ua_val last_update_system_id,
3213: v_ua_val last_update_login,
3214: v_ua_val last_updated_by
3215: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
3216: WHERE meos.standard_rate_1 is NOT NULL
3217: AND meos.standard_rate_1 <> 0
3218: AND meos.hour_fk_key IN (SELECT hour_pk_key
3219: FROM mth_hour_d
3220: WHERE from_time >= p_n_recalc_from_date

Line 3217: AND meos.standard_rate_1 <> 0

3213: v_ua_val last_update_login,
3214: v_ua_val last_updated_by
3215: FROM MTH_EQUIP_OUTPUT_SUMMARY meos
3216: WHERE meos.standard_rate_1 is NOT NULL
3217: AND meos.standard_rate_1 <> 0
3218: AND meos.hour_fk_key IN (SELECT hour_pk_key
3219: FROM mth_hour_d
3220: WHERE from_time >= p_n_recalc_from_date
3221: AND to_time <= p_n_recalc_to_date)