VIEW: APPS.CS_ACTIVE_COVERAGES_RG_V

Source

View Text - Preformatted

SELECT COVERAGE_ID , NAME , DESCRIPTION , COVERAGE_LEVEL , TIME_BILLABLE_PERCENT , MAX_TIME_BILLABLE_AMOUNT , MATERIAL_BILLABLE_PERCENT , MAX_MATERIAL_BILLABLE_AMOUNT , EXPENSE_BILLABLE_PERCENT , MAX_EXPENSE_BILLABLE_AMOUNT , MAX_COVERAGE_AMOUNT , RESPONSE_TIME_PERIOD_CODE , RESPONSE_TIME_VALUE , TO_CHAR(SUNDAY_START_TIME,'HH24:MI') SUNDAY_START_TIME , TO_CHAR(SUNDAY_END_TIME,'HH24:MI') SUNDAY_END_TIME , TO_CHAR(MONDAY_START_TIME,'HH24:MI') MONDAY_START_TIME , TO_CHAR(MONDAY_END_TIME,'HH24:MI') MONDAY_END_TIME , TO_CHAR(TUESDAY_START_TIME,'HH24:MI') TUESDAY_START_TIME , TO_CHAR(TUESDAY_END_TIME,'HH24:MI') TUESDAY_END_TIME , TO_CHAR(WEDNESDAY_START_TIME,'HH24:MI') WEDNESDAY_START_TIME , TO_CHAR(WEDNESDAY_END_TIME,'HH24:MI') WEDNESDAY_END_TIME , TO_CHAR(THURSDAY_START_TIME,'HH24:MI') THURSDAY_START_TIME , TO_CHAR(THURSDAY_END_TIME,'HH24:MI') THURSDAY_END_TIME , TO_CHAR(FRIDAY_START_TIME,'HH24:MI') FRIDAY_START_TIME , TO_CHAR(FRIDAY_END_TIME,'HH24:MI') FRIDAY_END_TIME , TO_CHAR(SATURDAY_START_TIME,'HH24:MI') SATURDAY_START_TIME , TO_CHAR(SATURDAY_END_TIME,'HH24:MI') SATURDAY_END_TIME FROM CS_COVERAGES WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))

View Text - HTML Formatted

SELECT COVERAGE_ID
, NAME
, DESCRIPTION
, COVERAGE_LEVEL
, TIME_BILLABLE_PERCENT
, MAX_TIME_BILLABLE_AMOUNT
, MATERIAL_BILLABLE_PERCENT
, MAX_MATERIAL_BILLABLE_AMOUNT
, EXPENSE_BILLABLE_PERCENT
, MAX_EXPENSE_BILLABLE_AMOUNT
, MAX_COVERAGE_AMOUNT
, RESPONSE_TIME_PERIOD_CODE
, RESPONSE_TIME_VALUE
, TO_CHAR(SUNDAY_START_TIME
, 'HH24:MI') SUNDAY_START_TIME
, TO_CHAR(SUNDAY_END_TIME
, 'HH24:MI') SUNDAY_END_TIME
, TO_CHAR(MONDAY_START_TIME
, 'HH24:MI') MONDAY_START_TIME
, TO_CHAR(MONDAY_END_TIME
, 'HH24:MI') MONDAY_END_TIME
, TO_CHAR(TUESDAY_START_TIME
, 'HH24:MI') TUESDAY_START_TIME
, TO_CHAR(TUESDAY_END_TIME
, 'HH24:MI') TUESDAY_END_TIME
, TO_CHAR(WEDNESDAY_START_TIME
, 'HH24:MI') WEDNESDAY_START_TIME
, TO_CHAR(WEDNESDAY_END_TIME
, 'HH24:MI') WEDNESDAY_END_TIME
, TO_CHAR(THURSDAY_START_TIME
, 'HH24:MI') THURSDAY_START_TIME
, TO_CHAR(THURSDAY_END_TIME
, 'HH24:MI') THURSDAY_END_TIME
, TO_CHAR(FRIDAY_START_TIME
, 'HH24:MI') FRIDAY_START_TIME
, TO_CHAR(FRIDAY_END_TIME
, 'HH24:MI') FRIDAY_END_TIME
, TO_CHAR(SATURDAY_START_TIME
, 'HH24:MI') SATURDAY_START_TIME
, TO_CHAR(SATURDAY_END_TIME
, 'HH24:MI') SATURDAY_END_TIME
FROM CS_COVERAGES
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))