VIEW: BIM.EDW_BIM_OPPR_OPPLINES_LTC#

Source

View Text - Preformatted

select OPPLINE_PK OPPLINE_PK, OPPLINE_PK_KEY OPPLINE_PK_KEY, OPPORTUNITY_FK OPPORTUNITY_FK, OPPORTUNITY_FK_KEY OPPORTUNITY_FK_KEY, OPPLINE_DP OPPLINE_DP, NAME NAME, OPP_LEAD_LINE_ID OPP_LEAD_LINE_ID, LEAD_ID LEAD_ID, WIN_PROBABILITY WIN_PROBABILITY, SALES_STAGE_ID SALES_STAGE_ID, PRICE_VOLUMN_MARGIN PRICE_VOLUMN_MARGIN, PRICE PRICE, ORIG_OPPORTUNITY_LINE_ID ORIG_OPPORTUNITY_LINE_ID, ORIGINAL_LEAD_LINE_ID ORIGINAL_LEAD_LINE_ID, QUOTED_LINE_FLAG QUOTED_LINE_FLAG, CHANNEL_CODE CHANNEL_CODE, SHIP_DATE SHIP_DATE, DECISION_DATE DECISION_DATE, 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_OPPR_OPPLINES_LTC"

View Text - HTML Formatted

SELECT OPPLINE_PK OPPLINE_PK
, OPPLINE_PK_KEY OPPLINE_PK_KEY
, OPPORTUNITY_FK OPPORTUNITY_FK
, OPPORTUNITY_FK_KEY OPPORTUNITY_FK_KEY
, OPPLINE_DP OPPLINE_DP
, NAME NAME
, OPP_LEAD_LINE_ID OPP_LEAD_LINE_ID
, LEAD_ID LEAD_ID
, WIN_PROBABILITY WIN_PROBABILITY
, SALES_STAGE_ID SALES_STAGE_ID
, PRICE_VOLUMN_MARGIN PRICE_VOLUMN_MARGIN
, PRICE PRICE
, ORIG_OPPORTUNITY_LINE_ID ORIG_OPPORTUNITY_LINE_ID
, ORIGINAL_LEAD_LINE_ID ORIGINAL_LEAD_LINE_ID
, QUOTED_LINE_FLAG QUOTED_LINE_FLAG
, CHANNEL_CODE CHANNEL_CODE
, SHIP_DATE SHIP_DATE
, DECISION_DATE DECISION_DATE
, 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_OPPR_OPPLINES_LTC"