APPS.XLA_MAPPING_SETS_FVL
[Home] [Help]
| Product: | XLA - Subledger Accounting |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.XLA_MAPPING_SETS_FVL
|
SELECT MSB.ROWID ROW_ID
, MSB.MAPPING_SET_CODE MAPPING_SET_CODE
, MSB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, MSL.NAME NAME
, MSL.DESCRIPTION DESCRIPTION
, MSB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, FLS.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, MSB.VALUE_SET_ID VALUE_SET_ID
, VAL.FLEX_VALUE_SET_NAME VALUE_SET_NAME
, MSB.FLEXFIELD_ASSIGN_MODE_CODE FLEXFIELD_ASSIGN_MODE_CODE
, MSB.FLEXFIELD_SEGMENT_CODE FLEXFIELD_SEGMENT_CODE
, SEB.SEGMENT_NAME FLEXFIELD_SEGMENT_NAME
, MSB.VIEW_APPLICATION_ID VIEW_APPLICATION_ID
, APB.APPLICATION_NAME VIEW_APPLICATION_NAME
, MSB.LOOKUP_TYPE LOOKUP_TYPE
, LKP.MEANING LOOKUP_TYPE_MEANING
, MSB.ENABLED_FLAG ENABLED_FLAG
, MSB.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, VAL1.FLEX_VALUE_SET_NAME FLEX_VALUE_SET_NAME
, MSB.CREATION_DATE CREATION_DATE
, MSB.CREATED_BY CREATED_BY
, MSB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MSB.LAST_UPDATED_BY LAST_UPDATED_BY
, MSB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM XLA_MAPPING_SETS_B MSB
, XLA_MAPPING_SETS_TL MSL
, FND_ID_FLEX_STRUCTURES_TL FLS
, FND_ID_FLEX_SEGMENTS SEB
, FND_FLEX_VALUE_SETS VAL
, FND_FLEX_VALUE_SETS VAL1
, FND_APPLICATION_TL APB
, FND_LOOKUP_TYPES_TL LKP
WHERE MSB.MAPPING_SET_CODE = MSL.MAPPING_SET_CODE
AND MSB.AMB_CONTEXT_CODE = MSL.AMB_CONTEXT_CODE
AND MSL.LANGUAGE = USERENV('LANG')
AND MSB.ACCOUNTING_COA_ID = FLS.ID_FLEX_NUM(+)
AND FLS.ID_FLEX_CODE(+) = 'GL#'
AND FLS.APPLICATION_ID(+) = 101
AND FLS.LANGUAGE (+) = USERENV('LANG')
AND MSB.FLEXFIELD_SEGMENT_CODE = SEB.APPLICATION_COLUMN_NAME(+)
AND SEB.APPLICATION_ID(+) = 101
AND SEB.ID_FLEX_CODE(+) = 'GL#'
AND SEB.ID_FLEX_NUM(+) = MSB.ACCOUNTING_COA_ID
AND MSB.VALUE_SET_ID = VAL.FLEX_VALUE_SET_ID(+)
AND MSB.FLEX_VALUE_SET_ID = VAL1.FLEX_VALUE_SET_ID(+)
AND MSB.VIEW_APPLICATION_ID = APB.APPLICATION_ID(+)
AND APB.LANGUAGE (+) = USERENV('LANG')
AND MSB.VIEW_APPLICATION_ID = LKP.VIEW_APPLICATION_ID(+)
AND MSB.LOOKUP_TYPE = LKP.LOOKUP_TYPE(+)
AND LKP.LANGUAGE (+) = USERENV('LANG')