View: OKS_LINE_DETAILS_V

Product:	OKS - Service Contracts
Description:
Implementation/DBA Data:	APPS.OKS_LINE_DETAILS_V

View Text

SELECT L.DNZ_CHR_ID CONTRACT_ID
, L.ID LINE_ID
, L.COGNOMEN LINE_REFERENCE
, L.LINE_NUMBER SERVICE_LINE_NUMBER
, X.DESCRIPTION SERVICE_NAME
, I.OBJECT1_ID1 OBJECT1_ID1
, I.OBJECT1_ID2 OBJECT1_ID2
, L.START_DATE SERVICE_START_DATE
, L.END_DATE SERVICE_END_DATE
, C.NAME CUSTOMER_ACCOUNT_NAME
, BTO.DESCRIPTION LINE_BTO_ADDRESS
, STO.DESCRIPTION LINE_STO_ADDRESS
FROM OKC_K_LINES_V L
, OKC_K_ITEMS I
, OKX_SYSTEM_ITEMS_V X
, OKX_CUSTOMER_ACCOUNTS_V C
, OKX_CUST_SITE_USES_V BTO
, OKX_CUST_SITE_USES_V STO
WHERE L.LSE_ID IN (1
, 12
, 14
, 19)
AND L.CLE_ID IS NULL
AND L.CHR_ID IS NOT NULL
AND L.ID = I.CLE_ID
AND X.ID1 = I.OBJECT1_ID1
AND X.ID2 = I.OBJECT1_ID2
AND C.ID1(+) = L.CUST_ACCT_ID
AND BTO.ID1(+) = L.BILL_TO_SITE_USE_ID
AND STO.ID1(+) = L.SHIP_TO_SITE_USE_ID

Columns