SQL> select * from table(dbms_xplan.display_cursor(format=>'allstats last'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
SQL_ID  g0r6x2tykv29b, child number 0

explain plan for    SELECT /*+ GATHER_PLAN_STATISTICS */  DISTINCT
HOB.PO_HEADER_ID,OOH.ORDER_NUMBER,POH.ATTRIBUTE13 OC_NO FROM
OE_ORDER_HEADERS OOH,OE_ORDER_LINES OOL,HWKR_OM_B2B_RELATION_V HOB,
PO_HEADERS POH  WHERE OOH.HEADER_ID = OOL.HEADER_ID  AND
HOB.PO_HEADER_ID =   POH.PO_HEADER_ID  AND OOL.FLOW_STATUS_CODE NOT IN
( 'ENTERED','CANCELLED'  )    AND OOL.LINE_ID = HOB.OE_LINE_ID (+)
AND OOH.ORDER_NUMBER = 1067045

NOTE: cannot fetch plan for SQL_ID: g0r6x2tykv29b, CHILD_NUMBER: 0

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
      Please verify value of SQL_ID and CHILD_NUMBER;
      It could also be that the plan is no longer in cursor cache (check v$sql_p
lan)



14 rows selected.