View: OKS_HEADER_DETAILS_V

Product:	OKS - Service Contracts
Description:	Service contracts header details view
Implementation/DBA Data:	APPS.OKS_HEADER_DETAILS_V

View Text

SELECT K.ID CONTRACT_ID
, K.CONTRACT_NUMBER CONTRACT_NUMBER
, K.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, K.START_DATE START_DATE
, K.END_DATE END_DATE
, (SELECT ST.MEANING
FROM OKC_STATUSES_V ST
WHERE ST.CODE=K.STS_CODE) " STATUS"
, K.SHORT_DESCRIPTION SHORT_DESCRIPTION
, PX.PARTY_ID PARTY_ID
, PX.PARTY_NUMBER PARTY_NUMBER
, PX.PARTY_NAME PARTY_NAME
, BTO.DESCRIPTION HEADER_BTO_ADDRESS
, K.CURRENCY_CODE CURRENCY
, K.AUTHORING_ORG_ID ORG_ID
, K.INV_ORGANIZATION_ID INV_ORG_ID
, K.LAST_UPDATE_DATE LAST_UPDATE_DATE
, K.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
FROM OKC_K_HEADERS_V K
, OKC_K_PARTY_ROLES_B PR
, HZ_PARTIES PX
, OKX_CUST_SITE_USES_V BTO
WHERE PR.DNZ_CHR_ID = K.ID
AND PR.CLE_ID IS NULL
AND PX.PARTY_ID = PR.OBJECT1_ID1
AND K.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND PR.RLE_CODE = 'CUSTOMER'
AND PR.CHR_ID = K.ID
AND BTO.ID1(+) = K.BILL_TO_SITE_USE_ID

Columns