4. Get the order from the plan
{"Image DocumentName": "4. Get the order from the plan", "Image ImageDescription": "0 FILTER. 0 NESTED LOOPS. 8 NESTED LOOPS NESTED LOOPS. 360 NESTED LOOPS. 10 NESTED LOOPS. 10 (1)TABLE ACCESS (BY INDEX ROWID) OF. PS_PP_PAYMENT_TMP 11 INDEX (RANGE SCAN) OF PSAPP_PAYMENT_TMP (NON-UNIQUE) 20 (2)INDEX (RANGE SCAN) OF PSAPAYMENT_ID_ITEM 360 (3)TABLE ACCESS (BY INDEX ROWID) OF PS_SET_CNTRL_REC 370 INDEX (RANGE SCAN) OF PSBSET_CNTRL_REC (4)TABLE ACCESS (BY INDEX ROWID) OF PS_CUSTOMER INDEX (RANGE SCAN) OF PS#CUSTOMER (NON-UNIQUE) (5)INDEX (RANGE SCAN) OF PS#ITEM (NON-UNIQUE) 8 (6)TABLE ACCESS (BY INDEX ROWID) OF PS_CUST_OPTION 16 INDEX (RANGE SCAN) OF PS_CUST_OPTION (UNIQUE) 0 SORT (AGGREGATE) 0 TABLE ACCESS (BY INDEX ROWID) OF PS_CUST_OPTION INDEX (RANGE SCAN) OF PS_CUST_OPTION (UNIQUE) .The order in which the tables are processed within the query can be obtained from the explain plan. I have added the bracketed numbers.  Go-Faster Consultancy Ltd.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}