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 409: FROM eam_failure_combinations EFC,

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

Line 416: FROM EAM_FAILURE_COMBINATIONS EFC2

412: AND EFSA.inventory_item_id = l_inventory_item_id
413: AND EFSA.effective_end_date is null
414: AND EFSA.set_id = EFC.set_id
415: AND exists ( SELECT /*+ no_unnest */ 'x'
416: FROM EAM_FAILURE_COMBINATIONS EFC2
417: WHERE NVL(EFC2.EFFECTIVE_END_DATE, SYSDATE) >= SYSDATE
418: AND EFC2.SET_ID = EFSA.SET_ID
419: )
420: AND exists ( SELECT 'x'

Line 446: FROM eam_failure_combinations EFC,

442: ) THEN
443:
444: SELECT count(1)
445: INTO l_valid_cause_code
446: FROM eam_failure_combinations EFC,
447: eam_failure_set_associations EFSA
448: WHERE EFC.cause_code = l_eam_failure_codes_record.cause_code
449: AND EFSA.inventory_item_id = l_inventory_item_id
450: AND EFSA.effective_end_date IS NULL

Line 454: FROM eam_failure_combinations EFC2

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

Line 481: FROM eam_failure_combinations EFC,

477: ) THEN
478:
479: SELECT COUNT(1)
480: INTO l_valid_resolution_code
481: FROM eam_failure_combinations EFC,
482: eam_failure_set_associations EFSA
483: WHERE EFC.resolution_code = l_eam_failure_codes_record.resolution_code
484: AND EFSA.inventory_item_id = l_inventory_item_id
485: AND EFSA.EFFECTIVE_END_DATE IS NULL

Line 490: FROM eam_failure_combinations EFC2

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

Line 781: FROM eam_failure_combinations EFC,

777: WHERE failure_id = l_eam_failure_codes_record.failure_id
778: );
779: SELECT COMBINATION_ID
780: INTO l_combination_id
781: FROM eam_failure_combinations EFC,
782: eam_failure_set_associations EFSA
783: WHERE EFC.failure_code = l_eam_failure_codes_record.failure_code
784: AND EFC.cause_code = l_eam_failure_codes_record.cause_code
785: AND EFC.resolution_code = l_eam_failure_codes_record.resolution_code

Line 790: FROM eam_failure_combinations EFC2

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