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 MTL_SYSTEM_ITEMS_KFV

Line 329: MTL_SYSTEM_ITEMS_KFV MSIKFV,

325: FROM WIP_DISCRETE_JOBS WDJ,
326: WIP_ENTITIES WE,
327: CSI_ITEM_INSTANCES CII,
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,

Line 522: MTL_SYSTEM_ITEMS_KFV MSIKFV,

518: FROM WIP_DISCRETE_JOBS WDJ,
519: WIP_ENTITIES WE,
520: CSI_ITEM_INSTANCES CII,
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,

Line 681: MTL_SYSTEM_ITEMS_KFV MSIKFV,

677: FROM WIP_DISCRETE_JOBS WDJ,
678: WIP_ENTITIES WE,
679: CSI_ITEM_INSTANCES CII,
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,

Line 926: MTL_SYSTEM_ITEMS_KFV MSIKFV,

922: FROM WIP_DISCRETE_JOBS WDJ,
923: WIP_ENTITIES WE,
924: CSI_ITEM_INSTANCES CII,
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,

Line 1027: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1023: FROM WIP_DISCRETE_JOBS WDJ,
1024: WIP_ENTITIES WE,
1025: CSI_ITEM_INSTANCES CII,
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,

Line 1129: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1125: FROM WIP_DISCRETE_JOBS WDJ,
1126: WIP_ENTITIES WE,
1127: CSI_ITEM_INSTANCES CII,
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,

Line 1274: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1270: FROM WIP_DISCRETE_JOBS WDJ,
1271: WIP_ENTITIES WE,
1272: CSI_ITEM_INSTANCES CII,
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,

Line 1809: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1805: FROM WIP_DISCRETE_JOBS WDJ,
1806: WIP_ENTITIES WE,
1807: CSI_ITEM_INSTANCES CII,
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,

Line 1901: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1897: FROM WIP_DISCRETE_JOBS WDJ,
1898: WIP_ENTITIES WE,
1899: CSI_ITEM_INSTANCES CII,
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,

Line 1993: MTL_SYSTEM_ITEMS_KFV MSIKFV,

1989: 'Y' INCLUDE_FOR_COST_AGGR
1990: FROM WIP_DISCRETE_JOBS WDJ,
1991: WIP_ENTITIES WE,
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,

Line 2092: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2088: 'Y' INCLUDE_FOR_COST_AGGR
2089: FROM WIP_DISCRETE_JOBS WDJ,
2090: WIP_ENTITIES WE,
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,

Line 2177: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2173: FROM WIP_DISCRETE_JOBS WDJ,
2174: WIP_ENTITIES WE,
2175: CSI_ITEM_INSTANCES CII,
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,

Line 2267: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2263: FROM WIP_DISCRETE_JOBS WDJ,
2264: WIP_ENTITIES WE,
2265: CSI_ITEM_INSTANCES CII,
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,

Line 2356: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2352: 'Y' INCLUDE_FOR_COST_AGGR
2353: FROM WIP_DISCRETE_JOBS WDJ,
2354: WIP_ENTITIES WE,
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,

Line 2451: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2447: 'Y' INCLUDE_FOR_COST_AGGR
2448: FROM WIP_DISCRETE_JOBS WDJ,
2449: WIP_ENTITIES WE,
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,

Line 2536: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2532: FROM WIP_DISCRETE_JOBS WDJ,
2533: WIP_ENTITIES WE,
2534: CSI_ITEM_INSTANCES CII,
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,

Line 2653: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2649: 'Y' INCLUDE_FOR_COST_AGGR
2650: FROM WIP_DISCRETE_JOBS WDJ,
2651: WIP_ENTITIES WE,
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,

Line 2748: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2744: FROM WIP_DISCRETE_JOBS WDJ,
2745: WIP_ENTITIES WE,
2746: CSI_ITEM_INSTANCES CII,
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,

Line 2865: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2861: 'Y' INCLUDE_FOR_COST_AGGR
2862: FROM WIP_DISCRETE_JOBS WDJ,
2863: WIP_ENTITIES WE,
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,

Line 2960: MTL_SYSTEM_ITEMS_KFV MSIKFV,

2956: 'Y' INCLUDE_FOR_COST_AGGR
2957: FROM WIP_DISCRETE_JOBS WDJ,
2958: WIP_ENTITIES WE,
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,

Line 3083: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3079: 'Y' INCLUDE_FOR_COST_AGGR
3080: FROM WIP_DISCRETE_JOBS WDJ,
3081: WIP_ENTITIES WE,
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,

Line 3194: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3190: FROM WIP_DISCRETE_JOBS WDJ,
3191: WIP_ENTITIES WE,
3192: CSI_ITEM_INSTANCES CII,
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,

Line 3324: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3320: FROM WIP_DISCRETE_JOBS WDJ,
3321: WIP_ENTITIES WE,
3322: CSI_ITEM_INSTANCES CII,
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,

Line 3454: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3450: 'Y' INCLUDE_FOR_COST_AGGR
3451: FROM WIP_DISCRETE_JOBS WDJ,
3452: WIP_ENTITIES WE,
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,

Line 3576: MTL_SYSTEM_ITEMS_KFV MSIKFV,

3572: 'Y' INCLUDE_FOR_COST_AGGR
3573: FROM WIP_DISCRETE_JOBS WDJ,
3574: WIP_ENTITIES WE,
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,

Line 4236: MTL_SYSTEM_ITEMS_KFV MSIKFV,

4232: l_sql_stmt2 := ' FROM WIP_DISCRETE_JOBS WDJ,
4233: WIP_ENTITIES WE,
4234: CSI_ITEM_INSTANCES CII,
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,

Line 4291: MTL_SYSTEM_ITEMS_KFV MSIKFV,

4287: EAFC.COMMENTS
4288: FROM WIP_DISCRETE_JOBS WDJ,
4289: CSI_ITEM_INSTANCES CII,
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,

Line 4334: MTL_SYSTEM_ITEMS_KFV MSIKFV,

4330: MEL.LOCATION_CODES ASSET_LOCATION,
4331: BD.DEPARTMENT_CODE OWNING_DEPARTMENT
4332: FROM MTL_SERIAL_NUMBERS MSN,
4333: MTL_CATEGORIES_KFV MCKFV,
4334: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4335: MTL_EAM_LOCATIONS MEL,
4336: BOM_DEPARTMENTS BD,
4337: CSI_ITEM_INSTANCES CII,
4338: (SELECT * FROM EAM_ORG_MAINT_DEFAULTS WHERE ORGANIZATION_ID= '||l_org_id|| ' ) EOMD1 ' ||

Line 4470: MTL_SYSTEM_ITEMS_KFV MSIKFV,

4466: FROM WIP_DISCRETE_JOBS WDJ,
4467: WIP_ENTITIES WE,
4468: CSI_ITEM_INSTANCES CII,
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,

Line 4560: MTL_SYSTEM_ITEMS_KFV MSIKFV,

4556:
4557: FROM WIP_DISCRETE_JOBS WDJ,
4558: CSI_ITEM_INSTANCES CII,
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,

Line 4604: MTL_SYSTEM_ITEMS_KFV MSIKFV,

4600: MEL.LOCATION_CODES ASSET_LOCATION,
4601: BD.DEPARTMENT_CODE OWNING_DEPARTMENT
4602: FROM MTL_SERIAL_NUMBERS MSN,
4603: MTL_CATEGORIES_KFV MCKFV,
4604: MTL_SYSTEM_ITEMS_KFV MSIKFV,
4605: MTL_EAM_LOCATIONS MEL,
4606: BOM_DEPARTMENTS BD,
4607: CSI_ITEM_INSTANCES CII,
4608: (SELECT * FROM EAM_ORG_MAINT_DEFAULTS WHERE ORGANIZATION_ID= '||l_org_id|| ' ) EOMD1 ' ||