SQL to get the Ship confirmation Errors
Summary:
SQL to get the Ship confirmation Errors
Content (please ensure you mask any confidential information):
We are trying to create a report or identifying all the errors occurred during the process of ship confirmation. We do have a standard spreadsheet which helps us to get the extract of orders and shipment details but we can view only 500 records at any given point of time.
We need a SQL which can help us to extract all the orders and corresponding details which are currently stuck in "Manage Shipping Transactions Interface"
Can anyone share a SQL which can help us to view all the errors/lot details at one place.