View: OKS_LINES_V

Product:	OKS - Service Contracts
Description:	View is Used for Contracts Quote Printing
Implementation/DBA Data:	APPS.OKS_LINES_V

View Text

SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.ID LINE_ID
, L.NAME SERVICE_NAME
, L.START_DATE SERVICE_START_DATE
, L.END_DATE SERVICE_END_DATE
, C.NAME CUSTOMER_ACCOUNT_NAME
, BTO.ADDRESS1 BILL2_ADDRESS1
, BTO.ADDRESS2 BILL2_ADDRESS2
, BTO.COUNTRY BILL2_COUNTRY
, NULL SHIP2_ADDRESS1
, NULL SHIP2_ADDRESS2
, NULL SHIP2_COUNTRY
FROM OKC_K_HEADERS_V K
, OKC_K_LINES_V L
, OKX_CUSTOMER_ACCOUNTS_V C
, OKX_CUST_SITE_USES_V BTO
WHERE K.ID = L.DNZ_CHR_ID
AND L.LSE_ID IN (1
, 19)
AND C.ID1 = L.CUST_ACCT_ID
AND BTO.ID1(+) = L.BILL_TO_SITE_USE_ID

Columns