VIEW: APPS.OKS_CONTRACTS_V

Source

View Text - Preformatted

SELECT distinct hdr.contract_number contract_number ,hdr.contract_number_modifier ,hdr.currency_code ,hdr.scs_code scs_code ,hdr.start_date start_date ,hdr.end_date end_date ,rl.object1_id1 Cust_id ,hdr.id ,1 service_id ,'A' Service ,'B' line_number ,ks.period_start period_start ,ks.period_type period_type From OKC_K_HEADERS_b hdr ,OKC_K_PARTY_ROLES_b rl ,OKC_K_LINES_b line ,OKC_STATUSES_b st ,OKS_K_HEADERS_B ks WHERE rl.dnz_chr_id = hdr.id and rl.chr_id = hdr.id and rl.cle_id Is Null and rl.rle_code IN ('CUSTOMER', 'SUBSCRIBER') and line.dnz_chr_id = hdr.id and line.chr_id = hdr.id and line.cle_id is NULL and line.lse_id IN (1, 19, 46) and st.code = hdr.sts_code and st.ste_code in ( 'ACTIVE', 'SIGNED') and hdr.date_terminated IS NULL and ks.chr_id = hdr.id

View Text - HTML Formatted

SELECT DISTINCT HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, HDR.CONTRACT_NUMBER_MODIFIER
, HDR.CURRENCY_CODE
, HDR.SCS_CODE SCS_CODE
, HDR.START_DATE START_DATE
, HDR.END_DATE END_DATE
, RL.OBJECT1_ID1 CUST_ID
, HDR.ID
, 1 SERVICE_ID
, 'A' SERVICE
, 'B' LINE_NUMBER
, KS.PERIOD_START PERIOD_START
, KS.PERIOD_TYPE PERIOD_TYPE
FROM OKC_K_HEADERS_B HDR
, OKC_K_PARTY_ROLES_B RL
, OKC_K_LINES_B LINE
, OKC_STATUSES_B ST
, OKS_K_HEADERS_B KS
WHERE RL.DNZ_CHR_ID = HDR.ID
AND RL.CHR_ID = HDR.ID
AND RL.CLE_ID IS NULL
AND RL.RLE_CODE IN ('CUSTOMER'
, 'SUBSCRIBER')
AND LINE.DNZ_CHR_ID = HDR.ID
AND LINE.CHR_ID = HDR.ID
AND LINE.CLE_ID IS NULL
AND LINE.LSE_ID IN (1
, 19
, 46)
AND ST.CODE = HDR.STS_CODE
AND ST.STE_CODE IN ( 'ACTIVE'
, 'SIGNED')
AND HDR.DATE_TERMINATED IS NULL
AND KS.CHR_ID = HDR.ID