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.BIM_R_LIMP_DAILY_FACTS#

Source

View Text - Preformatted


select DAILY_TRANSACTION_ID DAILY_TRANSACTION_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LEAD_REGION LEAD_REGION, LEAD_COUNTRY LEAD_COUNTRY, OBJECT_BUSINESS_UNIT_ID OBJECT_BUSINESS_UNIT_ID, LEAD_IMPORT_STATUS LEAD_IMPORT_STATUS, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, PARENT_OBJECT_ID PARENT_OBJECT_ID, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE, YEAR YEAR, QTR QTR, MONTH MONTH, LEADS_VALID LEADS_VALID, LEADS_INVALID LEADS_INVALID, LEADS_NEW LEADS_NEW, FAILURE_REASON FAILURE_REASON, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, WEEKEND_DATE WEEKEND_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, METRIC1 METRIC1, METRIC2 METRIC2, METRIC3 METRIC3, METRIC4 METRIC4, METRIC5 METRIC5, METRIC6 METRIC6, METRIC7 METRIC7, METRIC8 METRIC8, METRIC9 METRIC9, METRIC10 METRIC10, METRIC11 METRIC11, METRIC12 METRIC12, METRIC13 METRIC13, METRIC14 METRIC14, METRIC15 METRIC15 from "BIM"."BIM_R_LIMP_DAILY_FACTS"

View Text - HTML Formatted

SELECT DAILY_TRANSACTION_ID DAILY_TRANSACTION_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LEAD_REGION LEAD_REGION
, LEAD_COUNTRY LEAD_COUNTRY
, OBJECT_BUSINESS_UNIT_ID OBJECT_BUSINESS_UNIT_ID
, LEAD_IMPORT_STATUS LEAD_IMPORT_STATUS
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, PARENT_OBJECT_ID PARENT_OBJECT_ID
, PARENT_OBJECT_TYPE PARENT_OBJECT_TYPE
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, LEADS_VALID LEADS_VALID
, LEADS_INVALID LEADS_INVALID
, LEADS_NEW LEADS_NEW
, FAILURE_REASON FAILURE_REASON
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, WEEKEND_DATE WEEKEND_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, METRIC1 METRIC1
, METRIC2 METRIC2
, METRIC3 METRIC3
, METRIC4 METRIC4
, METRIC5 METRIC5
, METRIC6 METRIC6
, METRIC7 METRIC7
, METRIC8 METRIC8
, METRIC9 METRIC9
, METRIC10 METRIC10
, METRIC11 METRIC11
, METRIC12 METRIC12
, METRIC13 METRIC13
, METRIC14 METRIC14
, METRIC15 METRIC15
FROM "BIM"."BIM_R_LIMP_DAILY_FACTS"