1. Tables and Views for Financials
  2. XLA_FSN_MAP_SET_INP_VIEW

XLA_FSN_MAP_SET_INP_VIEW

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: VIEW

Columns

Name

MAPPING_SET_CODE

AMB_CONTEXT_CODE

RULE_DETAIL_ID

SOURCE_ORIGIN_CODE

SOURCE_APPLICATION_ID

SOURCE_TYPE_CODE

SOURCE_CODE

FLEX_SEGMENT_CODE

INPUT_SEQ

Query

SQL_Statement

Select I.MAPPING_SET_CODE Mapping_Set_Code,

I.AMB_CONTEXT_CODE AMB_Context_Code,

D.SEGMENT_RULE_DETAIL_ID Rule_Detail_ID,

I.SOURCE_ORIGIN_CODE Source_Origin_Code,

I.SOURCE_APPLICATION_ID Source_Application_ID,

I.SOURCE_TYPE_CODE Source_Type_Code,

I.SOURCE_CODE Source_Code,

I.FLEX_SEGMENT Flex_Segment_Code,

I.INPUT_SEQ

from XLA_MAPPING_SET_INPUTS I,

XLA_SEG_RULE_DETAILS D

where D.VALUE_MAPPING_SET_CODE = I.MAPPING_SET_CODE

and D.AMB_CONTEXT_CODE = I.AMB_CONTEXT_CODE