DBA Data[Home] [Help] [Dependency Information]

TABLE: BIM.EDW_BIM_TGSMT_M

Object Details
Object Name: EDW_BIM_TGSMT_M
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.EDW_BIM_TGSMT_M
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_BIM_TGSMT_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnL9_TGTSGMT_PK
ColumnL9_TGTSGMT_PK_KEY
EDW_BIM_TGSMT_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnL9_TGTSGMT_PK_KEY
Columns
Name Datatype Length Mandatory Comments
L9_TGTSGMT_PK_KEY NUMBER
Yes System Generated Unique Identifier of the lowest level of Target Segment dimension .
L8_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 8 of target segment
L7_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 7 of target segment
L6_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 6 of target segment
L5_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 5 of target segment
L4_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 4 of target segment
L3_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 3 of target segment
L2_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 2 of target segment
L1_TGTSGMT_PK_KEY NUMBER

System generated unique identifier for level 1 of target segment
L0_ALL_PK_KEY NUMBER

System generated unique identifier for all level in target segment dimension .
L0_ALL_PK VARCHAR2 (40)
Unique identifier for all level in target segment dimension .
L0_NAME VARCHAR2 (80)
Displayed name of the all level .
L1_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L1_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L1_NAME VARCHAR2 (240)
Reserved for future use in Express .
L1_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L1_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L1_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L1_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L1_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L1_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L1_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L1_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L1_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L1_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L2_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L2_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L2_NAME VARCHAR2 (240)
Reserved for future use in Express .
L2_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L2_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L2_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L2_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L2_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L2_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L2_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L2_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L2_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L2_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L3_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L3_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L3_NAME VARCHAR2 (240)
Reserved for future use in Express .
L3_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L3_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L3_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L3_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L3_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L3_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L3_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L3_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L3_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L3_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L4_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L4_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L4_NAME VARCHAR2 (240)
Reserved for future use in Express .
L4_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L4_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L4_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L4_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L4_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L4_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L4_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L4_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L4_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L4_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L5_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L5_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L5_NAME VARCHAR2 (240)
Reserved for future use in Express .
L5_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L5_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L5_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L5_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L5_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L5_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L5_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L5_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L5_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L5_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L6_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L6_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L6_NAME VARCHAR2 (240)
Reserved for future use in Express .
L6_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L6_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L6_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L6_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L6_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L6_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L6_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L6_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L6_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L6_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L7_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L7_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L7_NAME VARCHAR2 (240)
Reserved for future use in Express .
L7_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L7_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L7_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L7_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L7_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L7_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L7_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L7_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L7_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L7_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L8_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L8_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L8_NAME VARCHAR2 (240)
Reserved for future use in Express .
L8_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L8_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L8_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L8_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L8_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L8_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L8_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L8_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L8_USER_ATTRIBUTE1 VARCHAR2 (4000)
User Attribute .
L8_USER_ATTRIBUTE2 VARCHAR2 (4000)
User Attribute .
L8_USER_ATTRIBUTE3 VARCHAR2 (4000)
User Attribute .
L8_USER_ATTRIBUTE4 VARCHAR2 (4000)
User Attribute .
L8_USER_ATTRIBUTE5 VARCHAR2 (4000)
User Attribute .
L9_TGTSGMT_PK VARCHAR2 (120)
Unique identifier for target segment .
L9_TGTSGMT_DP VARCHAR2 (240)
Field for discoverer so customers can have a display column that identifies all records uniquely .
L9_NAME VARCHAR2 (240)
Reserved for future use in Express .
L9_TGTSGMT_ID NUMBER

OLTP unique identifier for target segment .
L9_TGTSGMT_CODE VARCHAR2 (40)
Unique code of the target segment .
L9_MARKET_SEGMENT_FLAG VARCHAR2 (20)
Indicates whether the target segment is also a market segment .
L9_ENABLED_FLAG VARCHAR2 (20)
Indicates whether the target segment is active .
L9_ORIGINAL_SIZE NUMBER

Original Size of the target segment .
L9_TGTSGMT_NAME VARCHAR2 (240)
Name of the target segment .
L9_DESCRIPTION VARCHAR2 (4000)
Long description of target segment .
L9_INSTANCE VARCHAR2 (40)
Instance Identifier ,
L9_USER_ATTRIBUTE1 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE2 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE3 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE4 VARCHAR2 (240)
User Attribute .
L9_USER_ATTRIBUTE5 VARCHAR2 (240)
User Attribute .
L9_LAST_UPDATE_DATE DATE

Standard Who Column .
L9_CREATION_DATE DATE

Standard Who Column .
SECURITY_GROUP_ID NUMBER

Standard Who Column .
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
Query Text

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


SELECT L9_TGTSGMT_PK_KEY
,      L8_TGTSGMT_PK_KEY
,      L7_TGTSGMT_PK_KEY
,      L6_TGTSGMT_PK_KEY
,      L5_TGTSGMT_PK_KEY
,      L4_TGTSGMT_PK_KEY
,      L3_TGTSGMT_PK_KEY
,      L2_TGTSGMT_PK_KEY
,      L1_TGTSGMT_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_TGTSGMT_PK
,      L1_TGTSGMT_DP
,      L1_NAME
,      L1_TGTSGMT_ID
,      L1_TGTSGMT_CODE
,      L1_MARKET_SEGMENT_FLAG
,      L1_ENABLED_FLAG
,      L1_ORIGINAL_SIZE
,      L1_TGTSGMT_NAME
,      L1_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_TGTSGMT_PK
,      L2_TGTSGMT_DP
,      L2_NAME
,      L2_TGTSGMT_ID
,      L2_TGTSGMT_CODE
,      L2_MARKET_SEGMENT_FLAG
,      L2_ENABLED_FLAG
,      L2_ORIGINAL_SIZE
,      L2_TGTSGMT_NAME
,      L2_DESCRIPTION
,      L2_INSTANCE
,      L2_USER_ATTRIBUTE1
,      L2_USER_ATTRIBUTE2
,      L2_USER_ATTRIBUTE3
,      L2_USER_ATTRIBUTE4
,      L2_USER_ATTRIBUTE5
,      L3_TGTSGMT_PK
,      L3_TGTSGMT_DP
,      L3_NAME
,      L3_TGTSGMT_ID
,      L3_TGTSGMT_CODE
,      L3_MARKET_SEGMENT_FLAG
,      L3_ENABLED_FLAG
,      L3_ORIGINAL_SIZE
,      L3_TGTSGMT_NAME
,      L3_DESCRIPTION
,      L3_INSTANCE
,      L3_USER_ATTRIBUTE1
,      L3_USER_ATTRIBUTE2
,      L3_USER_ATTRIBUTE3
,      L3_USER_ATTRIBUTE4
,      L3_USER_ATTRIBUTE5
,      L4_TGTSGMT_PK
,      L4_TGTSGMT_DP
,      L4_NAME
,      L4_TGTSGMT_ID
,      L4_TGTSGMT_CODE
,      L4_MARKET_SEGMENT_FLAG
,      L4_ENABLED_FLAG
,      L4_ORIGINAL_SIZE
,      L4_TGTSGMT_NAME
,      L4_DESCRIPTION
,      L4_INSTANCE
,      L4_USER_ATTRIBUTE1
,      L4_USER_ATTRIBUTE2
,      L4_USER_ATTRIBUTE3
,      L4_USER_ATTRIBUTE4
,      L4_USER_ATTRIBUTE5
,      L5_TGTSGMT_PK
,      L5_TGTSGMT_DP
,      L5_NAME
,      L5_TGTSGMT_ID
,      L5_TGTSGMT_CODE
,      L5_MARKET_SEGMENT_FLAG
,      L5_ENABLED_FLAG
,      L5_ORIGINAL_SIZE
,      L5_TGTSGMT_NAME
,      L5_DESCRIPTION
,      L5_INSTANCE
,      L5_USER_ATTRIBUTE1
,      L5_USER_ATTRIBUTE2
,      L5_USER_ATTRIBUTE3
,      L5_USER_ATTRIBUTE4
,      L5_USER_ATTRIBUTE5
,      L6_TGTSGMT_PK
,      L6_TGTSGMT_DP
,      L6_NAME
,      L6_TGTSGMT_ID
,      L6_TGTSGMT_CODE
,      L6_MARKET_SEGMENT_FLAG
,      L6_ENABLED_FLAG
,      L6_ORIGINAL_SIZE
,      L6_TGTSGMT_NAME
,      L6_DESCRIPTION
,      L6_INSTANCE
,      L6_USER_ATTRIBUTE1
,      L6_USER_ATTRIBUTE2
,      L6_USER_ATTRIBUTE3
,      L6_USER_ATTRIBUTE4
,      L6_USER_ATTRIBUTE5
,      L7_TGTSGMT_PK
,      L7_TGTSGMT_DP
,      L7_NAME
,      L7_TGTSGMT_ID
,      L7_TGTSGMT_CODE
,      L7_MARKET_SEGMENT_FLAG
,      L7_ENABLED_FLAG
,      L7_ORIGINAL_SIZE
,      L7_TGTSGMT_NAME
,      L7_DESCRIPTION
,      L7_INSTANCE
,      L7_USER_ATTRIBUTE1
,      L7_USER_ATTRIBUTE2
,      L7_USER_ATTRIBUTE3
,      L7_USER_ATTRIBUTE4
,      L7_USER_ATTRIBUTE5
,      L8_TGTSGMT_PK
,      L8_TGTSGMT_DP
,      L8_NAME
,      L8_TGTSGMT_ID
,      L8_TGTSGMT_CODE
,      L8_MARKET_SEGMENT_FLAG
,      L8_ENABLED_FLAG
,      L8_ORIGINAL_SIZE
,      L8_TGTSGMT_NAME
,      L8_DESCRIPTION
,      L8_INSTANCE
,      L8_USER_ATTRIBUTE1
,      L8_USER_ATTRIBUTE2
,      L8_USER_ATTRIBUTE3
,      L8_USER_ATTRIBUTE4
,      L8_USER_ATTRIBUTE5
,      L9_TGTSGMT_PK
,      L9_TGTSGMT_DP
,      L9_NAME
,      L9_TGTSGMT_ID
,      L9_TGTSGMT_CODE
,      L9_MARKET_SEGMENT_FLAG
,      L9_ENABLED_FLAG
,      L9_ORIGINAL_SIZE
,      L9_TGTSGMT_NAME
,      L9_DESCRIPTION
,      L9_INSTANCE
,      L9_USER_ATTRIBUTE1
,      L9_USER_ATTRIBUTE2
,      L9_USER_ATTRIBUTE3
,      L9_USER_ATTRIBUTE4
,      L9_USER_ATTRIBUTE5
,      L9_LAST_UPDATE_DATE
,      L9_CREATION_DATE
,      SECURITY_GROUP_ID
,      LAST_UPDATE_DATE
,      CREATION_DATE
FROM BIM.EDW_BIM_TGSMT_M;

Dependencies

[top of page]

BIM.EDW_BIM_TGSMT_M does not reference any database object

BIM.EDW_BIM_TGSMT_M is referenced by following:

SchemaAPPS
SynonymEDW_BIM_TGSMT_M