VIEW: APPS.CS_COVERAGES_V

Source

View Text - Preformatted

SELECT CC1.ROWID ROW_ID , CC1.COVERAGE_ID , CC1.COVERAGE_TEMPLATE_ID , CC1.TEMPLATE_FLAG , CC1.NAME , CC1.START_DATE_ACTIVE , CC1.END_DATE_ACTIVE , CC1.DESCRIPTION , CC1.MAX_SUPPORT_COVERAGE_AMT , CC1.EXCEPTION_COVERAGE_ID , CC2.NAME EXCEPTION_COVERAGE , CC1.RENEWAL_TERMS , CC1.TERMINATION_TERMS , CC1.LAST_UPDATE_DATE , CC1.LAST_UPDATED_BY , CC1.CREATION_DATE , CC1.CREATED_BY , CC1.LAST_UPDATE_LOGIN , CC1.ATTRIBUTE1 , CC1.ATTRIBUTE2 , CC1.ATTRIBUTE3 , CC1.ATTRIBUTE4 , CC1.ATTRIBUTE5 , CC1.ATTRIBUTE6 , CC1.ATTRIBUTE7 , CC1.ATTRIBUTE8 , CC1.ATTRIBUTE9 , CC1.ATTRIBUTE10 , CC1.ATTRIBUTE11 , CC1.ATTRIBUTE12 , CC1.ATTRIBUTE13 , CC1.ATTRIBUTE14 , CC1.ATTRIBUTE15 , CC1.OBJECT_VERSION_NUMBER , CC1.CONTEXT FROM CS_COVERAGES CC1, CS_COVERAGES CC2 WHERE CC1.TEMPLATE_FLAG IN ('Y', 'N') AND CC1.EXCEPTION_COVERAGE_ID = CC2.COVERAGE_ID(+)

View Text - HTML Formatted

SELECT CC1.ROWID ROW_ID
, CC1.COVERAGE_ID
, CC1.COVERAGE_TEMPLATE_ID
, CC1.TEMPLATE_FLAG
, CC1.NAME
, CC1.START_DATE_ACTIVE
, CC1.END_DATE_ACTIVE
, CC1.DESCRIPTION
, CC1.MAX_SUPPORT_COVERAGE_AMT
, CC1.EXCEPTION_COVERAGE_ID
, CC2.NAME EXCEPTION_COVERAGE
, CC1.RENEWAL_TERMS
, CC1.TERMINATION_TERMS
, CC1.LAST_UPDATE_DATE
, CC1.LAST_UPDATED_BY
, CC1.CREATION_DATE
, CC1.CREATED_BY
, CC1.LAST_UPDATE_LOGIN
, CC1.ATTRIBUTE1
, CC1.ATTRIBUTE2
, CC1.ATTRIBUTE3
, CC1.ATTRIBUTE4
, CC1.ATTRIBUTE5
, CC1.ATTRIBUTE6
, CC1.ATTRIBUTE7
, CC1.ATTRIBUTE8
, CC1.ATTRIBUTE9
, CC1.ATTRIBUTE10
, CC1.ATTRIBUTE11
, CC1.ATTRIBUTE12
, CC1.ATTRIBUTE13
, CC1.ATTRIBUTE14
, CC1.ATTRIBUTE15
, CC1.OBJECT_VERSION_NUMBER
, CC1.CONTEXT
FROM CS_COVERAGES CC1
, CS_COVERAGES CC2
WHERE CC1.TEMPLATE_FLAG IN ('Y'
, 'N')
AND CC1.EXCEPTION_COVERAGE_ID = CC2.COVERAGE_ID(+)