DBA Data[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: TableBIS.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ATTR_MAPPING_FK NUMBER (15) Yes Description
SEGMENT_DATATYPE VARCHAR2 (20)
Description
VALUE_SET_DATATYPE VARCHAR2 (20)
Description
STRUCTURE_NUM NUMBER (15) Yes Description
STRUCTURE_NAME VARCHAR2 (30) Yes Description
APPLICATION_COLUMN_NAME VARCHAR2 (30) Yes Description
SEGMENT_NAME VARCHAR2 (30)
Description
VALUE_SET_ID NUMBER (10) Yes Description
VALUE_SET_NAME VARCHAR2 (60) Yes Description
VALUE_SET_TYPE VARCHAR2 (1) Yes Description
INSTANCE_CODE VARCHAR2 (30) Yes Description
ID_FLEX_CODE VARCHAR2 (50) Yes Description
APPLICATION_ID NUMBER
Yes Description
FLEX_FIELD_TYPE VARCHAR2 (1) Yes Description
FLEX_FIELD_NAME VARCHAR2 (50) Yes Description
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:

SchemaAPPS
SynonymEDW_FLEX_ATTRIBUTE_MAPPINGS