FND Design Data [Home] [Help]

View: EDW_BIM_TGSMT_M_IV

Product: BIM - Marketing Intelligence(Obsolete)
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

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