VIEW: BIM.BIM_R_LIMP_WEEKLY_FACTS#

Source

View Text - Preformatted

select WEEKLY_TRANSACTION_ID WEEKLY_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, 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 from "BIM"."BIM_R_LIMP_WEEKLY_FACTS"

View Text - HTML Formatted

SELECT WEEKLY_TRANSACTION_ID WEEKLY_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
, 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
FROM "BIM"."BIM_R_LIMP_WEEKLY_FACTS"