Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   MODE: ALL_ROWS
      0   SORT (ORDER BY)
      0    CONCATENATION
      0     FILTER
      0      NESTED LOOPS (OUTER)
      0       NESTED LOOPS (OUTER)
      0        NESTED LOOPS
      0         NESTED LOOPS
      0          NESTED LOOPS
     22           NESTED LOOPS
     22            TABLE ACCESS   MODE: ANALYZED (FULL) OF
                       'MTL_CATEGORIES_B' (TABLE)
     22            INDEX   MODE: ANALYZED (UNIQUE SCAN) OF
                       'MTL_CATEGORIES_TL_U1' (INDEX (UNIQUE))
      0           TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID)
                      OF 'PO_REQUISITION_LINES_ALL' (TABLE)
1585746            INDEX   MODE: ANALYZED (RANGE SCAN) OF
                       'PO_REQUISITION_LINES_N2' (INDEX)
      0          TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                     'PO_REQUISITION_HEADERS_ALL' (TABLE)
      0           INDEX   MODE: ANALYZED (UNIQUE SCAN) OF
                      'PO_REQUISITION_HEADERS_U1' (INDEX (UNIQUE))
      0         TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                    'PO_REQ_DISTRIBUTIONS_ALL' (TABLE)
      0          INDEX   MODE: ANALYZED (RANGE SCAN) OF
                     'PO_REQ_DISTRIBUTIONS_N1' (INDEX)
      0        TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                   'PO_DISTRIBUTIONS_ALL' (TABLE)
      0         INDEX   MODE: ANALYZED (RANGE SCAN) OF
                    'PO_DISTRIBUTIONS_N2' (INDEX)
      0       TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                  'PO_HEADERS_ALL' (TABLE)
      0        INDEX   MODE: ANALYZED (UNIQUE SCAN) OF
                   'PO_HEADERS_U1' (INDEX (UNIQUE))
      0     FILTER
      0      NESTED LOOPS (OUTER)
      0       NESTED LOOPS (OUTER)
      0        NESTED LOOPS
      0         NESTED LOOPS
      0          NESTED LOOPS
      0           NESTED LOOPS
      0            TABLE ACCESS   MODE: ANALYZED (FULL) OF
                       'MTL_CATEGORIES_B' (TABLE)
      0            INDEX   MODE: ANALYZED (UNIQUE SCAN) OF
                       'MTL_CATEGORIES_TL_U1' (INDEX (UNIQUE))
      0           TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID)
                      OF 'PO_REQUISITION_LINES_ALL' (TABLE)
      0            INDEX   MODE: ANALYZED (RANGE SCAN) OF
                       'PO_REQUISITION_LINES_N2' (INDEX)
      0          TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                     'PO_REQUISITION_HEADERS_ALL' (TABLE)
      0           INDEX   MODE: ANALYZED (UNIQUE SCAN) OF
                      'PO_REQUISITION_HEADERS_U1' (INDEX (UNIQUE))
      0         TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                    'PO_REQ_DISTRIBUTIONS_ALL' (TABLE)
      0          INDEX   MODE: ANALYZED (RANGE SCAN) OF
                     'PO_REQ_DISTRIBUTIONS_N1' (INDEX)
      0        TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                   'PO_DISTRIBUTIONS_ALL' (TABLE)
      0         INDEX   MODE: ANALYZED (RANGE SCAN) OF
                    'PO_DISTRIBUTIONS_N2' (INDEX)
      0       TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF
                  'PO_HEADERS_ALL' (TABLE)
      0        INDEX   MODE: ANALYZED (UNIQUE SCAN) OF
                   'PO_HEADERS_U1' (INDEX (UNIQUE))