How to pass comma separated values as input parameter in BIP – Oracle Fusion Applications

Sample Code

SELECT
hp.party_id, hp.party_Number, hp.party_name 
FROM hz_parties hp 
where 1=1
and hp.party_number IN
 (  select regexp_substr (
           :P_PARTY_NUM_CSV,
           '[^,]+',
           1,
           level
         ) value
  from   dual 
  connect by level <= 
    length ( :P_PARTY_NUM_CSV ) - length ( replace ( :P_PARTY_NUM_CSV, ',' ) ) + 1 )

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: BIP