DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_PVT dependencies on OKC_SUBCLASSES_V

Line 15436: ,okc_subclasses_v CAT

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

Line 15499: ,okc_subclasses_v CAT

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