SELECT
    NVL(SUM(PSAPC.ITEM_QUAN),0)
  INTO
    vItemCount
  FROM
    POB_SHIP_ADDRESS_PROD_CATALOG PSAPC,
    POB_VENDOR_CLAIM_DTL PVCD
  WHERE
    PSAPC.POB_SHIP_ADDRESS_ID IN (SELECT * FROM TABLE(split(psPobShipAddressID))) AND
    PSAPC.POB_PROD_CATALOG_ID = PVCD.POB_PROD_CATALOG_ID AND
    PVCD.POB_VENDOR_CLAIM_ID = piPobVendorClaimID;

CREATE OR REPLACE FUNCTION SPLIT
(
    p_list VARCHAR2,
    p_del VARCHAR2 := ','
) return split_tbl pipelined
is
    l_idx    PLS_INTEGER;
    l_list    VARCHAR2(32767) := p_list;
BEGIN
    LOOP
        l_idx := INSTR(l_list,p_del);
        IF l_idx > 0 THEN
            pipe row(SUBSTR(l_list,1,l_idx-1));
            l_list := SUBSTR(l_list,l_idx+length(p_del));
        ELSE
            pipe row(l_list);
            EXIT;
        END IF;
    END LOOP;
    RETURN;
END SPLIT;

SELECT STATEMENT, GOAL = ALL_ROWS			Cost=42	Cardinality=1	Bytes=27
 SORT AGGREGATE				Cardinality=1	Bytes=27
  HASH JOIN SEMI			Cost=42	Cardinality=7	Bytes=189
   TABLE ACCESS BY INDEX ROWID	Object owner=MASYS	Object name=POB_SHIP_ADDRESS_PROD_CATALOG	Cost=3	Cardinality=16	Bytes=224
    NESTED LOOPS			Cost=17	Cardinality=117	Bytes=2925
     INDEX RANGE SCAN	Object owner=MASYS	Object name=UK_PVCD_PVCIDPPCID_INDX	Cost=2	Cardinality=7	Bytes=77
     INDEX RANGE SCAN	Object owner=MASYS	Object name=PSAPC_PPCID_IDX	Cost=2	Cardinality=16	
   COLLECTION ITERATOR PICKLER FETCH		Object name=SPLIT