DBA Data[Home] [Help]

VIEW: BIM.EDW_BIM_MKSG_MKTSGMTS_LTC#

Source

View Text - Preformatted

select MKTSGMT_PK MKTSGMT_PK, MKTSGMT_PK_KEY MKTSGMT_PK_KEY, ALL_FK ALL_FK, ALL_FK_KEY ALL_FK_KEY, MKTSGMT_DP MKTSGMT_DP, NAME NAME, MKTSGMT_ID MKTSGMT_ID, MKTSGMT_CODE MKTSGMT_CODE, ENABLED_FLAG ENABLED_FLAG, MKTSGMT_NAME MKTSGMT_NAME, DESCRIPTION DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID from "BIM"."EDW_BIM_MKSG_MKTSGMTS_LTC"
View Text - HTML Formatted

SELECT MKTSGMT_PK MKTSGMT_PK
, MKTSGMT_PK_KEY MKTSGMT_PK_KEY
, ALL_FK ALL_FK
, ALL_FK_KEY ALL_FK_KEY
, MKTSGMT_DP MKTSGMT_DP
, NAME NAME
, MKTSGMT_ID MKTSGMT_ID
, MKTSGMT_CODE MKTSGMT_CODE
, ENABLED_FLAG ENABLED_FLAG
, MKTSGMT_NAME MKTSGMT_NAME
, DESCRIPTION DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "BIM"."EDW_BIM_MKSG_MKTSGMTS_LTC"