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 WIP_ENTITIES

Line 319: WIP_ENTITIES WE,

315: CII.LAST_VLD_ORGANIZATION_ID ASSET_ORGANIZATION_ID,
316: METER.METER_TYPE,
317: CII.CREATION_DATE ASSET_CREATION_DATE
318: FROM WIP_DISCRETE_JOBS WDJ,
319: WIP_ENTITIES WE,
320: CSI_ITEM_INSTANCES CII,
321: MTL_CATEGORIES_KFV MCKFV,
322: MTL_SYSTEM_ITEMS_KFV MSIKFV,
323: MTL_EAM_LOCATIONS MEL,

Line 511: WIP_ENTITIES WE,

507: EAF.FAILURE_DATE,
508: EAFC.COMMENTS,
509: CII.LAST_VLD_ORGANIZATION_ID ASSET_ORGANIZATION_ID
510: FROM WIP_DISCRETE_JOBS WDJ,
511: WIP_ENTITIES WE,
512: CSI_ITEM_INSTANCES CII,
513: MTL_CATEGORIES_KFV MCKFV,
514: MTL_SYSTEM_ITEMS_KFV MSIKFV,
515: MTL_EAM_LOCATIONS MEL,

Line 670: WIP_ENTITIES WE,

666: 'Y' INCLUDE_FOR_COST_AGGR,
667: METER.PRIMARY_FAILURE_METER,
668: METER.METER_ID
669: FROM WIP_DISCRETE_JOBS WDJ,
670: WIP_ENTITIES WE,
671: CSI_ITEM_INSTANCES CII,
672: MTL_CATEGORIES_KFV MCKFV,
673: MTL_SYSTEM_ITEMS_KFV MSIKFV,
674: MTL_EAM_LOCATIONS MEL,

Line 913: WIP_ENTITIES WE,

909: 'Y' INCLUDE_FOR_READING_AGGR,
910: 'Y' INCLUDE_FOR_COST_AGGR,
911: NULL METER_ID
912: FROM WIP_DISCRETE_JOBS WDJ,
913: WIP_ENTITIES WE,
914: CSI_ITEM_INSTANCES CII,
915: MTL_CATEGORIES_KFV MCKFV,
916: MTL_SYSTEM_ITEMS_KFV MSIKFV,
917: MTL_EAM_LOCATIONS MEL,

Line 1014: WIP_ENTITIES WE,

1010: 'Y' INCLUDE_FOR_READING_AGGR,
1011: 'Y' INCLUDE_FOR_COST_AGGR,
1012: NULL METER_ID
1013: FROM WIP_DISCRETE_JOBS WDJ,
1014: WIP_ENTITIES WE,
1015: CSI_ITEM_INSTANCES CII,
1016: MTL_CATEGORIES_KFV MCKFV,
1017: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1018: MTL_EAM_LOCATIONS MEL,

Line 1116: WIP_ENTITIES WE,

1112: 'Y' INCLUDE_FOR_COST_AGGR,
1113: METER.METER_ID,
1114: METER.PRIMARY_FAILURE_METER
1115: FROM WIP_DISCRETE_JOBS WDJ,
1116: WIP_ENTITIES WE,
1117: CSI_ITEM_INSTANCES CII,
1118: MTL_CATEGORIES_KFV MCKFV,
1119: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1120: MTL_EAM_LOCATIONS MEL,

Line 1259: WIP_ENTITIES WE,

1255: 'Y' INCLUDE_FOR_COST_AGGR,
1256: METER.METER_ID,
1257: METER.PRIMARY_FAILURE_METER
1258: FROM WIP_DISCRETE_JOBS WDJ,
1259: WIP_ENTITIES WE,
1260: CSI_ITEM_INSTANCES CII,
1261: MTL_CATEGORIES_KFV MCKFV,
1262: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1263: MTL_EAM_LOCATIONS MEL,

Line 1789: WIP_ENTITIES WE,

1785: NULL READING_BETWEEN_FAILURES,
1786: 'Y' INCLUDE_FOR_READING_AGGR,
1787: 'Y' INCLUDE_FOR_COST_AGGR
1788: FROM WIP_DISCRETE_JOBS WDJ,
1789: WIP_ENTITIES WE,
1790: CSI_ITEM_INSTANCES CII,
1791: MTL_CATEGORIES_KFV MCKFV,
1792: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1793: MTL_EAM_LOCATIONS MEL,

Line 1880: WIP_ENTITIES WE,

1876: NULL READING_BETWEEN_FAILURES,
1877: 'Y' INCLUDE_FOR_READING_AGGR,
1878: 'Y' INCLUDE_FOR_COST_AGGR
1879: FROM WIP_DISCRETE_JOBS WDJ,
1880: WIP_ENTITIES WE,
1881: MTL_CATEGORIES_KFV MCKFV,
1882: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1883: MTL_EAM_LOCATIONS MEL,
1884: BOM_DEPARTMENTS BD,

Line 1979: WIP_ENTITIES WE,

1975: NULL READING_BETWEEN_FAILURES,
1976: 'Y' INCLUDE_FOR_READING_AGGR,
1977: 'Y' INCLUDE_FOR_COST_AGGR
1978: FROM WIP_DISCRETE_JOBS WDJ,
1979: WIP_ENTITIES WE,
1980: MTL_CATEGORIES_KFV MCKFV,
1981: MTL_SYSTEM_ITEMS_KFV MSIKFV,
1982: MTL_EAM_LOCATIONS MEL,
1983: BOM_DEPARTMENTS BD,

Line 2062: WIP_ENTITIES WE,

2058: NULL READING_BETWEEN_FAILURES,
2059: 'Y' INCLUDE_FOR_READING_AGGR,
2060: 'Y' INCLUDE_FOR_COST_AGGR
2061: FROM WIP_DISCRETE_JOBS WDJ,
2062: WIP_ENTITIES WE,
2063: CSI_ITEM_INSTANCES CII,
2064: MTL_CATEGORIES_KFV MCKFV,
2065: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2066: MTL_EAM_LOCATIONS MEL,

Line 2151: WIP_ENTITIES WE,

2147: NULL READING_BETWEEN_FAILURES,
2148: 'Y' INCLUDE_FOR_READING_AGGR,
2149: 'Y' INCLUDE_FOR_COST_AGGR
2150: FROM WIP_DISCRETE_JOBS WDJ,
2151: WIP_ENTITIES WE,
2152: MTL_CATEGORIES_KFV MCKFV,
2153: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2154: MTL_EAM_LOCATIONS MEL,
2155: BOM_DEPARTMENTS BD,

Line 2246: WIP_ENTITIES WE,

2242: NULL READING_BETWEEN_FAILURES,
2243: 'Y' INCLUDE_FOR_READING_AGGR,
2244: 'Y' INCLUDE_FOR_COST_AGGR
2245: FROM WIP_DISCRETE_JOBS WDJ,
2246: WIP_ENTITIES WE,
2247: MTL_CATEGORIES_KFV MCKFV,
2248: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2249: MTL_EAM_LOCATIONS MEL,
2250: BOM_DEPARTMENTS BD,

Line 2329: WIP_ENTITIES WE,

2325: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2326: 'Y' INCLUDE_FOR_READING_AGGR,
2327: 'Y' INCLUDE_FOR_COST_AGGR
2328: FROM WIP_DISCRETE_JOBS WDJ,
2329: WIP_ENTITIES WE,
2330: CSI_ITEM_INSTANCES CII,
2331: MTL_CATEGORIES_KFV MCKFV,
2332: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2333: MTL_EAM_LOCATIONS MEL,

Line 2447: WIP_ENTITIES WE,

2443: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2444: 'Y' INCLUDE_FOR_READING_AGGR,
2445: 'Y' INCLUDE_FOR_COST_AGGR
2446: FROM WIP_DISCRETE_JOBS WDJ,
2447: WIP_ENTITIES WE,
2448: MTL_CATEGORIES_KFV MCKFV,
2449: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2450: MTL_EAM_LOCATIONS MEL,
2451: BOM_DEPARTMENTS BD,

Line 2540: WIP_ENTITIES WE,

2536: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2537: 'Y' INCLUDE_FOR_READING_AGGR,
2538: 'Y' INCLUDE_FOR_COST_AGGR
2539: FROM WIP_DISCRETE_JOBS WDJ,
2540: WIP_ENTITIES WE,
2541: MTL_CATEGORIES_KFV MCKFV,
2542: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2543: MTL_EAM_LOCATIONS MEL,
2544: BOM_DEPARTMENTS BD,

Line 2663: WIP_ENTITIES WE,

2659: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2660: 'Y' INCLUDE_FOR_READING_AGGR,
2661: 'Y' INCLUDE_FOR_COST_AGGR
2662: FROM WIP_DISCRETE_JOBS WDJ,
2663: WIP_ENTITIES WE,
2664: MTL_CATEGORIES_KFV MCKFV,
2665: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2666: MTL_EAM_LOCATIONS MEL,
2667: BOM_DEPARTMENTS BD,

Line 2772: WIP_ENTITIES WE,

2768: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2769: 'Y' INCLUDE_FOR_READING_AGGR,
2770: 'Y' INCLUDE_FOR_COST_AGGR
2771: FROM WIP_DISCRETE_JOBS WDJ,
2772: WIP_ENTITIES WE,
2773: CSI_ITEM_INSTANCES CII,
2774: MTL_CATEGORIES_KFV MCKFV,
2775: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2776: MTL_EAM_LOCATIONS MEL,

Line 2901: WIP_ENTITIES WE,

2897: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
2898: 'Y' INCLUDE_FOR_READING_AGGR,
2899: 'Y' INCLUDE_FOR_COST_AGGR
2900: FROM WIP_DISCRETE_JOBS WDJ,
2901: WIP_ENTITIES WE,
2902: MTL_CATEGORIES_KFV MCKFV,
2903: MTL_SYSTEM_ITEMS_KFV MSIKFV,
2904: MTL_EAM_LOCATIONS MEL,
2905: BOM_DEPARTMENTS BD,

Line 3023: WIP_ENTITIES WE,

3019: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
3020: 'Y' INCLUDE_FOR_READING_AGGR,
3021: 'Y' INCLUDE_FOR_COST_AGGR
3022: FROM WIP_DISCRETE_JOBS WDJ,
3023: WIP_ENTITIES WE,
3024: MTL_CATEGORIES_KFV MCKFV,
3025: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3026: MTL_EAM_LOCATIONS MEL,
3027: BOM_DEPARTMENTS BD,

Line 3557: WIP_ENTITIES WE,

3553: '||'''Y'''||' INCLUDE_FOR_READING_AGGR,
3554: '||'''Y'''||' INCLUDE_FOR_COST_AGGR ';
3555:
3556: l_sql_stmt2 := ' FROM WIP_DISCRETE_JOBS WDJ,
3557: WIP_ENTITIES WE,
3558: CSI_ITEM_INSTANCES CII,
3559: MTL_CATEGORIES_KFV MCKFV,
3560: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3561: MTL_EAM_LOCATIONS MEL,

Line 3791: WIP_ENTITIES WE,

3787: (LAG(METER.CURRENT_READING,1,NULL) OVER ( PARTITION BY EAF.OBJECT_ID, METER.METER_ID ORDER BY WDJ.DATE_COMPLETED ))) )) READING_BETWEEN_FAILURES,
3788: '||'''Y'''||' INCLUDE_FOR_READING_AGGR,
3789: '||'''Y'''||' INCLUDE_FOR_COST_AGGR
3790: FROM WIP_DISCRETE_JOBS WDJ,
3791: WIP_ENTITIES WE,
3792: CSI_ITEM_INSTANCES CII,
3793: MTL_CATEGORIES_KFV MCKFV,
3794: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3795: MTL_EAM_LOCATIONS MEL,