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.EAM_FAILURE_ANALYSIS_PVT dependencies on EAM_METER_READINGS

Line 358: FROM EAM_METER_READINGS_V EMR1

354: FROM
355: (
356: SELECT
357: Max(EMR1.METER_READING_ID) METER_READING_ID
358: FROM EAM_METER_READINGS_V EMR1
359: GROUP BY EMR1.WIP_ENTITY_ID,
360: EMR1.METER_ID
361: )
362: )) METER

Line 709: FROM EAM_METER_READINGS_V EMR1

705: FROM
706: (
707: SELECT
708: Max(EMR1.METER_READING_ID) METER_READING_ID
709: FROM EAM_METER_READINGS_V EMR1
710: GROUP BY EMR1.WIP_ENTITY_ID,
711: EMR1.METER_ID
712: )
713: )) METER

Line 1155: FROM EAM_METER_READINGS_V EMR1

1151: FROM
1152: (
1153: SELECT
1154: Max(EMR1.METER_READING_ID) METER_READING_ID
1155: FROM EAM_METER_READINGS_V EMR1
1156: GROUP BY EMR1.WIP_ENTITY_ID,
1157: EMR1.METER_ID
1158: )
1159: )) METER

Line 1298: FROM EAM_METER_READINGS_V EMR1

1294: FROM
1295: (
1296: SELECT
1297: Max(EMR1.METER_READING_ID) METER_READING_ID
1298: FROM EAM_METER_READINGS_V EMR1
1299: GROUP BY EMR1.WIP_ENTITY_ID,
1300: EMR1.METER_ID
1301: )
1302: )) METER

Line 2367: FROM EAM_METER_READINGS_V EMR1

2363: FROM
2364: (
2365: SELECT
2366: Max(EMR1.METER_READING_ID) METER_READING_ID
2367: FROM EAM_METER_READINGS_V EMR1
2368: GROUP BY EMR1.WIP_ENTITY_ID,
2369: EMR1.METER_ID
2370: )
2371: )) METER

Line 2467: EAM_METER_READINGS EMR

2463: EMR.WIP_ENTITY_ID,
2464: EM.METER_TYPE
2465: FROM EAM_METERS EM,
2466: EAM_ASSET_METERS EAM,
2467: EAM_METER_READINGS EMR
2468: WHERE EM.METER_ID = EAM.METER_ID
2469: AND EMR.METER_ID = EAM.METER_ID
2470: AND EM.REQUIRED_FLAG = 'Y'
2471: --AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 2477: FROM EAM_METER_READINGS EMR1

2473: -- (l_selected_meter IS NOT NULL AND EM.METER_ID = l_selected_meter))
2474: AND EMR.METER_READING_ID IN
2475: (SELECT METER_READING_ID FROM
2476: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2477: FROM EAM_METER_READINGS EMR1
2478: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2479: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2480: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2481: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID

Line 2561: EAM_METER_READINGS EMR

2557: EM.METER_TYPE
2558:
2559: FROM EAM_METERS EM,
2560: EAM_ASSET_METERS EAM,
2561: EAM_METER_READINGS EMR
2562:
2563: WHERE EM.METER_ID = EAM.METER_ID
2564: AND EMR.METER_ID = EAM.METER_ID
2565: AND EM.REQUIRED_FLAG = 'Y'

Line 2572: FROM EAM_METER_READINGS EMR1

2568: -- (l_selected_meter IS NOT NULL AND EM.METER_ID = l_selected_meter))
2569: AND EMR.METER_READING_ID IN
2570: (SELECT METER_READING_ID FROM
2571: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2572: FROM EAM_METER_READINGS EMR1
2573: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2574: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2575: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2576: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID

Line 2683: EAM_METER_READINGS EMR

2679: EMR.WIP_ENTITY_ID,
2680: EM.METER_TYPE
2681: FROM EAM_METERS EM,
2682: EAM_ASSET_METERS EAM,
2683: EAM_METER_READINGS EMR
2684: WHERE EM.METER_ID = EAM.METER_ID
2685: AND EMR.METER_ID = EAM.METER_ID
2686: AND EM.REQUIRED_FLAG = 'Y'
2687: AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 2691: FROM EAM_METER_READINGS EMR1

2687: AND EAM.PRIMARY_FAILURE_METER = 'Y'
2688: AND EMR.METER_READING_ID IN
2689: (SELECT METER_READING_ID FROM
2690: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2691: FROM EAM_METER_READINGS EMR1
2692: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2693: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2694: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2695: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID

Line 2810: FROM EAM_METER_READINGS_V EMR1

2806: FROM
2807: (
2808: SELECT
2809: Max(EMR1.METER_READING_ID) METER_READING_ID
2810: FROM EAM_METER_READINGS_V EMR1
2811: GROUP BY EMR1.WIP_ENTITY_ID,
2812: EMR1.METER_ID
2813: )
2814: )) METER

Line 2921: EAM_METER_READINGS EMR

2917: EMR.WIP_ENTITY_ID,
2918: EM.METER_TYPE
2919: FROM EAM_METERS EM,
2920: EAM_ASSET_METERS EAM,
2921: EAM_METER_READINGS EMR
2922: WHERE EM.METER_ID = EAM.METER_ID
2923: AND EMR.METER_ID = EAM.METER_ID
2924: AND EM.REQUIRED_FLAG = 'Y'
2925: AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 2929: FROM EAM_METER_READINGS EMR1

2925: AND EAM.PRIMARY_FAILURE_METER = 'Y'
2926: AND EMR.METER_READING_ID IN
2927: (SELECT METER_READING_ID FROM
2928: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2929: FROM EAM_METER_READINGS EMR1
2930: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2931: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2932: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2933: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID

Line 3043: EAM_METER_READINGS EMR

3039: EMR.WIP_ENTITY_ID,
3040: EM.METER_TYPE
3041: FROM EAM_METERS EM,
3042: EAM_ASSET_METERS EAM,
3043: EAM_METER_READINGS EMR
3044: WHERE EM.METER_ID = EAM.METER_ID
3045: AND EMR.METER_ID = EAM.METER_ID
3046: AND EM.REQUIRED_FLAG = 'Y'
3047: AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 3051: FROM EAM_METER_READINGS EMR1

3047: AND EAM.PRIMARY_FAILURE_METER = 'Y'
3048: AND EMR.METER_READING_ID IN
3049: (SELECT METER_READING_ID FROM
3050: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
3051: FROM EAM_METER_READINGS EMR1
3052: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
3053: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3054: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
3055: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID

Line 3828: FROM EAM_METER_READINGS_V EMR1

3824: FROM
3825: (
3826: SELECT
3827: Max(EMR1.METER_READING_ID) METER_READING_ID
3828: FROM EAM_METER_READINGS_V EMR1
3829: GROUP BY EMR1.WIP_ENTITY_ID,
3830: EMR1.METER_ID
3831: )
3832: )) METER