VIEW: INV.MTL_SERIAL_NUMBERS#

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, INITIALIZATION_DATE INITIALIZATION_DATE, COMPLETION_DATE COMPLETION_DATE, SHIP_DATE SHIP_DATE, CURRENT_STATUS CURRENT_STATUS, REVISION REVISION, LOT_NUMBER LOT_NUMBER, FIXED_ASSET_TAG FIXED_ASSET_TAG, RESERVED_ORDER_ID RESERVED_ORDER_ID, PARENT_ITEM_ID PARENT_ITEM_ID, PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, ORIGINAL_WIP_ENTITY_ID ORIGINAL_WIP_ENTITY_ID, ORIGINAL_UNIT_VENDOR_ID ORIGINAL_UNIT_VENDOR_ID, VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER, LAST_TXN_SOURCE_TYPE_ID LAST_TXN_SOURCE_TYPE_ID, LAST_TRANSACTION_ID LAST_TRANSACTION_ID, LAST_RECEIPT_ISSUE_TYPE LAST_RECEIPT_ISSUE_TYPE, LAST_TXN_SOURCE_NAME LAST_TXN_SOURCE_NAME, LAST_TXN_SOURCE_ID LAST_TXN_SOURCE_ID, DESCRIPTIVE_TEXT DESCRIPTIVE_TEXT, CURRENT_SUBINVENTORY_CODE CURRENT_SUBINVENTORY_CODE, CURRENT_LOCATOR_ID CURRENT_LOCATOR_ID, CURRENT_ORGANIZATION_ID CURRENT_ORGANIZATION_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GROUP_MARK_ID GROUP_MARK_ID, LINE_MARK_ID LINE_MARK_ID, LOT_LINE_MARK_ID LOT_LINE_MARK_ID, GEN_OBJECT_ID GEN_OBJECT_ID, SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN, 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, C_ATTRIBUTE21 C_ATTRIBUTE21, C_ATTRIBUTE22 C_ATTRIBUTE22, C_ATTRIBUTE23 C_ATTRIBUTE23, C_ATTRIBUTE24 C_ATTRIBUTE24, C_ATTRIBUTE25 C_ATTRIBUTE25, C_ATTRIBUTE26 C_ATTRIBUTE26, C_ATTRIBUTE27 C_ATTRIBUTE27, C_ATTRIBUTE28 C_ATTRIBUTE28, C_ATTRIBUTE29 C_ATTRIBUTE29, C_ATTRIBUTE30 C_ATTRIBUTE30, 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, D_ATTRIBUTE11 D_ATTRIBUTE11, D_ATTRIBUTE12 D_ATTRIBUTE12, D_ATTRIBUTE13 D_ATTRIBUTE13, D_ATTRIBUTE14 D_ATTRIBUTE14, D_ATTRIBUTE15 D_ATTRIBUTE15, D_ATTRIBUTE16 D_ATTRIBUTE16, D_ATTRIBUTE17 D_ATTRIBUTE17, D_ATTRIBUTE18 D_ATTRIBUTE18, D_ATTRIBUTE19 D_ATTRIBUTE19, D_ATTRIBUTE20 D_ATTRIBUTE20, 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, N_ATTRIBUTE11 N_ATTRIBUTE11, N_ATTRIBUTE12 N_ATTRIBUTE12, N_ATTRIBUTE13 N_ATTRIBUTE13, N_ATTRIBUTE14 N_ATTRIBUTE14, N_ATTRIBUTE15 N_ATTRIBUTE15, N_ATTRIBUTE16 N_ATTRIBUTE16, N_ATTRIBUTE17 N_ATTRIBUTE17, N_ATTRIBUTE18 N_ATTRIBUTE18, N_ATTRIBUTE19 N_ATTRIBUTE19, N_ATTRIBUTE20 N_ATTRIBUTE20, N_ATTRIBUTE21 N_ATTRIBUTE21, N_ATTRIBUTE22 N_ATTRIBUTE22, N_ATTRIBUTE23 N_ATTRIBUTE23, N_ATTRIBUTE24 N_ATTRIBUTE24, N_ATTRIBUTE25 N_ATTRIBUTE25, N_ATTRIBUTE26 N_ATTRIBUTE26, N_ATTRIBUTE27 N_ATTRIBUTE27, N_ATTRIBUTE28 N_ATTRIBUTE28, N_ATTRIBUTE29 N_ATTRIBUTE29, N_ATTRIBUTE30 N_ATTRIBUTE30, STATUS_ID STATUS_ID, TERRITORY_CODE TERRITORY_CODE, COST_GROUP_ID COST_GROUP_ID, 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, NUMBER_OF_REPAIRS NUMBER_OF_REPAIRS, LPN_ID LPN_ID, INSPECTION_STATUS INSPECTION_STATUS, PREVIOUS_STATUS PREVIOUS_STATUS, LPN_TXN_ERROR_FLAG LPN_TXN_ERROR_FLAG, 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, PROD_ORGANIZATION_ID PROD_ORGANIZATION_ID, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID, EQP_SERIAL_NUMBER EQP_SERIAL_NUMBER, ORGANIZATION_TYPE ORGANIZATION_TYPE, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, OWNING_TP_TYPE OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE PLANNING_TP_TYPE, ONHAND_QUANTITIES_ID ONHAND_QUANTITIES_ID, WIP_ENTITY_ID WIP_ENTITY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, INTRAOPERATION_STEP_TYPE INTRAOPERATION_STEP_TYPE, EAM_INSTANTIATION_FLAG EAM_INSTANTIATION_FLAG, DEPENDENT_ASSET_FLAG DEPENDENT_ASSET_FLAG, EAM_LINEAR_LOCATION_ID EAM_LINEAR_LOCATION_ID, RESERVATION_ID RESERVATION_ID, AVAILABILITY_TYPE AVAILABILITY_TYPE, INVENTORY_ATP_CODE INVENTORY_ATP_CODE, RESERVABLE_TYPE RESERVABLE_TYPE, PARENT_LOT_NUMBER PARENT_LOT_NUMBER, OPERATIONAL_LOG_FLAG OPERATIONAL_LOG_FLAG, OPERATIONAL_STATUS_FLAG OPERATIONAL_STATUS_FLAG from "INV"."MTL_SERIAL_NUMBERS"

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
, INITIALIZATION_DATE INITIALIZATION_DATE
, COMPLETION_DATE COMPLETION_DATE
, SHIP_DATE SHIP_DATE
, CURRENT_STATUS CURRENT_STATUS
, REVISION REVISION
, LOT_NUMBER LOT_NUMBER
, FIXED_ASSET_TAG FIXED_ASSET_TAG
, RESERVED_ORDER_ID RESERVED_ORDER_ID
, PARENT_ITEM_ID PARENT_ITEM_ID
, PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, ORIGINAL_WIP_ENTITY_ID ORIGINAL_WIP_ENTITY_ID
, ORIGINAL_UNIT_VENDOR_ID ORIGINAL_UNIT_VENDOR_ID
, VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER
, VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER
, LAST_TXN_SOURCE_TYPE_ID LAST_TXN_SOURCE_TYPE_ID
, LAST_TRANSACTION_ID LAST_TRANSACTION_ID
, LAST_RECEIPT_ISSUE_TYPE LAST_RECEIPT_ISSUE_TYPE
, LAST_TXN_SOURCE_NAME LAST_TXN_SOURCE_NAME
, LAST_TXN_SOURCE_ID LAST_TXN_SOURCE_ID
, DESCRIPTIVE_TEXT DESCRIPTIVE_TEXT
, CURRENT_SUBINVENTORY_CODE CURRENT_SUBINVENTORY_CODE
, CURRENT_LOCATOR_ID CURRENT_LOCATOR_ID
, CURRENT_ORGANIZATION_ID CURRENT_ORGANIZATION_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GROUP_MARK_ID GROUP_MARK_ID
, LINE_MARK_ID LINE_MARK_ID
, LOT_LINE_MARK_ID LOT_LINE_MARK_ID
, GEN_OBJECT_ID GEN_OBJECT_ID
, SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY
, COUNTRY_OF_ORIGIN COUNTRY_OF_ORIGIN
, 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
, C_ATTRIBUTE21 C_ATTRIBUTE21
, C_ATTRIBUTE22 C_ATTRIBUTE22
, C_ATTRIBUTE23 C_ATTRIBUTE23
, C_ATTRIBUTE24 C_ATTRIBUTE24
, C_ATTRIBUTE25 C_ATTRIBUTE25
, C_ATTRIBUTE26 C_ATTRIBUTE26
, C_ATTRIBUTE27 C_ATTRIBUTE27
, C_ATTRIBUTE28 C_ATTRIBUTE28
, C_ATTRIBUTE29 C_ATTRIBUTE29
, C_ATTRIBUTE30 C_ATTRIBUTE30
, 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
, D_ATTRIBUTE11 D_ATTRIBUTE11
, D_ATTRIBUTE12 D_ATTRIBUTE12
, D_ATTRIBUTE13 D_ATTRIBUTE13
, D_ATTRIBUTE14 D_ATTRIBUTE14
, D_ATTRIBUTE15 D_ATTRIBUTE15
, D_ATTRIBUTE16 D_ATTRIBUTE16
, D_ATTRIBUTE17 D_ATTRIBUTE17
, D_ATTRIBUTE18 D_ATTRIBUTE18
, D_ATTRIBUTE19 D_ATTRIBUTE19
, D_ATTRIBUTE20 D_ATTRIBUTE20
, 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
, N_ATTRIBUTE11 N_ATTRIBUTE11
, N_ATTRIBUTE12 N_ATTRIBUTE12
, N_ATTRIBUTE13 N_ATTRIBUTE13
, N_ATTRIBUTE14 N_ATTRIBUTE14
, N_ATTRIBUTE15 N_ATTRIBUTE15
, N_ATTRIBUTE16 N_ATTRIBUTE16
, N_ATTRIBUTE17 N_ATTRIBUTE17
, N_ATTRIBUTE18 N_ATTRIBUTE18
, N_ATTRIBUTE19 N_ATTRIBUTE19
, N_ATTRIBUTE20 N_ATTRIBUTE20
, N_ATTRIBUTE21 N_ATTRIBUTE21
, N_ATTRIBUTE22 N_ATTRIBUTE22
, N_ATTRIBUTE23 N_ATTRIBUTE23
, N_ATTRIBUTE24 N_ATTRIBUTE24
, N_ATTRIBUTE25 N_ATTRIBUTE25
, N_ATTRIBUTE26 N_ATTRIBUTE26
, N_ATTRIBUTE27 N_ATTRIBUTE27
, N_ATTRIBUTE28 N_ATTRIBUTE28
, N_ATTRIBUTE29 N_ATTRIBUTE29
, N_ATTRIBUTE30 N_ATTRIBUTE30
, STATUS_ID STATUS_ID
, TERRITORY_CODE TERRITORY_CODE
, COST_GROUP_ID COST_GROUP_ID
, 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
, NUMBER_OF_REPAIRS NUMBER_OF_REPAIRS
, LPN_ID LPN_ID
, INSPECTION_STATUS INSPECTION_STATUS
, PREVIOUS_STATUS PREVIOUS_STATUS
, LPN_TXN_ERROR_FLAG LPN_TXN_ERROR_FLAG
, 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
, PROD_ORGANIZATION_ID PROD_ORGANIZATION_ID
, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID
, EQP_SERIAL_NUMBER EQP_SERIAL_NUMBER
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, OWNING_TP_TYPE OWNING_TP_TYPE
, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID
, PLANNING_TP_TYPE PLANNING_TP_TYPE
, ONHAND_QUANTITIES_ID ONHAND_QUANTITIES_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, INTRAOPERATION_STEP_TYPE INTRAOPERATION_STEP_TYPE
, EAM_INSTANTIATION_FLAG EAM_INSTANTIATION_FLAG
, DEPENDENT_ASSET_FLAG DEPENDENT_ASSET_FLAG
, EAM_LINEAR_LOCATION_ID EAM_LINEAR_LOCATION_ID
, RESERVATION_ID RESERVATION_ID
, AVAILABILITY_TYPE AVAILABILITY_TYPE
, INVENTORY_ATP_CODE INVENTORY_ATP_CODE
, RESERVABLE_TYPE RESERVABLE_TYPE
, PARENT_LOT_NUMBER PARENT_LOT_NUMBER
, OPERATIONAL_LOG_FLAG OPERATIONAL_LOG_FLAG
, OPERATIONAL_STATUS_FLAG OPERATIONAL_STATUS_FLAG
FROM "INV"."MTL_SERIAL_NUMBERS"