View: CS_CONTRACT_COVERAGES_V

Product:	CS - Service
Description:	List of Contracts and Coverages available
Implementation/DBA Data:	APPS.CS_CONTRACT_COVERAGES_V

View Text

SELECT HDR.ORG_ID
, HDR.CONTRACT_ID
, HDR.CONTRACT_NUMBER
, HDR.PARTY_ID
, HDR.START_DATE_ACTIVE
, HDR.END_DATE_ACTIVE
, HDR.BILL_TO_SITE_USE_ID
, HDR.SHIP_TO_SITE_USE_ID
, HDR.PRICE_LIST_ID
, HDR.CURRENCY_CODE
, COV.ACTUAL_COVERAGE_ID
, COV.COVERAGE_NAME
, COV.START_DATE
, COV.END_DATE
, TG.TXN_GROUP_ID
, TG.BUSINESS_PROCESS_ID
, 'N'
FROM OKS_ENT_HEADERS_V HDR
, OKS_ENT_COVERAGES_V COV
, OKS_ENT_TXN_GROUPS_V TG
WHERE HDR.CONTRACT_TEMPLATE_YN = 'N'
AND HDR.CONTRACT_ID = COV.CONTRACT_ID
AND COV.ACTUAL_COVERAGE_ID = TG.COVERAGE_ID UNION SELECT HDR.ORG_ID
, HDR.CONTRACT_ID
, HDR.CONTRACT_NUMBER
, HDR.PARTY_ID
, HDR.START_DATE_ACTIVE
, HDR.END_DATE_ACTIVE
, HDR.BILL_TO_SITE_USE_ID
, HDR.SHIP_TO_SITE_USE_ID
, HDR.PRICE_LIST_ID
, HDR.CURRENCY_CODE
, COV.ACTUAL_COVERAGE_ID
, COV.COVERAGE_NAME
, COV.START_DATE
, COV.END_DATE
, TG.TXN_GROUP_ID
, TG.BUSINESS_PROCESS_ID
, 'Y'
FROM OKS_ENT_HEADERS_V HDR
, OKS_ENT_COVERAGES_V COV
, OKS_ENT_TXN_GROUPS_V TG
WHERE HDR.CONTRACT_TEMPLATE_YN = 'N'
AND HDR.CONTRACT_ID = COV.CONTRACT_ID
AND COV.EXCEPTION_COVERAGE_ID = TG.COVERAGE_ID

Columns