[Home] [Help]
| Product: | BIM - Marketing Intelligence(Obsolete) |
|---|---|
| Description: | Instead of Views |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID ROW_ID
, OPPORTUNITY_AMOUNT_G
, OPPORTUNITY_AMOUNT_B
, LEAD_AMOUNT_G
, LEAD_AMOUNT_B
, GLOBAL_CURRENCY_FK_KEY
, BASE_CURRENCY_FK_KEY
, SHIP_TO_SITE_FK_KEY
, LINE_OFFER_FK_KEY
, INITIATED_ORDER_AMT_G
, INITIATED_ORDER_AMT_B
, INITIATED_ORDER_AMT_T
, ACTUAL_ORDER_AMT_G
, ACTUAL_ORDER_AMT_B
, ACTUAL_ORDER_AMT_T
, INITIATED_NO_OF_ORDERS
, ACTUAL_NO_OF_ORDERS
, USER_FK5_KEY
, USER_FK4_KEY
, USER_FK3_KEY
, USER_FK2_KEY
, USER_FK1_KEY
, USER_MEASURE5
, USER_MEASURE4
, USER_MEASURE3
, USER_MEASURE2
, USER_MEASURE1
, SLIST_ACTUAL_COST_G
, SLIST_ACTUAL_COST_B
, SLIST_ACTUAL_COST_T
, COGS_G
, COGS_B
, COGS_T
, ACTUAL_REVENUE_G
, ACTUAL_REVENUE_B
, ACTUAL_REVENUE_T
, INITIATED_REVENUE_G
, INITIATED_REVENUE_B
, INITIATED_REVENUE_T
, OPPORTUNITY_AMOUNT_T
, LEAD_AMOUNT_T
, EVENT_NUMBER_CANCELLED
, EVENT_NUMBER_ATTENDED
, EVENT_NUMBER_AVAILABLE
, EVENT_NUMBER_ENROLLED
, NUMBER_TARGETED
, NUMBER_RESPONDED
, EVENT_ACTUAL_COST_G
, EVENT_ACTUAL_COST_B
, EVENT_ACTUAL_COST_T
, EVENT_REGISTRATION_REVENUE_G
, EVENT_REGISTRATION_REVENUE_B
, EVENT_REGISTRATION_REVENUE_T
, EVENT_FRCST_COST_G
, EVENT_FRCST_COST_B
, EVENT_FRCST_COST_T
, EVENT_FRCST_REVENUE_G
, EVENT_FRCST_REVENUE_B
, EVENT_FRCST_REVENUE_T
, CMPGN_ACTUAL_COST_G
, CMPGN_ACTUAL_COST_B
, CMPGN_ACTUAL_COST_T
, CMPGN_FRCST_COST_G
, CMPGN_FRCST_COST_B
, CMPGN_FRCST_COST_T
, CMPGN_FRCST_REVENUE_G
, CMPGN_FRCST_REVENUE_B
, CMPGN_FRCST_REVENUE_T
, REVCOST_PK_KEY
, SRCLST_FK_KEY
, TRX_CURRENCY_FK_KEY
, BILL_TO_SITE_FK_KEY
, MKTSGMT_FK_KEY
, CUSTOMER_FK_KEY
, TIME_FK_KEY
, SLSCHNL_FK_KEY
, ORG_FK_KEY
, TGTSGMT_FK_KEY
, HEADER_OFFER_FK_KEY
, OPPSTATUS_FK_KEY
, OPPORTUNITY_FK_KEY
, LEADSTATUS_FK_KEY
, LEAD_FK_KEY
, CMPGN_STATUS_FK_KEY
, MEDCHNL_FK_KEY
, EVENT_FK_KEY
, UOM_FK_KEY
, ITEM_FK_KEY
, CMPGN_FK_KEY
, USER_ATTRIBUTE15
, USER_ATTRIBUTE14
, USER_ATTRIBUTE13
, USER_ATTRIBUTE12
, USER_ATTRIBUTE11
, USER_ATTRIBUTE10
, USER_ATTRIBUTE9
, USER_ATTRIBUTE8
, USER_ATTRIBUTE7
, USER_ATTRIBUTE6
, USER_ATTRIBUTE5
, USER_ATTRIBUTE4
, USER_ATTRIBUTE3
, USER_ATTRIBUTE2
, USER_ATTRIBUTE1
, REVCOST_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, SECURITY_GROUP_ID
, USER_ATTRIBUTE15 OPERATION_CODE
FROM BIM_EDW_RVCT_MTH_F