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_ASSET_FAILURE_CODES

Line 332: EAM_ASSET_FAILURE_CODES EAFC,

328: MTL_CATEGORIES_KFV MCKFV,
329: MTL_SYSTEM_ITEMS_KFV MSIKFV,
330: MTL_EAM_LOCATIONS MEL,
331: BOM_DEPARTMENTS BD,
332: EAM_ASSET_FAILURE_CODES EAFC,
333: EAM_ASSET_FAILURES EAF,
334: ORG_ORGANIZATION_DEFINITIONS OOD,
335: EAM_FAILURE_CODES EFC,
336: EAM_CAUSE_CODES ECC,

Line 525: EAM_ASSET_FAILURE_CODES EAFC,

521: MTL_CATEGORIES_KFV MCKFV,
522: MTL_SYSTEM_ITEMS_KFV MSIKFV,
523: MTL_EAM_LOCATIONS MEL,
524: BOM_DEPARTMENTS BD,
525: EAM_ASSET_FAILURE_CODES EAFC,
526: EAM_ASSET_FAILURES EAF,
527: ORG_ORGANIZATION_DEFINITIONS OOD,
528: EAM_FAILURE_CODES EFC,
529: EAM_CAUSE_CODES ECC,

Line 684: EAM_ASSET_FAILURE_CODES EAFC,

680: MTL_CATEGORIES_KFV MCKFV,
681: MTL_SYSTEM_ITEMS_KFV MSIKFV,
682: MTL_EAM_LOCATIONS MEL,
683: BOM_DEPARTMENTS BD,
684: EAM_ASSET_FAILURE_CODES EAFC,
685: EAM_ASSET_FAILURES EAF,
686: ORG_ORGANIZATION_DEFINITIONS OOD,
687: (SELECT
688: ccb.counter_id METER_ID,

Line 929: EAM_ASSET_FAILURE_CODES EAFC,

925: MTL_CATEGORIES_KFV MCKFV,
926: MTL_SYSTEM_ITEMS_KFV MSIKFV,
927: MTL_EAM_LOCATIONS MEL,
928: BOM_DEPARTMENTS BD,
929: EAM_ASSET_FAILURE_CODES EAFC,
930: EAM_ASSET_FAILURES EAF,
931: ORG_ORGANIZATION_DEFINITIONS OOD
932: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
933: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 1030: EAM_ASSET_FAILURE_CODES EAFC,

1026: MTL_CATEGORIES_KFV MCKFV,
1027: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1028: MTL_EAM_LOCATIONS MEL,
1029: BOM_DEPARTMENTS BD,
1030: EAM_ASSET_FAILURE_CODES EAFC,
1031: EAM_ASSET_FAILURES EAF,
1032: ORG_ORGANIZATION_DEFINITIONS OOD
1033: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1034: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 1132: EAM_ASSET_FAILURE_CODES EAFC,

1128: MTL_CATEGORIES_KFV MCKFV,
1129: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1130: MTL_EAM_LOCATIONS MEL,
1131: BOM_DEPARTMENTS BD,
1132: EAM_ASSET_FAILURE_CODES EAFC,
1133: EAM_ASSET_FAILURES EAF,
1134: ORG_ORGANIZATION_DEFINITIONS OOD,
1135: (SELECT
1136: ccb.counter_id METER_ID,

Line 1277: EAM_ASSET_FAILURE_CODES EAFC,

1273: MTL_CATEGORIES_KFV MCKFV,
1274: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1275: MTL_EAM_LOCATIONS MEL,
1276: BOM_DEPARTMENTS BD,
1277: EAM_ASSET_FAILURE_CODES EAFC,
1278: EAM_ASSET_FAILURES EAF,
1279: ORG_ORGANIZATION_DEFINITIONS OOD,
1280: (SELECT
1281: ccb.counter_id METER_ID,

Line 1812: EAM_ASSET_FAILURE_CODES EAFC,

1808: MTL_CATEGORIES_KFV MCKFV,
1809: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1810: MTL_EAM_LOCATIONS MEL,
1811: BOM_DEPARTMENTS BD,
1812: EAM_ASSET_FAILURE_CODES EAFC,
1813: EAM_ASSET_FAILURES EAF,
1814: ORG_ORGANIZATION_DEFINITIONS OOD
1815: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1816: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 1904: EAM_ASSET_FAILURE_CODES EAFC,

1900: MTL_CATEGORIES_KFV MCKFV,
1901: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1902: MTL_EAM_LOCATIONS MEL,
1903: BOM_DEPARTMENTS BD,
1904: EAM_ASSET_FAILURE_CODES EAFC,
1905: EAM_ASSET_FAILURES EAF,
1906: ORG_ORGANIZATION_DEFINITIONS OOD
1907: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1908: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 1996: EAM_ASSET_FAILURE_CODES EAFC,

1992: MTL_CATEGORIES_KFV MCKFV,
1993: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1994: MTL_EAM_LOCATIONS MEL,
1995: BOM_DEPARTMENTS BD,
1996: EAM_ASSET_FAILURE_CODES EAFC,
1997: EAM_ASSET_FAILURES EAF,
1998: CSI_ITEM_INSTANCES CII,
1999: ORG_ORGANIZATION_DEFINITIONS OOD
2000: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2028: EAM_ASSET_FAILURE_CODES EAFC,

2024: FROM MTL_OBJECT_GENEALOGY
2025: START WITH PARENT_OBJECT_ID IN
2026: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2027: FROM CSI_ITEM_INSTANCES CII,
2028: EAM_ASSET_FAILURE_CODES EAFC,
2029: EAM_ASSET_FAILURES EAF,
2030: WIP_DISCRETE_JOBS WDJ,
2031: MTL_SERIAL_NUMBERS MSN
2032: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2095: EAM_ASSET_FAILURE_CODES EAFC,

2091: MTL_CATEGORIES_KFV MCKFV,
2092: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2093: MTL_EAM_LOCATIONS MEL,
2094: BOM_DEPARTMENTS BD,
2095: EAM_ASSET_FAILURE_CODES EAFC,
2096: EAM_ASSET_FAILURES EAF,
2097: ORG_ORGANIZATION_DEFINITIONS OOD,
2098: CSI_ITEM_INSTANCES CII
2099: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2115: FROM EAM_ASSET_FAILURE_CODES EAFC,

2111: AND MCKFV.CATEGORY_ID (+) = CII.CATEGORY_ID
2112: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
2113: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2114: AND EAF.OBJECT_ID IN (SELECT EAF.OBJECT_ID OBJECT_ID --This part will select parent assets
2115: FROM EAM_ASSET_FAILURE_CODES EAFC,
2116: EAM_ASSET_FAILURES EAF,
2117: WIP_DISCRETE_JOBS WDJ,
2118: CSI_ITEM_INSTANCES CII
2119: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2180: EAM_ASSET_FAILURE_CODES EAFC,

2176: MTL_CATEGORIES_KFV MCKFV,
2177: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2178: MTL_EAM_LOCATIONS MEL,
2179: BOM_DEPARTMENTS BD,
2180: EAM_ASSET_FAILURE_CODES EAFC,
2181: EAM_ASSET_FAILURES EAF,
2182: ORG_ORGANIZATION_DEFINITIONS OOD
2183: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2184: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 2270: EAM_ASSET_FAILURE_CODES EAFC,

2266: MTL_CATEGORIES_KFV MCKFV,
2267: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2268: MTL_EAM_LOCATIONS MEL,
2269: BOM_DEPARTMENTS BD,
2270: EAM_ASSET_FAILURE_CODES EAFC,
2271: EAM_ASSET_FAILURES EAF,
2272: ORG_ORGANIZATION_DEFINITIONS OOD
2273: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2274: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 2359: EAM_ASSET_FAILURE_CODES EAFC,

2355: MTL_CATEGORIES_KFV MCKFV,
2356: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2357: MTL_EAM_LOCATIONS MEL,
2358: BOM_DEPARTMENTS BD,
2359: EAM_ASSET_FAILURE_CODES EAFC,
2360: EAM_ASSET_FAILURES EAF,
2361: CSI_ITEM_INSTANCES CII,
2362: ORG_ORGANIZATION_DEFINITIONS OOD
2363: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2390: FROM EAM_ASSET_FAILURE_CODES EAFC,

2386: (SELECT OBJECT_ID --This part will select all children assets
2387: FROM MTL_OBJECT_GENEALOGY
2388: START WITH PARENT_OBJECT_ID IN
2389: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2390: FROM EAM_ASSET_FAILURE_CODES EAFC,
2391: EAM_ASSET_FAILURES EAF,
2392: WIP_DISCRETE_JOBS WDJ,
2393: MTL_SERIAL_NUMBERS MSN,
2394: CSI_ITEM_INSTANCES CII

Line 2454: EAM_ASSET_FAILURE_CODES EAFC,

2450: MTL_CATEGORIES_KFV MCKFV,
2451: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2452: MTL_EAM_LOCATIONS MEL,
2453: BOM_DEPARTMENTS BD,
2454: EAM_ASSET_FAILURE_CODES EAFC,
2455: EAM_ASSET_FAILURES EAF,
2456: CSI_ITEM_INSTANCES CII,
2457: ORG_ORGANIZATION_DEFINITIONS OOD
2458: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2474: FROM EAM_ASSET_FAILURE_CODES EAFC,

2470: AND MCKFV.CATEGORY_ID (+) = CII.CATEGORY_ID
2471: AND MEL.LOCATION_ID (+) = EAF.AREA_ID
2472: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2473: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
2474: FROM EAM_ASSET_FAILURE_CODES EAFC,
2475: EAM_ASSET_FAILURES EAF,
2476: WIP_DISCRETE_JOBS WDJ,
2477: CSI_ITEM_INSTANCES
2478: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 2539: EAM_ASSET_FAILURE_CODES EAFC,

2535: MTL_CATEGORIES_KFV MCKFV,
2536: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2537: MTL_EAM_LOCATIONS MEL,
2538: BOM_DEPARTMENTS BD,
2539: EAM_ASSET_FAILURE_CODES EAFC,
2540: EAM_ASSET_FAILURES EAF,
2541: ORG_ORGANIZATION_DEFINITIONS OOD,
2542: (SELECT
2543: ccb.counter_id METER_ID,

Line 2656: EAM_ASSET_FAILURE_CODES EAFC,

2652: MTL_CATEGORIES_KFV MCKFV,
2653: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2654: MTL_EAM_LOCATIONS MEL,
2655: BOM_DEPARTMENTS BD,
2656: EAM_ASSET_FAILURE_CODES EAFC,
2657: EAM_ASSET_FAILURES EAF,
2658: CSI_ITEM_INSTANCES CII,
2659: ORG_ORGANIZATION_DEFINITIONS OOD,
2660: (SELECT EM.METER_ID,

Line 2751: EAM_ASSET_FAILURE_CODES EAFC,

2747: MTL_CATEGORIES_KFV MCKFV,
2748: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2749: MTL_EAM_LOCATIONS MEL,
2750: BOM_DEPARTMENTS BD,
2751: EAM_ASSET_FAILURE_CODES EAFC,
2752: EAM_ASSET_FAILURES EAF,
2753: ORG_ORGANIZATION_DEFINITIONS OOD,
2754: (SELECT
2755: ccb.counter_id METER_ID,

Line 2868: EAM_ASSET_FAILURE_CODES EAFC,

2864: MTL_CATEGORIES_KFV MCKFV,
2865: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2866: MTL_EAM_LOCATIONS MEL,
2867: BOM_DEPARTMENTS BD,
2868: EAM_ASSET_FAILURE_CODES EAFC,
2869: EAM_ASSET_FAILURES EAF,
2870: CSI_ITEM_INSTANCES CII,
2871: ORG_ORGANIZATION_DEFINITIONS OOD,
2872: (SELECT EM.METER_ID,

Line 2963: EAM_ASSET_FAILURE_CODES EAFC,

2959: MTL_CATEGORIES_KFV MCKFV,
2960: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2961: MTL_EAM_LOCATIONS MEL,
2962: BOM_DEPARTMENTS BD,
2963: EAM_ASSET_FAILURE_CODES EAFC,
2964: EAM_ASSET_FAILURES EAF,
2965: ORG_ORGANIZATION_DEFINITIONS OOD,
2966: CSI_ITEM_INSTANCES CII,
2967: (SELECT EM.METER_ID,

Line 3023: EAM_ASSET_FAILURE_CODES EAFC,

3019: FROM MTL_OBJECT_GENEALOGY
3020: START WITH PARENT_OBJECT_ID IN
3021: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3022: FROM CSI_ITEM_INSTANCES CII,
3023: EAM_ASSET_FAILURE_CODES EAFC,
3024: EAM_ASSET_FAILURES EAF,
3025: WIP_DISCRETE_JOBS WDJ,
3026: MTL_SERIAL_NUMBERS MSN
3027: WHERE NVL(WDJ.STATUS_TYPE,4) IN (4,5,12)

Line 3086: EAM_ASSET_FAILURE_CODES EAFC,

3082: MTL_CATEGORIES_KFV MCKFV,
3083: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3084: MTL_EAM_LOCATIONS MEL,
3085: BOM_DEPARTMENTS BD,
3086: EAM_ASSET_FAILURE_CODES EAFC,
3087: EAM_ASSET_FAILURES EAF,
3088: ORG_ORGANIZATION_DEFINITIONS OOD,
3089: CSI_ITEM_INSTANCES CII,
3090: (SELECT EM.METER_ID,

Line 3129: FROM EAM_ASSET_FAILURE_CODES EAFC,

3125: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
3126: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
3127: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3128: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
3129: FROM EAM_ASSET_FAILURE_CODES EAFC,
3130: EAM_ASSET_FAILURES EAF,
3131: WIP_DISCRETE_JOBS WDJ,
3132: CSI_ITEM_INSTANCES CII
3133: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 3197: EAM_ASSET_FAILURE_CODES EAFC,

3193: MTL_CATEGORIES_KFV MCKFV,
3194: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3195: MTL_EAM_LOCATIONS MEL,
3196: BOM_DEPARTMENTS BD,
3197: EAM_ASSET_FAILURE_CODES EAFC,
3198: EAM_ASSET_FAILURES EAF,
3199: ORG_ORGANIZATION_DEFINITIONS OOD,
3200: (SELECT
3201: ccb.counter_id METER_ID,

Line 3327: EAM_ASSET_FAILURE_CODES EAFC,

3323: MTL_CATEGORIES_KFV MCKFV,
3324: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3325: MTL_EAM_LOCATIONS MEL,
3326: BOM_DEPARTMENTS BD,
3327: EAM_ASSET_FAILURE_CODES EAFC,
3328: EAM_ASSET_FAILURES EAF,
3329: ORG_ORGANIZATION_DEFINITIONS OOD,
3330: (SELECT
3331: ccb.counter_id METER_ID,

Line 3457: EAM_ASSET_FAILURE_CODES EAFC,

3453: MTL_CATEGORIES_KFV MCKFV,
3454: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3455: MTL_EAM_LOCATIONS MEL,
3456: BOM_DEPARTMENTS BD,
3457: EAM_ASSET_FAILURE_CODES EAFC,
3458: EAM_ASSET_FAILURES EAF,
3459: CSI_ITEM_INSTANCES CII,
3460: ORG_ORGANIZATION_DEFINITIONS OOD,
3461: (SELECT EM.METER_ID,

Line 3512: EAM_ASSET_FAILURE_CODES EAFC,

3508: FROM MTL_OBJECT_GENEALOGY
3509: START WITH PARENT_OBJECT_ID IN
3510: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3511: FROM CSI_ITEM_INSTANCES CII,
3512: EAM_ASSET_FAILURE_CODES EAFC,
3513: EAM_ASSET_FAILURES EAF,
3514: WIP_DISCRETE_JOBS WDJ,
3515: MTL_SERIAL_NUMBERS MSN
3516: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID

Line 3579: EAM_ASSET_FAILURE_CODES EAFC,

3575: MTL_CATEGORIES_KFV MCKFV,
3576: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3577: MTL_EAM_LOCATIONS MEL,
3578: BOM_DEPARTMENTS BD,
3579: EAM_ASSET_FAILURE_CODES EAFC,
3580: EAM_ASSET_FAILURES EAF,
3581: CSI_ITEM_INSTANCES CII,
3582: ORG_ORGANIZATION_DEFINITIONS OOD,
3583: (SELECT EM.METER_ID,

Line 3622: FROM EAM_ASSET_FAILURE_CODES EAFC,

3618: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
3619: AND EAF.OBJECT_ID = METER.MAINTENANCE_OBJECT_ID (+)
3620: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3621: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
3622: FROM EAM_ASSET_FAILURE_CODES EAFC,
3623: EAM_ASSET_FAILURES EAF,
3624: WIP_DISCRETE_JOBS WDJ,
3625: CSI_ITEM_INSTANCES CII
3626: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 4239: EAM_ASSET_FAILURE_CODES EAFC,

4235: MTL_CATEGORIES_KFV MCKFV,
4236: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4237: MTL_EAM_LOCATIONS MEL,
4238: BOM_DEPARTMENTS BD,
4239: EAM_ASSET_FAILURE_CODES EAFC,
4240: EAM_ASSET_FAILURES EAF,
4241: ORG_ORGANIZATION_DEFINITIONS OOD
4242: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
4243: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID

Line 4294: EAM_ASSET_FAILURE_CODES EAFC,

4290: MTL_CATEGORIES_KFV MCKFV,
4291: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4292: MTL_EAM_LOCATIONS MEL,
4293: BOM_DEPARTMENTS BD,
4294: EAM_ASSET_FAILURE_CODES EAFC,
4295: EAM_ASSET_FAILURES EAF,
4296: EAM_FAILURE_CODES EFC,
4297: EAM_CAUSE_CODES ECC,
4298: MTL_SERIAL_NUMBERS MSN,

Line 4473: EAM_ASSET_FAILURE_CODES EAFC,

4469: MTL_CATEGORIES_KFV MCKFV,
4470: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4471: MTL_EAM_LOCATIONS MEL,
4472: BOM_DEPARTMENTS BD,
4473: EAM_ASSET_FAILURE_CODES EAFC,
4474: EAM_ASSET_FAILURES EAF,
4475: ORG_ORGANIZATION_DEFINITIONS OOD,
4476: (SELECT
4477: ccb.counter_id METER_ID,

Line 4563: EAM_ASSET_FAILURE_CODES EAFC,

4559: MTL_CATEGORIES_KFV MCKFV,
4560: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4561: MTL_EAM_LOCATIONS MEL,
4562: BOM_DEPARTMENTS BD,
4563: EAM_ASSET_FAILURE_CODES EAFC,
4564: EAM_ASSET_FAILURES EAF,
4565: EAM_FAILURE_CODES EFC,
4566: EAM_CAUSE_CODES ECC,
4567: EAM_RESOLUTION_CODES ERC,