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 325: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 518: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 677: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 922: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1023: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1125: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1270: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1770: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

1766: l_msg_data VARCHAR2(500);
1767: l_return_status VARCHAR2(1) := 'S';
1768: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria] - View By Asset Category */
1769: CURSOR c_recs_ac_simple IS
1770: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
1771: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
1772: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
1773: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
1774: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 1805: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1862: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

1858: ) ;
1859:
1860: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria and l_gen_object_id is not null] - View By Asset Category */
1861: CURSOR c_recs_ac_simple_1 IS
1862: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
1863: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
1864: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
1865: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
1866: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 1897: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 1955: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

1951:
1952:
1953: /* [Parent + Child Failure WOs][When ANY of failure code/from date/to date have been entered as search criteria] - View By Asset Category */
1954: CURSOR c_recs_wo_ac_simple IS
1955: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
1956: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
1957: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
1958: NVL(WDJ.ASSET_NUMBER, WDJ.REBUILD_SERIAL_NUMBER) MAINTAINED_NUMBER,
1959: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 1990: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2030: WIP_DISCRETE_JOBS WDJ,

2026: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2027: FROM CSI_ITEM_INSTANCES CII,
2028: EAM_ASSET_FAILURE_CODES EAFC,
2029: EAM_ASSET_FAILURES EAF,
2030: WIP_DISCRETE_JOBS WDJ,
2031: MTL_SERIAL_NUMBERS MSN
2032: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2033: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2034: AND WDJ.STATUS_TYPE IN (4,5,12)

Line 2089: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2117: WIP_DISCRETE_JOBS WDJ,

2113: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2114: AND EAF.OBJECT_ID IN (SELECT EAF.OBJECT_ID OBJECT_ID --This part will select parent assets
2115: FROM EAM_ASSET_FAILURE_CODES EAFC,
2116: EAM_ASSET_FAILURES EAF,
2117: WIP_DISCRETE_JOBS WDJ,
2118: CSI_ITEM_INSTANCES CII
2119: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2120: AND WDJ.STATUS_TYPE IN (4,5,12)
2121: AND EAF.SOURCE_TYPE = 1

Line 2138: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

2134:
2135: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria] - View By Failure Code */
2136:
2137: CURSOR c_recs_fc_simple IS
2138: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
2139: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
2140: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
2141: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
2142: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 2173: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2228: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

2224: ) ;
2225: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria and l_gen_object_id is not null] - View By Failure Code */
2226:
2227: CURSOR c_recs_fc_simple_1 IS
2228: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
2229: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
2230: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
2231: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
2232: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 2263: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2318: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

2314: ) ;
2315:
2316: /* [Parent + Child Failure WOs][When ANY of failure code/from date/to date have been entered as search criteria] - View By Failure Code */
2317: CURSOR c_recs_wo_fc_simple IS
2318: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
2319: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
2320: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
2321: NVL(WDJ.ASSET_NUMBER, WDJ.REBUILD_SERIAL_NUMBER) MAINTAINED_NUMBER,
2322: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 2353: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2392: WIP_DISCRETE_JOBS WDJ,

2388: START WITH PARENT_OBJECT_ID IN
2389: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
2390: FROM EAM_ASSET_FAILURE_CODES EAFC,
2391: EAM_ASSET_FAILURES EAF,
2392: WIP_DISCRETE_JOBS WDJ,
2393: MTL_SERIAL_NUMBERS MSN,
2394: CSI_ITEM_INSTANCES CII
2395: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2396: AND WDJ.STATUS_TYPE IN (4,5,12)

Line 2448: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2476: WIP_DISCRETE_JOBS WDJ,

2472: AND BD.DEPARTMENT_ID (+) = EAF.DEPARTMENT_ID
2473: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
2474: FROM EAM_ASSET_FAILURE_CODES EAFC,
2475: EAM_ASSET_FAILURES EAF,
2476: WIP_DISCRETE_JOBS WDJ,
2477: CSI_ITEM_INSTANCES
2478: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2479: AND WDJ.STATUS_TYPE IN (4,5,12)
2480: AND EAF.SOURCE_TYPE = 1

Line 2497: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

2493:
2494: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria] - View By Asset Number */
2495:
2496: CURSOR c_meter_recs_an_simple IS
2497: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
2498: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
2499: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
2500: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
2501: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 2532: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2650: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2709: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

2705: )));
2706: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria and l_gen_object_id is not null] - View By Asset Number */
2707:
2708: CURSOR c_meter_recs_an_simple_1 IS
2709: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
2710: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
2711: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
2712: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
2713: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 2744: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2862: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 2922: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

2918:
2919:
2920: /* [Parent + Child Failure WOs][When ANY of failure code/from date/to date have been entered as search criteria] - View By Asset Number */
2921: CURSOR c_meter_recs_wo_an_simple IS
2922: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
2923: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
2924: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
2925: CII.INSTANCE_NUMBER,
2926: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 2957: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3025: WIP_DISCRETE_JOBS WDJ,

3021: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3022: FROM CSI_ITEM_INSTANCES CII,
3023: EAM_ASSET_FAILURE_CODES EAFC,
3024: EAM_ASSET_FAILURES EAF,
3025: WIP_DISCRETE_JOBS WDJ,
3026: MTL_SERIAL_NUMBERS MSN
3027: WHERE NVL(WDJ.STATUS_TYPE,4) IN (4,5,12)
3028: AND EAF.SOURCE_TYPE(+) = 1
3029: AND EAF.OBJECT_TYPE(+) = 3

Line 3080: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3131: WIP_DISCRETE_JOBS WDJ,

3127: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3128: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
3129: FROM EAM_ASSET_FAILURE_CODES EAFC,
3130: EAM_ASSET_FAILURES EAF,
3131: WIP_DISCRETE_JOBS WDJ,
3132: CSI_ITEM_INSTANCES CII
3133: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3134: AND WDJ.STATUS_TYPE IN (4,5,12)
3135: AND EAF.SOURCE_TYPE = 1

Line 3151: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

3147:
3148: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria] - View By Asset Group */
3149:
3150: CURSOR c_meter_recs_ag_simple IS
3151: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
3152: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
3153: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
3154: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
3155: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 3190: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3281: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

3277: ) ;
3278: /* [Parent + Child Failure WOs][When NONE of failure code/from date/to date have been entered as search criteria and l_gen_object_id is not null] - View By Asset Group */
3279:
3280: CURSOR c_meter_recs_ag_simple_1 IS
3281: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
3282: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
3283: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
3284: CII.INSTANCE_NUMBER MAINTAINED_NUMBER,
3285: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 3320: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3412: SELECT /+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) /

3408:
3409:
3410: /* [Parent + Child Failure WOs][When ANY of failure code/from date/to date have been entered as search criteria] - View By Asset Group */
3411: CURSOR c_meter_recs_wo_ag_simple IS
3412: SELECT /*+ use_nl(EAF WDJ) index(WDJ WIP_DISCRETE_JOBS_U1) */
3413: MSIKFV.EAM_ITEM_TYPE ASSET_TYPE,
3414: EAF.OBJECT_ID MAINTENANCE_OBJECT_ID,
3415: NVL(WDJ.ASSET_NUMBER, WDJ.REBUILD_SERIAL_NUMBER) MAINTAINED_NUMBER,
3416: CII.INSTANCE_DESCRIPTION AS DESCRIPTIVE_TEXT,

Line 3451: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3514: WIP_DISCRETE_JOBS WDJ,

3510: ( SELECT MSN.GEN_OBJECT_ID PARENT_OBJECT_ID
3511: FROM CSI_ITEM_INSTANCES CII,
3512: EAM_ASSET_FAILURE_CODES EAFC,
3513: EAM_ASSET_FAILURES EAF,
3514: WIP_DISCRETE_JOBS WDJ,
3515: MTL_SERIAL_NUMBERS MSN
3516: WHERE CII.INVENTORY_ITEM_ID = MSN.INVENTORY_ITEM_ID
3517: AND CII.SERIAL_NUMBER = MSN.SERIAL_NUMBER
3518: AND WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID

Line 3573: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 3624: WIP_DISCRETE_JOBS WDJ,

3620: AND METER.WIP_ENTITY_ID (+) = EAF.SOURCE_ID
3621: AND EAF.OBJECT_ID IN ( SELECT EAF.OBJECT_ID OBJECT_ID --This part will select all parent assets
3622: FROM EAM_ASSET_FAILURE_CODES EAFC,
3623: EAM_ASSET_FAILURES EAF,
3624: WIP_DISCRETE_JOBS WDJ,
3625: CSI_ITEM_INSTANCES CII
3626: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3627: AND WDJ.STATUS_TYPE IN (4,5,12)
3628: AND EAF.SOURCE_TYPE = 1

Line 4232: l_sql_stmt2 := ' FROM WIP_DISCRETE_JOBS WDJ,

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

Line 4288: FROM WIP_DISCRETE_JOBS WDJ,

4284: EAFC.RESOLUTION_CODE,
4285: ERC.DESCRIPTION RESOLUTION_DESC,
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,

Line 4466: FROM WIP_DISCRETE_JOBS WDJ,

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

Line 4557: FROM WIP_DISCRETE_JOBS WDJ,

4553: ERC.DESCRIPTION RESOLUTION_DESC,
4554: EAF.FAILURE_DATE,
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,