[Home] [Help]
330: MTL_EAM_LOCATIONS MEL,
331: BOM_DEPARTMENTS BD,
332: EAM_ASSET_FAILURE_CODES EAFC,
333: EAM_ASSET_FAILURES EAF,
334: ORG_ORGANIZATION_DEFINITIONS OOD,
335: EAM_FAILURE_CODES EFC,
336: EAM_CAUSE_CODES ECC,
337: EAM_RESOLUTION_CODES ERC,
338: (SELECT
523: MTL_EAM_LOCATIONS MEL,
524: BOM_DEPARTMENTS BD,
525: EAM_ASSET_FAILURE_CODES EAFC,
526: EAM_ASSET_FAILURES EAF,
527: ORG_ORGANIZATION_DEFINITIONS OOD,
528: EAM_FAILURE_CODES EFC,
529: EAM_CAUSE_CODES ECC,
530: EAM_RESOLUTION_CODES ERC
531: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
682: MTL_EAM_LOCATIONS MEL,
683: BOM_DEPARTMENTS BD,
684: EAM_ASSET_FAILURE_CODES EAFC,
685: EAM_ASSET_FAILURES EAF,
686: ORG_ORGANIZATION_DEFINITIONS OOD,
687: (SELECT
688: ccb.counter_id METER_ID,
689: cctl.name METER_NAME,
690: ccb.uom_code METER_UOM,
927: MTL_EAM_LOCATIONS MEL,
928: BOM_DEPARTMENTS BD,
929: EAM_ASSET_FAILURE_CODES EAFC,
930: EAM_ASSET_FAILURES EAF,
931: ORG_ORGANIZATION_DEFINITIONS OOD
932: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
933: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
934: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
935: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1028: MTL_EAM_LOCATIONS MEL,
1029: BOM_DEPARTMENTS BD,
1030: EAM_ASSET_FAILURE_CODES EAFC,
1031: EAM_ASSET_FAILURES EAF,
1032: ORG_ORGANIZATION_DEFINITIONS OOD
1033: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1034: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1035: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
1036: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1130: MTL_EAM_LOCATIONS MEL,
1131: BOM_DEPARTMENTS BD,
1132: EAM_ASSET_FAILURE_CODES EAFC,
1133: EAM_ASSET_FAILURES EAF,
1134: ORG_ORGANIZATION_DEFINITIONS OOD,
1135: (SELECT
1136: ccb.counter_id METER_ID,
1137: cctl.name METER_NAME,
1138: ccb.uom_code METER_UOM,
1275: MTL_EAM_LOCATIONS MEL,
1276: BOM_DEPARTMENTS BD,
1277: EAM_ASSET_FAILURE_CODES EAFC,
1278: EAM_ASSET_FAILURES EAF,
1279: ORG_ORGANIZATION_DEFINITIONS OOD,
1280: (SELECT
1281: ccb.counter_id METER_ID,
1282: cctl.name METER_NAME,
1283: ccb.uom_code METER_UOM,
1810: MTL_EAM_LOCATIONS MEL,
1811: BOM_DEPARTMENTS BD,
1812: EAM_ASSET_FAILURE_CODES EAFC,
1813: EAM_ASSET_FAILURES EAF,
1814: ORG_ORGANIZATION_DEFINITIONS OOD
1815: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1816: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1817: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
1818: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1902: MTL_EAM_LOCATIONS MEL,
1903: BOM_DEPARTMENTS BD,
1904: EAM_ASSET_FAILURE_CODES EAFC,
1905: EAM_ASSET_FAILURES EAF,
1906: ORG_ORGANIZATION_DEFINITIONS OOD
1907: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1908: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1909: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
1910: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1995: BOM_DEPARTMENTS BD,
1996: EAM_ASSET_FAILURE_CODES EAFC,
1997: EAM_ASSET_FAILURES EAF,
1998: CSI_ITEM_INSTANCES CII,
1999: ORG_ORGANIZATION_DEFINITIONS OOD
2000: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2001: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2002: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
2003: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2093: MTL_EAM_LOCATIONS MEL,
2094: BOM_DEPARTMENTS BD,
2095: EAM_ASSET_FAILURE_CODES EAFC,
2096: EAM_ASSET_FAILURES EAF,
2097: ORG_ORGANIZATION_DEFINITIONS OOD,
2098: CSI_ITEM_INSTANCES CII
2099: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2100: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2101: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
2178: MTL_EAM_LOCATIONS MEL,
2179: BOM_DEPARTMENTS BD,
2180: EAM_ASSET_FAILURE_CODES EAFC,
2181: EAM_ASSET_FAILURES EAF,
2182: ORG_ORGANIZATION_DEFINITIONS OOD
2183: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2184: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2185: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
2186: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2268: MTL_EAM_LOCATIONS MEL,
2269: BOM_DEPARTMENTS BD,
2270: EAM_ASSET_FAILURE_CODES EAFC,
2271: EAM_ASSET_FAILURES EAF,
2272: ORG_ORGANIZATION_DEFINITIONS OOD
2273: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2274: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2275: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
2276: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2358: BOM_DEPARTMENTS BD,
2359: EAM_ASSET_FAILURE_CODES EAFC,
2360: EAM_ASSET_FAILURES EAF,
2361: CSI_ITEM_INSTANCES CII,
2362: ORG_ORGANIZATION_DEFINITIONS OOD
2363: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2364: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2365: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
2366: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2453: BOM_DEPARTMENTS BD,
2454: EAM_ASSET_FAILURE_CODES EAFC,
2455: EAM_ASSET_FAILURES EAF,
2456: CSI_ITEM_INSTANCES CII,
2457: ORG_ORGANIZATION_DEFINITIONS OOD
2458: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2459: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2460: AND WDJ.ORGANIZATION_ID + 0 = OOD.ORGANIZATION_ID
2461: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2537: MTL_EAM_LOCATIONS MEL,
2538: BOM_DEPARTMENTS BD,
2539: EAM_ASSET_FAILURE_CODES EAFC,
2540: EAM_ASSET_FAILURES EAF,
2541: ORG_ORGANIZATION_DEFINITIONS OOD,
2542: (SELECT
2543: ccb.counter_id METER_ID,
2544: cctl.name METER_NAME,
2545: ccb.uom_code METER_UOM,
2655: BOM_DEPARTMENTS BD,
2656: EAM_ASSET_FAILURE_CODES EAFC,
2657: EAM_ASSET_FAILURES EAF,
2658: CSI_ITEM_INSTANCES CII,
2659: ORG_ORGANIZATION_DEFINITIONS OOD,
2660: (SELECT EM.METER_ID,
2661: EM.METER_NAME,
2662: EM.METER_UOM,
2663: EAM.MAINTENANCE_OBJECT_ID,
2749: MTL_EAM_LOCATIONS MEL,
2750: BOM_DEPARTMENTS BD,
2751: EAM_ASSET_FAILURE_CODES EAFC,
2752: EAM_ASSET_FAILURES EAF,
2753: ORG_ORGANIZATION_DEFINITIONS OOD,
2754: (SELECT
2755: ccb.counter_id METER_ID,
2756: cctl.name METER_NAME,
2757: ccb.uom_code METER_UOM,
2867: BOM_DEPARTMENTS BD,
2868: EAM_ASSET_FAILURE_CODES EAFC,
2869: EAM_ASSET_FAILURES EAF,
2870: CSI_ITEM_INSTANCES CII,
2871: ORG_ORGANIZATION_DEFINITIONS OOD,
2872: (SELECT EM.METER_ID,
2873: EM.METER_NAME,
2874: EM.METER_UOM,
2875: EAM.MAINTENANCE_OBJECT_ID,
2961: MTL_EAM_LOCATIONS MEL,
2962: BOM_DEPARTMENTS BD,
2963: EAM_ASSET_FAILURE_CODES EAFC,
2964: EAM_ASSET_FAILURES EAF,
2965: ORG_ORGANIZATION_DEFINITIONS OOD,
2966: CSI_ITEM_INSTANCES CII,
2967: (SELECT EM.METER_ID,
2968: EM.METER_NAME,
2969: EM.METER_UOM,
3084: MTL_EAM_LOCATIONS MEL,
3085: BOM_DEPARTMENTS BD,
3086: EAM_ASSET_FAILURE_CODES EAFC,
3087: EAM_ASSET_FAILURES EAF,
3088: ORG_ORGANIZATION_DEFINITIONS OOD,
3089: CSI_ITEM_INSTANCES CII,
3090: (SELECT EM.METER_ID,
3091: EM.METER_NAME,
3092: EM.METER_UOM,
3195: MTL_EAM_LOCATIONS MEL,
3196: BOM_DEPARTMENTS BD,
3197: EAM_ASSET_FAILURE_CODES EAFC,
3198: EAM_ASSET_FAILURES EAF,
3199: ORG_ORGANIZATION_DEFINITIONS OOD,
3200: (SELECT
3201: ccb.counter_id METER_ID,
3202: cctl.name METER_NAME,
3203: ccb.uom_code METER_UOM,
3325: MTL_EAM_LOCATIONS MEL,
3326: BOM_DEPARTMENTS BD,
3327: EAM_ASSET_FAILURE_CODES EAFC,
3328: EAM_ASSET_FAILURES EAF,
3329: ORG_ORGANIZATION_DEFINITIONS OOD,
3330: (SELECT
3331: ccb.counter_id METER_ID,
3332: cctl.name METER_NAME,
3333: ccb.uom_code METER_UOM,
3456: BOM_DEPARTMENTS BD,
3457: EAM_ASSET_FAILURE_CODES EAFC,
3458: EAM_ASSET_FAILURES EAF,
3459: CSI_ITEM_INSTANCES CII,
3460: ORG_ORGANIZATION_DEFINITIONS OOD,
3461: (SELECT EM.METER_ID,
3462: EM.METER_NAME,
3463: EM.METER_UOM,
3464: EAM.MAINTENANCE_OBJECT_ID,
3578: BOM_DEPARTMENTS BD,
3579: EAM_ASSET_FAILURE_CODES EAFC,
3580: EAM_ASSET_FAILURES EAF,
3581: CSI_ITEM_INSTANCES CII,
3582: ORG_ORGANIZATION_DEFINITIONS OOD,
3583: (SELECT EM.METER_ID,
3584: EM.METER_NAME,
3585: EM.METER_UOM,
3586: EAM.MAINTENANCE_OBJECT_ID,
4237: MTL_EAM_LOCATIONS MEL,
4238: BOM_DEPARTMENTS BD,
4239: EAM_ASSET_FAILURE_CODES EAFC,
4240: EAM_ASSET_FAILURES EAF,
4241: ORG_ORGANIZATION_DEFINITIONS OOD
4242: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
4243: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
4244: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
4245: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
4471: MTL_EAM_LOCATIONS MEL,
4472: BOM_DEPARTMENTS BD,
4473: EAM_ASSET_FAILURE_CODES EAFC,
4474: EAM_ASSET_FAILURES EAF,
4475: ORG_ORGANIZATION_DEFINITIONS OOD,
4476: (SELECT
4477: ccb.counter_id METER_ID,
4478: cctl.name METER_NAME,
4479: ccb.uom_code METER_UOM,