FND Design Data [Home] [Help]

View: ITG_ALL_SEGMENTS_V

Product: ITG - Internet Procurement Enterprise Connector
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT DISTINCT SOB.CHART_OF_ACCOUNTS_ID
, SEG.SEGMENT_NUM
, SEG.SEGMENT_NAME
, SEG.FLEX_VALUE_SET_ID
FROM GL_SETS_OF_BOOKS SOB
, FND_ID_FLEX_SEGMENTS SEG
WHERE SOB.CHART_OF_ACCOUNTS_ID = SEG.ID_FLEX_NUM

Columns

Name
CHART_OF_ACCOUNTS_ID
SEGMENT_NUM
SEGMENT_NAME
FLEX_VALUE_SET_ID