ONT Orders Failing Trip Stop
Description
List of orders with accounts
Run
ONT Orders Failing Trip Stop and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |