Oracle 11g - Join two tables based on complex query that splits values
I have two queries, one quite complex (courtesy of expert exchange user sdstuber) that splits a value in a column in to its constituent parts and then finds all the matching rows and pivots the data and another that is a simple select, from where.
Each of these queries and their data are in the attached example spreadsheet under tabs "Part One" and "Part Two". You will in Part One how the simple column data is transfomed into a new set of rows.
What I need to do is join the resulting sets of data together and the example is in the third tab "Example Join". Split-Example.xlsx