VIEW: BIM.EDW_BIM_OFFERS_M#

Source

View Text - Preformatted

select L1_OFFER_PK_KEY L1_OFFER_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_OFFER_PK L1_OFFER_PK, L1_OFFER_DP L1_OFFER_DP, L1_NAME L1_NAME, L1_ACTIVITY_OFFER_ID L1_ACTIVITY_OFFER_ID, L1_OFFER_CODE L1_OFFER_CODE, L1_OFFER_TYPE L1_OFFER_TYPE, L1_PRIMARY_OFFER_FLAG L1_PRIMARY_OFFER_FLAG, L1_LIST_HEADER_ID L1_LIST_HEADER_ID, L1_OFFER_NAME L1_OFFER_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, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE, L1_CREATION_DATE L1_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_OFFERS_M"

View Text - HTML Formatted

SELECT L1_OFFER_PK_KEY L1_OFFER_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_OFFER_PK L1_OFFER_PK
, L1_OFFER_DP L1_OFFER_DP
, L1_NAME L1_NAME
, L1_ACTIVITY_OFFER_ID L1_ACTIVITY_OFFER_ID
, L1_OFFER_CODE L1_OFFER_CODE
, L1_OFFER_TYPE L1_OFFER_TYPE
, L1_PRIMARY_OFFER_FLAG L1_PRIMARY_OFFER_FLAG
, L1_LIST_HEADER_ID L1_LIST_HEADER_ID
, L1_OFFER_NAME L1_OFFER_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
, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE
, L1_CREATION_DATE L1_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_OFFERS_M"