eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BIM.EDW_BIM_LEAD_LEADS_LTC#

Source

View Text - Preformatted


select LEAD_PK LEAD_PK, LEAD_PK_KEY LEAD_PK_KEY, ALL_FK ALL_FK, ALL_FK_KEY ALL_FK_KEY, LEAD_DP LEAD_DP, NAME NAME, SALES_LEAD_ID SALES_LEAD_ID, LEAD_NUMBER LEAD_NUMBER, TOTAL_SCORE TOTAL_SCORE, SCORECARD_ID SCORECARD_ID, BUDGET_AMOUNT BUDGET_AMOUNT, ASSIGN_TO_PERSON_ID ASSIGN_TO_PERSON_ID, ASSIGN_DATE ASSIGN_DATE, INITIATING_CONTACT_ID INITIATING_CONTACT_ID, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID, CUSTOMER_ID CUSTOMER_ID, ADDRESS_ID ADDRESS_ID, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE, URGENT_FLAG URGENT_FLAG, PARENT_PROJECT PARENT_PROJECT, LEAD_RANK_CODE LEAD_RANK_CODE, KEEP_FLAG KEEP_FLAG, IMPORT_FLAG IMPORT_FLAG, DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE, CURRENCY_CODE CURRENCY_CODE, CLOSE_REASON CLOSE_REASON, BUDGET_STATUS_CODE BUDGET_STATUS_CODE, ACCEPT_FLAG ACCEPT_FLAG, CONTACT_ROLE_CODE CONTACT_ROLE_CODE, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, LEAD_DESCRIPTION LEAD_DESCRIPTION, INSTANCE INSTANCE, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, DELETED_FLAG DELETED_FLAG from "BIM"."EDW_BIM_LEAD_LEADS_LTC"

View Text - HTML Formatted

SELECT LEAD_PK LEAD_PK
, LEAD_PK_KEY LEAD_PK_KEY
, ALL_FK ALL_FK
, ALL_FK_KEY ALL_FK_KEY
, LEAD_DP LEAD_DP
, NAME NAME
, SALES_LEAD_ID SALES_LEAD_ID
, LEAD_NUMBER LEAD_NUMBER
, TOTAL_SCORE TOTAL_SCORE
, SCORECARD_ID SCORECARD_ID
, BUDGET_AMOUNT BUDGET_AMOUNT
, ASSIGN_TO_PERSON_ID ASSIGN_TO_PERSON_ID
, ASSIGN_DATE ASSIGN_DATE
, INITIATING_CONTACT_ID INITIATING_CONTACT_ID
, SOURCE_PROMOTION_ID SOURCE_PROMOTION_ID
, CUSTOMER_ID CUSTOMER_ID
, ADDRESS_ID ADDRESS_ID
, VEHICLE_RESPONSE_CODE VEHICLE_RESPONSE_CODE
, URGENT_FLAG URGENT_FLAG
, PARENT_PROJECT PARENT_PROJECT
, LEAD_RANK_CODE LEAD_RANK_CODE
, KEEP_FLAG KEEP_FLAG
, IMPORT_FLAG IMPORT_FLAG
, DECISION_TIMEFRAME_CODE DECISION_TIMEFRAME_CODE
, CURRENCY_CODE CURRENCY_CODE
, CLOSE_REASON CLOSE_REASON
, BUDGET_STATUS_CODE BUDGET_STATUS_CODE
, ACCEPT_FLAG ACCEPT_FLAG
, CONTACT_ROLE_CODE CONTACT_ROLE_CODE
, ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, LEAD_DESCRIPTION LEAD_DESCRIPTION
, INSTANCE INSTANCE
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, DELETED_FLAG DELETED_FLAG
FROM "BIM"."EDW_BIM_LEAD_LEADS_LTC"