VIEW: APPS.CS_CONTRACT_COVERAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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