eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CS_COV_FOR_CONTRACT_V

Object Details

Object Name:	CS_COV_FOR_CONTRACT_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
NAME	VARCHAR2	(30)	Yes
DESCRIPTION	VARCHAR2	(240)
START_DATE_ACTIVE	DATE
END_DATE_ACTIVE	DATE
COVERAGE_TXN_GROUP_ID	NUMBER		Yes
OFFSET_DURATION	NUMBER
OFFSET_PERIOD	VARCHAR2	(15)
SUNDAY_START_TIME	DATE
SUNDAY_END_TIME	DATE
MONDAY_START_TIME	DATE
MONDAY_END_TIME	DATE
TUESDAY_START_TIME	DATE
TUESDAY_END_TIME	DATE
WEDNESDAY_START_TIME	DATE
WEDNESDAY_END_TIME	DATE
THURSDAY_START_TIME	DATE
THURSDAY_END_TIME	DATE
FRIDAY_START_TIME	DATE
FRIDAY_END_TIME	DATE
SATURDAY_START_TIME	DATE
SATURDAY_END_TIME	DATE
TIME_ZONE	VARCHAR2	(30)
TXN_GROUP	VARCHAR2	(90)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COVERAGE_TXN_GROUP_ID
,      OFFSET_DURATION
,      OFFSET_PERIOD
,      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
,      TIME_ZONE
,      TXN_GROUP
FROM APPS.CS_COV_FOR_CONTRACT_V;

Dependencies

[top of page]

APPS.CS_COV_FOR_CONTRACT_V references the following:

APPS: CS_BUSINESS_PROCESSES; CS_COVERAGES; CS_COVERAGE_TXN_GROUPS; CS_TIME_ZONES

APPS.CS_COV_FOR_CONTRACT_V is not referenced by any database object