VIEW: INV.MTL_EAM_ASSET_NUM_INTERFACE#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SERIAL_NUMBER SERIAL_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER, VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER, DESCRIPTIVE_TEXT DESCRIPTIVE_TEXT, CURRENT_ORGANIZATION_ID CURRENT_ORGANIZATION_ID, SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY, ORIGINATION_DATE ORIGINATION_DATE, C_ATTRIBUTE1 C_ATTRIBUTE1, C_ATTRIBUTE2 C_ATTRIBUTE2, C_ATTRIBUTE3 C_ATTRIBUTE3, C_ATTRIBUTE4 C_ATTRIBUTE4, C_ATTRIBUTE5 C_ATTRIBUTE5, C_ATTRIBUTE6 C_ATTRIBUTE6, C_ATTRIBUTE7 C_ATTRIBUTE7, C_ATTRIBUTE8 C_ATTRIBUTE8, C_ATTRIBUTE9 C_ATTRIBUTE9, C_ATTRIBUTE10 C_ATTRIBUTE10, C_ATTRIBUTE11 C_ATTRIBUTE11, C_ATTRIBUTE12 C_ATTRIBUTE12, C_ATTRIBUTE13 C_ATTRIBUTE13, C_ATTRIBUTE14 C_ATTRIBUTE14, C_ATTRIBUTE15 C_ATTRIBUTE15, C_ATTRIBUTE16 C_ATTRIBUTE16, C_ATTRIBUTE17 C_ATTRIBUTE17, C_ATTRIBUTE18 C_ATTRIBUTE18, C_ATTRIBUTE19 C_ATTRIBUTE19, C_ATTRIBUTE20 C_ATTRIBUTE20, D_ATTRIBUTE1 D_ATTRIBUTE1, D_ATTRIBUTE2 D_ATTRIBUTE2, D_ATTRIBUTE3 D_ATTRIBUTE3, D_ATTRIBUTE4 D_ATTRIBUTE4, D_ATTRIBUTE5 D_ATTRIBUTE5, D_ATTRIBUTE6 D_ATTRIBUTE6, D_ATTRIBUTE7 D_ATTRIBUTE7, D_ATTRIBUTE8 D_ATTRIBUTE8, D_ATTRIBUTE9 D_ATTRIBUTE9, D_ATTRIBUTE10 D_ATTRIBUTE10, N_ATTRIBUTE1 N_ATTRIBUTE1, N_ATTRIBUTE2 N_ATTRIBUTE2, N_ATTRIBUTE3 N_ATTRIBUTE3, N_ATTRIBUTE4 N_ATTRIBUTE4, N_ATTRIBUTE5 N_ATTRIBUTE5, N_ATTRIBUTE6 N_ATTRIBUTE6, N_ATTRIBUTE7 N_ATTRIBUTE7, N_ATTRIBUTE8 N_ATTRIBUTE8, N_ATTRIBUTE9 N_ATTRIBUTE9, N_ATTRIBUTE10 N_ATTRIBUTE10, STATUS_ID STATUS_ID, TERRITORY_CODE TERRITORY_CODE, TIME_SINCE_NEW TIME_SINCE_NEW, CYCLES_SINCE_NEW CYCLES_SINCE_NEW, TIME_SINCE_OVERHAUL TIME_SINCE_OVERHAUL, CYCLES_SINCE_OVERHAUL CYCLES_SINCE_OVERHAUL, TIME_SINCE_REPAIR TIME_SINCE_REPAIR, CYCLES_SINCE_REPAIR CYCLES_SINCE_REPAIR, TIME_SINCE_VISIT TIME_SINCE_VISIT, CYCLES_SINCE_VISIT CYCLES_SINCE_VISIT, TIME_SINCE_MARK TIME_SINCE_MARK, CYCLES_SINCE_MARK CYCLES_SINCE_MARK, WIP_ACCOUNTING_CLASS_CODE WIP_ACCOUNTING_CLASS_CODE, MAINTAINABLE_FLAG MAINTAINABLE_FLAG, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID, NETWORK_ASSET_FLAG NETWORK_ASSET_FLAG, FA_ASSET_ID FA_ASSET_ID, PN_LOCATION_ID PN_LOCATION_ID, EAM_LOCATION_ID EAM_LOCATION_ID, ASSET_CRITICALITY_CODE ASSET_CRITICALITY_CODE, CATEGORY_ID CATEGORY_ID, INTERFACE_GROUP_ID INTERFACE_GROUP_ID, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, BATCH_ID BATCH_ID, ERROR_CODE ERROR_CODE, ERROR_MESSAGE ERROR_MESSAGE, ORGANIZATION_CODE ORGANIZATION_CODE, EQP_SERIAL_NUMBER EQP_SERIAL_NUMBER, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID, PROD_ORGANIZATION_ID PROD_ORGANIZATION_ID, FA_ASSET_NUMBER FA_ASSET_NUMBER, LOCATION_CODES LOCATION_CODES, PROCESS_FLAG PROCESS_FLAG, IMPORT_MODE IMPORT_MODE, IMPORT_SCOPE IMPORT_SCOPE, OWNING_DEPARTMENT_CODE OWNING_DEPARTMENT_CODE, ASSET_CRITICALITY_ID ASSET_CRITICALITY_ID, CURRENT_STATUS CURRENT_STATUS, PROD_ORGANIZATION_CODE PROD_ORGANIZATION_CODE, PARENT_INVENTORY_ITEM_ID PARENT_INVENTORY_ITEM_ID, BATCH_NAME BATCH_NAME, INSTANCE_NUMBER INSTANCE_NUMBER, ACTIVE_START_DATE ACTIVE_START_DATE, ACTIVE_END_DATE ACTIVE_END_DATE, PARENT_INSTANCE_NUMBER PARENT_INSTANCE_NUMBER, SUPPLIER_WARRANTY_EXP_DATE SUPPLIER_WARRANTY_EXP_DATE, OPERATIONAL_LOG_FLAG OPERATIONAL_LOG_FLAG, CHECKIN_STATUS CHECKIN_STATUS from "INV"."MTL_EAM_ASSET_NUM_INTERFACE"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SERIAL_NUMBER SERIAL_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER
, VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER
, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
, DESCRIPTIVE_TEXT DESCRIPTIVE_TEXT
, CURRENT_ORGANIZATION_ID CURRENT_ORGANIZATION_ID
, SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY
, ORIGINATION_DATE ORIGINATION_DATE
, C_ATTRIBUTE1 C_ATTRIBUTE1
, C_ATTRIBUTE2 C_ATTRIBUTE2
, C_ATTRIBUTE3 C_ATTRIBUTE3
, C_ATTRIBUTE4 C_ATTRIBUTE4
, C_ATTRIBUTE5 C_ATTRIBUTE5
, C_ATTRIBUTE6 C_ATTRIBUTE6
, C_ATTRIBUTE7 C_ATTRIBUTE7
, C_ATTRIBUTE8 C_ATTRIBUTE8
, C_ATTRIBUTE9 C_ATTRIBUTE9
, C_ATTRIBUTE10 C_ATTRIBUTE10
, C_ATTRIBUTE11 C_ATTRIBUTE11
, C_ATTRIBUTE12 C_ATTRIBUTE12
, C_ATTRIBUTE13 C_ATTRIBUTE13
, C_ATTRIBUTE14 C_ATTRIBUTE14
, C_ATTRIBUTE15 C_ATTRIBUTE15
, C_ATTRIBUTE16 C_ATTRIBUTE16
, C_ATTRIBUTE17 C_ATTRIBUTE17
, C_ATTRIBUTE18 C_ATTRIBUTE18
, C_ATTRIBUTE19 C_ATTRIBUTE19
, C_ATTRIBUTE20 C_ATTRIBUTE20
, D_ATTRIBUTE1 D_ATTRIBUTE1
, D_ATTRIBUTE2 D_ATTRIBUTE2
, D_ATTRIBUTE3 D_ATTRIBUTE3
, D_ATTRIBUTE4 D_ATTRIBUTE4
, D_ATTRIBUTE5 D_ATTRIBUTE5
, D_ATTRIBUTE6 D_ATTRIBUTE6
, D_ATTRIBUTE7 D_ATTRIBUTE7
, D_ATTRIBUTE8 D_ATTRIBUTE8
, D_ATTRIBUTE9 D_ATTRIBUTE9
, D_ATTRIBUTE10 D_ATTRIBUTE10
, N_ATTRIBUTE1 N_ATTRIBUTE1
, N_ATTRIBUTE2 N_ATTRIBUTE2
, N_ATTRIBUTE3 N_ATTRIBUTE3
, N_ATTRIBUTE4 N_ATTRIBUTE4
, N_ATTRIBUTE5 N_ATTRIBUTE5
, N_ATTRIBUTE6 N_ATTRIBUTE6
, N_ATTRIBUTE7 N_ATTRIBUTE7
, N_ATTRIBUTE8 N_ATTRIBUTE8
, N_ATTRIBUTE9 N_ATTRIBUTE9
, N_ATTRIBUTE10 N_ATTRIBUTE10
, STATUS_ID STATUS_ID
, TERRITORY_CODE TERRITORY_CODE
, TIME_SINCE_NEW TIME_SINCE_NEW
, CYCLES_SINCE_NEW CYCLES_SINCE_NEW
, TIME_SINCE_OVERHAUL TIME_SINCE_OVERHAUL
, CYCLES_SINCE_OVERHAUL CYCLES_SINCE_OVERHAUL
, TIME_SINCE_REPAIR TIME_SINCE_REPAIR
, CYCLES_SINCE_REPAIR CYCLES_SINCE_REPAIR
, TIME_SINCE_VISIT TIME_SINCE_VISIT
, CYCLES_SINCE_VISIT CYCLES_SINCE_VISIT
, TIME_SINCE_MARK TIME_SINCE_MARK
, CYCLES_SINCE_MARK CYCLES_SINCE_MARK
, WIP_ACCOUNTING_CLASS_CODE WIP_ACCOUNTING_CLASS_CODE
, MAINTAINABLE_FLAG MAINTAINABLE_FLAG
, OWNING_DEPARTMENT_ID OWNING_DEPARTMENT_ID
, NETWORK_ASSET_FLAG NETWORK_ASSET_FLAG
, FA_ASSET_ID FA_ASSET_ID
, PN_LOCATION_ID PN_LOCATION_ID
, EAM_LOCATION_ID EAM_LOCATION_ID
, ASSET_CRITICALITY_CODE ASSET_CRITICALITY_CODE
, CATEGORY_ID CATEGORY_ID
, INTERFACE_GROUP_ID INTERFACE_GROUP_ID
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, BATCH_ID BATCH_ID
, ERROR_CODE ERROR_CODE
, ERROR_MESSAGE ERROR_MESSAGE
, ORGANIZATION_CODE ORGANIZATION_CODE
, EQP_SERIAL_NUMBER EQP_SERIAL_NUMBER
, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID
, PROD_ORGANIZATION_ID PROD_ORGANIZATION_ID
, FA_ASSET_NUMBER FA_ASSET_NUMBER
, LOCATION_CODES LOCATION_CODES
, PROCESS_FLAG PROCESS_FLAG
, IMPORT_MODE IMPORT_MODE
, IMPORT_SCOPE IMPORT_SCOPE
, OWNING_DEPARTMENT_CODE OWNING_DEPARTMENT_CODE
, ASSET_CRITICALITY_ID ASSET_CRITICALITY_ID
, CURRENT_STATUS CURRENT_STATUS
, PROD_ORGANIZATION_CODE PROD_ORGANIZATION_CODE
, PARENT_INVENTORY_ITEM_ID PARENT_INVENTORY_ITEM_ID
, BATCH_NAME BATCH_NAME
, INSTANCE_NUMBER INSTANCE_NUMBER
, ACTIVE_START_DATE ACTIVE_START_DATE
, ACTIVE_END_DATE ACTIVE_END_DATE
, PARENT_INSTANCE_NUMBER PARENT_INSTANCE_NUMBER
, SUPPLIER_WARRANTY_EXP_DATE SUPPLIER_WARRANTY_EXP_DATE
, OPERATIONAL_LOG_FLAG OPERATIONAL_LOG_FLAG
, CHECKIN_STATUS CHECKIN_STATUS
FROM "INV"."MTL_EAM_ASSET_NUM_INTERFACE"