[Home] [Help]
| Product: | BIM - Marketing Intelligence(Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID ROW_ID
, L2_SALES_LEAD_LINE_ID
, L2_LEADLINE_PK_KEY
, L1_TOTAL_SCORE
, L1_SCORECARD_ID
, L1_SALES_LEAD_ID
, L1_BUDGET_AMOUNT
, L1_ASSIGN_TO_PERSON_ID
, L1_LEAD_PK_KEY
, L0_ALL_PK_KEY
, L1_INITIATING_CONTACT_ID
, L1_SOURCE_PROMOTION_ID
, L1_CUSTOMER_ID
, L1_ADDRESS_ID
, L2_USER_ATTRIBUTE5
, L2_USER_ATTRIBUTE4
, L2_USER_ATTRIBUTE3
, L2_USER_ATTRIBUTE2
, L2_USER_ATTRIBUTE1
, L2_NAME
, L2_LEADLINE_PK
, L2_LEADLINE_DP
, L2_INSTANCE
, L1_VEHICLE_RESPONSE_CODE
, L1_USER_ATTRIBUTE5
, L1_USER_ATTRIBUTE4
, L1_USER_ATTRIBUTE3
, L1_USER_ATTRIBUTE2
, L1_USER_ATTRIBUTE1
, L1_URGENT_FLAG
, L1_PARENT_PROJECT
, L1_NAME
, L1_LEAD_RANK_CODE
, L1_LEAD_PK
, L1_LEAD_NUMBER
, L1_LEAD_DP
, L1_LEAD_DESCRIPTION
, L1_DELETED_FLAG
, L1_KEEP_FLAG
, L1_INSTANCE
, L1_IMPORT_FLAG
, L1_DECISION_TIMEFRAME_CODE
, L1_CURRENCY_CODE
, L1_CLOSE_REASON
, L1_BUDGET_STATUS_CODE
, L1_ACCEPT_FLAG
, L0_NAME
, L0_ALL_PK
, L1_CONTACT_ROLE_CODE
, L1_ORIG_SYSTEM_REFERENCE
, L2_LAST_UPDATE_DATE
, L2_CREATION_DATE
, L1_ASSIGN_DATE
, SECURITY_GROUP_ID
, L2_USER_ATTRIBUTE5 OPERATION_CODE
FROM EDW_BIM_LEADS_M