create table ss_load_trans 
(
  source_id   varchar2(20) not null,
  trans_logic trans_dtl
)  
NESTED TABLE trans_logic STORE AS trans_logic_tab


create type t_typ_trans_dtl is object
(
    trans_id     varchar2(20),
    sc_flg       char(1),
    dc_flg       char(1),
    sub_trans_id sub_trans_dtl
)    
    
CREATE TYPE trans_dtl
   AS TABLE OF t_typ_trans_dtl;
    
create  type t_typ_sub_trans_dtl is object
(
    sub_trans_id  varchar2(20),
    sc_value      varchar2(500),
    fc_value      varchar2(500),
    cc_value      varchar2(500),
    dc_value      varchar2(500)
)    

CREATE TYPE sub_trans_dtl
   AS TABLE OF t_typ_sub_trans_dtl;

create table ss_load_trans
(
  source_id   varchar2(20) not null,
  trans_logic trans_dtl
)  
NESTED TABLE trans_logic STORE AS nested_tab return as value

Error starting at line 1 in command:
create table ss_load_trans
(
  source_id   varchar2(20) not null,
  trans_logic trans_dtl
)  
NESTED TABLE trans_logic STORE AS nested_tab return as value
Error at Command Line:1 Column:1
Error report:
SQL Error: ORA-02320: failure in creating storage table for nested table column TRANS_LOGIC
ORA-22913: must specify table name for nested table column or attribute
02320. 00000 -  "failure in creating storage table for nested table column %s"
*Cause:    An error occurred while creating the storage table for the
           specified nested table column.
*Action:   See the messages that follow for more details. If the situation
           they describe can be corrected, do so; otherwise contact Oracle
           Support.

orclz> CREATE OR REPLACE TYPE trans_dtl AS TABLE OF VARCHAR2(30);
  2  /

Type created.

orclz>
orclz>
orclz> create table ss_load_trans
  2  (
  3    source_id   varchar2(20) not null,
  4    trans_logic trans_dtl
  5  )
  6  NESTED TABLE trans_logic STORE AS nested_tab return as value;

Table created.

orclz>

create table ss_load_trans 
(
  source_id   varchar2(20) not null,
  trans_logic trans_dtl
)  
NESTED TABLE trans_logic STORE AS trans_logic_tab


create type t_typ_trans_dtl is object
(
    trans_id     varchar2(20),
    sc_flg       char(1),
    dc_flg       char(1),
    sub_trans_id sub_trans_dtl
)    
    
CREATE TYPE trans_dtl
   AS TABLE OF t_typ_trans_dtl;
    
create  type t_typ_sub_trans_dtl is object
(
    sub_trans_id  varchar2(20),
    sc_value      varchar2(500),
    fc_value      varchar2(500),
    cc_value      varchar2(500),
    dc_value      varchar2(500)
)    

CREATE TYPE sub_trans_dtl
   AS TABLE OF t_typ_sub_trans_dtl;

SCOTT@orcl> create  type t_typ_sub_trans_dtl is object
  2  (
  3  	 sub_trans_id  varchar2(20),
  4  	 sc_value      varchar2(500),
  5  	 fc_value      varchar2(500),
  6  	 cc_value      varchar2(500),
  7  	 dc_value      varchar2(500)
  8  );
  9  /

Type created.

SCOTT@orcl> CREATE TYPE sub_trans_dtl
  2  	AS TABLE OF t_typ_sub_trans_dtl;
  3  /

Type created.

SCOTT@orcl> create type t_typ_trans_dtl is object
  2  (
  3  	 trans_id     varchar2(20),
  4  	 sc_flg       char(1),
  5  	 dc_flg       char(1),
  6  	 sub_trans_id sub_trans_dtl
  7  );
  8  /

Type created.

SCOTT@orcl> CREATE TYPE trans_dtl
  2  	AS TABLE OF t_typ_trans_dtl;
  3  /

Type created.

SCOTT@orcl> create table ss_load_trans
  2  (
  3    source_id   varchar2(20) not null,
  4    trans_logic trans_dtl
  5  )
  6  NESTED TABLE trans_logic STORE AS trans_logic_tab
  7    (NESTED TABLE sub_trans_id STORE AS sub_trans_id_tab)
  8  /

Table created.

[b][u]Overview of my requirement is[/u] [/b]

I will have multiple source files on jurisdiction basis
for each source i will have multiple columns
for each columns have multiple transformations
for each transformation i have multiple sub transformation

so i decided to have collection tables in the below format
Suggestions if my design is wrong 

This is the first time am implementing collection with nested tables.

create or replace 
type t_typ_sub_trans_dtl is object
(
    tbl_id        varchar2(20),
    trans_id     varchar2(20),
    sub_trans_id  varchar2(20),
    sc_flg       char(1),
    dc_flg       char(1),   
    sc_value      varchar2(500),
    fc_value      varchar2(500),
    cc_value      varchar2(500),
    src_tbl_name varchar2(150),
    src_col_name varchar(150),
    trgt_tbl_name varchar2(150),
    trgt_col_name varchar2(150)
)    

create or replace 
TYPE sub_trans_dtl
   AS TABLE OF t_typ_sub_trans_dtl;

  CREATE TABLE SS_REPO.SS_LOAD_TRANS 
   (	SOURCE_ID VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	TBL_ID VARCHAR2(20 BYTE), 
	TBL_NAME VARCHAR2(150 BYTE), 
	STG_TBL_NAME VARCHAR2(150 BYTE) NOT NULL ENABLE, 
	STG_COL_NAME VARCHAR2(150 BYTE) NOT NULL ENABLE, 
	PRIORITY_FLG NUMBER, 
	TRANS_ID VARCHAR2(20 BYTE), 
	SUB_TRANS_LOGIC SS_REPO.SUB_TRANS_DTL  DEFAULT SS_REPO.SUB_TRANS_DTL()
   ) 
 NESTED TABLE SUB_TRANS_LOGIC STORE AS SUB_TRANS_LOGIC_TAB

[b]My aim is to delete and update the data by referring columns in nested table.[/b]

Error starting at line 28 in command:
delete  from TABLE(select a.sub_trans_logic from ss_load_trans a where a.source_id ='TH_RDSINV3' and stg_col_name='SEGMENT' ) e
  where e.trans_id='RDS3_T10' and e.sub_trans_id='RDS3_ST10' 
Error report:
SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 -  "single-row subquery returns more than one row"
*Cause:    
*Action:

SCOTT@orcl> COLUMN source_id	FORMAT A10
SCOTT@orcl> COLUMN stg_col_name FORMAT A19
SCOTT@orcl> SELECT a.source_id, a.stg_col_name, e.trans_id, e.sub_trans_id
  2  FROM   ss_load_trans a,
  3  	    TABLE (a.sub_trans_logic) e
  4  /

SOURCE_ID  STG_COL_NAME        TRANS_ID             SUB_TRANS_ID
---------- ------------------- -------------------- --------------------
TH_RDSINV3 RC_AO_CODE          RDS3_T1              RDS3_ST1
TH_RDSINV3 SEGMENT             RDS3_T10             RDS3_ST2
TH_RDSINV3 SEGMENT             RDS3_T10             RDS3_ST10
TH_RDSINV3 BRANCH_CODE         RDS3_T2              RDS3_ST2
TH_RDSINV3 GEID                RDS3_T3              RDS3_ST3
TH_RDSINV3 FIRST_NAME          RDS3_T5              RDS3_ST5
TH_RDSINV3 LAST_NAME           RDS3_T6              RDS3_ST6
TH_RDSINV3 MGR_GEID            RDS3_T7              RDS3_ST7
TH_RDSINV3 TEAM                RDS3_T8              RDS3_ST8
TH_RDSINV3 IS_HIGH_PERFORMANCE RDS3_T9              RDS3_ST9

10 rows selected.

SCOTT@orcl> delete from TABLE
  2    (select a.sub_trans_logic
  3  	from   ss_load_trans a
  4  	where  a.source_id ='TH_RDSINV3'
  5  	and   stg_col_name='SEGMENT' ) e
  6  where e.trans_id='RDS3_T10'
  7  and   e.sub_trans_id='RDS3_ST10'
  8  /

1 row deleted.

SCOTT@orcl> SELECT a.source_id, a.stg_col_name, e.trans_id, e.sub_trans_id
  2  FROM   ss_load_trans a,
  3  	    TABLE (a.sub_trans_logic) e
  4  /

SOURCE_ID  STG_COL_NAME        TRANS_ID             SUB_TRANS_ID
---------- ------------------- -------------------- --------------------
TH_RDSINV3 RC_AO_CODE          RDS3_T1              RDS3_ST1
TH_RDSINV3 SEGMENT             RDS3_T10             RDS3_ST2
TH_RDSINV3 BRANCH_CODE         RDS3_T2              RDS3_ST2
TH_RDSINV3 GEID                RDS3_T3              RDS3_ST3
TH_RDSINV3 FIRST_NAME          RDS3_T5              RDS3_ST5
TH_RDSINV3 LAST_NAME           RDS3_T6              RDS3_ST6
TH_RDSINV3 MGR_GEID            RDS3_T7              RDS3_ST7
TH_RDSINV3 TEAM                RDS3_T8              RDS3_ST8
TH_RDSINV3 IS_HIGH_PERFORMANCE RDS3_T9              RDS3_ST9

9 rows selected.