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 DUAL

Line 41: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_GROUP_ID FROM DUAL;

37: p_from_date_clause => p_from_date_clause,
38: P_CURRENT_ORG_ID => l_current_org_id, -- 12581897
39: x_ref_failures => l_ref_failures);
40:
41: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_GROUP_ID FROM DUAL;
42:
43: LOOP
44: FETCH l_REF_FAILURES BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
45:

Line 149: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

145: END IF;
146:
147: l_validate_currency := p_compute_repair_costs;
148:
149: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
150:
151: LOOP
152: FETCH x_ref_failures BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
153: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 783: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

779: l_validate_currency := 'Y';
780: l_current_org_id := p_current_org_id;
781:
782: OPEN c_history_records_simple;
783: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
784: LOOP
785: FETCH c_history_records_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
786:
787: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 1387: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1383: l_asset_failure_tbl.DELETE();
1384:
1385: IF p_view_by = 1 /* 'ASSET_NUMBER' */ THEN
1386: OPEN c_hist_meter_recs_an_simple;
1387: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1388: LOOP
1389: FETCH c_hist_meter_recs_an_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
1390: IF ( l_asset_failure_tbl.Count > 0 ) THEN
1391: VALIDATE_RECORDS( p_asset_failure_tbl => l_asset_failure_tbl,

Line 1415: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1411: CLOSE c_hist_meter_recs_an_simple;
1412:
1413: ELSIF p_view_by = 2 /* 'ASSET_GROUP' */ THEN
1414: OPEN c_hist_meter_recs_ag_simple;
1415: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1416: LOOP
1417: FETCH c_hist_meter_recs_ag_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
1418: IF ( l_asset_failure_tbl.Count > 0 ) THEN
1419: VALIDATE_RECORDS( p_asset_failure_tbl => l_asset_failure_tbl,

Line 1443: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1439: CLOSE c_hist_meter_recs_ag_simple;
1440:
1441: ELSIF p_view_by = 3 /* 'ASSET_CATEGORY' */ THEN
1442: OPEN c_hist_recs_ac_simple;
1443: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1444: LOOP
1445: FETCH c_hist_recs_ac_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
1446: IF ( l_asset_failure_tbl.Count > 0 ) THEN
1447: VALIDATE_RECORDS( p_asset_failure_tbl => l_asset_failure_tbl,

Line 1470: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

1466: CLOSE c_hist_recs_ac_simple;
1467:
1468: ELSIF p_view_by = 4 /* 'FAILURE_CODE' */ THEN
1469: OPEN c_hist_recs_fc_simple;
1470: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1471:
1472: LOOP
1473: FETCH c_hist_recs_fc_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
1474: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3680: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3676: IF p_view_by = 1 /* 'ASSET_NUMBER' */ THEN
3677: IF p_gen_object_id = 0 THEN
3678: OPEN c_meter_recs_an_simple;
3679: IF ( l_group_id IS NULL OR l_group_id = 0) then
3680: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3681: END IF;
3682: LOOP
3683: FETCH c_meter_recs_an_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3684: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3708: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3704: CLOSE c_meter_recs_an_simple;
3705: ELSE
3706: OPEN c_meter_recs_an_simple_1;
3707: IF ( l_group_id IS NULL OR l_group_id = 0) then
3708: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3709: END IF;
3710: LOOP
3711: FETCH c_meter_recs_an_simple_1 BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3712: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3738: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3734: ELSIF p_view_by = 2 /* 'ASSET_GROUP' */ THEN
3735: IF p_gen_object_id = 0 THEN
3736: OPEN c_meter_recs_ag_simple;
3737: IF ( l_group_id IS NULL OR l_group_id = 0) then
3738: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3739: END IF;
3740: LOOP
3741: FETCH c_meter_recs_ag_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3742: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3767: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3763: CLOSE c_meter_recs_ag_simple;
3764: ELSE
3765: OPEN c_meter_recs_ag_simple_1;
3766: IF ( l_group_id IS NULL OR l_group_id = 0) then
3767: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3768: END IF;
3769: LOOP
3770: FETCH c_meter_recs_ag_simple_1 BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3771: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3798: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3794: ELSIF p_view_by = 3 /* Asset Category */ THEN
3795: IF p_gen_object_id = 0 THEN
3796: OPEN c_recs_ac_simple;
3797: IF ( l_group_id IS NULL OR l_group_id = 0) then
3798: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3799: END IF;
3800: LOOP
3801: FETCH c_recs_ac_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3802: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3825: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3821: CLOSE c_recs_ac_simple;
3822: ELSE
3823: OPEN c_recs_ac_simple_1;
3824: IF ( l_group_id IS NULL OR l_group_id = 0) then
3825: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3826: END IF;
3827: LOOP
3828: FETCH c_recs_ac_simple_1 BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3829: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3854: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3850: ELSIF p_view_by = 4 /* Failure Code */ THEN
3851: IF p_gen_object_id = 0 THEN
3852: OPEN c_recs_fc_simple;
3853: IF ( l_group_id IS NULL OR l_group_id = 0) then
3854: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3855: END IF;
3856: LOOP
3857: FETCH c_recs_fc_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3858: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3882: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3878: CLOSE c_recs_fc_simple;
3879: ELSE
3880: OPEN c_recs_fc_simple_1;
3881: IF ( l_group_id IS NULL OR l_group_id = 0) then
3882: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3883: END IF;
3884: LOOP
3885: FETCH c_recs_fc_simple_1 BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3886: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3914: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3910: ELSE /*( p_failure_code IS NOT NULL OR p_to_date IS NOT NULL OR p_from_date IS NOT NULL)*/
3911: IF p_view_by = 1 /* 'ASSET_NUMBER' */ THEN
3912: OPEN c_meter_recs_wo_an_simple;
3913: IF ( l_group_id IS NULL OR l_group_id = 0) then
3914: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3915: END IF;
3916: LOOP
3917: FETCH c_meter_recs_wo_an_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3918: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3943: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3939:
3940: ELSIF p_view_by = 2 /* 'ASSET_GROUP' */ THEN
3941: OPEN c_meter_recs_ag_simple;
3942: IF ( l_group_id IS NULL OR l_group_id = 0) then
3943: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3944: END IF;
3945: LOOP
3946: FETCH c_meter_recs_ag_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3947: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 3973: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3969:
3970: ELSIF p_view_by = 3 /* Asset Category */ THEN
3971: OPEN c_recs_ac_simple;
3972: IF ( l_group_id IS NULL OR l_group_id = 0) then
3973: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3974: END IF;
3975: LOOP
3976: FETCH c_recs_ac_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
3977: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 4001: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

3997:
3998: ELSIF p_view_by = 4 /* Failure Code */ THEN
3999: OPEN c_recs_fc_simple;
4000: IF ( l_group_id IS NULL OR l_group_id = 0) then
4001: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
4002: END IF;
4003: LOOP
4004: FETCH c_recs_fc_simple BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;
4005: IF ( l_asset_failure_tbl.Count > 0 ) THEN

Line 4101: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;

4097:
4098: l_group_id := x_group_id;
4099: l_validate_currency := p_compute_repair_costs;
4100: IF ( l_group_id IS NULL OR l_group_id = 0) then
4101: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
4102: END IF;
4103:
4104: LOOP
4105: FETCH x_ref_failures BULK COLLECT INTO l_asset_failure_tbl LIMIT 500;