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 365: FROM EAM_METER_READINGS_V EMR1

361: FROM
362: (
363: SELECT
364: Max(EMR1.METER_READING_ID) METER_READING_ID
365: FROM EAM_METER_READINGS_V EMR1
366: GROUP BY EMR1.WIP_ENTITY_ID,
367: EMR1.METER_ID
368: )
369: )) METER

Line 717: FROM EAM_METER_READINGS_V EMR1

713: FROM
714: (
715: SELECT
716: Max(EMR1.METER_READING_ID) METER_READING_ID
717: FROM EAM_METER_READINGS_V EMR1
718: GROUP BY EMR1.WIP_ENTITY_ID,
719: EMR1.METER_ID
720: )
721: )) METER

Line 1165: FROM EAM_METER_READINGS_V EMR1

1161: FROM
1162: (
1163: SELECT
1164: Max(EMR1.METER_READING_ID) METER_READING_ID
1165: FROM EAM_METER_READINGS_V EMR1
1166: GROUP BY EMR1.WIP_ENTITY_ID,
1167: EMR1.METER_ID
1168: )
1169: )) METER

Line 1310: FROM EAM_METER_READINGS_V EMR1

1306: FROM
1307: (
1308: SELECT
1309: Max(EMR1.METER_READING_ID) METER_READING_ID
1310: FROM EAM_METER_READINGS_V EMR1
1311: GROUP BY EMR1.WIP_ENTITY_ID,
1312: EMR1.METER_ID
1313: )
1314: )) METER

Line 2571: FROM EAM_METER_READINGS_V EMR1

2567: FROM
2568: (
2569: SELECT
2570: Max(EMR1.METER_READING_ID) METER_READING_ID
2571: FROM EAM_METER_READINGS_V EMR1
2572: GROUP BY EMR1.WIP_ENTITY_ID,
2573: EMR1.METER_ID
2574: )
2575: )) METER

Line 2671: EAM_METER_READINGS EMR

2667: EMR.WIP_ENTITY_ID,
2668: EM.METER_TYPE
2669: FROM EAM_METERS EM,
2670: EAM_ASSET_METERS EAM,
2671: EAM_METER_READINGS EMR
2672: WHERE EM.METER_ID = EAM.METER_ID
2673: AND EMR.METER_ID = EAM.METER_ID
2674: AND EM.REQUIRED_FLAG = 'Y'
2675: --AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 2681: FROM EAM_METER_READINGS EMR1

2677: -- (l_selected_meter IS NOT NULL AND EM.METER_ID = l_selected_meter))
2678: AND EMR.METER_READING_ID IN
2679: (SELECT METER_READING_ID FROM
2680: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2681: FROM EAM_METER_READINGS EMR1
2682: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2683: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2684: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2685: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID

Line 2783: FROM EAM_METER_READINGS_V EMR1

2779: FROM
2780: (
2781: SELECT
2782: Max(EMR1.METER_READING_ID) METER_READING_ID
2783: FROM EAM_METER_READINGS_V EMR1
2784: GROUP BY EMR1.WIP_ENTITY_ID,
2785: EMR1.METER_ID
2786: )
2787: )) METER

Line 2883: EAM_METER_READINGS EMR

2879: EMR.WIP_ENTITY_ID,
2880: EM.METER_TYPE
2881: FROM EAM_METERS EM,
2882: EAM_ASSET_METERS EAM,
2883: EAM_METER_READINGS EMR
2884: WHERE EM.METER_ID = EAM.METER_ID
2885: AND EMR.METER_ID = EAM.METER_ID
2886: AND EM.REQUIRED_FLAG = 'Y'
2887: --AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 2893: FROM EAM_METER_READINGS EMR1

2889: -- (l_selected_meter IS NOT NULL AND EM.METER_ID = l_selected_meter))
2890: AND EMR.METER_READING_ID IN
2891: (SELECT METER_READING_ID FROM
2892: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2893: FROM EAM_METER_READINGS EMR1
2894: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2895: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2896: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2897: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID

Line 2979: EAM_METER_READINGS EMR

2975: EM.METER_TYPE
2976:
2977: FROM EAM_METERS EM,
2978: EAM_ASSET_METERS EAM,
2979: EAM_METER_READINGS EMR
2980:
2981: WHERE EM.METER_ID = EAM.METER_ID
2982: AND EMR.METER_ID = EAM.METER_ID
2983: AND EM.REQUIRED_FLAG = 'Y'

Line 2990: FROM EAM_METER_READINGS EMR1

2986: -- (l_selected_meter IS NOT NULL AND EM.METER_ID = l_selected_meter))
2987: AND EMR.METER_READING_ID IN
2988: (SELECT METER_READING_ID FROM
2989: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
2990: FROM EAM_METER_READINGS EMR1
2991: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
2992: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2993: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2994: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID

Line 3101: EAM_METER_READINGS EMR

3097: EMR.WIP_ENTITY_ID,
3098: EM.METER_TYPE
3099: FROM EAM_METERS EM,
3100: EAM_ASSET_METERS EAM,
3101: EAM_METER_READINGS EMR
3102: WHERE EM.METER_ID = EAM.METER_ID
3103: AND EMR.METER_ID = EAM.METER_ID
3104: AND EM.REQUIRED_FLAG = 'Y'
3105: AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 3109: FROM EAM_METER_READINGS EMR1

3105: AND EAM.PRIMARY_FAILURE_METER = 'Y'
3106: AND EMR.METER_READING_ID IN
3107: (SELECT METER_READING_ID FROM
3108: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
3109: FROM EAM_METER_READINGS EMR1
3110: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
3111: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3112: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
3113: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID

Line 3229: FROM EAM_METER_READINGS_V EMR1

3225: FROM
3226: (
3227: SELECT
3228: Max(EMR1.METER_READING_ID) METER_READING_ID
3229: FROM EAM_METER_READINGS_V EMR1
3230: GROUP BY EMR1.WIP_ENTITY_ID,
3231: EMR1.METER_ID
3232: )
3233: )) METER

Line 3359: FROM EAM_METER_READINGS_V EMR1

3355: FROM
3356: (
3357: SELECT
3358: Max(EMR1.METER_READING_ID) METER_READING_ID
3359: FROM EAM_METER_READINGS_V EMR1
3360: GROUP BY EMR1.WIP_ENTITY_ID,
3361: EMR1.METER_ID
3362: )
3363: )) METER

Line 3472: EAM_METER_READINGS EMR

3468: EMR.WIP_ENTITY_ID,
3469: EM.METER_TYPE
3470: FROM EAM_METERS EM,
3471: EAM_ASSET_METERS EAM,
3472: EAM_METER_READINGS EMR
3473: WHERE EM.METER_ID = EAM.METER_ID
3474: AND EMR.METER_ID = EAM.METER_ID
3475: AND EM.REQUIRED_FLAG = 'Y'
3476: AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 3480: FROM EAM_METER_READINGS EMR1

3476: AND EAM.PRIMARY_FAILURE_METER = 'Y'
3477: AND EMR.METER_READING_ID IN
3478: (SELECT METER_READING_ID FROM
3479: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
3480: FROM EAM_METER_READINGS EMR1
3481: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
3482: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3483: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
3484: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID

Line 3594: EAM_METER_READINGS EMR

3590: EMR.WIP_ENTITY_ID,
3591: EM.METER_TYPE
3592: FROM EAM_METERS EM,
3593: EAM_ASSET_METERS EAM,
3594: EAM_METER_READINGS EMR
3595: WHERE EM.METER_ID = EAM.METER_ID
3596: AND EMR.METER_ID = EAM.METER_ID
3597: AND EM.REQUIRED_FLAG = 'Y'
3598: AND EAM.PRIMARY_FAILURE_METER = 'Y'

Line 3602: FROM EAM_METER_READINGS EMR1

3598: AND EAM.PRIMARY_FAILURE_METER = 'Y'
3599: AND EMR.METER_READING_ID IN
3600: (SELECT METER_READING_ID FROM
3601: (SELECT Max(EMR1.METER_READING_ID) METER_READING_ID,EMR1.WIP_ENTITY_ID,EMR1.METER_ID
3602: FROM EAM_METER_READINGS EMR1
3603: GROUP BY EMR1.WIP_ENTITY_ID, EMR1.METER_ID ))) METER
3604: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3605: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
3606: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID

Line 4504: FROM EAM_METER_READINGS_V EMR1

4500: FROM
4501: (
4502: SELECT
4503: Max(EMR1.METER_READING_ID) METER_READING_ID
4504: FROM EAM_METER_READINGS_V EMR1
4505: GROUP BY EMR1.WIP_ENTITY_ID,
4506: EMR1.METER_ID
4507: )
4508: )) METER