eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_STATUSES_V

Line 14397: -- okc_statuses_v sts,

14393: -- okc_k_lines_b cle_cov,
14394: -- oks_k_lines_b okscle_cov,
14395: -- okc_k_lines_b cle_cvl,
14396: -- okc_k_items cim,
14397: -- okc_statuses_v sts,
14398: -- oks_cov_types_v cvt
14399: -- where cle.chr_id = okh.id
14400: -- and okh.sts_code = sts.code
14401: -- and sts.ste_code = 'ACTIVE'

Line 14430: okc_statuses_v sts,

14426: oks_k_lines_b cle_ksl,
14427: oks_k_lines_b okscle_cov,
14428: okc_k_lines_b cle_cvl,
14429: okc_k_items cim,
14430: okc_statuses_v sts,
14431: oks_cov_types_v cvt
14432: where cle.chr_id = okh.id
14433: and okh.sts_code = sts.code
14434: and sts.ste_code = 'ACTIVE'

Line 14463: -- okc_statuses_v sts,

14459: -- okc_k_lines_b cle_cov,
14460: -- oks_k_lines_b okscle_cov,
14461: -- okc_k_lines_b cle_cvl,
14462: -- okc_k_items cim,
14463: -- okc_statuses_v sts,
14464: -- oks_cov_types_v covtyp
14465: -- where cle.chr_id = okh.id
14466: -- and okh.sts_code = sts.code
14467: -- and sts.ste_code = 'ACTIVE'

Line 14498: okc_statuses_v sts,

14494: oks_k_lines_b cle_ksl,
14495: oks_k_lines_b okscle_cov,
14496: okc_k_lines_b cle_cvl,
14497: okc_k_items cim,
14498: okc_statuses_v sts,
14499: oks_cov_types_v covtyp
14500: where cle.chr_id = okh.id
14501: and okh.sts_code = sts.code
14502: and sts.ste_code = 'ACTIVE'

Line 16840: ,okc_statuses_v STS

16836: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16837: ,Okc_K_Lines_B SV
16838: ,Okc_K_Lines_B CL
16839: ,okc_subclasses_v CAT
16840: ,okc_statuses_v STS
16841: WHERE HD.Id = Cx_Chr_Id
16842: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
16843: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
16844: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 16916: ,okc_statuses_v STS

16912: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16913: ,Okc_K_Lines_B SV
16914: ,Okc_K_Lines_B CL
16915: ,okc_subclasses_v CAT
16916: ,okc_statuses_v STS
16917: WHERE HD.Id = Cx_Chr_Id
16918: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ----Modified condition for ER9681794
16919: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
16920: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 16979: ,okc_statuses_v STS

16975: ,STS.meaning HD_sts_meaning
16976: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
16977: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
16978: ,okc_subclasses_v CAT
16979: ,okc_statuses_v STS
16980: WHERE HD.Id = Cx_Chr_Id -- Modified for Bug#13840327
16981: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
16982: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
16983: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 17033: ,okc_statuses_v STS

17029: ,STS.meaning HD_sts_meaning
17030: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
17031: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
17032: ,okc_subclasses_v CAT
17033: ,okc_statuses_v STS
17034: WHERE HD.Id = nvl(Cx_Chr_Id,HD.Id)
17035: AND HD.Scs_Code IN ('SERVICE','WARRANTY','SUBSCRIPTION') ------Modified condition for ER9681794
17036: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
17037: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 17089: ,okc_statuses_v STS

17085: ,STS.meaning HD_sts_meaning
17086: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
17087: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
17088: ,okc_subclasses_v CAT
17089: ,okc_statuses_v STS
17090: WHERE HD.Scs_Code IN ('SERVICE','WARRANTY')
17091: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
17092: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)
17093: AND HD.Sts_code = STS.code

Line 21343: FROM OKC_STATUSES_V ;

21339: PROCEDURE Fetch_Sts_Meaning IS
21340:
21341: CURSOR GET_STATUS_CUR IS
21342: SELECT CODE,MEANING
21343: FROM OKC_STATUSES_V ;
21344:
21345: i Number;
21346: BEGIN
21347: i := 1;