VIEW: APPS.OKS_ENT_LINE_DETAILS_V

Source

View Text - Preformatted

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, OKSSRV.STANDARD_COV_YN STANDARD_COV_YN from okc_k_headers_all_b hdr, okc_k_lines_b svl, okc_k_items cim, mtl_system_items_b_kfv mtl, okc_k_lines_v cov, oks_k_Lines_b okssrv WHERE hdr.id = svl.chr_id and hdr.id = svl.dnz_chr_id and hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION') and svl.id = cim.cle_id and cim.object1_id1 = mtl.inventory_item_id and cim.object1_id2 = mtl.organization_id and okssrv.cle_id = svl.id and cov.id = okssrv.coverage_id and cov.lse_id in (2,15,20)

View Text - HTML Formatted

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
, OKSSRV.STANDARD_COV_YN STANDARD_COV_YN
FROM OKC_K_HEADERS_ALL_B HDR
, OKC_K_LINES_B SVL
, OKC_K_ITEMS CIM
, MTL_SYSTEM_ITEMS_B_KFV MTL
, OKC_K_LINES_V COV
, OKS_K_LINES_B OKSSRV
WHERE HDR.ID = SVL.CHR_ID
AND HDR.ID = SVL.DNZ_CHR_ID
AND HDR.SCS_CODE IN ('SERVICE'
, 'WARRANTY'
, 'SUBSCRIPTION')
AND SVL.ID = CIM.CLE_ID
AND CIM.OBJECT1_ID1 = MTL.INVENTORY_ITEM_ID
AND CIM.OBJECT1_ID2 = MTL.ORGANIZATION_ID
AND OKSSRV.CLE_ID = SVL.ID
AND COV.ID = OKSSRV.COVERAGE_ID
AND COV.LSE_ID IN (2
, 15
, 20)