VIEW: APPS.PSB_FLEX_MAPPING_SEGMENTS_V

Source

View Text - Preformatted

SELECT DISTINCT val.flex_mapping_set_id ,val.application_column_name ,seg.segment_name ,seg.id_flex_num ,val.flex_value_set_id FROM psb_flex_mapping_set_values val ,fnd_id_flex_segments_vl seg ,psb_flex_mapping_sets sets where val.flex_mapping_set_id = sets.flex_mapping_set_id and seg.application_column_name = val.application_column_name and seg.application_id = 101 and seg.id_flex_code='GL#'

View Text - HTML Formatted

SELECT DISTINCT VAL.FLEX_MAPPING_SET_ID
, VAL.APPLICATION_COLUMN_NAME
, SEG.SEGMENT_NAME
, SEG.ID_FLEX_NUM
, VAL.FLEX_VALUE_SET_ID
FROM PSB_FLEX_MAPPING_SET_VALUES VAL
, FND_ID_FLEX_SEGMENTS_VL SEG
, PSB_FLEX_MAPPING_SETS SETS
WHERE VAL.FLEX_MAPPING_SET_ID = SETS.FLEX_MAPPING_SET_ID
AND SEG.APPLICATION_COLUMN_NAME = VAL.APPLICATION_COLUMN_NAME
AND SEG.APPLICATION_ID = 101
AND SEG.ID_FLEX_CODE='GL#'