VIEW: APPS.CS_COVERAGES_ACTIVE_V

Source

View Text - Preformatted

SELECT COVERAGE_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , NAME , DESCRIPTION , START_DATE_ACTIVE , END_DATE_ACTIVE , 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 , SUNDAY_START_TIME , SUNDAY_END_TIME , MONDAY_START_TIME , MONDAY_END_TIME , TUESDAY_START_TIME , TUESDAY_END_TIME , WEDNESDAY_START_TIME , WEDNESDAY_END_TIME , THURSDAY_START_TIME , THURSDAY_END_TIME , FRIDAY_START_TIME , FRIDAY_END_TIME , SATURDAY_START_TIME , SATURDAY_END_TIME , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , CONTEXT 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NAME
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, 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
, SUNDAY_START_TIME
, SUNDAY_END_TIME
, MONDAY_START_TIME
, MONDAY_END_TIME
, TUESDAY_START_TIME
, TUESDAY_END_TIME
, WEDNESDAY_START_TIME
, WEDNESDAY_END_TIME
, THURSDAY_START_TIME
, THURSDAY_END_TIME
, FRIDAY_START_TIME
, FRIDAY_END_TIME
, SATURDAY_START_TIME
, SATURDAY_END_TIME
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, CONTEXT
FROM CS_COVERAGES
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))