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 52: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_GROUP_ID FROM DUAL;

48: p_current_org_id => p_current_org_id,
49: x_unmatched_uom_class => l_unmatched_uom_class,
50: x_unmatched_currency => l_unmatched_currency); */
51:
52: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_GROUP_ID FROM DUAL;
53:
54: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
55: p_asset_failure_tbl => l_asset_failure_tbl);
56:

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

153: p_current_org_id => l_current_org_id,
154: x_unmatched_uom_class => l_unmatched_uom_class,
155: x_unmatched_currency => l_unmatched_currency);
156:
157: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
158:
159: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
160: p_asset_failure_tbl => l_asset_failure_tbl);
161:

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

783: p_current_org_id => l_current_org_id,
784: x_unmatched_uom_class => l_unmatched_uom_class,
785: x_unmatched_currency => l_unmatched_currency); */
786:
787: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
788:
789: INSERT_INTO_TEMP_TABLE(l_group_id, l_asset_failure_tbl);
790:
791: --No need to calculate Repair Costs in Failure History Page.

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

1380: p_current_org_id => p_current_org_id,
1381: x_unmatched_uom_class => l_unmatched_uom_class,
1382: x_unmatched_currency => l_unmatched_currency);
1383:
1384: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1385:
1386: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1387: p_asset_failure_tbl => l_asset_failure_tbl);
1388:

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

1407: p_current_org_id => p_current_org_id,
1408: x_unmatched_uom_class => l_unmatched_uom_class,
1409: x_unmatched_currency => l_unmatched_currency);
1410:
1411: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1412:
1413: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1414: p_asset_failure_tbl => l_asset_failure_tbl);
1415:

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

1434: p_current_org_id => p_current_org_id,
1435: x_unmatched_uom_class => l_unmatched_uom_class,
1436: x_unmatched_currency => l_unmatched_currency);
1437:
1438: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1439:
1440: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1441: p_asset_failure_tbl => l_asset_failure_tbl);
1442:

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

1461: p_current_org_id => p_current_org_id,
1462: x_unmatched_uom_class => l_unmatched_uom_class,
1463: x_unmatched_currency => l_unmatched_currency);
1464:
1465: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
1466:
1467: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
1468: p_asset_failure_tbl => l_asset_failure_tbl);
1469:

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

3134: x_unmatched_uom_class => l_unmatched_uom_class,
3135: x_unmatched_currency => l_unmatched_currency);
3136:
3137: IF ( l_group_id IS NULL OR l_group_id = 0) then
3138: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3139: END IF;
3140:
3141: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3142: p_asset_failure_tbl => l_asset_failure_tbl);

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

3162: x_unmatched_uom_class => l_unmatched_uom_class,
3163: x_unmatched_currency => l_unmatched_currency);
3164:
3165: IF ( l_group_id IS NULL OR l_group_id = 0) then
3166: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3167: END IF;
3168:
3169: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3170: p_asset_failure_tbl => l_asset_failure_tbl);

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

3190: p_current_org_id => p_current_org_id,
3191: x_unmatched_uom_class => l_unmatched_uom_class,
3192: x_unmatched_currency => l_unmatched_currency);
3193: IF ( l_group_id IS NULL OR l_group_id = 0) then
3194: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3195: END IF;
3196:
3197: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3198: p_asset_failure_tbl => l_asset_failure_tbl);

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

3217: p_current_org_id => p_current_org_id,
3218: x_unmatched_uom_class => l_unmatched_uom_class,
3219: x_unmatched_currency => l_unmatched_currency);
3220: IF ( l_group_id IS NULL OR l_group_id = 0) then
3221: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3222: END IF;
3223:
3224: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3225: p_asset_failure_tbl => l_asset_failure_tbl);

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

3248: x_unmatched_uom_class => l_unmatched_uom_class,
3249: x_unmatched_currency => l_unmatched_currency);
3250:
3251: IF ( l_group_id IS NULL OR l_group_id = 0) then
3252: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3253: END IF;
3254:
3255: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3256: p_asset_failure_tbl => l_asset_failure_tbl);

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

3276: x_unmatched_uom_class => l_unmatched_uom_class,
3277: x_unmatched_currency => l_unmatched_currency);
3278:
3279: IF ( l_group_id IS NULL OR l_group_id = 0) then
3280: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3281: END IF;
3282:
3283: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3284: p_asset_failure_tbl => l_asset_failure_tbl);

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

3304: p_current_org_id => p_current_org_id,
3305: x_unmatched_uom_class => l_unmatched_uom_class,
3306: x_unmatched_currency => l_unmatched_currency);
3307: IF ( l_group_id IS NULL OR l_group_id = 0) then
3308: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3309: END IF;
3310:
3311: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3312: p_asset_failure_tbl => l_asset_failure_tbl);

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

3331: p_current_org_id => p_current_org_id,
3332: x_unmatched_uom_class => l_unmatched_uom_class,
3333: x_unmatched_currency => l_unmatched_currency);
3334: IF ( l_group_id IS NULL OR l_group_id = 0) then
3335: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3336: END IF;
3337:
3338: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3339: p_asset_failure_tbl => l_asset_failure_tbl);

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

3435: x_unmatched_uom_class => l_unmatched_uom_class,
3436: x_unmatched_currency => l_unmatched_currency);
3437:
3438: IF ( l_group_id IS NULL OR l_group_id = 0) then
3439: SELECT EAM_FAILURE_HISTORY_TEMP_S.NEXTVAL INTO l_group_id FROM DUAL;
3440: END IF;
3441:
3442: INSERT_INTO_TEMP_TABLE(p_group_id => l_group_id,
3443: p_asset_failure_tbl => l_asset_failure_tbl);