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_STATUS_M#

Source

View Text - Preformatted


select L1_LEADSTATUS_PK_KEY L1_LEADSTATUS_PK_KEY, L0_ALL_PK_KEY L0_ALL_PK_KEY, L0_ALL_PK L0_ALL_PK, L0_NAME L0_NAME, L1_LEADSTATUS_PK L1_LEADSTATUS_PK, L1_LEADSTATUS_DP L1_LEADSTATUS_DP, L1_NAME L1_NAME, L1_STATUS_CODE L1_STATUS_CODE, L1_MEANING L1_MEANING, L1_DESCRIPTION L1_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, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE, L1_CREATION_DATE L1_CREATION_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE from "BIM"."EDW_BIM_LEAD_STATUS_M"

View Text - HTML Formatted

SELECT L1_LEADSTATUS_PK_KEY L1_LEADSTATUS_PK_KEY
, L0_ALL_PK_KEY L0_ALL_PK_KEY
, L0_ALL_PK L0_ALL_PK
, L0_NAME L0_NAME
, L1_LEADSTATUS_PK L1_LEADSTATUS_PK
, L1_LEADSTATUS_DP L1_LEADSTATUS_DP
, L1_NAME L1_NAME
, L1_STATUS_CODE L1_STATUS_CODE
, L1_MEANING L1_MEANING
, L1_DESCRIPTION L1_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
, L1_LAST_UPDATE_DATE L1_LAST_UPDATE_DATE
, L1_CREATION_DATE L1_CREATION_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
FROM "BIM"."EDW_BIM_LEAD_STATUS_M"