INV_PENDING_TXN_LOTS_V
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: VIEW
Columns
Name |
---|
TRANSACTION_STATE TRANSACTION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID TRANSACTION_QUANTITY PRIMARY_QUANTITY LOT_NUMBER LOT_EXPIRATION_DATE SERIAL_TRANSACTION_TEMP_ID ERROR_CODE SECONDARY_QUANTITY SECONDARY_UNIT_OF_MEASURE SUBLOT_NUM REASON_CODE PRODUCT_CODE PRODUCT_TRANSACTION_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 EXPIRATION_ACTION_CODE EXPIRATION_ACTION_DATE HOLD_DATE ORIGINATION_TYPE PARENT_LOT_NUMBER REASON_ID PARENT_OBJECT_TYPE PARENT_OBJECT_ID PARENT_OBJECT_NUMBER PARENT_ITEM_ID PARENT_OBJECT_TYPE2 PARENT_OBJECT_ID2 PARENT_OBJECT_NUMBER2 DESCRIPTION VENDOR_ID SUPPLIER_LOT_NUMBER TERRITORY_CODE ORIGINATION_DATE DATE_CODE GRADE_CODE CHANGE_DATE MATURITY_DATE STATUS_ID RETEST_DATE AGE ITEM_SIZE COLOR LOT_VOLUME VOLUME_UOM PLACE_OF_ORIGIN BEST_BY_DATE LOT_LENGTH LENGTH_UOM RECYCLED_CONTENT LOT_THICKNESS THICKNESS_UOM LOT_WIDTH WIDTH_UOM CURL_WRINKLE_FOLD LOT_ATTRIBUTE_CATEGORY 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 VENDOR_NAME GROUP_HEADER_ID PUT_AWAY_RULE_ID PICK_RULE_ID QC_GRADE PROCESS_FLAG SOURCE_CODE SOURCE_LINE_ID 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 '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 , TRANSACTION_QUANTITY TRANSACTION_QUANTITY , PRIMARY_QUANTITY PRIMARY_QUANTITY , LOT_NUMBER LOT_NUMBER , LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , SERIAL_TRANSACTION_TEMP_ID SERIAL_TRANSACTION_TEMP_ID , ERROR_CODE ERROR_CODE , SECONDARY_QUANTITY SECONDARY_QUANTITY , SECONDARY_UNIT_OF_MEASURE SECONDARY_UNIT_OF_MEASURE , SUBLOT_NUM SUBLOT_NUM , REASON_CODE REASON_CODE , 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 , EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE , EXPIRATION_ACTION_DATE EXPIRATION_ACTION_DATE , HOLD_DATE HOLD_DATE , ORIGINATION_TYPE ORIGINATION_TYPE , PARENT_LOT_NUMBER PARENT_LOT_NUMBER , REASON_ID REASON_ID , 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 , DESCRIPTION DESCRIPTION , VENDOR_ID VENDOR_ID , SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER , TERRITORY_CODE TERRITORY_CODE , ORIGINATION_DATE ORIGINATION_DATE , DATE_CODE DATE_CODE , GRADE_CODE GRADE_CODE , CHANGE_DATE CHANGE_DATE , MATURITY_DATE MATURITY_DATE , STATUS_ID STATUS_ID , RETEST_DATE RETEST_DATE , AGE AGE , ITEM_SIZE ITEM_SIZE , COLOR COLOR , LOT_VOLUME LOT_VOLUME , VOLUME_UOM VOLUME_UOM , PLACE_OF_ORIGIN PLACE_OF_ORIGIN , BEST_BY_DATE BEST_BY_DATE , LOT_LENGTH LOT_LENGTH , LENGTH_UOM LENGTH_UOM , RECYCLED_CONTENT RECYCLED_CONTENT , LOT_THICKNESS LOT_THICKNESS , THICKNESS_UOM THICKNESS_UOM , LOT_WIDTH LOT_WIDTH , WIDTH_UOM WIDTH_UOM , CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD , LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY , 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 , VENDOR_NAME VENDOR_NAME , GROUP_HEADER_ID GROUP_HEADER_ID , PUT_AWAY_RULE_ID PUT_AWAY_RULE_ID , PICK_RULE_ID PICK_RULE_ID , QC_GRADE QC_GRADE , NULL PROCESS_FLAG , NULL SOURCE_CODE , NULL SOURCE_LINE_ID , 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_TRANSACTION_LOTS_TEMP UNION ALL SELECT '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 , TRANSACTION_QUANTITY TRANSACTION_QUANTITY , PRIMARY_QUANTITY PRIMARY_QUANTITY , LOT_NUMBER LOT_NUMBER , LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , SERIAL_TRANSACTION_TEMP_ID SERIAL_TRANSACTION_TEMP_ID , ERROR_CODE ERROR_CODE , SECONDARY_TRANSACTION_QUANTITY SECONDARY_QUANTITY , NULL SECONDARY_UNIT_OF_MEASURE , SUBLOT_NUM SUBLOT_NUM , REASON_CODE REASON_CODE , 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 , EXPIRATION_ACTION_CODE EXPIRATION_ACTION_CODE , EXPIRATION_ACTION_DATE EXPIRATION_ACTION_DATE , HOLD_DATE HOLD_DATE , ORIGINATION_TYPE ORIGINATION_TYPE , PARENT_LOT_NUMBER PARENT_LOT_NUMBER , REASON_ID REASON_ID , 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 , DESCRIPTION DESCRIPTION , VENDOR_ID VENDOR_ID , SUPPLIER_LOT_NUMBER SUPPLIER_LOT_NUMBER , TERRITORY_CODE TERRITORY_CODE , ORIGINATION_DATE ORIGINATION_DATE , DATE_CODE DATE_CODE , GRADE_CODE GRADE_CODE , CHANGE_DATE CHANGE_DATE , MATURITY_DATE MATURITY_DATE , STATUS_ID STATUS_ID , RETEST_DATE RETEST_DATE , AGE AGE , ITEM_SIZE ITEM_SIZE , COLOR COLOR , LOT_VOLUME LOT_VOLUME , VOLUME_UOM VOLUME_UOM , PLACE_OF_ORIGIN PLACE_OF_ORIGIN , BEST_BY_DATE BEST_BY_DATE , LOT_LENGTH LOT_LENGTH , LENGTH_UOM LENGTH_UOM , RECYCLED_CONTENT RECYCLED_CONTENT , LOT_THICKNESS LOT_THICKNESS , THICKNESS_UOM THICKNESS_UOM , LOT_WIDTH LOT_WIDTH , WIDTH_UOM WIDTH_UOM , CURL_WRINKLE_FOLD CURL_WRINKLE_FOLD , LOT_ATTRIBUTE_CATEGORY LOT_ATTRIBUTE_CATEGORY , 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 , VENDOR_NAME VENDOR_NAME , NULL GROUP_HEADER_ID , NULL PUT_AWAY_RULE_ID , NULL PICK_RULE_ID , NULL QC_GRADE , PROCESS_FLAG PROCESS_FLAG , SOURCE_CODE SOURCE_CODE , SOURCE_LINE_ID SOURCE_LINE_ID , 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_TRANSACTION_LOTS_INTERFACE |