View: FND_INDEXED_SEGS_V

Product:	FND - Application Object Library
Description:	Indexed columns in the GL_CODE_COMBINATIONS table
Implementation/DBA Data:	APPS.FND_INDEXED_SEGS_V

View Text

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

Columns