So, someone forgot some joins. I captured the explain plan and it has costs showing with "E" and "P". I had not seen these before so I'm just reaching out if there is a definition.
I assumed the following...
K = 1,000
M = 1,000,000
G = 1,000,000,000
P = ?
E = ?
Am I right and to E and P just keep extending?
Plan ...
------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time | Pstart| Pstop | Inst |IN-OUT|
------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | | 18E(100)| | | | | |
| 1 | HASH UNIQUE | | 18E| 15E| 15E| 18E (0)|999:59:59 | | | | |
| 2 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 | | | | |
| 3 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 | | | | |
| 4 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 | | | | |
| 5 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 | | | | |
| 6 | MERGE JOIN CARTESIAN | | 18E| 15E| | 18E (0)|999:59:59 | | | | |
| 7 | MERGE JOIN CARTESIAN | | 518P| 15E| | 14P (1)|999:59:59 | | | | |
| 8 | MERGE JOIN CARTESIAN | | 28G| 2699G| | 40M (57)| 00:26:22 | | | | |
| 9 | NESTED LOOPS | | 56515 | 4801K| | 224 (2)| 00:00:01 | | | | |
|* 10 | TABLE ACCESS BY INDEX ROWID| PURCHASE_ORDER | 1 | 45 | | 1 (0)| 00:00:01 | | | | |
|* 11 | INDEX UNIQUE SCAN | PK_PURCHASE_ORDER | 1 | | | 1 (0)| 00:00:01 | | | | |
| 12 | REMOTE | APPLICATION_FACILITY | 1 | 6 | | 2 (0)| 00:00:01 | | | NA553 | R->S |
| 13 | TABLE ACCESS FULL | VENDOR_ITEM | 56515 | 2317K| | 223 (2)| 00:00:01 | | | | |
| 14 | BUFFER SORT | | 512K| 6511K| | 40M (57)| 00:26:22 | | | | |
| 15 | REMOTE | INVENTORY_ADJUSTMENT | 512K| 6511K| | 309 (0)| 00:00:01 | | | NA553 | R->S |
| 16 | BUFFER SORT | | 17M| 579M| | 14P (1)|999:59:59 | | | | |
| 17 | PARTITION RANGE ALL | | 17M| 579M| | 517K (1)| 00:00:21 | 1 | 2357 | | |
| 18 | TABLE ACCESS FULL | INVENTORY_ITEM | 17M| 579M| | 517K (1)| 00:00:21 | 1 | 2357 | | |
| 19 | BUFFER SORT | | 591K| 10M| | 18E (0)|999:59:59 | | | | |
| 20 | TABLE ACCESS FULL | DRUG_XREF | 591K| 10M| | 8562 (2)| 00:00:01 | | | | |
| 21 | BUFFER SORT | | 17M| 408M| | 18E (0)|999:59:59 | | | | |
| 22 | PARTITION RANGE ALL | | 17M| 408M| | 90865 (1)| 00:00:04 | 1 | 2357 | | |
| 23 | TABLE ACCESS FULL | STORAGE_LOCATION | 17M| 408M| | 90865 (1)| 00:00:04 | 1 | 2357 | | |
| 24 | BUFFER SORT | | 891M| 19G| | 18E (0)|999:59:59 | | | | |
| 25 | TABLE ACCESS FULL | INVENTORY_ADJUSTMENT | 891M| 19G| | 4100K (2)| 00:02:41 | | | | |
| 26 | BUFFER SORT | | 67M| 3924M| | 18E (0)|999:59:59 | | | | |
| 27 | TABLE ACCESS FULL | PURCHASE_ORDER_ITEM | 67M| 3924M| | 240K (2)| 00:00:10 | | | | |
| 28 | BUFFER SORT | | 590K| 17M| | 18E (0)|999:59:59 | | | | |
| 29 | INDEX FULL SCAN | IN_PRODUCT_6 | 590K| 17M| | 236 (1)| 00:00:01 | | | | |
------------------------------------------------------------------------------------------------------------------------------------------------------