VIEW: APPS.CS_COV_FOR_CONTRACT_V

Source

View Text - Preformatted

SELECT cov.name, cov.description, cov.start_date_active, cov.end_date_active, ctg.coverage_txn_group_id, ctg.offset_duration, ctg.offset_period, ctg.sunday_start_time, ctg.sunday_end_time, ctg.monday_start_time, ctg.monday_end_time, ctg.tuesday_start_time, ctg.tuesday_end_time, ctg.wednesday_start_time, ctg.wednesday_end_time, ctg.thursday_start_time, ctg.thursday_end_time, ctg.friday_start_time, ctg.friday_end_time, ctg.saturday_start_time, ctg.saturday_end_time, tz.name time_zone, bp.name txn_group FROM cs_coverages cov, cs_coverage_txn_groups ctg, cs_time_zones tz, cs_business_processes bp WHERE cov.coverage_id = ctg.coverage_id AND ctg.time_zone_id = tz.time_zone_id(+) AND ctg.business_process_id = bp.business_process_id

View Text - HTML Formatted

SELECT COV.NAME
, COV.DESCRIPTION
, COV.START_DATE_ACTIVE
, COV.END_DATE_ACTIVE
, CTG.COVERAGE_TXN_GROUP_ID
, CTG.OFFSET_DURATION
, CTG.OFFSET_PERIOD
, CTG.SUNDAY_START_TIME
, CTG.SUNDAY_END_TIME
, CTG.MONDAY_START_TIME
, CTG.MONDAY_END_TIME
, CTG.TUESDAY_START_TIME
, CTG.TUESDAY_END_TIME
, CTG.WEDNESDAY_START_TIME
, CTG.WEDNESDAY_END_TIME
, CTG.THURSDAY_START_TIME
, CTG.THURSDAY_END_TIME
, CTG.FRIDAY_START_TIME
, CTG.FRIDAY_END_TIME
, CTG.SATURDAY_START_TIME
, CTG.SATURDAY_END_TIME
, TZ.NAME TIME_ZONE
, BP.NAME TXN_GROUP
FROM CS_COVERAGES COV
, CS_COVERAGE_TXN_GROUPS CTG
, CS_TIME_ZONES TZ
, CS_BUSINESS_PROCESSES BP
WHERE COV.COVERAGE_ID = CTG.COVERAGE_ID
AND CTG.TIME_ZONE_ID = TZ.TIME_ZONE_ID(+)
AND CTG.BUSINESS_PROCESS_ID = BP.BUSINESS_PROCESS_ID