VIEW: APPS.GL_CONS_SEGMENT_ACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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