VIEW: BIM.EDW_BIM_TGSMT_M#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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