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.

[Home] [Help]

APPS.EAM_FAILURE_ANALYSIS_PVT dependencies on WIP_ENTITIES

Line 326: WIP_ENTITIES WE,

322: CII.LAST_VLD_ORGANIZATION_ID ASSET_ORGANIZATION_ID,
323: METER.METER_TYPE,
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,

Line 519: WIP_ENTITIES WE,

515: EAF.FAILURE_DATE,
516: EAFC.COMMENTS,
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,

Line 678: WIP_ENTITIES WE,

674: 'Y' INCLUDE_FOR_COST_AGGR,
675: METER.PRIMARY_FAILURE_METER,
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,

Line 923: WIP_ENTITIES WE,

919: 'Y' INCLUDE_FOR_READING_AGGR,
920: 'Y' INCLUDE_FOR_COST_AGGR,
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,

Line 1024: WIP_ENTITIES WE,

1020: 'Y' INCLUDE_FOR_READING_AGGR,
1021: 'Y' INCLUDE_FOR_COST_AGGR,
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,

Line 1126: WIP_ENTITIES WE,

1122: 'Y' INCLUDE_FOR_COST_AGGR,
1123: METER.METER_ID,
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,

Line 1271: WIP_ENTITIES WE,

1267: 'Y' INCLUDE_FOR_COST_AGGR,
1268: METER.METER_ID,
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,

Line 1806: WIP_ENTITIES WE,

1802: NULL READING_BETWEEN_FAILURES,
1803: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 1898: WIP_ENTITIES WE,

1894: NULL READING_BETWEEN_FAILURES,
1895: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 1991: WIP_ENTITIES WE,

1987: NULL READING_BETWEEN_FAILURES,
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,

Line 2090: WIP_ENTITIES WE,

2086: NULL READING_BETWEEN_FAILURES,
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,

Line 2174: WIP_ENTITIES WE,

2170: NULL READING_BETWEEN_FAILURES,
2171: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2264: WIP_ENTITIES WE,

2260: NULL READING_BETWEEN_FAILURES,
2261: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2354: WIP_ENTITIES WE,

2350: NULL READING_BETWEEN_FAILURES,
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,

Line 2449: WIP_ENTITIES WE,

2445: NULL READING_BETWEEN_FAILURES,
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,

Line 2533: WIP_ENTITIES WE,

2529: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2530: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2651: WIP_ENTITIES WE,

2647: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
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,

Line 2745: WIP_ENTITIES WE,

2741: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2742: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 2863: WIP_ENTITIES WE,

2859: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
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,

Line 2958: WIP_ENTITIES WE,

2954: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
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,

Line 3081: WIP_ENTITIES WE,

3077: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
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,

Line 3191: WIP_ENTITIES WE,

3187: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
3188: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 3321: WIP_ENTITIES WE,

3317: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
3318: 'Y' INCLUDE_FOR_READING_AGGR,
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,

Line 3452: WIP_ENTITIES WE,

3448: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
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,

Line 3574: WIP_ENTITIES WE,

3570: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
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,

Line 4233: WIP_ENTITIES WE,

4229: '||'''Y'''||' INCLUDE_FOR_READING_AGGR,
4230: '||'''Y'''||' INCLUDE_FOR_COST_AGGR ';
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,

Line 4467: WIP_ENTITIES WE,

4463: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
4464: '||'''Y'''||' INCLUDE_FOR_READING_AGGR,
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,