SELECT /*+ ORDERED RULE */ B.NUM_1, B.NUM_2, B.SYS_NAME B_SYS_NAME, B.REST_TYPE, V.NAME as V_NAME, P.C_NAME, P.AMOUNT, P.BAL_SUMMA, P.BAL_DELTA, P.OFICDATE, P.RUR_RATE as RATE, P.USD_RATE,  P.VALUE_ID as "share", cast( dbo.f_Concat( V.NAME, dbo.f_Concat3( '(', P.C_NAME, ')' )) as varchar(255)) as NAME, V.SYSNAME, V.V_TYPE, I.NAME as I_NAME, I.BRANCHES, p15.DIAL_MODE as DM_15, p18.DIAL_MODE as DM_18, S.CLASS as S_CLASS, ST.TYPENAME as S_TYPE, S.NOMINAL, S.NOM_VAL, P.LEVEL_,
 dbo.iif_dd(P.AMOUNT,'=',0, 0, P.BAL_SUMMA/dbo.iif_dd(P.AMOUNT,'=',0, 1, P.AMOUNT)) as BAL_PRICE,
 dbo.iif_dd(P.AMOUNT,'=',0, 0, P.RUR_RATE/dbo.iif_dd(P.AMOUNT,'=',0, 1, P.AMOUNT)) as RUR_PRICE,
P.IS_MARKET_RATE
FROM  table(cast(PR_B_PORTFOLIO( 29739, NULL, '04.06.2004', 'F' ) as T_PR_B_PORTFOLIO)) P
left outer join OD_VALUES V on V.ID=P.VALUE_ID
left outer join FS_OD_BALANCES B on B.ID=P.BAL_ACC
left outer join FS_OD_SHARES S on S.ID=P.VALUE_ID
left outer join FS_OD_FACES I on I.SELF_ID=S.ISSUER and I.LAST_FLAG=1
left outer join OD_P_FACES p15 on p15.FACE=S.ISSUER and p15.DIAL_MODE=15 /*федерал*/
left outer join OD_P_FACES p18 on p18.FACE=S.ISSUER and p18.DIAL_MODE=18 /*муниципал*/
left join OD_SHARE_TYPES_VIEW ST on ST.CLASS=S.CLASS and ST.TYPE_=S.TYPE_

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options

SQL> create or replace type test_row as object ( p1 int, p2 int);
  2  /

Type created.

SQL> create or replace type test_table_type as table of test_row;
  2  /

Type created.

SQL> create or replace function test_func(p_rownum integer) return test_table_type is
  2    Result test_table_type;
  3  begin
  4    select test_row( object_id, object_id )
  5      bulk collect into Result
  6    from all_objects where rownum <= p_rownum;  
  7    return(Result);
  8  end test_func;
  9  /

Function created.

SQL> create table test_table1 ( field1, field2) 
  2    as select  object_id, object_name from all_objects
  3  ;

Table created.

SQL> alter table test_table1 add primary key  (field1);

Table altered.

SQL> analyze table test_table1 compute statistics;

Table analyzed.

SQL>  set autotrace traceonly exp
SQL> select t1.p1, t2.field2  
  2  from  table( cast( test_func(10) as test_table_type) )t1, test_table1 t2
  3  where t1.p1 = t2.field1;

Execution Plan
----------------------------------------------------------

   0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=73 Card=8168 Bytes
          =253208)

   1    0   HASH JOIN (Cost=73 Card=8168 Bytes=253208)
   2    1     COLLECTION ITERATOR (PICKLER FETCH) OF 'TEST_FUNC'
   3    1     TABLE ACCESS (FULL) OF 'TEST_TABLE1' (TABLE) (Cost=48 Ca
          rd=40285 Bytes=1168265)

SQL> select /*+ CARDINALITY( t1 10) */ t1.p1, t2.field2  
  2  from  table( cast( test_func(10) as test_table_type) )t1, test_table1 t2
  3  where t1.p1 = t2.field1;

Execution Plan
----------------------------------------------------------

   0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=34 Card=10 Bytes=3
          10)

   1    0   NESTED LOOPS (Cost=34 Card=10 Bytes=310)
   2    1     COLLECTION ITERATOR (PICKLER FETCH) OF 'TEST_FUNC'
   3    1     TABLE ACCESS (BY INDEX ROWID) OF 'TEST_TABLE1' (TABLE) (
          Cost=1 Card=1 Bytes=29)

   4    3       INDEX (UNIQUE SCAN) OF 'SYS_C005426' (INDEX (UNIQUE))
          (Cost=0 Card=1)