View: OKS_ENT_LINE_DETAILS_V

Product:	OKS - Service Contracts
Description:	This is view is supposed to be called only by passing service_line_id as bind variable.
Implementation/DBA Data:	APPS.OKS_ENT_LINE_DETAILS_V

View Text

SELECT HDR.ID CONTRACT_ID
, HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, HDR.CONTRACT_NUMBER_MODIFIER MODIFIER
, SVL.ID SERVICE_LINE_ID
, MTL.CONCATENATED_SEGMENTS SERVICE_NAME
, MTL.DESCRIPTION SERVICE_DESCRIPTION
, COV.ID COVERAGE_LINE_ID
, COV.NAME COVERAGE_NAME
, COV.ITEM_DESCRIPTION COVERAGE_DESCRIPTION
, SVL.START_DATE SERVICE_START_DATE
, SVL.END_DATE SERVICE_END_DATE
, DECODE(SVL.LSE_ID
, 1
, 'N'
, 14
, 'Y'
, 19
, 'N') WARRANTY_FLAG
, SVL.STS_CODE STATUS_CODE
FROM OKC_K_HEADERS_B HDR
, OKC_K_LINES_B SVL
, OKC_K_ITEMS CIM
, MTL_SYSTEM_ITEMS_B_KFV MTL
, OKC_K_LINES_V COV
WHERE HDR.ID = SVL.CHR_ID
AND HDR.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND SVL.ID = CIM.CLE_ID
AND CIM.OBJECT1_ID1 = MTL.INVENTORY_ITEM_ID
AND CIM.OBJECT1_ID2 = MTL.ORGANIZATION_ID
AND SVL.ID = COV.CLE_ID
AND COV.LSE_ID IN (2
, 15
, 20)

Columns