ONT Orders Failing Trip Stop

Description
Categories: Toolkit - Setup & Support
Columns: Order Number, Line Number, Inventory Item Id, Item, Description, Inventory Item Status Code, Item Type, Primary Uom Code, Shippable Item Flag, Entity ...
List of orders with accounts
SELECT H.ORDER_NUMBER,
       L1.LINE_NUMBER,
       MSI.INVENTORY_ITEM_ID          INVENTORY_ITEM_ID,
       MSI.SEGMENT1                   ITEM,
       MSI.DESCRIPTION                DESCRIPTION,
       MSI.INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE,
       MSI.ITEM_TYPE                  ITEM_TYPE,
       MSI.PRIMARY_UOM_CODE           PRIMARY_UOM_CODE,
       MSI.SHIPPABLE_ITEM_FLAG        SHIPPABLE_ITEM_FLAG,
       GCC.SEGMENT1                   ENTITY,
       GCC.SEGMENT2                   DIV,
       GCC.SEGMENT3                   CC,
       GCC.SEGMENT4                   ACCOUNT,
       GCC.SEGMENT5                   PRODUCT,
       GCC.SEGMENT6                   DEF,
       GCC.SEGMENT7                   DEF,
       GCC.SEGMENT7                   DEF
  FROM APPS.MTL_SYSTEM_ITEMS     MSI,
       APPS.GL_CODE_COMBINATIONS GCC,
       APPS.OE_ORDER_HEADERS_ALL H,
       APPS.OE_ORDER_LINES_ALL   L1,
       apps.wsh_delivery_details wdd
 WHERE 1=1
      --AND MSI.COSTING_ENABLED_FLAG = 'Y'
      --   AND MSI.SALES_ACCOUNT(+) = GCC.CODE_COMBINATION_ID --REVENUE
   AND MSI.COST_OF_SALES_ACCOUNT(+) = GCC.CODE_COMBINATION_ID
      --AND MSI.ORGANIZATION_ID = 106
   AND L1.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
   AND H.HEADER_ID = L1.HEADER_ID
      --AND L1.FLOW_STATUS_CODE = 'CLOSED'
   AND L1.SHIP_FROM_ORG_ID = MSI.ORGANIZATION_ID
   AND L1.OPEN_FLAG = 'N'
      --AND L1.SHIPPED_QUANTITY > 0
   and wdd.source_code = 'OE'
   and wdd.source_header_id = L1.header_id
   and wdd.source_line_id = L1.line_id
--and wdd.released_status = 'C'
--B: Backordered- Line failed to be allocated in Inventory 
--C: Shipped -Line has been shipped 
--D: Cancelled -Line is Cancelled 
--N: Not Ready for Release -Line is not ready to be released 
--R: Ready to Release: Line is ready to be released 
--S: Released to Warehouse: Line has been released to Inventory for processing 
--X: Not Applicable- Line is not applicable for Pick Release 
--Y: Staged- Line has been picked and staged by Inventory