INV_PENDING_TXN_SERIALS_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

ROW_NUMBER TRANSACTION_STATE TRANSACTION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID VENDOR_SERIAL_NUMBER VENDOR_LOT_NUMBER FM_SERIAL_NUMBER TO_SERIAL_NUMBER ERROR_CODE PARENT_SERIAL_NUMBER SERIAL_ATTRIBUTE_CATEGORY TERRITORY_CODE ORIGINATION_DATE C_ATTRIBUTE1 C_ATTRIBUTE2 C_ATTRIBUTE3 C_ATTRIBUTE4 C_ATTRIBUTE5 C_ATTRIBUTE6 C_ATTRIBUTE7 C_ATTRIBUTE8 C_ATTRIBUTE9 C_ATTRIBUTE10 C_ATTRIBUTE11 C_ATTRIBUTE12 C_ATTRIBUTE13 C_ATTRIBUTE14 C_ATTRIBUTE15 C_ATTRIBUTE16 C_ATTRIBUTE17 C_ATTRIBUTE18 C_ATTRIBUTE19 C_ATTRIBUTE20 D_ATTRIBUTE1 D_ATTRIBUTE2 D_ATTRIBUTE3 D_ATTRIBUTE4 D_ATTRIBUTE5 D_ATTRIBUTE6 D_ATTRIBUTE7 D_ATTRIBUTE8 D_ATTRIBUTE9 D_ATTRIBUTE10 N_ATTRIBUTE1 N_ATTRIBUTE2 N_ATTRIBUTE3 N_ATTRIBUTE4 N_ATTRIBUTE5 N_ATTRIBUTE6 N_ATTRIBUTE7 N_ATTRIBUTE8 N_ATTRIBUTE9 N_ATTRIBUTE10 STATUS_ID TIME_SINCE_NEW CYCLES_SINCE_NEW TIME_SINCE_OVERHAUL CYCLES_SINCE_OVERHAUL TIME_SINCE_REPAIR CYCLES_SINCE_REPAIR TIME_SINCE_VISIT CYCLES_SINCE_VISIT TIME_SINCE_MARK CYCLES_SINCE_MARK NUMBER_OF_REPAIRS PRODUCT_CODE PRODUCT_TRANSACTION_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 PARENT_OBJECT_TYPE PARENT_OBJECT_ID PARENT_OBJECT_NUMBER PARENT_ITEM_ID PARENT_OBJECT_TYPE2 PARENT_OBJECT_ID2 PARENT_OBJECT_NUMBER2 OBJECT_TYPE2 OBJECT_NUMBER2 GROUP_HEADER_ID SERIAL_PREFIX END_ITEM_UNIT_NUMBER DFF_UPDATED_FLAG SOURCE_CODE SOURCE_LINE_ID PROCESS_FLAG STATUS_NAME JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE OBJECT_VERSION_NUMBER T_ATTRIBUTE1 T_ATTRIBUTE2 T_ATTRIBUTE3 T_ATTRIBUTE4 T_ATTRIBUTE5 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT TRANSACTION_TEMP_ID||FM_SERIAL_NUMBER ROW_NUMBER , 'VALIDATED' TRANSACTION_STATE , TRANSACTION_TEMP_ID TRANSACTION_ID , 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 , VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER , VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER , FM_SERIAL_NUMBER FM_SERIAL_NUMBER , TO_SERIAL_NUMBER TO_SERIAL_NUMBER , ERROR_CODE ERROR_CODE , PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER , SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY , TERRITORY_CODE TERRITORY_CODE , 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 , 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 , PRODUCT_CODE PRODUCT_CODE , PRODUCT_TRANSACTION_ID PRODUCT_TRANSACTION_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 , PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE , PARENT_OBJECT_ID PARENT_OBJECT_ID , PARENT_OBJECT_NUMBER PARENT_OBJECT_NUMBER , PARENT_ITEM_ID PARENT_ITEM_ID , PARENT_OBJECT_TYPE2 PARENT_OBJECT_TYPE2 , PARENT_OBJECT_ID2 PARENT_OBJECT_ID2 , PARENT_OBJECT_NUMBER2 PARENT_OBJECT_NUMBER2 , OBJECT_TYPE2 OBJECT_TYPE2 , OBJECT_NUMBER2 OBJECT_NUMBER2 , GROUP_HEADER_ID GROUP_HEADER_ID , SERIAL_PREFIX SERIAL_PREFIX , END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER , DFF_UPDATED_FLAG DFF_UPDATED_FLAG , NULL SOURCE_CODE , NULL SOURCE_LINE_ID , NULL PROCESS_FLAG , NULL STATUS_NAME , JOB_DEFINITION_NAME JOB_DEFINITION_NAME , JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE , OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , T_ATTRIBUTE1 T_ATTRIBUTE1 , T_ATTRIBUTE2 T_ATTRIBUTE2 , T_ATTRIBUTE3 T_ATTRIBUTE3 , T_ATTRIBUTE4 T_ATTRIBUTE4 , T_ATTRIBUTE5 T_ATTRIBUTE5 , ATTRIBUTE16 ATTRIBUTE16 , ATTRIBUTE17 ATTRIBUTE17 , ATTRIBUTE18 ATTRIBUTE18 , ATTRIBUTE19 ATTRIBUTE19 , ATTRIBUTE20 ATTRIBUTE20 , ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1 , ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2 , ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3 , ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4 , ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5 , ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6 , ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7 , ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8 , ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9 , ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10 , ATTRIBUTE_DATE1 ATTRIBUTE_DATE1 , ATTRIBUTE_DATE2 ATTRIBUTE_DATE2 , ATTRIBUTE_DATE3 ATTRIBUTE_DATE3 , ATTRIBUTE_DATE4 ATTRIBUTE_DATE4 , ATTRIBUTE_DATE5 ATTRIBUTE_DATE5 , ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1 , ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2 , ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3 , ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4 , ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5 FROM INV_SERIAL_NUMBERS_TEMP UNION ALL SELECT TRANSACTION_INTERFACE_ID||FM_SERIAL_NUMBER ROW_NUMBER , 'STAGED' TRANSACTION_STATE , TRANSACTION_INTERFACE_ID TRANSACTION_ID , 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 , VENDOR_SERIAL_NUMBER VENDOR_SERIAL_NUMBER , VENDOR_LOT_NUMBER VENDOR_LOT_NUMBER , FM_SERIAL_NUMBER FM_SERIAL_NUMBER , TO_SERIAL_NUMBER TO_SERIAL_NUMBER , ERROR_CODE ERROR_CODE , PARENT_SERIAL_NUMBER PARENT_SERIAL_NUMBER , SERIAL_ATTRIBUTE_CATEGORY SERIAL_ATTRIBUTE_CATEGORY , TERRITORY_CODE TERRITORY_CODE , 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 , 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 , PRODUCT_CODE PRODUCT_CODE , PRODUCT_TRANSACTION_ID PRODUCT_TRANSACTION_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 , PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE , PARENT_OBJECT_ID PARENT_OBJECT_ID , PARENT_OBJECT_NUMBER PARENT_OBJECT_NUMBER , PARENT_ITEM_ID PARENT_ITEM_ID , PARENT_OBJECT_TYPE2 PARENT_OBJECT_TYPE2 , PARENT_OBJECT_ID2 PARENT_OBJECT_ID2 , PARENT_OBJECT_NUMBER2 PARENT_OBJECT_NUMBER2 , NULL OBJECT_TYPE2 , NULL OBJECT_NUMBER2 , NULL GROUP_HEADER_ID , NULL SERIAL_PREFIX , NULL END_ITEM_UNIT_NUMBER , NULL DFF_UPDATED_FLAG , SOURCE_CODE SOURCE_CODE , SOURCE_LINE_ID SOURCE_LINE_ID , PROCESS_FLAG PROCESS_FLAG , STATUS_NAME STATUS_NAME , JOB_DEFINITION_NAME JOB_DEFINITION_NAME , JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE , OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , T_ATTRIBUTE1 T_ATTRIBUTE1 , T_ATTRIBUTE2 T_ATTRIBUTE2 , T_ATTRIBUTE3 T_ATTRIBUTE3 , T_ATTRIBUTE4 T_ATTRIBUTE4 , T_ATTRIBUTE5 T_ATTRIBUTE5 , ATTRIBUTE16 ATTRIBUTE16 , ATTRIBUTE17 ATTRIBUTE17 , ATTRIBUTE18 ATTRIBUTE18 , ATTRIBUTE19 ATTRIBUTE19 , ATTRIBUTE20 ATTRIBUTE20 , ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1 , ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2 , ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3 , ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4 , ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5 , ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6 , ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7 , ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8 , ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9 , ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10 , ATTRIBUTE_DATE1 ATTRIBUTE_DATE1 , ATTRIBUTE_DATE2 ATTRIBUTE_DATE2 , ATTRIBUTE_DATE3 ATTRIBUTE_DATE3 , ATTRIBUTE_DATE4 ATTRIBUTE_DATE4 , ATTRIBUTE_DATE5 ATTRIBUTE_DATE5 , ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1 , ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2 , ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3 , ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4 , ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5 FROM INV_SERIAL_NUMBERS_INTERFACE