View: GL_CONS_SEGMENT_ACTIONS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_CONS_SEGMENT_ACTIONS_V

View Text

SELECT MAX ( MAP.ROWID ) ROW_ID
, MAX ( MAP.SEGMENT_MAP_ID ) SEGMENT_MAP_ID
, MAX ( GL_CONS_SEGMENT_ACTIONS_PKG.GET_COA_MAPPING_ID ) MAPPING_ID
, MAX ( MAP.LAST_UPDATE_DATE ) LAST_UPDATE_DATE
, MAX ( MAP.LAST_UPDATED_BY ) LAST_UPDATED_BY
, MAX ( MAP.CREATION_DATE ) CREATION_DATE
, MAX ( MAP.CREATED_BY ) CREATED_BY
, MAX ( MAP.LAST_UPDATE_LOGIN ) LAST_UPDATE_LOGIN
, DECODE ( MAX ( MAP.SEGMENT_MAP_TYPE )
, ''
, 'N'
, 'C'
, 'C'
, 'S'
, 'S'
, 'P'
, 'R'
, 'R'
, 'R'
, 'V'
, 'R'
, 'U'
, 'R'
, 'N') SEGMENT_MAP_TYPE
, MAX ( FFS1.APPLICATION_COLUMN_NAME ) TO_APPLICATION_COLUMN_NAME
, FFS1.SEGMENT_NAME TO_SEGMENT_NAME
, FFS1.SEGMENT_NUM TO_SEGMENT_NUM
, FFS1.FLEX_VALUE_SET_ID TO_VALUE_SET_ID
, FFS1.ID_FLEX_NUM TO_ID_FLEX_NUM
, FFS2.APPLICATION_COLUMN_NAME FROM_APPLICATION_COLUMN_NAME
, FFS2.SEGMENT_NAME FROM_SEGMENT_NAME
, FFS2.SEGMENT_NUM FROM_SEGMENT_NUM
, FFS2.FLEX_VALUE_SET_ID FROM_VALUE_SET_ID
, FFS2.ID_FLEX_NUM FROM_ID_FLEX_NUM
, DECODE ( MAX ( MAP.SEGMENT_MAP_TYPE )
, 'S'
, MAX ( MAP.SINGLE_VALUE )
, NULL ) SINGLE_VALUE
FROM FND_ID_FLEX_SEGMENTS FFS2
, GL_CONS_SEGMENT_MAP MAP
, FND_ID_FLEX_SEGMENTS FFS1
WHERE FFS1.APPLICATION_ID = 101
AND FFS1.ID_FLEX_CODE = 'GL#'
AND FFS1.ENABLED_FLAG = 'Y'
AND FFS1.ID_FLEX_NUM = GL_CONS_SEGMENT_ACTIONS_PKG.GET_TO_COA_ID
AND MAP.TO_VALUE_SET_ID ( + ) = FFS1.FLEX_VALUE_SET_ID
AND MAP.TO_APPLICATION_COLUMN_NAME ( + ) = FFS1.APPLICATION_COLUMN_NAME
AND MAP.COA_MAPPING_ID ( + ) = GL_CONS_SEGMENT_ACTIONS_PKG.GET_COA_MAPPING_ID
AND FFS2.APPLICATION_ID ( + ) = 101
AND FFS2.ID_FLEX_CODE ( + ) = 'GL#'
AND FFS2.ENABLED_FLAG ( + ) = 'Y'
AND FFS2.ID_FLEX_NUM ( + ) = GL_CONS_SEGMENT_ACTIONS_PKG.GET_FROM_COA_ID
AND FFS2.APPLICATION_COLUMN_NAME ( + ) = NVL ( MAP.FROM_APPLICATION_COLUMN_NAME
, -1 )
AND FFS2.FLEX_VALUE_SET_ID ( + ) = NVL ( MAP.FROM_VALUE_SET_ID
, -1 ) GROUP BY MAP.COA_MAPPING_ID
, FFS1.SEGMENT_NAME
, FFS1.SEGMENT_NUM
, FFS1.FLEX_VALUE_SET_ID
, FFS1.ID_FLEX_NUM
, FFS2.APPLICATION_COLUMN_NAME
, FFS2.SEGMENT_NAME
, FFS2.SEGMENT_NUM
, FFS2.FLEX_VALUE_SET_ID
, FFS2.ID_FLEX_NUM

Columns