Wednesday, November 7, 2012

Find the Value Set For Reports

SELECT flex_value_set_name
  FROM fnd_flex_validation_tables ffvt, fnd_flex_value_sets ffvs
 WHERE ffvs.flex_value_set_id = ffvt.flex_value_set_id
   AND application_table_name LIKE '%HR_OPERATING%'  -- Table Name
   AND ID_COLUMN_NAME LIKE '%ORGANIZATION%'  -- column  you are passing to the report

No comments:

Post a Comment