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.

[Home] [Help]

VIEW: BIM.BIM_R_RRSN_WEEKLY_FACTS#

Source

View Text - Preformatted


select REASON_WEEKLY_TRANSACTION_ID REASON_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, OBJECT_ID OBJECT_ID, OBJECT_STATUS OBJECT_STATUS, OBJECT_TYPE OBJECT_TYPE, SOURCE_CODE SOURCE_CODE, SOURCE_CODE_ID SOURCE_CODE_ID, RESPONSE_COUNTRY RESPONSE_COUNTRY, RESPONSE_REGION RESPONSE_REGION, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, INVALID_REASON INVALID_REASON, INVALID_RESPONSES INVALID_RESPONSES, SURVEY_COMPLETED SURVEY_COMPLETED, LANDING_PAD_HITS LANDING_PAD_HITS, YEAR YEAR, QTR QTR, MONTH MONTH, 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_RRSN_WEEKLY_FACTS"

View Text - HTML Formatted

SELECT REASON_WEEKLY_TRANSACTION_ID REASON_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
, OBJECT_ID OBJECT_ID
, OBJECT_STATUS OBJECT_STATUS
, OBJECT_TYPE OBJECT_TYPE
, SOURCE_CODE SOURCE_CODE
, SOURCE_CODE_ID SOURCE_CODE_ID
, RESPONSE_COUNTRY RESPONSE_COUNTRY
, RESPONSE_REGION RESPONSE_REGION
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, INVALID_REASON INVALID_REASON
, INVALID_RESPONSES INVALID_RESPONSES
, SURVEY_COMPLETED SURVEY_COMPLETED
, LANDING_PAD_HITS LANDING_PAD_HITS
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, 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_RRSN_WEEKLY_FACTS"