APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_STATUSES_V

Line 13039: -- okc_statuses_v sts,

13035: -- okc_k_lines_b cle_cov,
13036: -- oks_k_lines_b okscle_cov,
13037: -- okc_k_lines_b cle_cvl,
13038: -- okc_k_items cim,
13039: -- okc_statuses_v sts,
13040: -- oks_cov_types_v cvt
13041: -- where cle.chr_id = okh.id
13042: -- and okh.sts_code = sts.code
13043: -- and sts.ste_code = 'ACTIVE'

Line 13072: okc_statuses_v sts,

13068: oks_k_lines_b cle_ksl,
13069: oks_k_lines_b okscle_cov,
13070: okc_k_lines_b cle_cvl,
13071: okc_k_items cim,
13072: okc_statuses_v sts,
13073: oks_cov_types_v cvt
13074: where cle.chr_id = okh.id
13075: and okh.sts_code = sts.code
13076: and sts.ste_code = 'ACTIVE'

Line 13105: -- okc_statuses_v sts,

13101: -- okc_k_lines_b cle_cov,
13102: -- oks_k_lines_b okscle_cov,
13103: -- okc_k_lines_b cle_cvl,
13104: -- okc_k_items cim,
13105: -- okc_statuses_v sts,
13106: -- oks_cov_types_v covtyp
13107: -- where cle.chr_id = okh.id
13108: -- and okh.sts_code = sts.code
13109: -- and sts.ste_code = 'ACTIVE'

Line 13140: okc_statuses_v sts,

13136: oks_k_lines_b cle_ksl,
13137: oks_k_lines_b okscle_cov,
13138: okc_k_lines_b cle_cvl,
13139: okc_k_items cim,
13140: okc_statuses_v sts,
13141: oks_cov_types_v covtyp
13142: where cle.chr_id = okh.id
13143: and okh.sts_code = sts.code
13144: and sts.ste_code = 'ACTIVE'

Line 15437: ,okc_statuses_v STS

15433: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
15434: ,Okc_K_Lines_B SV
15435: ,Okc_K_Lines_B CL
15436: ,okc_subclasses_v CAT
15437: ,okc_statuses_v STS
15438: WHERE HD.Id = Cx_Chr_Id
15439: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
15440: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
15441: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 15500: ,okc_statuses_v STS

15496: ,STS.meaning HD_sts_meaning
15497: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
15498: ,OKC_K_HEADERS_TL HDT -- Okc_K_Headers_V HD -- Modified for 12.0 MOAC project (JVARGHES)
15499: ,okc_subclasses_v CAT
15500: ,okc_statuses_v STS
15501: WHERE HD.Id = nvl(Cx_Chr_Id,HD.Id)
15502: AND HD.Scs_Code IN ('SERVICE','WARRANTY')
15503: AND HDT.ID = HD.ID -- Modified for 12.0 MOAC project (JVARGHES)
15504: AND HDT.LANGUAGE = USERENV('LANG') -- Modified for 12.0 MOAC project (JVARGHES)

Line 18991: FROM OKC_STATUSES_V ;

18987: PROCEDURE Fetch_Sts_Meaning IS
18988:
18989: CURSOR GET_STATUS_CUR IS
18990: SELECT CODE,MEANING
18991: FROM OKC_STATUSES_V ;
18992:
18993: i Number;
18994: BEGIN
18995: i := 1;