[Home] [Help] [Dependency Information]

TABLE: BIS.EDW_FLEX_ATTRIBUTE_MAPPINGS

Object Details

Object Name:	EDW_FLEX_ATTRIBUTE_MAPPINGS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.EDW_FLEX_ATTRIBUTE_MAPPINGS
Subobject Name:
Status:	VALID

This table stores the flexfield attributes mapped to Facts/Dimensions using the EBI Assistant. Its parent table is EDW_ATTRIBUTE_MAPPINGS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ATTR_MAPPING_FK
,      SEGMENT_DATATYPE
,      VALUE_SET_DATATYPE
,      STRUCTURE_NUM
,      STRUCTURE_NAME
,      APPLICATION_COLUMN_NAME
,      SEGMENT_NAME
,      VALUE_SET_ID
,      VALUE_SET_NAME
,      VALUE_SET_TYPE
,      INSTANCE_CODE
,      ID_FLEX_CODE
,      APPLICATION_ID
,      FLEX_FIELD_TYPE
,      FLEX_FIELD_NAME
FROM BIS.EDW_FLEX_ATTRIBUTE_MAPPINGS;

Dependencies

[top of page]

BIS.EDW_FLEX_ATTRIBUTE_MAPPINGS does not reference any database object

BIS.EDW_FLEX_ATTRIBUTE_MAPPINGS is referenced by following:

APPS

EDW_FLEX_ATTRIBUTE_MAPPINGS