We have a custom report in 11i for service contratcs and we are using below query and only if Coverage description is
of certain type we are printing the report.
We are in the process of upgrading to R12 and during testing we found that this query is returning values for only old contracts(11i) and not for new contracts.
select UPPER(OCTT.MEANING) COVERAGE_MEANING
FROM OKC_K_HEADERS_B OKHB , OKC_K_LINES_B OKLB , OKC_K_LINES_TL OKLT , OKS_K_LINES_B OKSLB, OKS_COV_TYPES_TL OCTT
WHERE OKHB.CONTRACT_NUMBER = :P_CONTRACT_NUMBER
AND OKHB.ID = OKLB.DNZ_CHR_ID
AND OKLB.ID = OKLT.ID
AND OKLT.LANGUAGE = USERENV('LANG')
AND OKSLB.CLE_ID = OKLB.ID
AND OCTT.CODE (+)= OKSLB.COVERAGE_TYPE
AND OCTT.LANGUAGE (+)= USERENV('LANG')
AND OKLB.LSE_ID = 2
we found that we need to use coverage_id from oklb to derive covergae type but LSE_ID = 2 condition is failing for all new contratcs.
We couldnt find any oracle documentaion detailing this type of changes?