VIEW: APPS.FND_INDEXED_SEGS_V

Source

View Text - Preformatted

SELECT SEGMENT_NAME, APPLICATION_COLUMN_NAME, ID_FLEX_NUM FROM FND_ID_FLEX_SEGMENTS SEG where ENABLED_FLAG = 'Y' AND ID_FLEX_CODE = 'GL#' AND APPLICATION_ID = 101 AND EXISTS( SELECT COLUMN_NAME FROM ALL_IND_COLUMNS COLS WHERE SEG.APPLICATION_COLUMN_NAME = COLS.COLUMN_NAME AND COLS.COLUMN_POSITION = 1 AND COLS.TABLE_NAME = 'GL_CODE_COMBINATIONS')

View Text - HTML Formatted

SELECT SEGMENT_NAME
, APPLICATION_COLUMN_NAME
, ID_FLEX_NUM
FROM FND_ID_FLEX_SEGMENTS SEG
WHERE ENABLED_FLAG = 'Y'
AND ID_FLEX_CODE = 'GL#'
AND APPLICATION_ID = 101
AND EXISTS( SELECT COLUMN_NAME
FROM ALL_IND_COLUMNS COLS
WHERE SEG.APPLICATION_COLUMN_NAME = COLS.COLUMN_NAME
AND COLS.COLUMN_POSITION = 1
AND COLS.TABLE_NAME = 'GL_CODE_COMBINATIONS')