Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create or replace type LineItem as object (
    Invoice# varchar (50),
    ItemId varchar (50),
    Quantity int,
    Description varchar (50) ,
    UnitPrice decimal (10,5) ,
    LineTotal decimal (10,5)
    );
  



create or replace type LineItems as table of LineItem;
with Invoice (invoice#, shipdate, terms) as (
    select 'INV001', date'27-04-18', 'CREDIT' from dual
)
select * 
from Invoice i
join table (LineItems (
    LineItem ('INV001', 'A000100', 1, 'GREEN WIDGET', 35.10, 35.10))) l on (l.Invoice# = i.Invoice#)


INVOICE#
SHIPDATE
TERMS
INVOICE#
ITEMID
QUANTITY
DESCRIPTION
UNITPRICE
LINETOTAL


INV001
18-APR-27
CREDIT
INV001
A000100
1
GREEN WIDGET
35.1
35.1


SELECT LI.* FROM INVOICE I, TABLE(I.LINEITEMS) LI;
ORA-00942: table or view does not exist

SELECT LI.*
FROM INVOICE I, TABLE(I.LineItems (
    LineItem ('INV001', 'A000100', 1, 'GREEN WIDGET', 35.10, 35.10))) LI;
ORA-00942: table or view does not exist