View: OKS_ENT_COVER_TIMES_V

Product:	OKS - Service Contracts
Description:	List if actual coverages attached to a contract line.
Implementation/DBA Data:	APPS.OKS_ENT_COVER_TIMES_V

View Text

SELECT KL.CLE_ID COVERAGE_ID
, BP.ID1 BUSINESS_PROCESS_ID
, BP.NAME BUSINESS_PROCESS_NAME
, CTZ.TIMEZONE_ID TIME_ZONE_ID
, TZ.NAME TIME_ZONE_NAME
, NULL COVERAGE_ON
, LPAD(TO_CHAR(CVT.START_HOUR)
, 2
, '0') || ':' ||LPAD(TO_CHAR(CVT.START_MINUTE)
, 2
, '0') COVERAGE_FROM
, LPAD(TO_CHAR(CVT.END_HOUR)
, 2
, '0') || ':' || LPAD(TO_CHAR(CVT.END_MINUTE)
, 2
, '0') COVERAGE_TO
, NVL(SUNDAY_YN
, 'N') COVERAGE_ON_SUNDAY
, NVL(MONDAY_YN
, 'N') COVERAGE_ON_MONDAY
, NVL(TUESDAY_YN
, 'N') COVERAGE_ON_TUESDAY
, NVL(WEDNESDAY_YN
, 'N') COVERAGE_ON_WEDNESDAY
, NVL(THURSDAY_YN
, 'N') COVERAGE_ON_THURSDAY
, NVL(FRIDAY_YN
, 'N') COVERAGE_ON_FRIDAY
, NVL(SATURDAY_YN
, 'N') COVERAGE_ON_SATURDAY
FROM OKC_K_LINES_B KL
, OKC_K_ITEMS IT
, OKX_BUS_PROCESSES_V BP
, OKS_COVERAGE_TIMEZONES CTZ
, OKS_COVERAGE_TIMES CVT
, OKX_TIMEZONES_V TZ
WHERE KL.LSE_ID IN (3
, 16
, 21)
AND KL.ID = CTZ.CLE_ID
AND CTZ.ID = CVT.COV_TZE_LINE_ID
AND KL.ID = IT.CLE_ID
AND IT.OBJECT1_ID1 = BP.ID1
AND IT.OBJECT1_ID2 = BP.ID2
AND CTZ.TIMEZONE_ID = TZ.TIMEZONE_ID

Columns