1 Reply Latest reply: Jan 25, 2013 9:07 AM by AlexAnd RSS

    Table Validated Vaue set

    909598
      Hi All,

      I am trying to create a Validated table value set with two tables and 5 fields cancatenated and with a substring
      I do not want to use a view.
      Can someone provide me a sample script for it please.
      Regards
        • 1. Re: Table Validated Vaue set
          AlexAnd
          look at fnd_flex_val_api.create_valueset_table
          fnd_flex_val_api.create_valueset_table(
          ...
          ,table_name                 => 'table1 t1, table2 t2'
          ..
          ,value_column_name          => 't1.column2'
          ...
          ,meaning_column_name        => 't1.column3||'-'||t2.column2'  
          ...
          ,id_column_name             => 't1.column5'
          ...
          ,where_order_by             => 'where t1.column1 = t2.column1'
          ..