VIEW: APPS.HR_COMPANY_VS_V

Source

View Text - Preformatted

SELECT distinct vs. flex_value_set_name, vs.description, vs.flex_value_set_id FROM fnd_flex_value_sets vs, fnd_segment_attribute_values v, fnd_id_flex_segments s WHERE s.application_id = 101 AND s.id_flex_code = 'GL#' AND s.enabled_flag = 'Y' AND v.application_id = s.application_id AND V.id_flex_code = s.id_flex_code AND v.id_flex_num = s.id_flex_num AND v.application_column_name = s.application_column_name AND v.segment_attribute_type = 'GL_BALANCING' AND v.attribute_value = 'Y' AND s.flex_value_set_id = vs.flex_value_set_id

View Text - HTML Formatted

SELECT DISTINCT VS. FLEX_VALUE_SET_NAME
, VS.DESCRIPTION
, VS.FLEX_VALUE_SET_ID
FROM FND_FLEX_VALUE_SETS VS
, FND_SEGMENT_ATTRIBUTE_VALUES V
, FND_ID_FLEX_SEGMENTS S
WHERE S.APPLICATION_ID = 101
AND S.ID_FLEX_CODE = 'GL#'
AND S.ENABLED_FLAG = 'Y'
AND V.APPLICATION_ID = S.APPLICATION_ID
AND V.ID_FLEX_CODE = S.ID_FLEX_CODE
AND V.ID_FLEX_NUM = S.ID_FLEX_NUM
AND V.APPLICATION_COLUMN_NAME = S.APPLICATION_COLUMN_NAME
AND V.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'
AND V.ATTRIBUTE_VALUE = 'Y'
AND S.FLEX_VALUE_SET_ID = VS.FLEX_VALUE_SET_ID