eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PSB_FLEX_MAPPING_SEGMENTS_V

Product:	PSB - Public Sector Budgeting (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
FLEX_MAPPING_SET_ID
APPLICATION_COLUMN_NAME
SEGMENT_NAME
ID_FLEX_NUM
FLEX_VALUE_SET_ID