INV_PENDING_TXNS_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

TRANSACTION_ID TRANSACTION_STATE ORGANIZATION_ID INVENTORY_ITEM_ID PROCESSING_STATUS ERROR_CODE ERROR_EXPLANATION SUBINVENTORY_CODE LOCATOR_ID TRANSFER_SUBINVENTORY TRANSFER_ORGANIZATION TRANSFER_TO_LOCATION REVISION TRANSACTION_QUANTITY TRANSACTION_UOM PRIMARY_QUANTITY SECONDARY_TRANSACTION_QUANTITY SECONDARY_UOM_CODE TRANSACTION_HEADER_ID TRANSACTION_BATCH_ID TRANSACTION_DATE TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_ID SOURCE_HEADER_NUMBER SOURCE_CODE SOURCE_LINE_ID SOURCE_HEADER_ID TRX_SOURCE_LINE_ID TRX_SOURCE_DELIVERY_ID DEMAND_SOURCE_HEADER_ID DEMAND_SOURCE_LINE DEMAND_SOURCE_DELIVERY MOVE_ORDER_HEADER_ID TRANSACTION_TYPE_ID TRANSACTION_ACTION_ID TRANSACTION_STATUS TRANSACTION_MODE LOCK_FLAG VALIDATION_REQUIRED REQUEST_ID TRANSACTION_REFERENCE REASON_ID LOCATION_TYPE SHIP_TO_LOCATION_ID SHIPMENT WAYBILL FREIGHT_CARRIER_ID CONTAINERS TRANSFER_COST TRANSPORTATION_COST EXPECTED_ARRIVAL_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY OBJECT_VERSION_NUMBER DEFAULT_TAXATION_COUNTRY FIRST_PTY_REG_ID THIRD_PTY_REG_ID FINAL_DISCHARGE_LOCATION_ID DOCUMENT_SUB_TYPE TRX_BUSINESS_CATEGORY USER_DEFINED_FISC_CLASS TAX_INVOICE_NUMBER TAX_INVOICE_DATE PRODUCT_FISC_CLASSIFICATION PRODUCT_CATEGORY INTENDED_USE_CLASSIF_ID PRODUCT_TYPE ASSESSABLE_VALUE TAX_CLASSIFICATION_CODE EXEMPT_CERTIFICATE_NUMBER EXEMPT_REASON_CODE SHIP_FROM_LOCATION_ID CATEGORY_ID OWNING_ORGANIZATION_ID OWNING_TP_TYPE XFR_OWNING_ORGANIZATION_ID TRANSFER_OWNING_TP_TYPE CURRENCY_CODE DISTRIBUTION_ACCOUNT_ID EXTERNAL_SYSTEM_PACKING_UNIT PJC_CONTEXT_CATEGORY PJC_PROJECT_ID PJC_TASK_ID TASK_ID PROJECT_ID INV_STRIPING_CATEGORY COUNTRY_OF_ORIGIN_CODE INV_RESERVED_ATTRIBUTE1 INV_RESERVED_ATTRIBUTE2 INV_USER_DEF_ATTRIBUTE1 INV_USER_DEF_ATTRIBUTE2 INV_USER_DEF_ATTRIBUTE3 INV_USER_DEF_ATTRIBUTE4 INV_USER_DEF_ATTRIBUTE5 INV_USER_DEF_ATTRIBUTE6 INV_USER_DEF_ATTRIBUTE7 INV_USER_DEF_ATTRIBUTE8 INV_USER_DEF_ATTRIBUTE9 INV_USER_DEF_ATTRIBUTE10 INV_PROJECT INV_TASK COUNTRY_OF_ORIGIN_NAME TRANSFER_INV_PROJECT TRANSFER_INV_TASK TRANSFER_PROJECT_ID TRANSFER_TASK_ID REQUESTER_ID LOT_TXN_GROUP_NAME SOURCE_LOT_FLAG EXTERNAL_SYS_TXN_REFERENCE REPRESENTATIVE_LOT_NUMBER LOAD_REQUEST_ID

Query

SQL_Statement

SELECT TRANSACTION_TEMP_ID AS TRANSACTION_ID , 'VALIDATED' AS TRANSACTION_STATE , ORGANIZATION_ID , INVENTORY_ITEM_ID , PROCESS_FLAG AS PROCESSING_STATUS , ERROR_CODE , ERROR_EXPLANATION , SUBINVENTORY_CODE , LOCATOR_ID , TRANSFER_SUBINVENTORY , TRANSFER_ORGANIZATION , TRANSFER_TO_LOCATION , REVISION , TRANSACTION_QUANTITY , TRANSACTION_UOM , PRIMARY_QUANTITY , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE , TRANSACTION_HEADER_ID , TRANSACTION_BATCH_ID , TRANSACTION_DATE , TRANSACTION_SOURCE_TYPE_ID , TRANSACTION_SOURCE_ID , TRANSACTION_SOURCE_NAME as SOURCE_HEADER_NUMBER , SOURCE_CODE , SOURCE_LINE_ID , NULL AS SOURCE_HEADER_ID , TRX_SOURCE_LINE_ID , TRX_SOURCE_DELIVERY_ID , DEMAND_SOURCE_HEADER_ID , DEMAND_SOURCE_LINE , DEMAND_SOURCE_DELIVERY , MOVE_ORDER_HEADER_ID , TRANSACTION_TYPE_ID , TRANSACTION_ACTION_ID , DECODE(NVL(TRANSACTION_STATUS, 1), 2, 2, 1) AS TRANSACTION_STATUS , TRANSACTION_MODE , LOCK_FLAG , NULL AS VALIDATION_REQUIRED , REQUEST_ID , TRANSACTION_REFERENCE , REASON_ID , LOCATION_TYPE , SHIP_TO_LOCATION AS SHIP_TO_LOCATION_ID , SHIPMENT_NUMBER AS SHIPMENT , WAYBILL_AIRBILL AS WAYBILL , FREIGHT_CARRIER_ID , CONTAINERS , TRANSFER_COST , TRANSPORTATION_COST , EXPECTED_ARRIVAL_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY , OBJECT_VERSION_NUMBER , DEFAULT_TAXATION_COUNTRY , FIRST_PTY_REG_ID , THIRD_PTY_REG_ID , FINAL_DISCHARGE_LOCATION_ID , DOCUMENT_SUB_TYPE , TRX_BUSINESS_CATEGORY , USER_DEFINED_FISC_CLASS , TAX_INVOICE_NUMBER , TAX_INVOICE_DATE , PRODUCT_FISC_CLASSIFICATION , PRODUCT_CATEGORY , INTENDED_USE_CLASSIF_ID , PRODUCT_TYPE , ASSESSABLE_VALUE , TAX_CLASSIFICATION_CODE , EXEMPT_CERTIFICATE_NUMBER , EXEMPT_REASON_CODE , SHIP_FROM_LOCATION_ID , CATEGORY_ID , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , CURRENCY_CODE , DISTRIBUTION_ACCOUNT_ID , EXTERNAL_SYSTEM_PACKING_UNIT , PJC_CONTEXT_CATEGORY , PJC_PROJECT_ID , PJC_TASK_ID , TASK_ID , PROJECT_ID , INV_STRIPING_CATEGORY , COUNTRY_OF_ORIGIN_CODE , INV_RESERVED_ATTRIBUTE1 , INV_RESERVED_ATTRIBUTE2 , INV_USER_DEF_ATTRIBUTE1 , INV_USER_DEF_ATTRIBUTE2 , INV_USER_DEF_ATTRIBUTE3 , INV_USER_DEF_ATTRIBUTE4 , INV_USER_DEF_ATTRIBUTE5 , INV_USER_DEF_ATTRIBUTE6 , INV_USER_DEF_ATTRIBUTE7 , INV_USER_DEF_ATTRIBUTE8 , INV_USER_DEF_ATTRIBUTE9 , INV_USER_DEF_ATTRIBUTE10 , NULL AS INV_PROJECT , NULL AS INV_TASK , NULL AS COUNTRY_OF_ORIGIN_NAME , NULL AS TRANSFER_INV_PROJECT , NULL AS TRANSFER_INV_TASK , TRANSFER_PROJECT_ID , TRANSFER_TASK_ID , REQUESTER_ID,LOT_TXN_GROUP_NAME,SOURCE_LOT_FLAG , EXTERNAL_SYS_TXN_REFERENCE , NULL AS REPRESENTATIVE_LOT_NUMBER , LOAD_REQUEST_ID FROM INV_MATERIAL_TXNS_TEMP UNION ALL SELECT TRANSACTION_INTERFACE_ID AS TRANSACTION_ID , 'STAGED' AS TRANSACTION_STATE , ORGANIZATION_ID , INVENTORY_ITEM_ID , DECODE(PROCESS_FLAG, '1', 'Y', '2', 'N', '3', 'E') AS PROCESSING_STATUS , ERROR_CODE , ERROR_EXPLANATION , SUBINVENTORY_CODE , LOCATOR_ID , TRANSFER_SUBINVENTORY , TRANSFER_ORGANIZATION , TRANSFER_LOCATOR , REVISION , TRANSACTION_QUANTITY , TRANSACTION_UOM , PRIMARY_QUANTITY , SECONDARY_TRANSACTION_QUANTITY , SECONDARY_UOM_CODE , TRANSACTION_HEADER_ID , TRANSACTION_BATCH_ID , TRANSACTION_DATE , TRANSACTION_SOURCE_TYPE_ID , TRANSACTION_SOURCE_ID , TRANSACTION_SOURCE_NAME as SOURCE_HEADER_NUMBER , SOURCE_CODE , SOURCE_LINE_ID , SOURCE_HEADER_ID , TRX_SOURCE_LINE_ID , TRX_SOURCE_DELIVERY_ID , DEMAND_SOURCE_HEADER_ID , DEMAND_SOURCE_LINE , DEMAND_SOURCE_DELIVERY , NULL AS MOVE_ORDER_HEADER_ID , TRANSACTION_TYPE_ID , TRANSACTION_ACTION_ID , NULL AS TRANSACTION_STATUS , TRANSACTION_MODE , DECODE(LOCK_FLAG, '1', 'Y', '2', 'N') AS LOCK_FLAG , VALIDATION_REQUIRED , REQUEST_ID , TRANSACTION_REFERENCE , REASON_ID , LOCATION_TYPE , SHIP_TO_LOCATION_ID , SHIPMENT_NUMBER AS SHIPMENT , WAYBILL_AIRBILL AS WAYBILL , FREIGHT_CARRIER_ID , CONTAINERS , TRANSFER_COST , TRANSPORTATION_COST , EXPECTED_ARRIVAL_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY , OBJECT_VERSION_NUMBER , DEFAULT_TAXATION_COUNTRY , FIRST_PTY_REG_ID , THIRD_PTY_REG_ID , FINAL_DISCHARGE_LOCATION_ID , DOCUMENT_SUB_TYPE , TRX_BUSINESS_CATEGORY , USER_DEFINED_FISC_CLASS , TAX_INVOICE_NUMBER , TAX_INVOICE_DATE , PRODUCT_FISC_CLASSIFICATION , PRODUCT_CATEGORY , INTENDED_USE_CLASSIF_ID , PRODUCT_TYPE , ASSESSABLE_VALUE , TAX_CLASSIFICATION_CODE , EXEMPT_CERTIFICATE_NUMBER , EXEMPT_REASON_CODE , SHIP_FROM_LOCATION_ID , CATEGORY_ID , OWNING_ORGANIZATION_ID , OWNING_TP_TYPE , XFR_OWNING_ORGANIZATION_ID , TRANSFER_OWNING_TP_TYPE , CURRENCY_CODE , DISTRIBUTION_ACCOUNT_ID , EXTERNAL_SYSTEM_PACKING_UNIT , PJC_CONTEXT_CATEGORY , PJC_PROJECT_ID , PJC_TASK_ID , TASK_ID , PROJECT_ID , INV_STRIPING_CATEGORY , COUNTRY_OF_ORIGIN_CODE , INV_RESERVED_ATTRIBUTE1 , INV_RESERVED_ATTRIBUTE2 , INV_USER_DEF_ATTRIBUTE1 , INV_USER_DEF_ATTRIBUTE2 , INV_USER_DEF_ATTRIBUTE3 , INV_USER_DEF_ATTRIBUTE4 , INV_USER_DEF_ATTRIBUTE5 , INV_USER_DEF_ATTRIBUTE6 , INV_USER_DEF_ATTRIBUTE7 , INV_USER_DEF_ATTRIBUTE8 , INV_USER_DEF_ATTRIBUTE9 , INV_USER_DEF_ATTRIBUTE10 , INV_PROJECT , INV_TASK , COUNTRY_OF_ORIGIN_NAME , TRANSFER_INV_PROJECT , TRANSFER_INV_TASK , TRANSFER_PROJECT_ID , TRANSFER_TASK_ID , REQUESTER_ID,LOT_TXN_GROUP_NAME,SOURCE_LOT_FLAG , EXTERNAL_SYS_TXN_REFERENCE,REPRESENTATIVE_LOT_NUMBER , LOAD_REQUEST_ID FROM INV_TRANSACTIONS_INTERFACE