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
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