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_CATEGORIES_KFV

Line 328: MTL_CATEGORIES_KFV MCKFV,

324: CII.CREATION_DATE ASSET_CREATION_DATE
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,

Line 521: MTL_CATEGORIES_KFV MCKFV,

517: CII.LAST_VLD_ORGANIZATION_ID ASSET_ORGANIZATION_ID
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,

Line 680: MTL_CATEGORIES_KFV MCKFV,

676: METER.METER_ID
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,

Line 925: MTL_CATEGORIES_KFV MCKFV,

921: NULL METER_ID
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,

Line 1026: MTL_CATEGORIES_KFV MCKFV,

1022: NULL METER_ID
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,

Line 1128: MTL_CATEGORIES_KFV MCKFV,

1124: METER.PRIMARY_FAILURE_METER
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,

Line 1273: MTL_CATEGORIES_KFV MCKFV,

1269: METER.PRIMARY_FAILURE_METER
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,

Line 1808: MTL_CATEGORIES_KFV MCKFV,

1804: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 1900: MTL_CATEGORIES_KFV MCKFV,

1896: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 1992: MTL_CATEGORIES_KFV MCKFV,

1988: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2091: MTL_CATEGORIES_KFV MCKFV,

2087: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2176: MTL_CATEGORIES_KFV MCKFV,

2172: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 2266: MTL_CATEGORIES_KFV MCKFV,

2262: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 2355: MTL_CATEGORIES_KFV MCKFV,

2351: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2450: MTL_CATEGORIES_KFV MCKFV,

2446: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2535: MTL_CATEGORIES_KFV MCKFV,

2531: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 2652: MTL_CATEGORIES_KFV MCKFV,

2648: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2747: MTL_CATEGORIES_KFV MCKFV,

2743: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 2864: MTL_CATEGORIES_KFV MCKFV,

2860: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2959: MTL_CATEGORIES_KFV MCKFV,

2955: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 3082: MTL_CATEGORIES_KFV MCKFV,

3078: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 3193: MTL_CATEGORIES_KFV MCKFV,

3189: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 3323: MTL_CATEGORIES_KFV MCKFV,

3319: 'Y' INCLUDE_FOR_COST_AGGR
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,

Line 3453: MTL_CATEGORIES_KFV MCKFV,

3449: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 3575: MTL_CATEGORIES_KFV MCKFV,

3571: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 4235: MTL_CATEGORIES_KFV MCKFV,

4231:
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,

Line 4290: MTL_CATEGORIES_KFV MCKFV,

4286: EAF.FAILURE_DATE,
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,

Line 4333: MTL_CATEGORIES_KFV MCKFV,

4329: MCKFV.CONCATENATED_SEGMENTS ASSET_CATEGORY,
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,

Line 4469: MTL_CATEGORIES_KFV MCKFV,

4465: '||'''Y'''||' INCLUDE_FOR_COST_AGGR
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,

Line 4559: MTL_CATEGORIES_KFV MCKFV,

4555: EAFC.COMMENTS
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,

Line 4603: MTL_CATEGORIES_KFV MCKFV,

4599: MCKFV.CONCATENATED_SEGMENTS ASSET_CATEGORY,
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,