This discussion is archived
1 Reply Latest reply: May 5, 2012 2:44 PM by Sandeep Gandhi, Consultant RSS

Meaning of LSE_ID = 2

user11258661 Newbie
Currently Being Moderated
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
into l_short_description
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
AND rownum=1;

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?


please help this is urgent!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points