SELECT HDR.CONTRACT_NUMBER CONTRACT_NUMBER , 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 FROM OKC_K_HEADERS_V HDR , OKC_K_PARTY_ROLES_V RL , OKC_K_LINES_V LINE , OKC_STATUSES_V ST WHERE RL.DNZ_CHR_ID = HDR.ID AND RL.CLE_ID IS NULL AND LINE.DNZ_CHR_ID = HDR.ID AND LINE.LSE_ID = 19 AND RL.RLE_CODE = 'CUSTOMER' AND ST.CODE = HDR.STS_CODE AND ST.STE_CODE IN ( 'ACTIVE' , 'SIGNED') AND HDR.CONTRACT_NUMBER_MODIFIER IS NULL AND EXISTS (SELECT 1 FROM OKC_K_REL_OBJS WHERE CHR_ID = HDR.ID)