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_DISCRETE_JOBS

Line 318: FROM WIP_DISCRETE_JOBS WDJ,

314: METER.CURRENT_READING_DATE CURRENT_READING_DATE,
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,

Line 510: FROM WIP_DISCRETE_JOBS WDJ,

506: ERC.DESCRIPTION RESOLUTION_DESC,
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,

Line 669: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 912: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1013: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1115: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1258: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1788: FROM WIP_DISCRETE_JOBS WDJ,

1784: NULL METER_UOM,
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,

Line 1879: FROM WIP_DISCRETE_JOBS WDJ,

1875: NULL METER_UOM,
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,

Line 1919: WIP_DISCRETE_JOBS WDJ,

1915: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
1916: FROM CSI_ITEM_INSTANCES CII,
1917: EAM_ASSET_FAILURE_CODES EAFC,
1918: EAM_ASSET_FAILURES EAF,
1919: WIP_DISCRETE_JOBS WDJ,
1920: MTL_SERIAL_NUMBERS MSN
1921: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1922: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1923: AND WDJ.STATUS_TYPE IN (4,5,12)

Line 1978: FROM WIP_DISCRETE_JOBS WDJ,

1974: NULL METER_UOM,
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,

Line 2006: WIP_DISCRETE_JOBS WDJ,

2002: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2003: AND EAF.OBJECT_ID IN (SELECT EAF.OBJECT_ID OBJECT_ID --This part will select parent assets
2004: FROM EAM_ASSET_FAILURE_CODES EAFC,
2005: EAM_ASSET_FAILURES EAF,
2006: WIP_DISCRETE_JOBS WDJ,
2007: CSI_ITEM_INSTANCES CII
2008: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2009: AND WDJ.STATUS_TYPE IN (4,5,12)
2010: AND EAF.SOURCE_TYPE = 1

Line 2061: FROM WIP_DISCRETE_JOBS WDJ,

2057: NULL METER_UOM,
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,

Line 2150: FROM WIP_DISCRETE_JOBS WDJ,

2146: NULL METER_UOM,
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,

Line 2189: WIP_DISCRETE_JOBS WDJ,

2185: START WITH PARENT_OBJECT_ID IN
2186: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2187: FROM EAM_ASSET_FAILURE_CODES EAFC,
2188: EAM_ASSET_FAILURES EAF,
2189: WIP_DISCRETE_JOBS WDJ,
2190: MTL_SERIAL_NUMBERS MSN,
2191: CSI_ITEM_INSTANCES CII
2192: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2193: AND WDJ.STATUS_TYPE IN (4,5,12)

Line 2245: FROM WIP_DISCRETE_JOBS WDJ,

2241: NULL METER_UOM,
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,

Line 2273: WIP_DISCRETE_JOBS WDJ,

2269: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2270: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
2271: FROM EAM_ASSET_FAILURE_CODES EAFC,
2272: EAM_ASSET_FAILURES EAF,
2273: WIP_DISCRETE_JOBS WDJ,
2274: CSI_ITEM_INSTANCES
2275: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2276: AND WDJ.STATUS_TYPE IN (4,5,12)
2277: AND EAF.SOURCE_TYPE = 1

Line 2328: FROM WIP_DISCRETE_JOBS WDJ,

2324: (METER.CURRENT_READING -
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,

Line 2446: FROM WIP_DISCRETE_JOBS WDJ,

2442: (METER.CURRENT_READING -
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,

Line 2539: FROM WIP_DISCRETE_JOBS WDJ,

2535: (METER.CURRENT_READING -
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,

Line 2607: WIP_DISCRETE_JOBS WDJ,

2603: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2604: FROM CSI_ITEM_INSTANCES CII,
2605: EAM_ASSET_FAILURE_CODES EAFC,
2606: EAM_ASSET_FAILURES EAF,
2607: WIP_DISCRETE_JOBS WDJ,
2608: MTL_SERIAL_NUMBERS MSN
2609: WHERE NVL(WDJ.STATUS_TYPE,4) IN (4,5,12)
2610: AND EAF.SOURCE_TYPE(+) = 1
2611: AND EAF.OBJECT_TYPE(+) = 3

Line 2662: FROM WIP_DISCRETE_JOBS WDJ,

2658: (METER.CURRENT_READING -
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,

Line 2713: WIP_DISCRETE_JOBS WDJ,

2709: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
2710: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
2711: FROM EAM_ASSET_FAILURE_CODES EAFC,
2712: EAM_ASSET_FAILURES EAF,
2713: WIP_DISCRETE_JOBS WDJ,
2714: CSI_ITEM_INSTANCES CII
2715: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2716: AND WDJ.STATUS_TYPE IN (4,5,12)
2717: AND EAF.SOURCE_TYPE = 1

Line 2771: FROM WIP_DISCRETE_JOBS WDJ,

2767: (METER.CURRENT_READING -
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,

Line 2900: FROM WIP_DISCRETE_JOBS WDJ,

2896: (METER.CURRENT_READING -
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,

Line 2963: WIP_DISCRETE_JOBS WDJ,

2959: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2960: FROM CSI_ITEM_INSTANCES CII,
2961: EAM_ASSET_FAILURE_CODES EAFC,
2962: EAM_ASSET_FAILURES EAF,
2963: WIP_DISCRETE_JOBS WDJ,
2964: MTL_SERIAL_NUMBERS MSN
2965: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
2966: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
2967: AND WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 3022: FROM WIP_DISCRETE_JOBS WDJ,

3018: (METER.CURRENT_READING -
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,

Line 3073: WIP_DISCRETE_JOBS WDJ,

3069: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3070: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
3071: FROM EAM_ASSET_FAILURE_CODES EAFC,
3072: EAM_ASSET_FAILURES EAF,
3073: WIP_DISCRETE_JOBS WDJ,
3074: CSI_ITEM_INSTANCES CII
3075: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3076: AND WDJ.STATUS_TYPE IN (4,5,12)
3077: AND EAF.SOURCE_TYPE = 1

Line 3556: l_sql_stmt2 := ' FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3612: FROM WIP_DISCRETE_JOBS WDJ,

3608: EAFC.RESOLUTION_CODE,
3609: ERC.DESCRIPTION RESOLUTION_DESC,
3610: EAF.FAILURE_DATE,
3611: EAFC.COMMENTS
3612: FROM WIP_DISCRETE_JOBS WDJ,
3613: CSI_ITEM_INSTANCES CII,
3614: MTL_CATEGORIES_KFV MCKFV,
3615: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3616: MTL_EAM_LOCATIONS MEL,

Line 3790: FROM WIP_DISCRETE_JOBS WDJ,

3786: (METER.CURRENT_READING -
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,

Line 3881: FROM WIP_DISCRETE_JOBS WDJ,

3877: ERC.DESCRIPTION RESOLUTION_DESC,
3878: EAF.FAILURE_DATE,
3879: EAFC.COMMENTS
3880:
3881: FROM WIP_DISCRETE_JOBS WDJ,
3882: CSI_ITEM_INSTANCES CII,
3883: MTL_CATEGORIES_KFV MCKFV,
3884: MTL_SYSTEM_ITEMS_KFV MSIKFV,
3885: MTL_EAM_LOCATIONS MEL,