[Home] [Help]
323: MTL_EAM_LOCATIONS MEL,
324: BOM_DEPARTMENTS BD,
325: EAM_ASSET_FAILURE_CODES EAFC,
326: EAM_ASSET_FAILURES EAF,
327: ORG_ORGANIZATION_DEFINITIONS OOD,
328: EAM_FAILURE_CODES EFC,
329: EAM_CAUSE_CODES ECC,
330: EAM_RESOLUTION_CODES ERC,
331: (SELECT
515: MTL_EAM_LOCATIONS MEL,
516: BOM_DEPARTMENTS BD,
517: EAM_ASSET_FAILURE_CODES EAFC,
518: EAM_ASSET_FAILURES EAF,
519: ORG_ORGANIZATION_DEFINITIONS OOD,
520: EAM_FAILURE_CODES EFC,
521: EAM_CAUSE_CODES ECC,
522: EAM_RESOLUTION_CODES ERC
523: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
674: MTL_EAM_LOCATIONS MEL,
675: BOM_DEPARTMENTS BD,
676: EAM_ASSET_FAILURE_CODES EAFC,
677: EAM_ASSET_FAILURES EAF,
678: ORG_ORGANIZATION_DEFINITIONS OOD,
679: (SELECT
680: ccb.counter_id METER_ID,
681: cctl.name METER_NAME,
682: ccb.uom_code METER_UOM,
917: MTL_EAM_LOCATIONS MEL,
918: BOM_DEPARTMENTS BD,
919: EAM_ASSET_FAILURE_CODES EAFC,
920: EAM_ASSET_FAILURES EAF,
921: ORG_ORGANIZATION_DEFINITIONS OOD
922: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
923: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
924: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
925: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1018: MTL_EAM_LOCATIONS MEL,
1019: BOM_DEPARTMENTS BD,
1020: EAM_ASSET_FAILURE_CODES EAFC,
1021: EAM_ASSET_FAILURES EAF,
1022: ORG_ORGANIZATION_DEFINITIONS OOD
1023: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1024: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1025: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
1026: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1120: MTL_EAM_LOCATIONS MEL,
1121: BOM_DEPARTMENTS BD,
1122: EAM_ASSET_FAILURE_CODES EAFC,
1123: EAM_ASSET_FAILURES EAF,
1124: ORG_ORGANIZATION_DEFINITIONS OOD,
1125: (SELECT
1126: ccb.counter_id METER_ID,
1127: cctl.name METER_NAME,
1128: ccb.uom_code METER_UOM,
1263: MTL_EAM_LOCATIONS MEL,
1264: BOM_DEPARTMENTS BD,
1265: EAM_ASSET_FAILURE_CODES EAFC,
1266: EAM_ASSET_FAILURES EAF,
1267: ORG_ORGANIZATION_DEFINITIONS OOD,
1268: (SELECT
1269: ccb.counter_id METER_ID,
1270: cctl.name METER_NAME,
1271: ccb.uom_code METER_UOM,
1793: MTL_EAM_LOCATIONS MEL,
1794: BOM_DEPARTMENTS BD,
1795: EAM_ASSET_FAILURE_CODES EAFC,
1796: EAM_ASSET_FAILURES EAF,
1797: ORG_ORGANIZATION_DEFINITIONS OOD
1798: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1799: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1800: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
1801: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1884: BOM_DEPARTMENTS BD,
1885: EAM_ASSET_FAILURE_CODES EAFC,
1886: EAM_ASSET_FAILURES EAF,
1887: CSI_ITEM_INSTANCES CII,
1888: ORG_ORGANIZATION_DEFINITIONS OOD
1889: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1890: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1891: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
1892: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
1982: MTL_EAM_LOCATIONS MEL,
1983: BOM_DEPARTMENTS BD,
1984: EAM_ASSET_FAILURE_CODES EAFC,
1985: EAM_ASSET_FAILURES EAF,
1986: ORG_ORGANIZATION_DEFINITIONS OOD,
1987: CSI_ITEM_INSTANCES CII
1988: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
1989: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
1990: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
2066: MTL_EAM_LOCATIONS MEL,
2067: BOM_DEPARTMENTS BD,
2068: EAM_ASSET_FAILURE_CODES EAFC,
2069: EAM_ASSET_FAILURES EAF,
2070: ORG_ORGANIZATION_DEFINITIONS OOD
2071: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2072: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2073: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
2074: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2155: BOM_DEPARTMENTS BD,
2156: EAM_ASSET_FAILURE_CODES EAFC,
2157: EAM_ASSET_FAILURES EAF,
2158: CSI_ITEM_INSTANCES CII,
2159: ORG_ORGANIZATION_DEFINITIONS OOD
2160: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2161: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2162: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
2163: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2250: BOM_DEPARTMENTS BD,
2251: EAM_ASSET_FAILURE_CODES EAFC,
2252: EAM_ASSET_FAILURES EAF,
2253: CSI_ITEM_INSTANCES CII,
2254: ORG_ORGANIZATION_DEFINITIONS OOD
2255: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
2256: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
2257: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
2258: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
2333: MTL_EAM_LOCATIONS MEL,
2334: BOM_DEPARTMENTS BD,
2335: EAM_ASSET_FAILURE_CODES EAFC,
2336: EAM_ASSET_FAILURES EAF,
2337: ORG_ORGANIZATION_DEFINITIONS OOD,
2338: (SELECT
2339: ccb.counter_id METER_ID,
2340: cctl.name METER_NAME,
2341: ccb.uom_code METER_UOM,
2451: BOM_DEPARTMENTS BD,
2452: EAM_ASSET_FAILURE_CODES EAFC,
2453: EAM_ASSET_FAILURES EAF,
2454: CSI_ITEM_INSTANCES CII,
2455: ORG_ORGANIZATION_DEFINITIONS OOD,
2456: (SELECT EM.METER_ID,
2457: EM.METER_NAME,
2458: EM.METER_UOM,
2459: EAM.MAINTENANCE_OBJECT_ID,
2543: MTL_EAM_LOCATIONS MEL,
2544: BOM_DEPARTMENTS BD,
2545: EAM_ASSET_FAILURE_CODES EAFC,
2546: EAM_ASSET_FAILURES EAF,
2547: ORG_ORGANIZATION_DEFINITIONS OOD,
2548: CSI_ITEM_INSTANCES CII,
2549: (SELECT EM.METER_ID,
2550: EM.METER_NAME,
2551: EM.METER_UOM,
2666: MTL_EAM_LOCATIONS MEL,
2667: BOM_DEPARTMENTS BD,
2668: EAM_ASSET_FAILURE_CODES EAFC,
2669: EAM_ASSET_FAILURES EAF,
2670: ORG_ORGANIZATION_DEFINITIONS OOD,
2671: CSI_ITEM_INSTANCES CII,
2672: (SELECT EM.METER_ID,
2673: EM.METER_NAME,
2674: EM.METER_UOM,
2776: MTL_EAM_LOCATIONS MEL,
2777: BOM_DEPARTMENTS BD,
2778: EAM_ASSET_FAILURE_CODES EAFC,
2779: EAM_ASSET_FAILURES EAF,
2780: ORG_ORGANIZATION_DEFINITIONS OOD,
2781: (SELECT
2782: ccb.counter_id METER_ID,
2783: cctl.name METER_NAME,
2784: ccb.uom_code METER_UOM,
2905: BOM_DEPARTMENTS BD,
2906: EAM_ASSET_FAILURE_CODES EAFC,
2907: EAM_ASSET_FAILURES EAF,
2908: CSI_ITEM_INSTANCES CII,
2909: ORG_ORGANIZATION_DEFINITIONS OOD,
2910: (SELECT EM.METER_ID,
2911: EM.METER_NAME,
2912: EM.METER_UOM,
2913: EAM.MAINTENANCE_OBJECT_ID,
3027: BOM_DEPARTMENTS BD,
3028: EAM_ASSET_FAILURE_CODES EAFC,
3029: EAM_ASSET_FAILURES EAF,
3030: CSI_ITEM_INSTANCES CII,
3031: ORG_ORGANIZATION_DEFINITIONS OOD,
3032: (SELECT EM.METER_ID,
3033: EM.METER_NAME,
3034: EM.METER_UOM,
3035: EAM.MAINTENANCE_OBJECT_ID,
3561: MTL_EAM_LOCATIONS MEL,
3562: BOM_DEPARTMENTS BD,
3563: EAM_ASSET_FAILURE_CODES EAFC,
3564: EAM_ASSET_FAILURES EAF,
3565: ORG_ORGANIZATION_DEFINITIONS OOD
3566: WHERE WDJ.WIP_ENTITY_ID = EAF.SOURCE_ID
3567: AND WDJ.ORGANIZATION_ID = EAF.MAINT_ORGANIZATION_ID
3568: AND WDJ.ORGANIZATION_ID = OOD.ORGANIZATION_ID
3569: AND WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
3795: MTL_EAM_LOCATIONS MEL,
3796: BOM_DEPARTMENTS BD,
3797: EAM_ASSET_FAILURE_CODES EAFC,
3798: EAM_ASSET_FAILURES EAF,
3799: ORG_ORGANIZATION_DEFINITIONS OOD,
3800: (SELECT
3801: ccb.counter_id METER_ID,
3802: cctl.name METER_NAME,
3803: ccb.uom_code METER_UOM,