View: OKS_CONTRACTS_V

Product:	OKS - Service Contracts
Description:	contracts view for contract details form
Implementation/DBA Data:	APPS.OKS_CONTRACTS_V

View Text

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)

Columns