DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_SUBCLASSES_V

Line 16839: ,okc_subclasses_v CAT

16835: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
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)

Line 16915: ,okc_subclasses_v CAT

16911: FROM OKC_K_HEADERS_ALL_B HD -- Modified for 12.0 MOAC project (JVARGHES)
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)

Line 16978: ,okc_subclasses_v CAT

16974: ,CAT.meaning HD_cat_meaning
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)

Line 17032: ,okc_subclasses_v CAT

17028: ,CAT.meaning HD_cat_meaning
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)

Line 17088: ,okc_subclasses_v CAT

17084: ,CAT.meaning HD_cat_meaning
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)