VIEW: BIM.EDW_BIM_LEADS_M#

Source

View Text - Preformatted

select L2_LEADLINE_PK_KEY L2_LEADLINE_PK_KEY, L1_LEAD_PK_KEY L1_LEAD_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_LEAD_PK L1_LEAD_PK, L1_LEAD_DP L1_LEAD_DP, L1_NAME L1_NAME, L1_SALES_LEAD_ID L1_SALES_LEAD_ID, L1_LEAD_NUMBER L1_LEAD_NUMBER, L1_TOTAL_SCORE L1_TOTAL_SCORE, L1_SCORECARD_ID L1_SCORECARD_ID, L1_BUDGET_AMOUNT L1_BUDGET_AMOUNT, L1_ASSIGN_TO_PERSON_ID L1_ASSIGN_TO_PERSON_ID, L1_ASSIGN_DATE L1_ASSIGN_DATE, L1_INITIATING_CONTACT_ID L1_INITIATING_CONTACT_ID, L1_SOURCE_PROMOTION_ID L1_SOURCE_PROMOTION_ID, L1_CUSTOMER_ID L1_CUSTOMER_ID, L1_ADDRESS_ID L1_ADDRESS_ID, L1_VEHICLE_RESPONSE_CODE L1_VEHICLE_RESPONSE_CODE, L1_URGENT_FLAG L1_URGENT_FLAG, L1_PARENT_PROJECT L1_PARENT_PROJECT, L1_LEAD_RANK_CODE L1_LEAD_RANK_CODE, L1_KEEP_FLAG L1_KEEP_FLAG, L1_IMPORT_FLAG L1_IMPORT_FLAG, L1_DECISION_TIMEFRAME_CODE L1_DECISION_TIMEFRAME_CODE, L1_CURRENCY_CODE L1_CURRENCY_CODE, L1_CLOSE_REASON L1_CLOSE_REASON, L1_BUDGET_STATUS_CODE L1_BUDGET_STATUS_CODE, L1_ACCEPT_FLAG L1_ACCEPT_FLAG, L1_CONTACT_ROLE_CODE L1_CONTACT_ROLE_CODE, L1_ORIG_SYSTEM_REFERENCE L1_ORIG_SYSTEM_REFERENCE, L1_LEAD_DESCRIPTION L1_LEAD_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, L2_LEADLINE_PK L2_LEADLINE_PK, L2_LEADLINE_DP L2_LEADLINE_DP, L2_NAME L2_NAME, L2_SALES_LEAD_LINE_ID L2_SALES_LEAD_LINE_ID, L2_INSTANCE L2_INSTANCE, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5, L2_LAST_UPDATE_DATE L2_LAST_UPDATE_DATE, L2_CREATION_DATE L2_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, L1_DELETED_FLAG L1_DELETED_FLAG from "BIM"."EDW_BIM_LEADS_M"

View Text - HTML Formatted

SELECT L2_LEADLINE_PK_KEY L2_LEADLINE_PK_KEY
, L1_LEAD_PK_KEY L1_LEAD_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_LEAD_PK L1_LEAD_PK
, L1_LEAD_DP L1_LEAD_DP
, L1_NAME L1_NAME
, L1_SALES_LEAD_ID L1_SALES_LEAD_ID
, L1_LEAD_NUMBER L1_LEAD_NUMBER
, L1_TOTAL_SCORE L1_TOTAL_SCORE
, L1_SCORECARD_ID L1_SCORECARD_ID
, L1_BUDGET_AMOUNT L1_BUDGET_AMOUNT
, L1_ASSIGN_TO_PERSON_ID L1_ASSIGN_TO_PERSON_ID
, L1_ASSIGN_DATE L1_ASSIGN_DATE
, L1_INITIATING_CONTACT_ID L1_INITIATING_CONTACT_ID
, L1_SOURCE_PROMOTION_ID L1_SOURCE_PROMOTION_ID
, L1_CUSTOMER_ID L1_CUSTOMER_ID
, L1_ADDRESS_ID L1_ADDRESS_ID
, L1_VEHICLE_RESPONSE_CODE L1_VEHICLE_RESPONSE_CODE
, L1_URGENT_FLAG L1_URGENT_FLAG
, L1_PARENT_PROJECT L1_PARENT_PROJECT
, L1_LEAD_RANK_CODE L1_LEAD_RANK_CODE
, L1_KEEP_FLAG L1_KEEP_FLAG
, L1_IMPORT_FLAG L1_IMPORT_FLAG
, L1_DECISION_TIMEFRAME_CODE L1_DECISION_TIMEFRAME_CODE
, L1_CURRENCY_CODE L1_CURRENCY_CODE
, L1_CLOSE_REASON L1_CLOSE_REASON
, L1_BUDGET_STATUS_CODE L1_BUDGET_STATUS_CODE
, L1_ACCEPT_FLAG L1_ACCEPT_FLAG
, L1_CONTACT_ROLE_CODE L1_CONTACT_ROLE_CODE
, L1_ORIG_SYSTEM_REFERENCE L1_ORIG_SYSTEM_REFERENCE
, L1_LEAD_DESCRIPTION L1_LEAD_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
, L2_LEADLINE_PK L2_LEADLINE_PK
, L2_LEADLINE_DP L2_LEADLINE_DP
, L2_NAME L2_NAME
, L2_SALES_LEAD_LINE_ID L2_SALES_LEAD_LINE_ID
, L2_INSTANCE L2_INSTANCE
, L2_USER_ATTRIBUTE1 L2_USER_ATTRIBUTE1
, L2_USER_ATTRIBUTE2 L2_USER_ATTRIBUTE2
, L2_USER_ATTRIBUTE3 L2_USER_ATTRIBUTE3
, L2_USER_ATTRIBUTE4 L2_USER_ATTRIBUTE4
, L2_USER_ATTRIBUTE5 L2_USER_ATTRIBUTE5
, L2_LAST_UPDATE_DATE L2_LAST_UPDATE_DATE
, L2_CREATION_DATE L2_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, L1_DELETED_FLAG L1_DELETED_FLAG
FROM "BIM"."EDW_BIM_LEADS_M"