select pzPVStream from pc_link_attachment where pxLinkedRefTo like 'PEGACOMMBANK-CORR-SWIFT XXP161115-000029!20161115T063801.679 GMT%' 
and pxObjClass ='Link-Attachment' 
order by pzInsKey

SELECT STATEMENT, GOAL = ALL_ROWS			Cost=87	Cardinality=1	Bytes=248	Optimizer=ALL_ROWS	CPU cost=12347198			Id=0	IO cost=86					Operation=SELECT STATEMENT								Plan id=8270	Position=87					Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
 PX COORDINATOR										Id=1						Operation=PX COORDINATOR				Parent id=0				Plan id=8270	Position=1	Projection="PZPVSTREAM"[LOB,4000]	Qblock name=SEL$1			Statement id=TEST_APP			Timestamp=12/20/2016 2:15:07 AM
  PX SEND QC (ORDER)	Object owner=SYS	Object name=:TQ10001	Cost=87	Cardinality=1	Bytes=248		CPU cost=12347198			Id=2	IO cost=86			Object node=:Q1001		Operation=PX SEND	Options=QC (ORDER)		Other tag=PARALLEL_TO_SERIAL	Parent id=1				Plan id=8270	Position=1	Projection=(#keys=0) "PZPVSTREAM"[LOB,4000]				Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
   SORT ORDER BY			Cost=87	Cardinality=1	Bytes=248		CPU cost=12347198			Id=3	IO cost=86			Object node=:Q1001		Operation=SORT	Options=ORDER BY		Other tag=PARALLEL_COMBINED_WITH_PARENT	Parent id=2				Plan id=8270	Position=1	Projection=(#keys=1) "PZINSKEY"[VARCHAR2,2040], "PZPVSTREAM"[LOB,4000]				Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
    PX RECEIVE			Cost=86	Cardinality=1	Bytes=248		CPU cost=616407			Id=4	IO cost=86			Object node=:Q1001		Operation=PX RECEIVE			Other tag=PARALLEL_COMBINED_WITH_PARENT	Parent id=3				Plan id=8270	Position=1	Projection="PZINSKEY"[VARCHAR2,2040], "PZPVSTREAM"[LOB,4000]				Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
     PX SEND RANGE	Object owner=SYS	Object name=:TQ10000	Cost=86	Cardinality=1	Bytes=248		CPU cost=616407			Id=5	IO cost=86			Object node=:Q1000		Operation=PX SEND	Options=RANGE		Other tag=PARALLEL_TO_PARALLEL	Parent id=4				Plan id=8270	Position=1	Projection=(#keys=1) "PZINSKEY"[VARCHAR2,2040], "PZPVSTREAM"[LOB,4000]				Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
      PX PARTITION RANGE ALL			Cost=86	Cardinality=1	Bytes=248		CPU cost=616407			Id=6	IO cost=86			Object node=:Q1000		Operation=PX PARTITION RANGE	Options=ALL		Other tag=PARALLEL_COMBINED_WITH_CHILD	Parent id=5	Partition id=6	Partition start=1	Partition stop=53	Plan id=8270	Position=1	Projection="PZINSKEY"[VARCHAR2,2040], "PZPVSTREAM"[LOB,4000]				Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
       TABLE ACCESS BY LOCAL INDEX ROWID	Object owner=CERS	Object name=PC_LINK_ATTACHMENT	Cost=86	Cardinality=1	Bytes=248	Optimizer=ANALYZED	CPU cost=616407		Filter predicates="PXOBJCLASS"='Link-Attachment'	Id=7	IO cost=86	Object alias=PC_LINK_ATTACHMENT@SEL$1	Object instance=1	Object node=:Q1000	Object type=TABLE	Operation=TABLE ACCESS	Options=BY LOCAL INDEX ROWID		Other tag=PARALLEL_COMBINED_WITH_PARENT	Parent id=6	Partition id=6	Partition start=1	Partition stop=53	Plan id=8270	Position=1	Projection="PZINSKEY"[VARCHAR2,2040], "PZPVSTREAM"[LOB,4000]	Qblock name=SEL$1			Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM
        INDEX RANGE SCAN	Object owner=CERS	Object name=PC_ATTACHMENT_IDX_02	Cost=86	Cardinality=1		Optimizer=ANALYZED	CPU cost=609915	Access predicates="PXLINKEDREFTO" LIKE 'PEGACOMMBANK-CORR-SWIFT XXP161115-000029!20161115T063801.679 GMT%'	Filter predicates="PXLINKEDREFTO" LIKE 'PEGACOMMBANK-CORR-SWIFT XXP161115-000029!20161115T063801.679 GMT%'	Id=8	IO cost=86	Object alias=PC_LINK_ATTACHMENT@SEL$1		Object node=:Q1000	Object type=INDEX	Operation=INDEX	Options=RANGE SCAN		Other tag=PARALLEL_COMBINED_WITH_PARENT	Parent id=7	Partition id=6	Partition start=1	Partition stop=53	Plan id=8270	Position=1	Projection="PC_LINK_ATTACHMENT".ROWID[ROWID,10]	Qblock name=SEL$1		Search columns=1	Statement id=TEST_APP		Time=2	Timestamp=12/20/2016 2:15:07 AM