VIEW: APPS.OKS_ENT_COVER_TIMES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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