VIEW: APPS.XLA_MAPPING_SETS_FVL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')