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_PROCESS_FAILURE_ENTRY_PVT dependencies on EAM_FAILURE_COMBINATIONS

Line 408: FROM eam_failure_combinations EFC,

404: ) THEN
405:
406: SELECT COUNT(1)
407: INTO l_valid_failure_code
408: FROM eam_failure_combinations EFC,
409: eam_failure_set_associations EFSA
410: WHERE EFC.failure_code = l_eam_failure_codes_record.failure_code
411: AND EFSA.inventory_item_id = l_inventory_item_id
412: AND EFSA.effective_end_date is null

Line 415: FROM EAM_FAILURE_COMBINATIONS EFC2

411: AND EFSA.inventory_item_id = l_inventory_item_id
412: AND EFSA.effective_end_date is null
413: AND EFSA.set_id = EFC.set_id
414: AND sysdate <= ( SELECT min(nvl(EFC2.EFFECTIVE_END_DATE, SYSDATE))
415: FROM EAM_FAILURE_COMBINATIONS EFC2
416: WHERE nvl(EFC2.EFFECTIVE_END_DATE, SYSDATE) >= sysdate
417: AND EFC2.SET_ID = EFSA.SET_ID
418: )
419: AND sysdate <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))

Line 442: FROM eam_failure_combinations EFC,

438: ) THEN
439:
440: SELECT count(1)
441: INTO l_valid_cause_code
442: FROM eam_failure_combinations EFC,
443: eam_failure_set_associations EFSA
444: WHERE EFC.cause_code = l_eam_failure_codes_record.cause_code
445: AND EFSA.inventory_item_id = l_inventory_item_id
446: AND EFSA.effective_end_date IS NULL

Line 450: FROM eam_failure_combinations EFC2

446: AND EFSA.effective_end_date IS NULL
447: AND EFSA.set_id = efc.set_id
448: AND efc.failure_code = l_eam_failure_codes_record.failure_code
449: AND SYSDATE <= ( SELECT min(nvl(EFC2.effective_end_date, sysdate))
450: FROM eam_failure_combinations EFC2
451: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
452: AND EFC2.set_id = EFSA.set_id
453: )
454: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))

Line 477: FROM eam_failure_combinations EFC,

473: ) THEN
474:
475: SELECT COUNT(1)
476: INTO l_valid_resolution_code
477: FROM eam_failure_combinations EFC,
478: eam_failure_set_associations EFSA
479: WHERE EFC.resolution_code = l_eam_failure_codes_record.resolution_code
480: AND EFSA.inventory_item_id = l_inventory_item_id
481: AND EFSA.EFFECTIVE_END_DATE IS NULL

Line 486: FROM eam_failure_combinations EFC2

482: AND EFSA.set_id = efc.set_id
483: AND EFC.failure_code = l_eam_failure_codes_record.failure_code
484: AND EFC.cause_code = l_eam_failure_codes_record.cause_code
485: AND SYSDATE <= ( SELECT min(nvl(EFC2.effective_end_date, sysdate))
486: FROM eam_failure_combinations EFC2
487: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
488: AND EFC2.set_id = EFSA.set_id
489: )
490: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))

Line 777: FROM eam_failure_combinations EFC,

773: WHERE failure_id = l_eam_failure_codes_record.failure_id
774: );
775: SELECT COMBINATION_ID
776: INTO l_combination_id
777: FROM eam_failure_combinations EFC,
778: eam_failure_set_associations EFSA
779: WHERE EFC.failure_code = l_eam_failure_codes_record.failure_code
780: AND EFC.cause_code = l_eam_failure_codes_record.cause_code
781: AND EFC.resolution_code = l_eam_failure_codes_record.resolution_code

Line 786: FROM eam_failure_combinations EFC2

782: AND EFSA.inventory_item_id = l_inventory_item_id
783: AND EFSA.effective_end_date is null
784: AND EFSA.set_id = EFC.set_id
785: AND SYSDATE <= ( SELECT min(nvl(EFC2.effective_end_date, sysdate))
786: FROM eam_failure_combinations EFC2
787: WHERE nvl(EFC2.effective_end_date, sysdate) >= sysdate
788: AND EFC2.set_id = EFSA.set_id
789: )
790: AND SYSDATE <= ( SELECT min(nvl(EFS.EFFECTIVE_END_DATE, SYSDATE))