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: OKS.OKS_COV_TXN_GROUPS_INT_ALL#

Source

View Text - Preformatted


select COVERAGE_BUS_PROCESS_ID COVERAGE_BUS_PROCESS_ID, COVERAGE_ID COVERAGE_ID, BUSINESS_PROCESS_ID BUSINESS_PROCESS_ID, OFFSET_DURATION OFFSET_DURATION, OFFSET_PERIOD OFFSET_PERIOD, START_DATE START_DATE, END_DATE END_DATE, PRICE_LIST_ID PRICE_LIST_ID, DISCOUNT_ID DISCOUNT_ID, COVERAGE_SUNDAY_START_TIME COVERAGE_SUNDAY_START_TIME, COVERAGE_SUNDAY_END_TIME COVERAGE_SUNDAY_END_TIME, COVERAGE_MONDAY_START_TIME COVERAGE_MONDAY_START_TIME, COVERAGE_MONDAY_END_TIME COVERAGE_MONDAY_END_TIME, COVERAGE_TUESDAY_START_TIME COVERAGE_TUESDAY_START_TIME, COVERAGE_TUESDAY_END_TIME COVERAGE_TUESDAY_END_TIME, COVERAGE_WEDNESDAY_START_TIME COVERAGE_WEDNESDAY_START_TIME, COVERAGE_WEDNESDAY_END_TIME COVERAGE_WEDNESDAY_END_TIME, COVERAGE_THURSDAY_START_TIME COVERAGE_THURSDAY_START_TIME, COVERAGE_THURSDAY_END_TIME COVERAGE_THURSDAY_END_TIME, COVERAGE_FRIDAY_START_TIME COVERAGE_FRIDAY_START_TIME, COVERAGE_FRIDAY_END_TIME COVERAGE_FRIDAY_END_TIME, COVERAGE_SATURDAY_START_TIME COVERAGE_SATURDAY_START_TIME, COVERAGE_SATURDAY_END_TIME COVERAGE_SATURDAY_END_TIME, TIME_ZONE_ID TIME_ZONE_ID, REACTION_NAME REACTION_NAME, REACTION_DESCRIPTION REACTION_DESCRIPTION, REACTION_TIME_ID REACTION_TIME_ID, REACTION_SEVERITY_CODE REACTION_SEVERITY_CODE, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID, SUNDAY_REACTION_TIMES SUNDAY_REACTION_TIMES, MONDAY_REACTION_TIMES MONDAY_REACTION_TIMES, TUESDAY_REACTION_TIMES TUESDAY_REACTION_TIMES, WEDNESDAY_REACTION_TIMES WEDNESDAY_REACTION_TIMES, THURSDAY_REACTION_TIMES THURSDAY_REACTION_TIMES, FRIDAY_REACTION_TIMES FRIDAY_REACTION_TIMES, SATURDAY_REACTION_TIMES SATURDAY_REACTION_TIMES, WORK_THROUGH_YN WORK_THROUGH_YN, ACTIVE_YN ACTIVE_YN, SUNDAY_RESOLUTION_TIMES SUNDAY_RESOLUTION_TIMES, MONDAY_RESOLUTION_TIMES MONDAY_RESOLUTION_TIMES, TUESDAY_RESOLUTION_TIMES TUESDAY_RESOLUTION_TIMES, WEDNESDAY_RESOLUTION_TIMES WEDNESDAY_RESOLUTION_TIMES, THURSDAY_RESOLUTION_TIMES THURSDAY_RESOLUTION_TIMES, FRIDAY_RESOLUTION_TIMES FRIDAY_RESOLUTION_TIMES, SATURDAY_RESOLUTION_TIMES SATURDAY_RESOLUTION_TIMES, PREFERRED_RESOURCE_TYPE PREFERRED_RESOURCE_TYPE, PREFERRED_RESOURCE_ID PREFERRED_RESOURCE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INTERFACED_STATUS_FLAG INTERFACED_STATUS_FLAG from "OKS"."OKS_COV_TXN_GROUPS_INT_ALL"

View Text - HTML Formatted

SELECT COVERAGE_BUS_PROCESS_ID COVERAGE_BUS_PROCESS_ID
, COVERAGE_ID COVERAGE_ID
, BUSINESS_PROCESS_ID BUSINESS_PROCESS_ID
, OFFSET_DURATION OFFSET_DURATION
, OFFSET_PERIOD OFFSET_PERIOD
, START_DATE START_DATE
, END_DATE END_DATE
, PRICE_LIST_ID PRICE_LIST_ID
, DISCOUNT_ID DISCOUNT_ID
, COVERAGE_SUNDAY_START_TIME COVERAGE_SUNDAY_START_TIME
, COVERAGE_SUNDAY_END_TIME COVERAGE_SUNDAY_END_TIME
, COVERAGE_MONDAY_START_TIME COVERAGE_MONDAY_START_TIME
, COVERAGE_MONDAY_END_TIME COVERAGE_MONDAY_END_TIME
, COVERAGE_TUESDAY_START_TIME COVERAGE_TUESDAY_START_TIME
, COVERAGE_TUESDAY_END_TIME COVERAGE_TUESDAY_END_TIME
, COVERAGE_WEDNESDAY_START_TIME COVERAGE_WEDNESDAY_START_TIME
, COVERAGE_WEDNESDAY_END_TIME COVERAGE_WEDNESDAY_END_TIME
, COVERAGE_THURSDAY_START_TIME COVERAGE_THURSDAY_START_TIME
, COVERAGE_THURSDAY_END_TIME COVERAGE_THURSDAY_END_TIME
, COVERAGE_FRIDAY_START_TIME COVERAGE_FRIDAY_START_TIME
, COVERAGE_FRIDAY_END_TIME COVERAGE_FRIDAY_END_TIME
, COVERAGE_SATURDAY_START_TIME COVERAGE_SATURDAY_START_TIME
, COVERAGE_SATURDAY_END_TIME COVERAGE_SATURDAY_END_TIME
, TIME_ZONE_ID TIME_ZONE_ID
, REACTION_NAME REACTION_NAME
, REACTION_DESCRIPTION REACTION_DESCRIPTION
, REACTION_TIME_ID REACTION_TIME_ID
, REACTION_SEVERITY_CODE REACTION_SEVERITY_CODE
, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, SUNDAY_REACTION_TIMES SUNDAY_REACTION_TIMES
, MONDAY_REACTION_TIMES MONDAY_REACTION_TIMES
, TUESDAY_REACTION_TIMES TUESDAY_REACTION_TIMES
, WEDNESDAY_REACTION_TIMES WEDNESDAY_REACTION_TIMES
, THURSDAY_REACTION_TIMES THURSDAY_REACTION_TIMES
, FRIDAY_REACTION_TIMES FRIDAY_REACTION_TIMES
, SATURDAY_REACTION_TIMES SATURDAY_REACTION_TIMES
, WORK_THROUGH_YN WORK_THROUGH_YN
, ACTIVE_YN ACTIVE_YN
, SUNDAY_RESOLUTION_TIMES SUNDAY_RESOLUTION_TIMES
, MONDAY_RESOLUTION_TIMES MONDAY_RESOLUTION_TIMES
, TUESDAY_RESOLUTION_TIMES TUESDAY_RESOLUTION_TIMES
, WEDNESDAY_RESOLUTION_TIMES WEDNESDAY_RESOLUTION_TIMES
, THURSDAY_RESOLUTION_TIMES THURSDAY_RESOLUTION_TIMES
, FRIDAY_RESOLUTION_TIMES FRIDAY_RESOLUTION_TIMES
, SATURDAY_RESOLUTION_TIMES SATURDAY_RESOLUTION_TIMES
, PREFERRED_RESOURCE_TYPE PREFERRED_RESOURCE_TYPE
, PREFERRED_RESOURCE_ID PREFERRED_RESOURCE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INTERFACED_STATUS_FLAG INTERFACED_STATUS_FLAG
FROM "OKS"."OKS_COV_TXN_GROUPS_INT_ALL"