VIEW: APPS.CSM_CONTR_HEADERS_V

Source

View Text - Preformatted

SELECT acc.access_id, acc.incident_id, acc.contract_service_id, acc.contract_number, acc.service_name, acc.service_description, acc.amount_uom_code , oks.coverage_name, oks.coverage_desc AS coverage_description, oks.START_DATE, oks.END_DATE , oks.DATE_TERMINATED FROM csm_contr_headers_acc acc, oks_ent_coverages_v oks WHERE acc.user_id = asg_base.get_user_id and acc.contract_number=oks.contract_number and acc.contract_service_id=oks.contract_line_id

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, ACC.INCIDENT_ID
, ACC.CONTRACT_SERVICE_ID
, ACC.CONTRACT_NUMBER
, ACC.SERVICE_NAME
, ACC.SERVICE_DESCRIPTION
, ACC.AMOUNT_UOM_CODE
, OKS.COVERAGE_NAME
, OKS.COVERAGE_DESC AS COVERAGE_DESCRIPTION
, OKS.START_DATE
, OKS.END_DATE
, OKS.DATE_TERMINATED
FROM CSM_CONTR_HEADERS_ACC ACC
, OKS_ENT_COVERAGES_V OKS
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.CONTRACT_NUMBER=OKS.CONTRACT_NUMBER
AND ACC.CONTRACT_SERVICE_ID=OKS.CONTRACT_LINE_ID