Product: | GL - General Ledger |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.GL_CONS_SEGMENT_MAP_V |
SELECT MAPV.ROW_ID ROW_ID
, MAPV.SEGMENT_MAP_ID SEGMENT_MAP_ID
, MAPV.COA_MAPPING_ID MAPPING_ID
, MAPV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MAPV.LAST_UPDATED_BY LAST_UPDATED_BY
, MAPV.TO_VALUE_SET_ID TO_VALUE_SET_ID
, MAPV.TO_APPLICATION_COLUMN_NAME TO_APPLICATION_COLUMN_NAME
, FFS1.SEGMENT_NAME TO_SEGMENT_NAME
, FFS1.SEGMENT_NUM TO_SEGMENT_NUM
, MAPV.SEGMENT_MAP_TYPE SEGMENT_MAP_TYPE
, L.MEANING SEGMENT_MAP_TYPE_DISPLAY
, MAPV.CREATION_DATE CREATION_DATE
, MAPV.CREATED_BY CREATED_BY
, MAPV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MAPV.FROM_VALUE_SET_ID FROM_VALUE_SET_ID
, MAPV.FROM_APPLICATION_COLUMN_NAME FROM_APPLICATION_COLUMN_NAME
, FFS2.SEGMENT_NAME FROM_SEGMENT_NAME
, FFS2.SEGMENT_NUM FROM_SEGMENT_NUM
, MAPV.SINGLE_VALUE SINGLE_VALUE
, MAPV.ATTRIBUTE1 ATTRIBUTE1
, MAPV.ATTRIBUTE2 ATTRIBUTE2
, MAPV.ATTRIBUTE3 ATTRIBUTE3
, MAPV.ATTRIBUTE4 ATTRIBUTE4
, MAPV.ATTRIBUTE5 ATTRIBUTE5
, MAPV.CONTEXT CONTEXT
, MAPV.PARENT_ROLLUP_VALUE PARENT_ROLLUP_VALUE
, FVS.VALIDATION_TYPE VALIDATION_TYPE
FROM GL_LOOKUPS L
, FND_ID_FLEX_SEGMENTS FFS1
, FND_ID_FLEX_SEGMENTS FFS2
, FND_FLEX_VALUE_SETS FVS
, GL_SEGMENT_MAP_CONS_V MAPV
WHERE FFS1.APPLICATION_ID = 101 AND FFS1.ID_FLEX_CODE = 'GL#' AND FFS1.ID_FLEX_NUM = MAPV.TO_CHART_OF_ACCOUNTS_ID AND FFS1.APPLICATION_COLUMN_NAME = MAPV.TO_APPLICATION_COLUMN_NAME AND FFS2.APPLICATION_ID(+) = 101 AND FFS2.ID_FLEX_CODE(+) = 'GL#' AND FFS2.ID_FLEX_NUM(+) = MAPV.FROM_CHART_OF_ACCOUNTS_ID AND FFS2.APPLICATION_COLUMN_NAME(+) = MAPV.FROM_APPLICATION_COLUMN_NAME
AND L.LOOKUP_TYPE = 'SEGMENT_MAP_TYPE' AND L.LOOKUP_CODE = MAPV.SEGMENT_MAP_TYPE AND FVS.FLEX_VALUE_SET_ID = MAPV.TO_VALUE_SET_ID